登录RMAN 报ORA-12162：TNS:net service name is incorrectly specified错误
浏览数：65 /
时间：2015年06月09日
登录RMAN 报ORA-12162：TNS:net service name is incorrectly specified错误
[oracle@localhost admin]$ date
Tue Apr 22 18:06:16 CST 2014
[oracle@localhost admin]$ rman target /
//出现诡异的ora-12162错误，第一反应是TNS，但第二反应告诉我，这是个简单的错误，注意环境变量
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Apr 22 18:08:11 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. 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-12162: TNS:net service name is incorrectly specified
[oracle@localhost admin]$ echo $ORACLE_HOME //查看ORACLE_HOME,设置正确
/u01/app/oracle/product/11.2.0/db_1
[oracle@localhost admin]$ echo $ORACLE_SID //查看ORACLE_SID,发现设置为空
[oracle@localhost ~]$ export ORACLE_SID=PROD //手工注入ORACLE_SID
[oracle@localhost ~]$ rman target / //启动RMAN,成功
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Apr 22 18:13:40 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=239015079)
RMAN>
[oracle@localhost admin]$ date
Tue Apr 22 18:06:16 CST 2014
[oracle@localhost admin]$ rman target /
//出现诡异的ora-12162错误，第一反应是TNS，但第二反应告诉我，这是个简单的错误，注意环境变量
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Apr 22 18:08:11 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. 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-12162: TNS:net service name is incorrectly specified
[oracle@localhost admin]$ echo $ORACLE_HOME //查看ORACLE_HOME,设置正确
/u01/app/oracle/product/11.2.0/db_1
[oracle@localhost admin]$ echo $ORACLE_SID //查看ORACLE_SID,发现设置为空
[oracle@localhost ~]$ export ORACLE_SID=PROD //手工注入ORACLE_SID
[oracle@localhost ~]$ rman target / //启动RMAN,成功
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Apr 22 18:13:40 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=239015079)
RMAN>
登录RMAN 报ORA-12162：TNS:net service name is incorrectly specified错误,古老的榕树,5-wow.com
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
