Can't be reason, if os user oracle can logon. The reason might be, that os user who can't logon don't have write permission to audit directory at os level. > _____________________________________________ > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ext David A. > Barbour > Sent: 01 November, 2006 14:07 > 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 > > >