ora_00333,ora_03114

最新推荐文章于 2025-10-09 12:03:33 发布

转载最新推荐文章于 2025-10-09 12:03:33 发布 · 281 阅读

本文介绍了解决ORA-00333错误的方法，包括将数据库启动到mount状态、使用openresetlogs打开数据库、关闭数据库并重新启动等步骤。同时，针对ORA-03114错误提供了重新启动监听器和开启数据库的解决方案。

打开数据库，显示ora－00333：重做日志读取块130917计数8192出错

1.启动到mount状态
> startup mount

2.用open resetlogs打开
> alter database open resetlogs

3.关库
> shutdown

4.重新启动
> startup

注释：打开数据库后显示ORA-03114 not connected to ORACLE

Cause:
A call to Oracle was attempted when no connection was established. Usually this happens
because a user-written program has not logged on. It may happen if communication trouble causes
a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER
SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases,

　　the client's connection to the database is terminated without waiting for the client to issue a request.

　　Action: Try again. If the message recurs and the program is user written, check the program.

解决：
启动监听
[oracle@solaris186:/export/home/oracle]$ lsnrctl start

重新开库
[oracle@solaris186:/export/home/oracle]$sqlplus / as sysdba

SYS@ prod>startup

SYS@ prod>show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1

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

转载于:http://blog.itpub.net/30146714/viewspace-1444403/