Hi Team,
I have Oracle 19c database running in Microsoft windows 2018 server. I have 15 PDBs running with no issues. I have recently patched this database with April 2023 patchset. But yesterday while I tried to create one PDB it failed with following error.
ORA-65010: maximum number of pluggable databases created
My max_pdbs is set to 25 but still failing with the same error while I tried to issue following command,
CREATE PLUGGABLE DATABASE Reporting_PRD_IR_RPT FROM Reporting_LIVE
PATH_PREFIX = 'D:\ORACLE\ORADATA\Reporting_PRD_IR_RPT'
FILE_NAME_CONVERT = ('D:\ORACLE\ORADATA\Reporting_PRD_IR_RPT', 'D:\Oracle\oradata\Reporting_LIVE')
SERVICE_NAME_CONVERT = ('Reporting_LIVE','Reporting_PRD_IR_RPT')
LOGGING;
The same script was running without any issue hundreds times but now all of sudden it is failing with ORA-65010.
Any suggestion how can it be fixed?
Thank you for your help in advance!
Ram