sqlplus连接报ORA-09925 Unable to create audit trail file错误处理

来源：互联网发布：淘宝网丞乐园童装编辑：程序博客网时间：2024/05/17 22:00

测试环境sqlplus连接报ORA-09925: Unable to create audit trail file错误

$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 10 13:13:44 2016

SQL> conn /as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
SVR4 Error: 13: Permission denied
Additional information: 9925
ORA-01075: you are currently logged on

1.从网站上查找资料显示可能为执行文件oracle权限问题，下面显示权限正常

$ ls -la $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 gpattst dba 254881424 Nov 10 11:21 /gpattst1/app/11204/bin/oracle

2.查看磁盘空间，确认空间足够
/dev/dsk/c0d3s0         98G    10G    86G    11%    /gpattst1
3.检查各目录的权限，onwner都为gpattst.
bash-3.00$ cd /gpattst1
bash-3.00$ ls -ltr
total 10869286
drwxr-xr-x   7 gpattst dba          512 Mar 11 2014 app
drwx------   2 gpattst dba         8192 Nov 10 09:08 lost+found
-rw-r--r--   1 gpattst dba      5562327552 Nov 10 09:15 app.tar
drwxr-xr-x   2 gpattst dba          512 Nov 10 09:34 gpattst1data
drwxr-xr-x   2 gpattst dba          512 Nov 10 09:35 gpattst1arc
4.检查环增变量设置

测试机上已存在的数据库实例如下：
$ ps -ef|grep pmon
zlnctest 4624     1   0   Sep 02 ?          21:01 ora_pmon_zlnctst
gpattst   458   425   0 13:34:08 pts/3       0:00 grep pmon
gpattst1 24246     1   0 23:31:19 ?           0:09 ora_pmon_gpattst1

再查看当前oracle用户的环境变量设置：
$ echo $ORACLE_SID
gpattst1

看起来实例名重命了，更改$HOME/.profile设置，由gpattst1改成gpattst
ORACLE_SID=gpattst;export ORACLE_SID

并刷新profile:source $HOME/.profile生效。

最后重新连接sqlplus，不再报错。
$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 10 13:38:02 2016

SQL> conn /as sysdba
Connected to an idle instance.

0 0