Duplicate Active Database 遇到 ORA-01017 invalid username/password
Oracle 11g 的新特性Duplicate Active Database可以在不備份target database的情況下構建 duplicate database,特別適合于為VLDB構建standby的場景。今天特意試一下,但是卻讓我遇上了 ORA-01017 invalid username/password,過程如下:
oracle@dev18:abank /home/oracle>rman target / auxiliary sys/__password__@abank_123
Recovery Manager: Release 11.2.0.1.0 - Production on Sun May 29 14:16:08 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: abank (DBID=433589790)
connected to auxiliary database: abank (not mounted)
RMAN> duplicate target database for standby from active database ;
Starting Duplicate Db at 2011-05-29 14:16:17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1149 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/opt/app/oracle/product/11.2.0/db/dbs/orapwabank' auxiliary format
'/opt/app/oracle/product/11.2.0/db/dbs/orapwabank' ;
}
executing Memory Script
Starting backup at 2011-05-29 14:16:18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=594 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/29/2011 14:16:19
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/29/2011 14:16:19
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server
打開rman的時候已經進行了驗證,理論上不應在有驗證的問題,google得知使用Duplicate Active Database要這樣登入rman:
rman target sys/__password__ auxiliary sys/__password__@abank_123
浙公網安備 33010602011771號