ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 启动数据库出现ORA-9925错误

启动数据库出现ORA-9925错误

原创 Linux操作系统 作者:yangtingkun 时间:2011-12-16 23:59:54 0 删除 编辑

尝试用非oracle用户启动数据库,碰到这个错误。

 

 

错误详细信息为:

enmo@jyoracle:/oracle/admin/enmo>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 16 20:28:09 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
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

其实这个错误很明显,是由于AUDIT TRAIL文件无法创建所致,导致这个问题多半是由于权限造成的,检查后发现果然如此:

enmo@jyoracle:/oracle/admin/enmo>ls
adump bdump cdump udump
enmo@jyoracle:/oracle/admin/enmo>ls -l
total 0
drwxr-xr-x 2 enmo dba 256 Dec 16 20:17 adump
drwxr-xr-x 2 enmo dba 256 Dec 16 20:14 bdump
drwxr-xr-x 2 enmo dba 256 Dec 16 20:14 cdump
drwxr-xr-x 2 enmo dba 256 Dec 16 20:15 udump
enmo@jyoracle:/oracle/admin/enmo>chmod 775 adump
enmo@jyoracle:/oracle/admin/enmo>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 16 20:29:46 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

由于当前的用户属于dba组,并非oracle用户,因此如果要数据库可以访问adump目录,应该设置改目录组选项可写。

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-713469/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10386390