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: Fuad Arshad <fuadar_at_yahoo.com>
Date: Wed, 1 Nov 2006 06:56:54 -0800 (PST)
Message-ID: <20061101145654.24170.qmail@web82104.mail.mud.yahoo.com>

did you upgrade to 9.2.0.8 or 10.2 
yuo might want ot run $ORACLE_HOME/install/changeperm.sh 


----- Original Message ----
From: "Pande, Rajendra" <rajendra.pande_at_ubs.com>
To: david.barbour1_at_gmail.com; jdunn_at_sefas.com; oracle-l_at_freelists.org
Sent: Wednesday, November 1, 2006 8:19:21 AM
Subject: RE: Can only run sqlplus as oracle user


Please also check the permissions on the oracle binary in $ORACLE_HOME/bin
The permission may not be right.
Rajendra Pande
1000 Lincoln harbor
ITI Infrastructure 
Ph - 201 352 1415 (19 422 1415)
Pager - 1 201 718 0176
_____________________________________________
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David A. Barbour
Sent: Wednesday, November 01, 2006 7:18 AM
To: jdunn_at_sefas.com; oracle-l_at_freelists.org
Subject: RE: Can only run sqlplus as oracle user
Did this work okay in the past and just start happening?  Did the permissions on the audit file destination get changed?
_____________________________________________
From: John Dunn [mailto:jdunn_at_sefas.com]
Sent: Wednesday, November 01, 2006 7:09 AM
To: 'David A. Barbour'; oracle-l_at_freelists.org
Subject: RE: Can only run sqlplus as oracle user
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


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





Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.
UBS Financial Services Inc. 
UBS International Inc.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 01 2006 - 08:56:54 CST

Original text of this message

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