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

简介:

今天手工建库的过程中遇到了这么个错误

ERROR:

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 9925

ORA-01075: you are currently logged on


[oracle@ocbsdb01 dbhome_1]$ ps -ef | grep smon

oracle   11903     1  0 22:18 ?        00:00:00 ora_smon_manual

oracle   12485  1690  0 22:28 pts/1    00:00:00 grep smon


[oracle@ocbsdb01 dbhome_1]$ kill -9 11903


[oracle@ocbsdb01 dbhome_1]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on 星期六 3月 11 22:28:41 2017


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


已连接到空闲例程。


SQL> 


其实就是oracle 提示你已经登录了。杀掉重新登录就好了


注意:这种ORA-09925 报错的原因有很多,具体得看实际情况来定




本文转自 yuri_cto 51CTO博客,原文链接:http://blog.51cto.com/laobaiv1/1905490,如需转载请自行联系原作者

相关文章
|
Oracle 关系型数据库 Unix
启动Oracle数据库报错ORA-48173、ORA-48187、OSD-00002、OS-Error (OS 5) Access is denied
启动Oracle数据库报错ORA-48173、ORA-48187、OSD-00002、OS-Error (OS 5) Access is denied
181 0
ORA-09925: Unable to create audit trail file
ORA-09925: Unable to create audit trail file
110 0
|
SQL 存储 监控
ORA-00257: archiver error. Connect internal only, until freed 错误解决
出现ORA-00257错误(空间不足错误),通过查找资料,绝大部分说这是由于归档日志太多,占用了全部的硬盘剩余空间导致的,通过简单删除日志或加大存储空间就能够解决。 SecureCRT登录服务器,切换用户oracle,连接oracle [root@userbeta~]# su - orac...
1777 0