RE: Can only run sqlplus as oracle user

From: David A. Barbour <david.barbour1_at_gmail.com>
Date: Wed, 1 Nov 2006 07:18:22 -0500
Message-ID: <018e01c6fdaf$d41b9780$0201a8c0@PC490124453669>

Did this work okay in the past and just start happening? Did the permissions on the audit file destination get changed?

From: John Dunn [mailto:jdunn_at_sefas.com] Sent: Wednesday, November 01, 2006 7:09 AM To: 'David A. Barbour'; oracle-l_at_freelists.org Subject: RE: Can only run sqlplus as oracle user

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

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 - 06:18:22 CST