DBaaS VM: Automatic Backups Failing With Error "DCS-10094:TDE wallet status is {0} instead of {1}Wallet Status not found as expected"
(Doc ID 2928455.1)
Last updated on FEBRUARY 20, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]Information in this document applies to any platform.
Symptoms
The automatic database backups are failing with an error
DCS Debug Log:
[2023-02-14 16:10:40,263] FINE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.commons.utils.CommonsUtils:
select wallet_type from v$encryption_wallet where UPPER(wrl_type) = 'FILE' and UPPER(status) like 'OPEN%' and rownum = 1 ;
[2023-02-14 16:10:40,263] FINE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.commons.utils.CommonsUtils:
exit ;
[2023-02-14 16:10:40,263] FINE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.commons.utils.CommonsUtils:
run: cmd= '[su,
oracle,
-c,
export NLS_LANG=AMERICAN;
export ORACLE_SID=xxxxxxxxxxxxxxxxxx;
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1;
export ORACLE_UNQNAME=xxxxxxxxxxxxxxxxxxxxxxxxxx;
/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/sqlplus -S -L -n / as sysdba @ /tmp/dcsserver/sqlplus/sqlplus2023-02-14_16-10-40-7994586386185705582.sql]'
[2023-02-14 16:10:40,564] FINE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.commons.utils.command.CommandExecutor: Return code: 0
[2023-02-14 16:10:40,564] FINE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.commons.utils.CommonsUtils: Output :
LOCAL_AUTOLOGIN
[2023-02-14 16:10:40,564] FINE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.agent.utils.db.SqlPlusHelper: Finished running Sql Script /tmp/dcsserver/sqlplus/sqlplus2023-02-14_16-10-40-7994586386185705582.sql
[2023-02-14 16:10:40,564] FINE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.agent.rpc.service.backup.BackupActions: wallet_type is LOCAL_AUTOLOGIN.
[2023-02-14 16:10:40,564] FINE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.agent.rpc.service.backup.BackupActions: Wallet status is not found as expected
[2023-02-14 16:10:40,564] SEVERE [Backup Validations : JobId=5efdb8e8-1e55-47fc-803f-fe403d86ff12] com.oracle.dcs.commons.jrpc.JsonRequestProcessor: RPC request invocation failed on request: {"classz":"******** "
DcsException{errorHttpCode=InternalError, msg=TDE wallet status is {0} instead of {1}Wallet Status not found as expected , msgId=10094, causedBy=null}
at com.oracle.dcs.commons.exception.DcsException$Builder.build(DcsException.java:69)
at com.oracle.dcs.agent.rpc.service.backup.BackupActions.checkWalletStatusForBackup(BackupActions.java:1526)
at com.oracle.dcs.agent.rpc.service.backup.BackupActions.validate12cTDEStatus(BackupActions.java:1428)
at com.oracle.dcs.agent.rpc.service.backup.BackupActions.validateDatabasebackup(BackupActions.java:1178)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
DCS Job Detail:
Error Code: DCS-10094
Cause: Invalid TDE Wallet status.
Action: Ensure the TDE Wallet status is valid as specified in the error message.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |