Can only run sqlplus as oracle user

From: John Dunn <jdunn_at_sefas.com>
Date: Wed, 1 Nov 2006 11:59:23 -0000
Message-ID: <001001c6fdad$2cd31b80$3e04050a@johnman>

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

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




application/ms-tnef attachment: winmail.dat

Received on Wed Nov 01 2006 - 05:59:23 CST