RE: Can only run sqlplus as oracle user

From: Pande, Rajendra <rajendra.pande_at_ubs.com>
Date: Wed, 1 Nov 2006 09:19:21 -0500
Message-ID: <125BE2CBD9387F458D424DCF96DEBEA801C8F37D@psle19.xchg.pwj.com>

Please also check the permissions on the oracle binary in $ORACLE_HOME/bin The permission may not be right.

Rajendra Pande
1000 Lincoln harbor
ITI Infrastructure
Ph - 201 352 1415 (19 422 1415)
Pager - 1 201 718 0176

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David A. Barbour
Sent: Wednesday, November 01, 2006 7:18 AM To: jdunn_at_sefas.com; oracle-l_at_freelists.org Subject: RE: Can only run sqlplus as oracle user

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

Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.

UBS Financial Services Inc.
UBS International Inc.

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

Received on Wed Nov 01 2006 - 08:19:21 CST