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