Unable to connect to PDB in Oracle 12.2
Unable to connect to PDB as a system in Oracle 12.2
Issue: When we are trying to connect as system user it is hanging forever and not allowing new connections. (No issues observed with existing application connections)
Error: Errors in alert log file
Errors in file
/u01/app/oracle/diag/rdbms/XXXXX/XXXXX/trace/xxxxx_ora_127384.trc:
ORA-04088: error during execution of trigger
'SYS.BLOCK_TOOLS_FROM_PROD'
ORA-00604: error occurred at recursive SQL level
1
ORA-20000: Development tools are not allowed
here.
ORA-06512: at line 13
2020-06-10 12:31:44.388000 +00:00
WARNING: CLMN has failed to cleanup a dead
process for 2400 attempts
2020-06-10 08:38:11.555000 +00:00
WARNING: CLMN has failed to cleanup a dead
process for 1000 attempts
Errors in file
/u01/app/oracle/diag/rdbms/xxxxx/xxxxx/trace/xxxxx_clmn_114254.trc
(incident=8918402) (PDBNAME=CDB$ROOT):
ORA-00700: soft internal error, arguments:
[ksuxdl: cleanup failures], [0x351C23FC0], [process], [1000], [0x34BDE7CC8],
[session], [601], [], [], [], [], []
Incident details in:
/u01/app/oracle/diag/rdbms/xxxxx/xxxxxx/incident/incdir_8918402/xxxxx_clmn_114254_i8918402.trc
Dumping diagnostic data in
directory=[cdmp_20200610083812], requested by (instance=1, osid=114254 (CLMN)),
summary=[incident=8918402].
Workaround: After restarting container database we were able to connect without any issues but issue recurring again after 3 days
Solution: We have raised Service request with oracle support and Support team confirmed that this is a bug 29794462.
Latest update from Oracle:
Latest update from Oracle:
Comments
Post a Comment