Re: EBS databse - Converting to Multi-tenant fails

Posted by satish on Dec 13, 2022; 6:05am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-databse-Converting-to-Multi-tenant-fails-tp11360p11364.html

Dear Erman,

Thanks for the update. Check for PDB violation failed. We are knocking our heads to understand what is wrong here. We raised SR but no progress.

[orasupp@erpsupportdb appsutil]$ cd $ORACLE_HOME/appsutil
[orasupp@erpsupportdb appsutil]$ . ./txkSetCfgCDB.env dboraclehome=$ORACLE_HOME

Oracle Home being passed: /u01/SUPPDB/19.3.0
[orasupp@erpsupportdb appsutil]$ export ORACLE_SID=suppcdb
[orasupp@erpsupportdb appsutil]$ cd $ORACLE_HOME/appsutil/bin
[orasupp@erpsupportdb bin]$ perl txkChkPDBCompatability.pl -dboraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -cdbsid=suppcdb -pdbsid=SUPPDB -servicetype=onpremise


Script Name    : txkChkPDBCompatability.pl
Script Version : 120.0.12020000.10
Started        : Tue Dec 13 10:01:57 IST 2022

Log File       : /u01/SUPPDB/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Tue_Dec_13_10_01_57_2022/txkChkPDBCompatability.log


-----------
Values used
-----------
Database Oracle Home    : /u01/SUPPDB/19.3.0
CDB SID                 : suppcdb
PDB SID                 : SUPPDB
OUT Directory           : /u01/SUPPDB/19.3.0/appsutil/log
Service Type            : onpremise




=========================
Validating oracle home...
=========================
Oracle Home: /u01/SUPPDB/19.3.0 exists.


===========================
Validating out directory...
===========================
Oracle Home: /u01/SUPPDB/19.3.0/appsutil/log exists.


=============================
Validating DB service type...
=============================
Service Type: onpremise
Service type is valid.


============================
Inside setFileLocations()...
============================
PDB_DESC_XML: /u01/SUPPDB/19.3.0/dbs/SUPPDB_PDBDesc.xml


**** Setting ORACLE_SID to suppcdb




========================
Inside getDBVersion()...
========================
DB_VERSION = db190



=================================
Inside checkPDBCompatibility()...
=================================
File /u01/SUPPDB/19.3.0/dbs/SUPPDB_PDBDesc.xml exists.
Generating SQL file : /u01/SUPPDB/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Tue_Dec_13_10_01_57_2022/create_pdb_compatible.sql
SQL output file     : /u01/SUPPDB/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Tue_Dec_13_10_01_57_2022/create_pdb_compatible.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...

==============================
Inside searchFileContents()...
==============================
log_file: /u01/SUPPDB/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Tue_Dec_13_10_01_57_2022/create_pdb_compatible.out
pattern: ERROR
================
Pattern found...
================
EXIT STATUS: 1
PDB compatability check did not go through successfully.
LOG FILE: /u01/SUPPDB/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Tue_Dec_13_10_01_57_2022/create_pdb_compatible.out.
*******FATAL ERROR*******
PROGRAM : (txkChkPDBCompatability.pl)
TIME    : Tue Dec 13 10:01:59 2022
FUNCTION: main::checkPDBCompatibility [ Level 1 ]
ERRORMSG: PDB compatability check did not go through successfully.

[orasupp@erpsupportdb ~]$


Thanks,
Satish