RAC RMAN 通道配置 RMAN-12001 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017 错误
做RAC 的RMAN 测试，配置通道后，检验时报错。
RMAN> configure channel 1 device type disk connect 'sys/admin@orcl1';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT 'sys/admin@orcl1';
new RMAN configuration parameters are successfully stored
RMAN> configure channel 2 device type disk connect 'sys/admin@orcl2';
new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT 'sys/admin@orcl2';
new RMAN configuration parameters are successfully stored
RMAN> show channel;
RMAN configuration parameters are:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT 'sys/admin@rac1';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT 'sys/admin@rac2';
RMAN> delete expired archivelog all;
using target database control file instead of recovery catalog
configuration for DISK channel 2 is ignored
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 09/20/2010 17:14:21
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01017: invalid username/password; logon denied
Tnsping 测试正常：
[oracle@rac1 u02]$ tnsping orcl1
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-SEP-2010 20:21:21
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (INSTANCE_NAME = orcl1)))
OK (0 msec)
[oracle@rac1 u02]$ tnsping orcl2
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-SEP-2010 20:21:25
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (INSTANCE_NAME = orcl2)))
OK (10 msec)
Oracle 官网对这个错误的说明：
Applies to:
~~~~~~~~~~~
Oracle Server Enterprise Edition but may happen Standard Edition as well.
Symptoms
~~~~~~~~~
A RMAN command such as "delete" results in errors like these:
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 09/05/2006 17:26:51
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01017: invalid username/password; logon denied
Changes
~~~~~~~~
Modification or addition of the persistent configuration parameter for
connecting to the target database.
Cause
~~~~~~
The RMAN "show all" command will show a setting like this one or with an incorrect
password, incorrect userid, etc:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
Solution
~~~~~~~~~
1) Return this persistent configuration parameter back to the default setting
as follows:
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;
of change the configuration to a correct value
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK connect '<username/password>';
2) Re-submit the failing operation.
Google 的一个结果，是因为 REMOTE_LOGIN_PASSWORDFILE 被修改了。 但是我检查了这个参数没有问题：
In addition, check to ensure that your REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE for each instance. Your password file may not be available or incorrect.
折腾了三个小时的结果是： 把密码记错了，测试环境的的密码是oracle，不是admin. 居然杯具到这个地步. 汗啊….
------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群：62697716(满); DBA2 群：62697977(满)
DBA3 群：63306533; 聊天 群：40132017
--加群需要在备注说明SGA的组成部分，否则拒绝申请
