Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can only run sqlplus as oracle user

Re: Can only run sqlplus as oracle user

From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 01 Nov 2006 05:31:29 -0700
Message-ID: <454893A1.9080000@evdbt.com>


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.



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn
Sent: Wednesday, November 01, 2006 6: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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 01 2006 - 06:31:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US