Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can only run sqlplus as oracle user
did you upgrade to 9.2.0.8 or 10.2 yuo might want ot run $ORACLE_HOME/install/changeperm.sh ----- Original Message ---- From: "Pande, Rajendra" <rajendra.pande_at_ubs.com> To: david.barbour1_at_gmail.com; jdunn_at_sefas.com; oracle-l_at_freelists.org Sent: Wednesday, November 1, 2006 8:19:21 AM Subject: RE: Can only run sqlplus as oracle user 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 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 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-lReceived on Wed Nov 01 2006 - 08:56:54 CST
![]() |
![]() |