ORA-12528: Message 12528 not found; product=RDBMS; facility=ORA

SQL> conn sys/sys@quest02 as sysdba;
已连接。
SQL> select * from dual;
 
D
-
X
 
SQL> archive log list;
数据库日志模式             非存档模式
自动存档             禁用
存档终点            USE_DB_RECOVERY_FILE_DEST
最早的概要日志序列     8
当前日志序列           10
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。
ORA-12528: Message 12528 not found;  product=RDBMS; facility=ORA
 
SQL> alter system set log_archive_start=ture scope=spfile;
alter system set log_archive_start=ture scope=spfile
*
ERROR 位于第 1 行:
ORA-03114: 未连接到 ORALCE
 

SQL> conn sys/sys@quest02 as sysdba;
ERROR:
ORA-12528: Message 12528 not found;  product=RDBMS; facility=ORA
 
 
 
SQL> select * from dual;
SP2-0640: 未连接
SQL> conn sys/sys@quest02 as sysdba;
ERROR:
ORA-12528: Message 12528 not found;  product=RDBMS; facility=ORA
 
 
 
SQL> exit
 
C:\Documents and Settings\Administrator>tnsping quest02
 
TNS Ping Utility for 32-bit Windows: Version 9.2.0.7.0 - Production on 06-1月 -2
009 09:57:10
 
Copyright (c) 1997 Oracle Corporation.  All rights reserved.
 
已使用的参数文件:
D:\oracle\ora92\network\admin\sqlnet.ora
 

已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.1.66)(PORT = 1521))) (CONNECT_DATA = (SID = quest02) (UR=A) (SER
VER = DEDICATED)))
OK(20毫秒)
 
C:\Documents and Settings\Administrator>sqlplus /nolog
 
SQL*Plus: Release 9.2.0.7.0 - Production on 星期二 1月 6 09:57:16 2009
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> conn sys/sys@quest02 as sysdba;
ERROR:
ORA-12528: Message 12528 not found;  product=RDBMS; facility=ORA
 
 
 
SQL> exit
 
C:\Documents and Settings\Administrator>set sid=quest02
 
C:\Documents and Settings\Administrator>sqlplus /nolog
 
SQL*Plus: Release 9.2.0.7.0 - Production on 星期二 1月 6 09:57:46 2009
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> conn sys/sys@quest02 as sysdba;
ERROR:
ORA-12528: Message 12528 not found;  product=RDBMS; facility=ORA
 
通过在本地tnsnames.ora文件中加入(UR=A)方法测试,不管用。
 
C:\Documents and Settings\Administrator>set ORACLE_SID=quest02
 
C:\Documents and Settings\Administrator>sqlplus /nolog
 
SQL*Plus: Release 9.2.0.7.0 - Production on 星期二 1月 6 10:03:56 2009
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> conn sys/sys@quest02 as sysdba;
ERROR:
ORA-12528: Message 12528 not found;  product=RDBMS; facility=ORA
 
网上大多解决方法都是加(UR=A),但我这个不信,目前还没有找到方法。看来得登陆到本地启动了。等有了解决方法在发布。如果各位知道请赐教afant_info@hotmail.com 谢谢
 
 

posted on 2009-01-06 10:18  afant  阅读(2981)  评论(0编辑  收藏  举报

导航