My Oracle Support Banner

EXACS:ADG Configuration fails with errors "CDG-50102" and "ORA-27106: system pages not available to allocate memory" (Doc ID 2888468.1)

Last updated on APRIL 29, 2024

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Information in this document applies to any platform.

Symptoms

 //From dgdeployer_2022-07-20_03_41_21.147524355925.log

2022-07-20 03:42:11.458662 - cmd took 0.0189590454101562 seconds^M
2022-07-20 03:42:11.459646 - WARNING: corereg: get: No value found for key mdbcs_sla^M
2022-07-20 03:42:11.563850 - cmd took 3.19933891296387 seconds^M
2022-07-20 03:42:11.564088 - INFO: NO of retries = 1^M
^M
2022-07-20 03:42:11.564212 - INFO: exec_on_node end:^M
^M
2022-07-20 03:42:11.564486 - INFO: Tnsnames.ora generated^M
2022-07-20 03:42:11.564630 - INFO: Starting database duplication^M
^M
2022-07-20 03:42:11.564795 - INFO: exec_on_standbys :^M
^M
2022-07-20 03:42:11.565336 - INFO: exec_on_node <node1>.oraclevcn.com start:^M
^M
2022-07-20 03:42:11.565700 - Output from cmd /bin/hostname -f run on localhost is:^M
2022-07-20 03:42:11.574092 - <node1>.oraclevcn.com^M
2022-07-20 03:42:11.574239 - cmd took 0.00815105438232422 seconds^M
2022-07-20 03:42:11.574546 - Output from cmd /bin/su -- opc -c '/bin/sudo /var/opt/oracle/ocde/assistants/dg/lib/dgrops duplicate_db <CDBNAME> rac /var/opt/oracle/dbaas_acfs/dgtmp_<CDBNAME>/dgparams.json' run on localhost is:^M
2022-07-20 03:42:23.512677 - CDG-50104 : DataGuard Configuration failed for <CDBNAME>_xsr_iad^M
Auxiliary database startup failed^M>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
File: dgdb, Line#: 1468, Log: /var/opt/oracle/log/<CDBNAME>/dgrops/dgrops_duplicate_db_2022-07-20_03:42:12.113491364280.log^M
...caught at /var/opt/oracle/ocde/assistants/dg/lib/dgrops line 97.^M
2022-07-20 03:42:12.125446 -^M

2022-07-20 03:42:18.129328 - Output from cmd /bin/chown oracle:oinstall /var/opt/oracle/dbaas_acfs/<CDBNAME>/<CDBNAME>_xsr_iad_pfile.ora run on localhost is:^M
2022-07-20 03:42:18.140197 - cmd took 0.0105910301208496 seconds^M
2022-07-20 03:42:18.141020 - Output from sql $VAR1 = [^M
'create spfile from pfile=\'/var/opt/oracle/dbaas_acfs/<CDBNAME>/<CDBNAME>_xsr_iad_pfile.ora\'',^M
'startup nomount'^M
];^M
is:^M
2022-07-20 03:42:18.144505 - 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/<CDBNAME>/<CDBNAME>_xsr_iad_pfile.ora'; startup nomount; quit^M
2022-07-20 03:42:23.397873 - ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance^M
ORA-27106: system pages not available to allocate memory^M>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Additional information: 6187^M
Additional information: 2^M
Additional information: 7^M
2022-07-20 03:42:23.398091 - Completed in 5.25716805458069 seconds^M
2022-07-20 03:42:23.398219 - sql execution failed:^M
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance^M
ORA-27106: system pages not available to allocate memory2022-07-20 03:42:23.401601 - INFO: dgdb: duplicate_db could not start the db for instantiation$VAR1 = [^M>>>>>>>>>>>>>>>>>
'ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance',^M
'ORA-27106: system pages not available to allocate memory'>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
];^M

CDG-50104 : DataGuard Configuration failed for <CDBNAME>_xsr_iad^M
Auxiliary database startup failed^M>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
File: dgdb, Line#: 1468, Log: /var/opt/oracle/log/<CDBNAME>/dgrops/dgrops_duplicate_db_2022-07-20_03:42:12.113491364280.log^M
2022-07-20 03:42:23.513359 - cmd took 11.9376430511475 seconds^M
2022-07-20 03:42:23.513676 - WARN : non-zero status returned^M
Command: /bin/su -- opc -c '/bin/sudo /var/opt/oracle/ocde/assistants/dg/lib/dgrops duplicate_db <CDBNAME> rac /var/opt/oracle/dbaas_acfs/dgtmp_<CDBNAME>/dgparams.json'^M
Exit: 1^M
Excerpt:^M
CDG-50104 : DataGuard Configuration failed for <CDBNAME>_xsr_iad^M
Auxiliary database startup failed^M
File: dgdb, Line#: 1468, Log: /var/opt/oracle/log/<CDBNAME>/dgrops/dgrops_duplicate_db_2022-07-20_03:42:12.113491364280.log^M
(...)^M
CDG-50104 : DataGuard Configuration failed for <CDBNAME>_xsr_iad^M
Auxiliary database startup failed^M
File: dgdb, Line#: 1468, Log: /var/opt/oracle/log/<CDBNAME>/dgrops/dgrops_duplicate_db_2022-07-20_03:42:12.113491364280.log^M
2022-07-20 03:42:28.514406 - INFO: NO of retries = 1^M
^M
2022-07-20 03:42:28.514553 - INFO: exec_on_node end:^M
^M
2022-07-20 03:42:28.515077 -^M
CDG-50102 : <CDBNAME> Database not ready for DG Configuration
ERROR: Error in creation of standby database>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
File: dgdeployer, Line#: 204, Log: /var/opt/oracle/log/<CDBNAME>/dgdeployer/dgdeployer_2022-07-20_03:41:21.147524355925.log^M
2022-07-20 03:42:28.515214 - INFO: ====== RESTORING TNSNAMES & LISTENER DUE TO FAILURES IN DG CONFIG ======^M

 

 

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


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