ORA-09925: Unable to create audit trail file Linux-x86_64 Problems

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.