D:\oracle\rmanbk>tnsping orcl1TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-NOV-2
010 14:14:20Copyright (c) 1997, 2010, Oracle. All rights reserved.Used parameter files:
D:\oracle\product\11.2.0\dbhome\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1
06.20)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl1.
jhtsz.com.cn)))
OK (90 msec)D:\oracle\rmanbk>tnsping orcl2TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-NOV-2
010 14:15:08Copyright (c) 1997, 2010, Oracle. All rights reserved.Used parameter files:
D:\oracle\product\11.2.0\dbhome\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 172.16.112.20)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl2)))
OK (70 msec)D:\oracle\rmanbk>lsnrctl stopLSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-NOV-2010 14:15
:48Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfullyD:\oracle\rmanbk>lsnrctl startLSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-NOV-2010 14:16
:21Copyright (c) 1991, 2010, Oracle. All rights reserved.Starting tnslsnr: please wait...TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is D:\oracle\product\11.2.0\dbhome\network\admin\listener.
ora
Log messages written to d:\oracle\diag\tnslsnr\webserver\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webserver.com)(PORT=1521
)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 08-NOV-2010 14:16:23
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\11.2.0\dbhome\network\admin\listener
.ora
Listener Log File d:\oracle\diag\tnslsnr\webserver\listener\alert\log.xm
l
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webserver.com)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfullyD:\oracle\rmanbk>rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Mon Nov 8 14:17:26 2010Copyright (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-12560: TNS:protocol adapter errorD:\oracle\rmanbk>其它命令执行都正常,就是最后一条不能执行,请问是什么原因?
010 14:14:20Copyright (c) 1997, 2010, Oracle. All rights reserved.Used parameter files:
D:\oracle\product\11.2.0\dbhome\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1
06.20)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl1.
jhtsz.com.cn)))
OK (90 msec)D:\oracle\rmanbk>tnsping orcl2TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-NOV-2
010 14:15:08Copyright (c) 1997, 2010, Oracle. All rights reserved.Used parameter files:
D:\oracle\product\11.2.0\dbhome\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 172.16.112.20)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl2)))
OK (70 msec)D:\oracle\rmanbk>lsnrctl stopLSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-NOV-2010 14:15
:48Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfullyD:\oracle\rmanbk>lsnrctl startLSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-NOV-2010 14:16
:21Copyright (c) 1991, 2010, Oracle. All rights reserved.Starting tnslsnr: please wait...TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is D:\oracle\product\11.2.0\dbhome\network\admin\listener.
ora
Log messages written to d:\oracle\diag\tnslsnr\webserver\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webserver.com)(PORT=1521
)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 08-NOV-2010 14:16:23
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\11.2.0\dbhome\network\admin\listener
.ora
Listener Log File d:\oracle\diag\tnslsnr\webserver\listener\alert\log.xm
l
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webserver.com)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfullyD:\oracle\rmanbk>rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Mon Nov 8 14:17:26 2010Copyright (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-12560: TNS:protocol adapter errorD:\oracle\rmanbk>其它命令执行都正常,就是最后一条不能执行,请问是什么原因?
造成ORA-12560: TNS: 协议适配器错误的问题的原因有三个:
1.监听服务没有起来。windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,启动oraclehome92TNSlistener服务。
2.database instance没有起起来。windows平台如下操作:开始---程序---管理工具---服务,打开服务面板,启动oracleserviceXXXX,XXXX就是你的database SID.
3.注册表问题。regedit,然后进入HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0将该环境变量ORACLE_SID设置为XXXX,XXXX就是你的database SID.或者右几我的电脑,属性--高级--环境变量---系统变量--新建,变量名=oracle_sid,变量值=XXXX,XXXX就是你的database SID.或者进入sqlplus前,在command line下输set oracle_sid=XXXX,XXXX就是你的database SID.
4.主机字符串输入SID.
用rman target userid/password@orcl2