ERROR:ORA-09925

最新推荐文章于 2024-01-26 08:30:17 发布

AC_coding

最新推荐文章于 2024-01-26 08:30:17 发布

阅读量1k

点赞数

分类专栏： Oracle 文章标签： oracle

Oracle 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

[oracle@oracle ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 15 12:02:16 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
SQL> conn / as sysdba
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

原因：$ORACLE_HOME/bin/oracle这个文件的属性有问题，变成了“-rwxr-xr-x ”，正常情况是“-rwsr-sr-x”。

//检查bin目录下的oracle执行程序权限
ls -lrt $ORACLE_HOME/bin/oracle
[oracle@oracle ~]$ cd /oracle/app/product/11.2.0/db_1/bin
[oracle@oracle oracle]$ su
Password: 
[root@oracle oracle]# chmod 6755 /oracle
[root@oracle oracle]# su - oracle
[oracle@oracle ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 15 12:07:54 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.