Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can only run sqlplus as oracle user
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_at_gmail.com] Sent:
Wednesday, November 01, 2006 12:07 PM
To: jdunn_at_sefas.com; oracle-l_at_freelists.org
Subject: RE: Can only run sqlplus as oracle user
Check to make sure your audit file destination isn't full.
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-lReceived on Wed Nov 01 2006 - 06:31:29 CST
![]() |
![]() |