ORA-09925: UnabletocreateaudittrailfileLinux-x86_64 Problems

ORA-09925: UnabletocreateaudittrailfileLinux-x86_64 troubleshooting, error reported when logging on to the database with a non-ORACLE user: [www. linuxi

ORA-09925: Unable to create audit trail file Linux-x86_64 issue handling when using a non-ORACLE user to log on to the database with the error: [www. linuxi

When a non-Oracle user logs on to the database, the following error occurs:

[@ Linuxidc ~] $ 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:

[@ Linuxidc ~] $ 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
[@ Linuxidc ~] $ Id
Uid = 504 (marven) gid = 501 (oinstall) groups = 501 (oinstall), 502 (dba)

Use the root user as follows:
[@ Linuxidc ~] $ 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:
[@ Linuxidc ~] $ 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.

,