RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password;
環境: 主庫 2節點RAC , 備庫 2節點RAC DG .
在使用RMAN duplicate from active database 建立data guard時碰到如下錯誤:
$ rman target sys/oracle@ay auxiliary sys/oracle@aydg
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
查詢發現發生這個錯誤大概有 3 個原因:
1. 主備庫的密碼檔案不一致
2. remote_login_passwordfile 必須設成 exclusive
3. 密碼檔名稱錯誤,比如SID=aydg1, 但是我們的密碼檔案是 orapwaydg, 導致找不到密碼檔案而報錯,應該修改為orapwaydg1 。
在使用RMAN duplicate from active database 建立data guard時碰到如下錯誤:
$ rman target sys/oracle@ay auxiliary sys/oracle@aydg
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
查詢發現發生這個錯誤大概有 3 個原因:
1. 主備庫的密碼檔案不一致
2. remote_login_passwordfile 必須設成 exclusive
3. 密碼檔名稱錯誤,比如SID=aydg1, 但是我們的密碼檔案是 orapwaydg, 導致找不到密碼檔案而報錯,應該修改為orapwaydg1 。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-2123066/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not availableErrorUXDatabaseOracleAI
- AD Administration error:ORA-01017: invalid username/password; logon deniedErrorGo
- ORA-01017:invalid username/password; logon deniedGo
- ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from TESTGo
- sqlplus / as sysdba報錯ORA-01017: invalid username/password; logon deniedSQLGo
- 【DG】搭建DG時報錯:ORA-01017、ORA-17627、ORA-17629 invalid username/password
- 遠端登入sys使用者報錯:ORA-01017: invalid username/password; logon deniedGo
- SYS使用者遠端登入報錯:ORA-01017: invalid username/password; logon deniedGo
- EBS在測試時報 APP-FND-01516: Invalid application username,password,or database.APPDatabase
- The password supplied with the username Domain\UserName was not correct. Verify that it was entered ...AI
- ConfigureGC.pl Reports - Invalid Username/Password. (文件 ID 602750.1)GC
- 【YashanDB資料庫】YAS-02143 invalid username/password, login denied資料庫
- nagios監控windows 報NSClient - ERROR: Invalid passwordiOSWindowsclientError
- WCF Security:authentication based on Username/Password - Part I
- RMAN 6217 not connected to auxiliary database with a net service nameUXDatabase
- auxiliary database: ORA-12528錯誤UXDatabase
- python urllib socks5 auth username password 設定Python
- WCF Services Sample: Authenticate Silverlight Client based on UserName and Passwordclient
- An error from listenerError
- 【RMAN】RMAN-05001: auxiliary filename conflicts with the target databaseUXDatabase
- [轉]How to release space from databaseDatabase
- Password is required when adding a database to AG group if the database has a master keyUIDatabaseAST
- SourceTreet提交時顯示remote: Incorrect username or password ( access token )(4種解決辦法)REM
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- OBIEE 11g users still able to login even with invalid password
- ERROR 1045 (28000): using password: YESError
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- invalid conversion from ‘LRUCache*‘ to ‘int‘ [-fpermissive] /new的使用
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid不同UXDatabaseOracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid相同UXDatabaseOracle
- tar: Error exit delayed from previous errorsError
- Connections could not be acquired from the underlying databaseUIDatabase
- Unload data to a flat file from Oracle databaseOracleDatabase
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- Connection to x as user y failed: ERROR: Wrong password for userAIError
- error: invalid type argument of unary ‘*‘ (have ‘int‘) *__first = __tmp;Error
- How to Resolve Invalid Objects in a Database [ID 158185.1]ObjectDatabase
- ORA-16649: possible failover to another database prevents this database from beiAIDatabase