Create PDB Descriptor Failed

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Create PDB Descriptor Failed

karthikmca.bhc
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
Reply | Threaded
Open this post in threaded view
|

Re: Create PDB Descriptor Failed

ErmanArslansOracleBlog
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?
Reply | Threaded
Open this post in threaded view
|

Re: Create PDB Descriptor Failed

karthikmca.bhc
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.
Reply | Threaded
Open this post in threaded view
|

Re: Create PDB Descriptor Failed

ErmanArslansOracleBlog
Administrator
:) Good. So your problem is solved, right?
Reply | Threaded
Open this post in threaded view
|

Re: Create PDB Descriptor Failed

karthikmca.bhc
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:




:) Good. So your problem is solved, right?




















If you reply to this email, your message will be added to the discussion below:


http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Create-PDB-Descriptor-Failed-tp8708p8715.html







To unsubscribe from Create PDB Descriptor Failed, click here.


NAML

--

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: +971 525826640

Web:  www.pharmatradeuae.com

 -- You only live once, but if you do it right, once is enough. --