Data guard association fails with 'ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance'
(Doc ID 2863857.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Gen 2 Exadata Cloud at Customer - Version All Versions to All Versions [Release All Releases]Information in this document applies to any platform.
Symptoms
Data guard association fails from console.
Logs show that the failure was during startup of standby instance during creation
2022-04-12 16:25:28.741130 - Output from sql $VAR1 = [
'create spfile from pfile=\'/var/opt/oracle/dbaas_acfs/cdbpa121/cdbdr121_pfile.ora\'',
'startup nomount'
];
is:
2022-04-12 16:25:28.743158 - DEBUG: SQL Executing set hea off set pagesize 5000 set linesize 400 set newpage none set feedback off set define off set verify off prompt =START= create spfile from pfile='/var/opt/oracle/dbaas_acfs/cdbpa121/cdbdr121_pfile.ora'; startup nomount; quit
2022-04-12 16:25:39.309839 - ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 7969177600 bytes
Fixed Size 2943168 bytes
Variable Size 1476396864 bytes
Database Buffers 4613734400 bytes
Redo Buffers 282267648 bytes
In-Memory Area 1593835520 bytes
2022-04-12 16:25:39.309969 - Completed in 10.5689249038696 seconds
2022-04-12 16:25:39.310027 - sql execution failed:
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance2022-04-12 16:25:39.311795 - INFO: dgdb: duplicate_db could not start the db for instantiation$VAR1 = [
'ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance'
];
$VAR1 = bless( {
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 |