C:\>sqlplusSQL*Plus: Release 9.2.0.1.0 - Production on 星期二 7月 15 09:31:21 2003Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.请输入用户名: dzzw/dzzw2003@dzzw
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
请输入用户名:
ERROR:
ORA-01017: 无效的用户名/口令;拒绝登录
请输入用户名:
ERROR:
ORA-01017: 无效的用户名/口令;拒绝登录
SP2-0157: 在3次尝试之后无法 CONNECT 到 ORACLE, 退出 SQL*PlusC:\>dgmgrl
DGMGRL for 32-bit Windows: Version 9.2.0.1.0 - Production.(c) Copyright 2002 Oracle Corporation. All rights reserved.Welcome to DGMGRL, type "help" for information.
DGMGRL> connect dzzw/dzzw2003
已连接。
错误:
ORA-16525: ??????????
ORA-06512: ?"SYS.X$DBMS_DRS", line 107
ORA-06512: ?line 2DGMGRL>我的数据库出现如上错误?请问如何解决?谢谢
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
请输入用户名:
ERROR:
ORA-01017: 无效的用户名/口令;拒绝登录
请输入用户名:
ERROR:
ORA-01017: 无效的用户名/口令;拒绝登录
SP2-0157: 在3次尝试之后无法 CONNECT 到 ORACLE, 退出 SQL*PlusC:\>dgmgrl
DGMGRL for 32-bit Windows: Version 9.2.0.1.0 - Production.(c) Copyright 2002 Oracle Corporation. All rights reserved.Welcome to DGMGRL, type "help" for information.
DGMGRL> connect dzzw/dzzw2003
已连接。
错误:
ORA-16525: ??????????
ORA-06512: ?"SYS.X$DBMS_DRS", line 107
ORA-06512: ?line 2DGMGRL>我的数据库出现如上错误?请问如何解决?谢谢
1、sqlplus /nolog
2、sql>conn / as sysdba;
3、sql>startup force
已连接。
SQL> startup force
ORACLE 例程已经启动。Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00204: ???????? (? 3?# ? 1)
ORA-00202: ????: 'D:\ORACLE\ORADATA\DZZW\CONTROL01.CTL'
ORA-27091: skgfqio: ???? I/O ??
ORA-27070: skgfdisp: ????/????
OSD-04006: ReadFile() J'0\, N^7(6AH!ND<~
O/S-Error: (OS 23) J}>]4mNs (Q-;7H_S`<l2i)!#
SQL>
还是不对呀!!!
connect sys/dzzw2003@dzzw(如果不成功,使用connect,不要使用后面的sys/dzzw2003@dzzw参数)
shutdown abort
startup
DGMGRL> startup
ORACLE 例程已经启动。
数据库装载完毕。
数据库已经打开。
DGMGRL> connect dzzw/dzzw2003@dzzw
已连接。
错误:
ORA-16525: 数据防护中介尚不可用
ORA-06512: 在"SYS.DBMS_DRS", line 48
ORA-06512: 在line 2
谢谢指点!
Text: the Data Guard broker is not yet available
-------------------------------------------------------------------
Cause: The Data Guard broker process has not yet been started, is initializing, or failed to start.
Action: If the broker has not been started set DRS_START to true and
allow the broker to finish initializing before making the request.
If the broker failed to start check the Data Guard log for
possible errors. Otherwise, retry the operation.