Create PDB Descriptor Failed
Locked
 
|
Hi Support,
I have successfully upgraded EBS 12.2 database from 12.1.0.2 to 19c(19.3). As per the Note ID 2552181.1 i am executing txkOnPremPrePDBCreationTasks.pl to create the PDB descriptor and its failed with below error. Please provide fix for the below: [oracle@1227demo ~]$ cd $ORACLE_HOME/appsutil [oracle@1227demo appsutil]$ pwd /u01/oracle/db/tech_st/19.3.0.0/appsutil [oracle@1227demo appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/u01/oracle/db/tech_st/19.3.0.0 Oracle Home being passed: /u01/oracle/db/tech_st/19.3.0.0 [oracle@1227demo appsutil]$ export ORACLE_SID=R1227 [oracle@1227demo appsutil]$ cd $ORACLE_HOME/appsutil/bin [oracle@1227demo bin]$ perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -appsuser=apps -dbsid=R1227 Enter the APPS Password: Script Name : txkOnPremPrePDBCreationTasks.pl Script Version : 120.0.12020000.13 Started : Sun Aug 30 01:19:01 +04 2020 Log File : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/txkOnPremPrePDBCreationTasks.log ----------- Values used ----------- DB Oracle Home : /u01/oracle/db/tech_st/19.3.0.0 OUT Directory : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log Skip DB shutdown : No EBS SID : R1227 APPS Schema Username : apps Is RAC? : No Logical Hostname : ========================= Validating oracle home... ========================= Oracle Home: /u01/oracle/db/tech_st/19.3.0.0 exists. =========================== Validating out directory... =========================== Out directory: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log exists. ============================ Inside getDBHostDetails()... ============================ DB Hostname : 1227demo DB Domain : energy-esi-dubai.com Logical hostname is not passed, hence using physical hostname details. Logical hostname: demo.energy-esi.com ========================== Inside setContextName()... ========================== CONTEXT_NAME: R1227_1227demo ============================ Inside setFileLocations()... ============================ ===================== Inside getDBName()... ===================== Generating SQL file : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/get_db_name.sql SQL output file : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/get_db_name.out Spool File : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/spool_get_db_name.log ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/get_db_name.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/get_db_name.out pattern: ERROR ============================= Could not find the pattern... ============================= Removing the file: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/get_db_name.sql EXIT STATUS: 0 Getting the value of DB Name... db_name: R1227 PDB_DESC_XML: /u01/oracle/db/tech_st/19.3.0.0/dbs/R1227_PDBDesc.xml INITPARAM_FILE: /u01/oracle/db/tech_st/19.3.0.0/dbs/R1227_initparam.sql DATATOP_FILE: /u01/oracle/db/tech_st/19.3.0.0/dbs/R1227_datatop.txt ======================== Inside getDBVersion()... ======================== DB_VERSION = db190 ============================ Shutting down the database... ============================= Shutdown mode : IMMEDIATE Generating SQL file : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/shutdown_IMMEDIATE.sql SQL output file : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/shutdown_IMMEDIATE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/shutdown_IMMEDIATE.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/shutdown_IMMEDIATE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/shutdown_IMMEDIATE.out. ======================= Starting the database... ======================== Startup mode : MOUNT Generating SQL file : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/startup_MOUNT.sql SQL output file : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/startup_MOUNT.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/startup_MOUNT.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/startup_MOUNT.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/startup_MOUNT.out. ================================= Inside createPDBDescriptorXML()... ================================== ================================= Inside backupPDBDescriptorXML()... ================================== File /u01/oracle/db/tech_st/19.3.0.0/dbs/R1227_PDBDesc.xml does not exist. File /u01/oracle/db/tech_st/19.3.0.0/dbs/R1227_PDBDesc.xml does not exist. Generating SQL file : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/create_pdb_desc_xml.sql SQL output file : /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/create_pdb_desc_xml.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/create_pdb_desc_xml.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/create_pdb_desc_xml.out pattern: ERROR ================ Pattern found... ================ EXIT STATUS: 1 PDB Descriptor XML creation did not go through successfully. LOG FILE: /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/create_pdb_desc_xml.out. *******FATAL ERROR******* PROGRAM : (txkOnPremPrePDBCreationTasks.pl) TIME : Sun Aug 30 01:19:48 2020 FUNCTION: main::createPDBDescriptorXML [ Level 1 ] ERRORMSG: PDB Descriptor XML creation did not go through successfully. *******FATAL ERROR******* PROGRAM : (txkOnPremPrePDBCreationTasks.pl) TIME : Sun Aug 30 01:19:48 2020 FUNCTION: main::createPDBDescriptorXML [ Level 1 ] ERRORMSG: PDB Descriptor XML creation did not go through successfully. [oracle@1227demo admin]$ vi /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/create_pdb_desc_xml.out SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 30 01:19:47 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected. alter database open read only * ERROR at line 1: ORA-01507: database not mounted BEGIN DBMS_PDB.DESCRIBE(pdb_descr_file => '/u01/oracle/db/tech_st/19.3.0.0/dbs/R1227_PDBDesc.xml'); END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_PDB.DESCRIBE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 |
Re: Create PDB Descriptor Failed
Administrator
|
I think you encountered a problem during startup mount.
What is written in u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/startup_MOUNT.out file? |
Re: Create PDB Descriptor Failed
|
|
Hi,
The mount.out file written the below. I have fixed it by removing the restore point which i was created before the upgrade of the database. Fix is shown below for our followers. $vi /u01/oracle/db/tech_st/19.3.0.0/appsutil/log/TXK_PRE_PDB_Sun_Aug_30_01_18_17_2020/startup_MOUNT.out SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 30 01:19:34 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. ORACLE instance started. Total System Global Area 6442448984 bytes Fixed Size 8910936 bytes Variable Size 2248146944 bytes Database Buffers 4160749568 bytes Redo Buffers 24641536 bytes ORA-38880: Cannot advance compatibility from 12.1.0.2.0 to 19.0.0.0.0 due to guaranteed restore points Fix: ---- -- Set to the old existing compatible. SQL> alter system set compatible='12.1.0.2.0' scope=spfile; SQL> startup force; --Check the flashback restore point and drop it: select GUARANTEE_FLASHBACK_DATABASE,NAME from v$restore_point; GUA NAME --- --------------- YES CLEAN_DATABASE select flashback_On from v$database; FLASHBACK_ON ------------------ YES alter database flashback off; SQL> select flashback_On from v$database; FLASHBACK_ON ------------------ RESTORE POINT ONLY drop restore point CLEAN_DATABASE; select flashback_On from v$database; FLASHBACK_ON ------------------ NO --Now update the compatible parameter in spfile and restart SQL> alter system set compatible='19.0.0' scope=spfile; SQL> startup force; SQL> create pfile from spfile; Karthik. |
Re: Create PDB Descriptor Failed
|
Administrator
|
:) Good. So your problem is solved, right?
|
Re: Create PDB Descriptor Failed
|
|
Yes resolved. Thanks for your help in fixing :) On Tue, 1 Sep 2020 at 10:25 AM ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:
Kind Regards... ? Karthik Rao | Oracle Database Administrator Pharmatrade LLC P.O.Box 11397 | Plot No.598-1177 Dubai Investment Park 1 | Jebel Ali|Dubai, UAE E-Mail: [hidden email] Tel. +971 4 8991189 Fax. +971 4 8849234 Mob: -- “You only live once, but if you do it right, once is enough.” -- |
Re: Create PDB Descriptor Failed
|
|
Hello Erman,
I'm also encountering a similar problem while executing txkChkPDBCompatability.pl script after upgrading my EBS database from 12c to 19c. $ perl txkChkPDBCompatability.pl -dboraclehome=/u01/oracle/VIS/19.3 -outdir=/u01/oracle/VIS/19.3/appsutil/log -cdbsid=VISCDB -pdbsid=VIS12279 -servicetype=onpremise Script Name : txkChkPDBCompatability.pl Script Version : 120.0.12020000.10 Started : Fri Mar 5 01:35:38 EST 2021 Log File : /u01/oracle/VIS/19.3/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Mar_5_01_35_38_2021/txkChkPDBCompatability.log ----------- Values used ----------- Database Oracle Home : /u01/oracle/VIS/19.3 CDB SID : VISCDB PDB SID : VIS12279 OUT Directory : /u01/oracle/VIS/19.3/appsutil/log Service Type : onpremise ========================= Validating oracle home... ========================= Oracle Home: /u01/oracle/VIS/19.3 exists. =========================== Validating out directory... =========================== Oracle Home: /u01/oracle/VIS/19.3/appsutil/log exists. ============================= Validating DB service type... ============================= Service Type: onpremise Service type is valid. ============================ Inside setFileLocations()... ============================ PDB_DESC_XML: /u01/oracle/VIS/19.3/dbs/VIS12279_PDBDesc.xml **** Setting ORACLE_SID to VISCDB ======================== Inside getDBVersion()... ======================== DB_VERSION = db190 ================================= Inside checkPDBCompatibility()... ================================= File /u01/oracle/VIS/19.3/dbs/VIS12279_PDBDesc.xml exists. Generating SQL file : /u01/oracle/VIS/19.3/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Mar_5_01_35_38_2021/create_pdb_compatible.sql SQL output file : /u01/oracle/VIS/19.3/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Mar_5_01_35_38_2021/create_pdb_compatible.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/VIS/19.3/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Mar_5_01_35_38_2021/create_pdb_compatible.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/VIS/19.3/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Mar_5_01_35_38_2021/create_pdb_compatible.out pattern: ERROR ================ Pattern found... ================ EXIT STATUS: 1 PDB compatability check did not go through successfully. LOG FILE: /u01/oracle/VIS/19.3/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Mar_5_01_35_38_2021/create_pdb_compatible.out. *******FATAL ERROR******* PROGRAM : (txkChkPDBCompatability.pl) TIME : Fri Mar 5 01:35:38 2021 FUNCTION: main::checkPDBCompatibility [ Level 1 ] ERRORMSG: PDB compatability check did not go through successfully. *******FATAL ERROR******* PROGRAM : (txkChkPDBCompatability.pl) TIME : Fri Mar 5 01:35:38 2021 FUNCTION: main::checkPDBCompatibility [ Level 1 ] ERRORMSG: PDB compatability check did not go through successfully.
|
Re: Create PDB Descriptor Failed
|
|
Please find the output from the .out file.
cat /u01/oracle/VIS/19.3/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Mar_5_01_35_38_2021/create_pdb_compatible.out SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 5 01:35:38 2021 Version 19.10.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected. CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY( * ERROR at line 3: ORA-06550: line 3, column 6: PLS-00201: identifier 'DBMS_PDB.CHECK_PLUG_COMPATIBILITY' must be declared ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.10.0.0.0 |
Re: Create PDB Descriptor Failed
|
|
perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=/u01/oracle/VIS/19.3 -outdir=/u01/oracle/VIS/19.3/appsutil/log -appsuser=apps -dbsid=VIS12279
Enter the APPS Password: Script Name : txkOnPremPrePDBCreationTasks.pl Script Version : 120.0.12020000.13 Started : Fri Mar 5 01:24:44 EST 2021 Log File : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/txkOnPremPrePDBCreationTasks.log ----------- Values used ----------- DB Oracle Home : /u01/oracle/VIS/19.3 OUT Directory : /u01/oracle/VIS/19.3/appsutil/log Skip DB shutdown : No EBS SID : VIS12279 APPS Schema Username : apps Is RAC? : No Logical Hostname : ========================= Validating oracle home... ========================= Oracle Home: /u01/oracle/VIS/19.3 exists. =========================== Validating out directory... =========================== Out directory: /u01/oracle/VIS/19.3/appsutil/log exists. ============================ Inside getDBHostDetails()... ============================ DB Hostname : e12279-db DB Domain : dcol1.delphix.com Logical hostname is not passed, hence using physical hostname details. Logical hostname: e12279-db.dcol1.delphix.com ========================== Inside setContextName()... ========================== CONTEXT_NAME: VIS12279_e12279-db ============================ Inside setFileLocations()... ============================ ===================== Inside getDBName()... ===================== Generating SQL file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/get_db_name.sql SQL output file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/get_db_name.out Spool File : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/spool_get_db_name.log ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/get_db_name.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/get_db_name.out pattern: ERROR ============================= Could not find the pattern... ============================= Removing the file: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/get_db_name.sql EXIT STATUS: 0 Getting the value of DB Name... db_name: VIS12279 PDB_DESC_XML: /u01/oracle/VIS/19.3/dbs/VIS12279_PDBDesc.xml INITPARAM_FILE: /u01/oracle/VIS/19.3/dbs/VIS12279_initparam.sql DATATOP_FILE: /u01/oracle/VIS/19.3/dbs/VIS12279_datatop.txt ======================== Inside getDBVersion()... ======================== DB_VERSION = db190 ============================= Shutting down the database... ============================= Shutdown mode : IMMEDIATE Generating SQL file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.sql SQL output file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.out. ======================== Starting the database... ======================== Startup mode : MOUNT Generating SQL file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/startup_MOUNT.sql SQL output file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/startup_MOUNT.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/startup_MOUNT.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/startup_MOUNT.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/startup_MOUNT.out. ================================== Inside createPDBDescriptorXML()... ================================== ================================== Inside backupPDBDescriptorXML()... ================================== File /u01/oracle/VIS/19.3/dbs/VIS12279_PDBDesc.xml does not exist. File /u01/oracle/VIS/19.3/dbs/VIS12279_PDBDesc.xml does not exist. Generating SQL file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/create_pdb_desc_xml.sql SQL output file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/create_pdb_desc_xml.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/create_pdb_desc_xml.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/create_pdb_desc_xml.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 PDB Descriptor XML /u01/oracle/VIS/19.3/dbs/VIS12279_PDBDesc.xml created successfully. LOG FILE: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/create_pdb_desc_xml.out. ============================= Shutting down the database... ============================= Shutdown mode : IMMEDIATE Generating SQL file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.sql SQL output file : /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.sql ============================== Inside searchFileContents()... ============================== log_file: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u01/oracle/VIS/19.3/appsutil/log/TXK_PRE_PDB_Fri_Mar_5_01_24_41_2021/shutdown_IMMEDIATE.out. **************************************************************************************** * * * IMPORTANT NOTE: DO NOT START THE DB TILL THE DATA FILES ARE MIGRATED * * * * IF DB IS STARTED, THEN PDB DESCRIPTOR XML GENERATED BECOMES INVALID * * * **************************************************************************************** Exiting from the script. Ended: Fri Mar 5 01:25:59 EST 2021 |
Re: Create PDB Descriptor Failed
|
|
As per the oracle documentation 2552181.1
I have also executed the steps mentioned in "Update the CDB initialization parameters" SQL> startup nomount; ORACLE instance started. Total System Global Area 2147482336 bytes Fixed Size 9136864 bytes Variable Size 570425344 bytes Database Buffers 1560281088 bytes Redo Buffers 7639040 bytes SQL> @$ORACLE_HOME/dbs/VIS12279_initparam.sql . . . System altered. SQL> alter system set LOCAL_LISTENER="e12279-db:1522" scope=both; System altered. SQL> shutdown; ORA-01507: database not mounted ORACLE instance shut down. SQL> SQL> SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORA-00119: invalid specification for system parameter CONNECTION_BROKERS ORA-00876: invalid CONNECTION_BROKERS specification #1 Do we need make entries for LOCAL_LISTENER inside tnsnames.ora file as well. I have attached all the out logs. Please let me know if you need anything else.logs.gz |
Re: Create PDB Descriptor Failed
|
|
Hi Erman,
I was able to resolve the issue after removing the CONNECTION_BROKERS parameter from the configuration file and re-start the database and then execute txkChkPDBCompatability.pl to verify any compatibility issues. At the moment, I see the following output from txkChkPDBCompatability.pl script - can you please let me know if we need to apply this patch on the PDB or can we ignore this violation. NAME CAUSE TYPE STATUS ---------- -------------------- ---------- ---------- MESSAGE ------------------------------------------------------------------------------------------------------------------------------------------------------ PDB$SEED SQL Patch ERROR RESOLVED Interim patch 32067171/23947975 (OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171)): Installed in the CDB but not in the PDB PDB$SEED SQL Patch ERROR RESOLVED '19.10.0.0.0 Release_Update 2101081850' is installed in the CDB but no release updates are installed in the PDB VIS12279 Non-CDB to PDB WARNING PENDING PDB plugged in is a non-CDB, requires noncdb_to_pdb.sql be run. VIS12279 OPTION WARNING PENDING Database option DV mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. VIS12279 OPTION WARNING PENDING Database option OLS mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. VIS12279 OPTION WARNING PENDING Database option OWM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. VIS12279 Parameter WARNING PENDING CDB parameter processes mismatch: Previous 500 Current 200 VIS12279 Parameter WARNING PENDING CDB parameter sessions mismatch: Previous 772 Current 400 |
Re: Create PDB Descriptor Failed
|
Administrator
|
"installed in the CDB but not in the PDB" type errors are already in the RESOLVED status.
"options" related mismatch warning seems ignorable. CDB must have the SAME or SUPERSET of options as the PDBs that it will contain. It is okay for a PDB to have a subset (fewer) options installed than the CDB into which it is plugged. (The reverse is NOT true, however -- the CDB must always have the same or more options as its PDBs). In your case you have option installed in CDB but not in PDB, so it is okay.. But; if you plan to use some of those features such as OLS (Label Security), then you may want to handle the related warning. Ref: OPTION WARNING Database option mismatch: PDB installed version NULL" in PDB_PLUG_IN_VIOLATIONS (Doc ID 2020172.1) |
«
Return to EBS 12.2
|
1 view|%1 views
| Free forum by Nabble | Edit this page |