Problem
创建Oracle数据库备份作业时,无法浏览Oracle 数据库实例,数据库状态显示“不可用”
Error Message
Oracle端调试日志:
4eec700 Tue Feb 9 15:20:09 2021 : OCISessionBegin() failed with database credentials.
4eec700 Tue Feb 9 15:20:09 2021 : OCI_ERROR: ORA-01017: invalid username/password; logon denied
4eec700 Tue Feb 9 15:20:09 2021 : Failed to logon to database, other error: Error code (0x3f9)
4eec700 Tue Feb 9 15:20:09 2021 : Returning E_RMAN_LOGON_OTHER error (0xe000100f)
4eec700 Tue Feb 9 15:20:09 2021 : OCIINTERCONNECT::LogonOracle: Logon is Unsuccessful
4eec700 Tue Feb 9 15:20:09 2021 : OCIInterconnect : Logon Failed. Error = -536866801
Cause
此问题发生于Oracle 群集环境, 需要重做数据库密码文件。
Solution
1.使用Oracle 官方KB,重做密码文件
Using ORAPWD
https://docs.oracle.com/cd/B28359_01/server.111/b28310/dba007.htm#ADMIN11059
Creating and Maintaining a Password File