My Oracle Support Banner

[OCI] Recovery Failed by DCS-10001:Internal error encountered: Failed to run sql in method : mountDatabaseAndRestoreSpAndControlFileOnErr (Doc ID 2657113.1)

Last updated on JUNE 01, 2020

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

At OCI DB system, recovery job failed as following:

[root@<hostname> opc]# /opt/oracle/dcs/bin/dbcli describe-job -i <Recovery Failed JOB ID>

Job details
----------------------------------------------------------------
ID: <Recovery Failed JOB ID>
Description: Create recovery-latest for db : <DB Name>
Status: Failure
Created: March 17, 2020 6:48:44 AM UTC
Message: DCS-10001:Internal error encountered: Failed to run sql in method : mountDatabaseAndRestoreSpAndControlFileOnErr.Failed to mount database:<DB Name>

DCS debug agent log shown:

2020-03-17 06:50:22,350 DEBUG [Database recovery : JobId=<JOB ID>] [] c.o.d.c.u.CommonsUtils: Output :
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
......
! com.oracle.dcs.commons.exception.DcsException: DCS-10001:Internal error encountered: Failed to run sql in method : mountDatabaseAndRestoreSpAndControlFileOnErr.Failed to mount database:<DB Name>

Changes

Deprecated parameter set.

2020-02-19T10:00:52.662559+00:00
ALTER SYSTEM SET sec_case_sensitive_logon=FALSE SCOPE=BOTH;

 

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
Changes
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.