RE: Can only run sqlplus as oracle user
- From: "Pande, Rajendra" <rajendra.pande@xxxxxxx>
- To: david.barbour1@xxxxxxxxx, jdunn@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 1 Nov 2006 09:19:21 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of David A. Barbour
Sent: Wednesday, November 01, 2006 7:18 AM
To: jdunn@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Wednesday, November 01, 2006 7:09 AM
To: 'David A. Barbour'; oracle-l@xxxxxxxxxxxxx
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@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
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.
Other related posts:
