When a non-ORACLE user logs on to the database, the following error occurs:
[Marven @ hpserver2 ~] $ Sqlplus "/as sysdba"
SQL * Plus: Release 10.2.0.4.0-Production on Wed Feb 1 15:55:07 2012
Copyright (c) 1982,200 7, Oracle. All Rights Reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL * Plus
At this time, check the oracle execution program permission in the bin directory as follows:
[Marven @ hpserver2 ~] $ Ls-lrt $ ORACLE_HOME/bin/oracle
-Rwxr-x -- x. 1 oracle oinstall 112701117 Dec 6/u01/app/oracle/product/10.2.0/db_1/bin/oracle
[Marven @ hpserver2 ~] $ Id
Uid = 504 (marven) gid = 501 (oinstall) groups = 501 (oinstall), 502 (dba)
Use the root user as follows:
[Marven @ hpserver2 ~] $ Su
Password:
[Root @ hpserver2 oracle] # chmod 6755 $ ORACLE_HOME/bin/oracle
[Root @ hpserver2 oracle] # ls-lrt $ ORACLE_HOME/bin/oracle
-Rwsr-sr-x. 1 oracle oinstall 112701117 Dec 6/u01/app/oracle/product/10.2.0/db_1/bin/oracle
[Root @ hpserver2 oracle] # exit
Logon successful:
[Marven @ hpserver2 ~] $ Sqlplus "/as sysdba"
SQL * Plus: Release 10.2.0.4.0-Production on Wed Feb 1 16:00:00 2012
Copyright (c) 1982,200 7, Oracle. All Rights Reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
OK.
From marvelyu's notes