Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [11-2006 Date Index] [Date Next] || [Thread Prev] [11-2006 Thread Index] [Thread Next]

Re: Can only run sqlplus as oracle user

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 01 Nov 2006 05:31:29 -0700
John,

Did you run "root.sh" after installation? Can you run "ls -l $ORACLE_HOME/bin/oracle" and are the file permissions "rwsr-s--x"?

Hope this helps?

-Tim





John Dunn wrote:
It isn't and in any case if I log onto Solaris as the oracle user and run
sqlplus it works fine



  -----Original Message-----
From: David A. Barbour [mailto:david.barbour1@xxxxxxxxx] Sent: Wednesday, November 01, 2006 12:07 PM
To:    jdunn@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject:    RE: Can only run sqlplus as oracle user

Check to make sure your audit file destination isn't full.

_____________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of John Dunn
Sent: Wednesday, November 01, 2006 6:59 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
http://www.freelists.org/webpage/oracle-l






[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.