问题描述
通过PL/SQL登录数据库报错
用sqlplus工具登录时会hang住
[oracle@db RACDB]$ !sql
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 12月 24 09:57:24 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
^CERROR:
ORA-01075: 您现在已登录
[oracle@db RACDB]$
[oracle@db RACDB]$ rman target /
恢复管理器: Release 11.2.0.4.0 - Production on 星期二 12月 24 09:58:35 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
^CRMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: 内部恢复管理器程序包初始化失败
RMAN-04005: 目标数据库中存在错误:
ORA-01013: 用户请求取消当前的操作
sqlplus和rman工具都进不到数据库,会hang住
[oracle@db archivelog]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 12月 24 10:07:45 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
exit
^CERROR:
ORA-01075: 您现在已登录
SQL> exit
sqlplus -prelim / as sysdba方式登录
[oracle@db archivelog]$ sqlplus -prelim / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 12月 24 10:10:55 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
强制关闭后启动
SQL> shutdown abort
ORACLE 例程已经关闭。
SQL> exit
从 ORACLE 断开
[oracle@db archivelog]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 12月 24 10:11:40 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 5.3982E+10 bytes
Fixed Size 2266024 bytes
Variable Size 2.9931E+10 bytes
Database Buffers 2.4025E+10 bytes
Redo Buffers 24084480 bytes
数据库装载完毕。
ORA-03113: 通信通道的文件结尾 进程 ID:
16606
会话 ID: 13147 序列号: 3
在告警日志看归档地址,清空物理文件后重新启动
如若还失败,startup mount;
然后关闭归档 alter database noarchivelog;
SQL> startup mount
ORACLE instance started.
Total System Global Area 5.3982E+10 bytes
Fixed Size 2266024 bytes
Variable Size 2.3622E+10 bytes
Database Buffers 3.0333E+10 bytes
Redo Buffers 24084480 bytes
Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1474
Current log sequence 1477
SQL> select status from v$instanc;
STATUS
------------
OPEN
注意,也有可能是挂载掉了,具体表现为df -h不好用