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的组成部分，否则拒绝申请