Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can only run sqlplus as oracle user

RE: Can only run sqlplus as oracle user

From: <Jorma.Vuorio_at_nokia.com>
Date: Wed, 1 Nov 2006 14:15:53 +0200
Message-ID: <3C8AF3212539E545B5E04BB7250DA32903C02C71@esebe105.NOE.Nokia.com>


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-l
Received on Wed Nov 01 2006 - 06:15:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US