RE: Can only run sqlplus as oracle user
- From: "David A. Barbour" <david.barbour1@xxxxxxxxx>
- To: <jdunn@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Nov 2006 07:18:22 -0500
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
Other related posts:
