EXACS:ADG setup fails with Errors "CDG-50101" and "ORA-65011: Pluggable database <PDBNMAE> does not exist"
(Doc ID 2888488.1)
Last updated on APRIL 19, 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
Facing the below issues while configuring the Active Data Gaurd through UI in Exacs.
//From dbaasapi_CONFIGURE_PRIMARY_2022-07-14_00_3A09_3A32.428983_138529.log
Use of uninitialized value in string eq at /var/opt/oracle/ocde/assistants/dg/dgcc line 108.
Invoke configureDG
configureDG
DG configuration stage set to : CONFIGURE_PRIMARY
initDGParams
Tools Directory : /var/opt/oracle/odgda
Calling setup_prereq
setup_prereq
Check VM status
VM Status Check completed with : 1
INFO: node_name : <Node1> instance_name : <CDBINST_1>
INFO: node_name : <Node2> instance_name : <CDBINST_2>
Invoke Create DG
createDG
Configure DG returned :
Failed to configure DG</out>
</exe>
2022-07-14 00:32:01.055350 -
CDG-50101 : DataGuard provisioning failed at stage configure primary>>>>>>>>>>>>>>>>>>>>>>>>
Check / Verify the JSON used for configure primary stage
File: dg_api, Line#: 782, Log: /var/opt/oracle/log/CDBERP/dbaasapi/db/dg/dbaasapi_CONFIGURE_PRIMARY_2022-07-14_00:09:32.428983_138529.log
2022-07-14 00:32:01.060267 - INFO: corereg: dela: Delete dg_connect_aliases
2022-07-14 00:32:01.060397 - INFO: corereg: dela: Delete dg_data_grp
2022-07-14 00:32:01.060475 - INFO: corereg: dela: Delete dg_dbname
2022-07-14 00:32:01.062452 - $VAR1 = [
'alter system set log_archive_config=\'\' scope=both sid=\'*\''
];
2022-07-14 00:32:01.063945 - DEBUG: SQL Executing set hea off set pagesize 5000 set linesize 400 set newpage none set feedback off prompt =START= alter system set log_archive_config='' scope=both sid='*'; quit
2022-07-14 00:32:01.897633 - _cleanupOnError: Cleaned the system for stage: 'CONFIGURE_PRIMARY'
2022-07-14 00:32:01.898377 -
CDG-50101 : DataGuard provisioning failed at stage CONFIGURE_PRIMARY>>>>>>>>>>>>>>>>
Please refer accompanying errors for failure
File: dg_api, Line#: 532, Log: /var/opt/oracle/log/CDBERP/dbaasapi/db/dg/dbaasapi_CONFIGURE_PRIMARY_2022-07-14_00:09:32.428983_138529.log
2022-07-14 00:32:01.898587 - CDG-50101 : DataGuard provisioning failed at stage CONFIGURE_PRIMARY
Please refer accompanying errors for failure
2022-07-14 00:32:01.899700 - Updating status of txn 7f276401-66c2-40f6-9762-925a4e4231bf { status => Failed, msg => 1, errmsg => CDG-50101 : DataGuard provisioning failed at stage CONFIGURE_PRIMARY
Please refer accompanying errors for failure
}
//From dgdeployer_2022-07-14_00:09:50.385492142750.log
022-07-14 00:10:34.435549 - cmd took 0.00545287132263184 seconds
2022-07-14 00:10:34.437142 - WARNING: corereg: get: No value found for key mdbcs_sla
2022-07-14 00:10:34.467273 - Output from cmd /<DBHOME>/bin/srvctl stop service -d <CDBNAME> -s <CDBNAME>_ser run on localhost is:
2022-07-14 00:10:34.966914 - PRCD-1316 : failed to stop services <CDBNAME>_ser for database <CDBNAME>
PRCD-1132 : Database <CDBNAME> does not have defined services: <CDBNAME>_ser
2022-07-14 00:10:34.967148 - cmd took 0.499316930770874 seconds
2022-07-14 00:10:34.967295 - WARN : non-zero status returned
Command: /<DBHOME>/bin/srvctl stop service -d <CDBNAME> -s <CDBNAME>_ser
Exit: 1
Excerpt:
PRCD-1316 : failed to stop services <CDBNAME>_ser for database <CDBNAME>
PRCD-1132 : Database <CDBNAME> does not have defined services: <CDBNAME>_ser
2022-07-14 00:10:34.971319 - Output from cmd /<DBHOME>/bin/srvctl remove service -d <CDBNAME> -s <CDBNAME>_ser run on localhost is:
2022-07-14 00:10:35.475257 - PRCR-1001 : Resource ora.<CDBNAME>.<CDBNAME>_ser.svc does not exist
2022-07-14 00:10:35.475485 - cmd took 0.503575086593628 seconds
2022-07-14 00:10:35.475631 - WARN : non-zero status returned
Command: /<DBHOME>/bin/srvctl remove service -d <CDBNAME> -s <CDBNAME>_ser
Exit: 1
Excerpt:
PRCR-1001 : Resource ora.<CDBNAME>.<CDBNAME>_ser.svc does not exist
2022-07-14 00:10:35.479864 - Output from cmd /<DBHOME>/bin/srvctl add service -d <CDBNAME> -s <CDBNAME>_ser -r <CDBNAME>1,<CDBNAME>2 -l PRIMARY -q TRUE -e SESSION -m BASIC -w 10 -z 150 run on localhost is:
2022-07-14 00:10:36.551928 - cmd took 1.07171106338501 seconds
2022-07-14 00:10:36.552388 - Output from cmd /bin/hostname -f run on localhost is:
2022-07-14 00:10:36.557789 - <Node1>.db.pprd.oraclevcn.com
2022-07-14 00:10:36.557928 - cmd took 0.00520610809326172 seconds
2022-07-14 00:10:36.561197 - Try [1/6]: Output from cmd /<DBHOME>/bin/srvctl start service -d <CDBNAME> -s <CDBNAME>_ser run on localhost is:
2022-07-14 00:10:37.797765 - cmd took 1.23614907264709 seconds
2022-07-14 00:10:37.802690 - Output from cmd /<DBHOME>/bin/srvctl stop service -d <CDBNAME> -s <CDBNAME>_ser_ro run on localhost is:
2022-07-14 00:10:38.320371 - PRCD-1316 : failed to stop services <CDBNAME>_ser_ro for database <CDBNAME>
PRCD-1132 : Database <CDBNAME> does not have defined services: <CDBNAME>_ser_ro
2022-07-14 00:10:38.320543 - cmd took 0.517361879348755 seconds
2022-07-14 00:10:38.320660 - WARN : non-zero status returned
Command: /<DBHOME>/bin/srvctl stop service -d <CDBNAME> -s <CDBNAME>_ser_ro
Exit: 1
Excerpt:
PRCD-1316 : failed to stop services <CDBNAME>_ser_ro for database <CDBNAME>
PRCD-1132 : Database <CDBNAME> does not have defined services: <CDBNAME>_ser_ro
2022-07-14 00:10:38.324321 - Output from cmd /<DBHOME>/bin/srvctl remove service -d <CDBNAME> -s <CDBNAME>_ser_ro run on localhost is:
2022-07-14 00:10:38.831309 - PRCR-1001 : Resource ora.<CDBNAME>.<CDBNAME>_ser_ro.svc does not exist
2022-07-14 00:10:38.831502 - cmd took 0.506668090820312 seconds
2022-07-14 00:10:38.831655 - WARN : non-zero status returned
Command: /<DBHOME>/bin/srvctl remove service -d <CDBNAME> -s <CDBNAME>_ser_ro
Exit: 1
Excerpt:
PRCR-1001 : Resource ora.<CDBNAME>.<CDBNAME>_ser_ro.svc does not exist>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2022-07-14 00:10:38.835458 - Output from cmd /<DBHOME>/bin/srvctl add service -d <CDBNAME> -s <CDBNAME>_ser_ro -r <CDBNAME>1,<CDBNAME>2 -l PHYSICAL_STANDBY -q TRUE -e SESSION -m BASIC -w 10 -z 150 run on localhost is:
2022-07-14 00:10:39.751952 - cmd took 0.916182994842529 seconds
2022-07-14 00:10:39.752386 - Output from cmd /bin/hostname -f run on localhost is:
2022-07-14 00:10:39.758555 - <Node1>.db.pprd.oraclevcn.com
2022-07-14 00:10:39.758669 - cmd took 0.00596904754638672 seconds
2022-07-14 00:10:39.762092 - Try [1/6]: Output from cmd /<DBHOME>/bin/srvctl start service -d <CDBNAME> -s <CDBNAME>_ser_ro run on localhost is:
2022-07-14 00:10:40.515051 - cmd took 0.752501010894775 seconds
2022-07-14 00:10:40.520078 - Output from cmd /<DBHOME>/bin/srvctl stop service -d <CDBNAME> -s <CDBNAME>_ser_ro run on localhost is:
2022-07-14 00:10:41.207746 - cmd took 0.687321901321411 seconds
2022-07-14 00:10:41.212746 - Output from sql alter system switch logfile is:
2022-07-14 00:10:41.215923 - 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= alter system switch logfile; quit
2022-07-14 00:10:41.661209 - Completed in 0.448416948318481 seconds
2022-07-14 00:10:44.666528 - Output from cmd /<DBHOME>/bin/srvctl stop service -d <CDBNAME> -s tmagerp_dg run on localhost is:
2022-07-14 00:10:45.278892 - PRCD-1316 : failed to stop services tmagerp_dg for database <CDBNAME>
PRCD-1132 : Database <CDBNAME> does not have defined services: tmagerp_dg>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2022-07-14 00:10:45.279100 - cmd took 0.611947059631348 seconds
2022-07-14 00:10:45.279261 - WARN : non-zero status returned
Command: /<DBHOME>/bin/srvctl stop service -d <CDBNAME> -s tmagerp_dg
Exit: 1
Excerpt:
PRCD-1316 : failed to stop services tmagerp_dg for database <CDBNAME>
PRCD-1132 : Database <CDBNAME> does not have defined services: tmagerp_dg
2022-07-14 00:10:45.284459 - Output from cmd /<DBHOME>/bin/srvctl remove service -d <CDBNAME> -s tmagerp_dg run on localhost is:
2022-07-14 00:10:45.792196 - PRCR-1001 : Resource ora.<CDBNAME>.tmagerp_dg.svc does not exist
2022-07-14 00:10:45.792392 - cmd took 0.507450103759766 seconds
2022-07-14 00:10:45.792518 - WARN : non-zero status returned
Command: /<DBHOME>/bin/srvctl remove service -d <CDBNAME> -s tmagerp_dg
Exit: 1
Excerpt:
PRCR-1001 : Resource ora.<CDBNAME>.tmagerp_dg.svc does not exist
2022-07-14 00:10:45.796867 - Output from cmd /<DBHOME>/bin/srvctl add service -d <CDBNAME> -s tmagerp_dg -r <CDBNAME>1,<CDBNAME>2 -l PRIMARY -q TRUE -e SESSION -m BASIC -w 10 -z 150 -pdb tmagerp run on localhost is:
2022-07-14 00:10:47.001823 - cmd took 1.20461702346802 seconds
2022-07-14 00:10:47.002315 - Output from cmd /bin/hostname -f run on localhost is:
2022-07-14 00:10:47.010132 - <Node1>.db.pprd.oraclevcn.com
2022-07-14 00:10:47.010398 - cmd took 0.00746393203735352 seconds
2022-07-14 00:10:47.015787 - Try [1/6]: Output from cmd /<DBHOME>/bin/srvctl start service -d <CDBNAME> -s tmagerp_dg run on localhost is:
2022-07-14 00:10:47.778427 - PRCD-1133 : failed to start services tmagerp_dg for database <CDBNAME>
PRCR-1095 : Failed to start resources using filter ((NAME == ora.<CDBNAME>.tmagerp_dg.svc) AND (TYPE == ora.service.type))
CRS-5017: The resource action "ora.<CDBNAME>.tmagerp_dg.svc start" encountered the following error:
ORA-65011: Pluggable database TMAGERP does not exist.>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
. For details refer to "(:CLSN00107:)" in "/<ORABASE>/diag/crs/<Node2>/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.<CDBNAME>.tmagerp_dg.svc' on '<Node2>' failed
CRS-5017: The resource action "ora.<CDBNAME>.tmagerp_dg.svc start" encountered the following error:
ORA-65011: Pluggable database TMAGERP does not exist.>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
. For details refer to "(:CLSN00107:)" in "/<ORABASE>/diag/crs/<Node1>/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.<CDBNAME>.tmagerp_dg.svc' on '<Node2>' failed
CRS-2632: There are no more servers to try to place resource 'ora.<CDBNAME>.tmagerp_dg.svc' on that would satisfy its placement policy
$VAR1 = bless( {
'observer_ip_records' => '/var/opt/oracle/dg/obs_ip_records.json',
'db' => bless( {
'sid' => '<CDBNAME>1',
'version' => undef,
'mversion' => undef,
'node' => undef,
'dbname' => '<CDBNAME>',
'oh' => '/u02/app/oracle/product/19.0.0.0/dbhome_1',
'user' => 'oracle',
'creg' => bless( {
'rfile' => '/var/opt/oracle/creg/<CDBNAME>.ini',
'rfile_tmp' => '/var/opt/oracle/log/reg_tmp_files/creg_<CDBNAME>.ini.tmp',
'use_grid' => 0,
QL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 <pdbname> READ WRITE NO>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>lower case.
SQL> show parameter case
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_pdb_name_case_sensitive boolean TRUE >>>>>>>>>>>>>>>> this is true and can connect with ""
sec_case_sensitive_logon boolean FALSE
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 |