Re: EBS databse - Converting to Multi-tenant fails
Posted by satish on Dec 13, 2022; 6:31am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-databse-Converting-to-Multi-tenant-fails-tp11360p11365.html
Dear Erman,
Database is shut down. We started the db and ran violation check.These are the errors. Can we ignore these violations
QL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 13 11:56:07 2022
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected.
NAME CAUSE TYPE STATUS
---------- -------------------- ---------- ----------
MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------
PDB$SEED SQL Patch ERROR RESOLVED
Interim patch 29213893/24892880 (DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER$ TABLE): Installed in the CDB but not in the PD
B
PDB$SEED SQL Patch ERROR RESOLVED
Interim patch 34411846/24917919 (OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846)): Installed in the CDB but not in the PDB
PDB$SEED SQL Patch ERROR RESOLVED
'19.17.0.0.0 Release_Update 2209242240' is installed in the CDB but no release updates are installed in the PDB
SUPPDB Non-CDB to PDB WARNING PENDING
PDB plugged in is a non-CDB, requires noncdb_to_pdb.sql be run.
SUPPDB OPTION WARNING PENDING
Database option DV mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
SUPPDB OPTION WARNING PENDING
Database option OLS mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
SUPPDB OPTION WARNING PENDING
Database option OWM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
SUPPDB Parameter WARNING PENDING
CDB parameter shared_pool_reserved_size mismatch: Previous 40M Current 74658611
SUPPDB Parameter WARNING PENDING
CDB parameter temp_undo_enabled mismatch: Previous TRUE Current FALSE
SUPPDB Parameter WARNING PENDING
CDB parameter smtp_out_server mismatch: Previous 'relay.emailgov.in:465' Current 'relay.emailgov.in:4
*.sql92_security=TRUE
*.temp_undo_enabled=TRUE
*.undo_management=', 'AUTO''
10 rows selected.
[orasupp@erpsupportdb ~]$
Thanks,
Satish