奇怪的问题，关于ORA-12560，急啊，在线！！！

rickynie

这个ORA-12560出现的非常奇怪，两台小机上运行oracle 9.2.0.4业务数据，一台服务器上是rmandb也是9.2.0.4，
我在客户机上联接rmandb，用rman target / catalog sys/oracle@rmandb时报错如下
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12560: TNS: 协议适配器错误

但是我在这台报错的机器上用
rman
rman>connect catalog sys/oracle@rmandb  却是正常的
并且在小机上运行rman target / catalog sys/oracle@rmandb也是正常的，不知怎么会这样，请高手指点一下，急啊

luocb1980

rman target=system/passwd@dbname catalog sys/oracle@rmandb
你这样试一试，是否还报错？？

blue_stone

rman
rman>connect catalog sys/oracle@rmandb  
rman> connect target /
to check whether target or catalog cannot be connected

rickynie

原帖由 luocb1980 于 2006-7-12 16:40 发表
rman target=system/passwd@dbname catalog sys/oracle@rmandb
你这样试一试，是否还报错？？

依然报错
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

rickynie

原帖由 blue_stone 于 2006-7-12 16:47 发表
rman
rman>connect catalog sys/oracle@rmandb  
rman> connect target /
to check whether target or catalog cannot be connected

依然报错
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

rickynie

现在看来是catalog库的机子上，不能connect target / 为什么呢，前几天都是好好的啊

rickynie

为什么不能 rman target / 啊，有人知道吗

rickynie

rman target sys/oracle@targetdb  可以运行
rman target /  不能运行报错
恢复管理器: 版本9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12560: TNS: 协议适配器错误


请高手啊

blue_stone

ORA-12560:TNS:协议适配器错误
说明你的Oracle服务没有起来, 查查
1 oracle net service起来了
2 oracleservice%ORACLE_SID%服务起来了(windows平台) ,并且将数据库启动到nomount或者mount状态了
3 ORACLE_SID环境变量设置正确.

检查方式, 使用 sqlplus /nolog
conn / as sysdba看可否登陆