Cloud tools are not known to provide huge amount of details when you have an error.
In this case we were running patching prechecks which were failing with:
root@orava01vm01 ~]# dbaascli patch db prereq --patchid 32518631 --dbnames OEPMTDB
DBAAS CLI version 21.1.1.2.0
Executing command patch db prereq --patchid 32518631 --dbnames OEPMTDB
INFO: EXACS patching
INFO: number of nodes - 2
This might take some time, please take a look at file /var/opt/oracle/log/exadbcpatch/exadbcpatch.log for progress on local node
ERROR: errmsg seen is: [FATAL] [DBAAS-31009] - One or more Oracle patching pre-checks resulted in error conditions that needs to be addressed before proceeding: PDB plugin violation with status = PENDING
[root@orava01vm01 ~]#Checking log, se can see error was given while trying to execute “select status from pdb_plug_in_violations where type = ‘ERROR’ and status = ‘PENDING’ order by name, time;”
/var/opt/oracle/log/exadbcpatch/exadbcpatch_2021-06-17_09:49:00.953609239406.log:
2021-06-17 09:50:11.488809 - Completed in 0.292616844177246 seconds
2021-06-17 09:50:11.490421 - DEBUG: SQL Executing set hea off set pagesize 5000 set linesize 400 set newpage none set feedback off prompt =START= select status from pdb_plug_in_violations where type = 'ERROR' and status = 'PENDING' order by name, time; quit
2021-06-17 09:50:11.764123 - INFO: Pre patching PDB plugin violation with status = PENDING.
2021-06-17 09:50:11.764447 - [FATAL] [DBAAS-31038] - pdb violation encountered in precheck
CAUSE: pdb violation
ACTION: Verify the logs at and try again.
2021-06-17 09:50:11.764956 - [FATAL] [DBAAS-31009] - One or more Oracle patching pre-checks resulted in error conditions that needs to be addressed before proceeding: PDB plugin violation with status = PENDING, resolve it and try again.So lets try to run the same ourselves:
SQL> select status from pdb_plug_in_violations where type = 'ERROR' and status = 'PENDING' order by name, time;
select status from pdb_plug_in_violations where type = 'ERROR' and status = 'PENDING' order by name, time
*
ERROR at line 1:
ORA-01219: database or pluggable database not open: queries allowed on fixed
tables or views only
SQL>
INST HOST INST_NAME STATUS DB_ROLE OPEN_MODE STARTUP_TIME
---- ------------------ ---------- ---------- ----------------- --------------------- --------------------
*1 orava01vm01 OEPMTDB1 MOUNTED PHYSICAL STANDBY MOUNTED 28-MAY-2021 02:57:01
2 orava02vm01 OEPMTDB2 MOUNTED PHYSICAL STANDBY MOUNTED 28-MAY-2021 02:57:01
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 OESUPYMP MOUNTED
SQL>Ops! This is a standby in MOUNTED state.
Once DB was open in READ-ONLY, prechecks were OK.
Comments