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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- sqlplus / as sysdba報錯ORA-01017: invalid username/password; logon deniedSQLGo
- 【YashanDB資料庫】YAS-02143 invalid username/password, login denied資料庫
- python urllib socks5 auth username password 設定Python
- Password is required when adding a database to AG group if the database has a master keyUIDatabaseAST
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid不同UXDatabaseOracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid相同UXDatabaseOracle
- ORA-16649: possible failover to another database prevents this database from beiAIDatabase
- invalid conversion from ‘LRUCache*‘ to ‘int‘ [-fpermissive] /new的使用
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- Oracle database 升級(文件)to 10.2.0.4 from 10.2.0.1OracleDatabase
- SourceTreet提交時顯示remote: Incorrect username or password ( access token )(4種解決辦法)REM
- 網站報錯:“Database Server Error”網站DatabaseServerError
- MySQL案例09:Last_IO_Error: Got fatal error 1236 from master when reading data from binary logMySqlASTErrorGo
- xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools)ErrorDeveloper
- error creating overlay mount to invalid argument unbuntu系統Error
- error: invalid type argument of unary ‘*‘ (have ‘int‘) *__first = __tmp;Error
- 解決docker: Error response from daemon故障DockerError
- oracle12.2 adg ORA-46952: standby database format mismatch for password fileOracleDatabaseORM
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)Errorlocalhost
- 解決ERROR 1030 (HY000): Got error 168 from storage engine apparmorErrorGoAPP
- PSQLException: ERROR: failed to find conversion function from unknown to charSQLExceptionErrorAIFunction
- Dynamics CRM Error- Creating Entity with an invalid parent. Entity: EmailErrorAI
- 報錯”ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)”Errorlocalhost
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- docker無法拉取(pull)映象Error response from daemonDockerError
- GTID複製報錯處理:Last_Error: Error 'Can't drop database 'test';ASTErrorDatabase
- 小程式 · 報錯:Error: errCode: -501007 ,errMsg: Invalid Key Name (__keyPath)Error
- MySQL主從複製報錯:Got fatal error 1236 from master when reading data fromMySqlGoErrorAST
- URL username 屬性
- Syntax Error: ValidationError: Invalid options object. Stylus Loader has been initialized using anErrorObjectZed
- Linux錯誤 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)LinuxErrorlocalhost
- Navicat tnt版本提示“failed to save password error code”的解決辦法AIError
- Error establishing a database connection 的解決方法(發現黑客入侵)ErrorDatabase黑客
- Kettle: pentaho-server-ce-9.4 : ERROR [SchemaUpdate] could not get database metadataServerErrorDatabase
- mysql 5.6.25報錯ERROR 1372 (HY000): Password hash 的一點思考MySqlError
- 解決Mysql:ERROR 1045 (28000):Access denied for user ‘root‘@‘localhost‘ (using password: NO)的方法MySqlErrorlocalhost