My Oracle Support Banner

[OCI] DV: Launch from Backup Failed: DCS-10001:Internal error encountered: Failed to run SQL script: <ORACLE_HOME>/utlpwdmg.sql (Doc ID 2859722.1)

Last updated on APRIL 11, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On an Oracle Database Vault enabled OCI DB system environment, launching from backup failed as following.

For gathering the DCS agent log, dbcli output, the VM should be reachable. Since no IP address was assigned for this case so please file a SR to Oracle Support to get the IP address from backend.

# /opt/oracle/dcs/bin/dbcli list-jobs

ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
......
<JOB_ID> Database service recovery with db name: <DB Name> Wednesday, November 10, 2021, 16:04:06 JST Failure

# /opt/oracle/dcs/bin/dbcli describe-job -i <JOB_ID>

Job details
----------------------------------------------------------------
ID: <JOB_ID>
Description: Database service recovery with db name: <DB Name>
Status: Failure
Created: November 10, 2021 4:04:06 PM JST
Progress: 87%
Message: DCS-10001:Internal error encountered: Failed to run SQL script: <ORACLE_HOME>/utlpwdmg.sql. ********
Cause: This is an internal error.
Action: Contact Oracle Support Services for assistance.

Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Restore Database November 10, 2021 4:04:42 PM JST November 10, 2021 6:03:45 PM JST Failure
Restore Database November 10, 2021 4:04:42 PM JST November 10, 2021 6:03:45 PM JST Failure
Restore Database November 10, 2021 4:04:42 PM JST November 10, 2021 6:03:45 PM JST Failure
Prepare DB System for Restore November 10, 2021 4:04:42 PM JST November 10, 2021 4:10:23 PM JST Success
Configure TDE November 10, 2021 4:10:23 PM JST November 10, 2021 4:10:40 PM JST Success
Restore Database November 10, 2021 4:10:40 PM JST November 10, 2021 5:59:35 PM JST Success
Mounting db November 10, 2021 4:12:43 PM JST November 10, 2021 4:13:03 PM JST Success
Register Database November 10, 2021 5:59:35 PM JST November 10, 2021 6:03:45 PM JST Failure
Register Database taskflow November 10, 2021 5:59:35 PM JST November 10, 2021 6:03:45 PM JST Failure
Update Database Password Profile November 10, 2021 6:03:41 PM JST November 10, 2021 6:03:43 PM JST Failure

 

DCS agent log shown ORA-47400 occurred while implementing ALTER PROFILE.

[2021-11-10 18:03:42,822] FINE [Update Database Password Profile :
JobId=<JOB_ID>]
com.oracle.dcs.commons.utils.CommonsUtils:
@@<ORACLE_HOME>/rdbms/admin/utlpwdmg.sql ********
[2021-11-10 18:03:42,822] FINE [Update Database Password Profile :
JobId=<JOB_ID>]
com.oracle.dcs.commons.utils.CommonsUtils:
exit ;

[2021-11-10 18:03:42,822] FINE [Update Database Password Profile :
......

[2021-11-10 18:03:43,580] FINE [Update Database Password Profile :
JobId=<JOB_ID>]
com.oracle.dcs.commons.utils.command.CommandExecutor: Return code: 0
[2021-11-10 18:03:43,581] FINE [Update Database Password Profile :
JobId=<JOB_ID>]
com.oracle.dcs.commons.utils.CommonsUtils: Output :
ALTER PROFILE DEFAULT LIMIT
*
ERROR at line 1:
ORA-47400: Command Rule violation for ALTER PROFILE on DEFAULT

 

 

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.