Re: Can only run sqlplus as oracle user

Hi

Most probably is you have problem with your oracle executable permissions. missing setuid probably.

Show us $ORACLE_HOME/bin/oracle

On 11/1/06, John Dunn <jdunn_at_sefas.com> wrote:
>
> I have applied the patch and run the changeperm script
>
> The error I get now is
>
> ERROR:
>
> ORA-01034: ORACLE not available
>
> ORA-27123: unable to attach to shared memory segment
>
> SVR4 Error: 13: Permission denied
>
> I do not get this error when logged into Solaris as the oracle user, only
> when logged is as another user.
>
> Any ideas?
>
>
>
> -----Original Message-----
> *From:* Kurth, Michael J. [mailto:Michael.Kurth_at_wfhc.org]
> *Sent:* Wednesday, November 01, 2006 1:06 PM
> *To:* jdunn_at_sefas.com
> *Subject:* RE: Can only run sqlplus as oracle user
>
>
> This may be due to bug 4516865.
>
> You can try:
> . cd $ORACLE_HOME/install
> . sh changeperm.sh
>
> This fixed my problem with not being able to run sqlplus from other user
> accounts.
>
> *Mike Kurth*
> Senior Oracle DBA
> Wheaton Franciscan Healthcare
> 414/465-4046 Phone
> 414/465-4080* Fax*
> Michael.Kurth_at_wfhc.org
>
>
>
> _____________________________________________
> *From: * oracle-l-bounce_at_freelists.org [*
> mailto:oracle-l-bounce_at_freelists.org*<oracle-l-bounce_at_freelists.org>
> ] * On Behalf Of* John Dunn
> *Sent: * Wednesday, November 01, 2006 5:59 AM
> *To: * oracle-l_at_freelists.org
> *Subject: * Can only run sqlplus as oracle user
>
> Platform is Solaris 10, Oracle 10
>
> I can run sqlplus OK when logged on to Solaris as the oracle user,
> but if I run sqlplus when logged in as another user I get the error
>
> ORA-09925: Unable to create audit trail file
>
> Oracle environment variables are the same for both users.
>
> Why should it matter what unix user I am logged on as?
>
> $ sqlplus /NOLOG
>
> SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 1 13:13:06 2006
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> SQL> connect sys as sysdba
> Enter password:
> ERROR:
> ORA-09925: Unable to create audit trail file
>
> John Dunn
> Product Consultant
> Direct Dial +44 (0) 117 373 6122
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.
> Tel: +44(0) 117 373 6114
> Fax: +44 (0) 117 373 6115
>
> *www.sefas.com*
>
>
>
> Privileged/Confidential information may be contained in this message. The
> information contained in this message is intended only for the use of the
> recipient(s) named above and their co-workers who are working on the same
> matter. The recipient of this information is prohibited from disclosing the
> information to any other party unless this disclosure has been authorized in
> advance.
>
> If you are not intended recipient of this message or any agent responsible
> for delivery of the message to the intended recipient, you are hereby
> notified that any disclosure, copying, distribution or action taken in
> reliance on the contents of this message is strictly prohibited. You should
> immediately destroy this message and kindly notify the sender by reply
> E-Mail. Please advise immediately if you or your employer does not consent
> to Internet E-Mail for messages of this kind. Opinions, conclusions and
> other information in this message that do not relate to the official
> business of the firm shall be understood as neither given nor endorsed by
> it.
>
>

--
http://www.freelists.org/webpage/oracle-l