?

做RAC 的RMAN 測(cè)試，配置通道后，檢驗(yàn)時(shí)報(bào)錯(cuò)。

?

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 測(cè)試正常：

?

[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 官網(wǎng)對(duì)這個(gè)錯(cuò)誤的說(shuō)明：

?

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 的一個(gè)結(jié)果，是因?yàn)?/span> REMOTE_LOGIN_PASSWORDFILE 被修改了。 但是我檢查了這個(gè)參數(shù)沒(méi)有問(wèn)題：

?

In addition, check to ensure that your REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE for each instance. Your password file may not be available or incorrect.

?

?

折騰了三個(gè)小時(shí)的結(jié)果是： 把密碼記錯(cuò)了，測(cè)試環(huán)境的的密碼是oracle，不是admin. 居然杯具到這個(gè)地步. ?汗啊….

?

?

?

------------------------------------------------------------------------------

Blog： http://blog.csdn.net/tianlesoftware

網(wǎng)上資源： http://tianlesoftware.download.csdn.net

相關(guān)視頻：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(滿); DBA2 群：62697977(滿)

DBA3 群：63306533;???? 聊天 群：40132017

--加群需要在備注說(shuō)明SGA的組成部分，否則拒絕申請(qǐng)

轉(zhuǎn)載于:https://www.cnblogs.com/tianlesoftware/archive/2010/09/21/3609989.html

總結(jié)

以上是生活随笔為你收集整理的RAC RMAN 通道配置 RMAN-12001 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017 错误的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。