Re: Can only run sqlplus as oracle user

Sounds more like permissions on the audit destination

On 11/1/06, John Dunn <jdunn_at_sefas.com> wrote:
>
> 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_at_gmail.com]
> > Sent: Wednesday, November 01, 2006 12:07 PM
> > 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
> >
> >
> >
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l