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: