ORA-12528: Message 12528 not found; product=RDBMS; facility=ORA
SQL> conn sys/sys@quest02 as sysdba;
已连接。
SQL> select * from dual;
已连接。
SQL> select * from dual;
D
-
X
-
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
数据库日志模式 非存档模式
自动存档 禁用
存档终点 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
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
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
009 09:57:10
Copyright (c) 1997 Oracle Corporation. All rights reserved.
已使用的参数文件:
D:\oracle\ora92\network\admin\sqlnet.ora
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
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
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
ERROR:
ORA-12528: Message 12528 not found; product=RDBMS; facility=ORA
网上大多解决方法都是加(UR=A),但我这个不信,目前还没有找到方法。看来得登陆到本地启动了。等有了解决方法在发布。如果各位知道请赐教afant_info@hotmail.com 谢谢