Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can only run sqlplus as oracle user
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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ext David A.
> Barbour
> Sent: 01 November, 2006 14:07
> To: jdunn_at_sefas.com; oracle-l_at_freelists.org
> Subject: RE: Can only run sqlplus as oracle user
>
> Check to make sure your audit file destination isn't full.
>
> _____________________________________________
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn
> Sent: Wednesday, November 01, 2006 6:59 AM
> To: oracle-l_at_freelists.org
> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 01 2006 - 06:15:53 CST
![]() |
![]() |