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: David A. Barbour <david.barbour1_at_gmail.com>
Date: Wed, 1 Nov 2006 07:07:28 -0500
Message-ID: <017e01c6fdae$4d6fb0a0$0201a8c0@PC490124453669>


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:07:28 CST

Original text of this message

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