Can only run sqlplus as oracle user

  • From: "John Dunn" <jdunn@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 1 Nov 2006 11:59:23 -0000

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 - Production on Wed Nov 1 13:13:06 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect sys as sysdba
Enter password: 
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

Other related posts: