Get installed sqlpatches in database

— From 12c onward

set lines 2000
select patch_id,status,description from dba_registry_sqlpatch;
(or)
SET LINESIZE 400
COLUMN action_time FORMAT A20
COLUMN action FORMAT A10
COLUMN status FORMAT A10
COLUMN description FORMAT A40
COLUMN version FORMAT A10
COLUMN bundle_series FORMAT A10
SELECT TO_CHAR(action_time, ‘DD-MON-YYYY HH24:MI:SS’) AS action_time,action, status, description,version,patch_id, bundle_series FROM sys.dba_registry_sqlpatch;

— For 11g and below:
set lines 2000
select * from dba_registry_history;

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

GET INDEX USAGE

—Index monitoring is required, to find whether indexes are really in use or not. Unused can be dropped to avoid overhead.
— First enable monitoring usage for the indexes.

alter index INDEX_NAME.S_ASSET_TEST monitoring usage;

–Below query to find the index usage:

select * from v$object_usage;

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Get sql query to html format

— We can spool output of an sql query to html format:

set pages 5000
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON –
HEAD “EMPLOYEE REPORT –



” –
BODY “TEXT=’#FF00Ff'” –
TABLE “WIDTH=’90%’ BORDER=’5′”
spool report.html
Select * from scott.emp;
spool off
exit

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

row_count of all the tables of a schema

select table_name,
to_number(extractvalue(dbms_xmlgen.getXMLtype(‘select /+ PARALLEL(8) */ count() cnt from “&&SCHEMA_NAME”.’||table_name),’/ROWSET/ROW/CNT’))
rows_in_table from dba_TABLES
where owner=’&&SCHEMA_NAME’;

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Disable or enable all triggers of schema

BEGIN
FOR j IN (SELECT trig_name
FROM user_triggers) LOOP

EXECUTE IMMEDIATE ‘ALTER TRIGGER ‘ || i.trig_name || ‘ DISABLE’;
END LOOP;
END;
/

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Get size of the database

col “Database Size” format a20
col “Free space” format a20
col “Used space” format a20
select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ‘ GB’ “Database Size”
, round(sum(used.bytes) / 1024 / 1024 / 1024 ) –
round(free.p / 1024 / 1024 / 1024) || ‘ GB’ “Used space”
, round(free.p / 1024 / 1024 / 1024) || ‘ GB’ “Free space”
from (select bytes
from v$datafile
union all
select bytes
from v$tempfile
union all
select bytes
from v$log) used
, (select sum(bytes) as p
from dba_free_space) free
group by free.p
/

Oracle E-Business Suite Installation EBS 12.2.0

Oracle E-Business Suite Installation (EBS 12.2.0).

Now i am going to install Oracle E-Business Suite Installation (EBS),For this I have already created an instance in my cloud account.

I have created an instance in the following specificaions as mentioned below,

OS Version: Oracle Linux 7.9

Shape: VM Standard E 2.4, 4 core CPU and 32 GB Memory.(depends of the CPU, our EBS installation software running time is decided)

Instance name: ANDHRA

Once the instance is created we can proceed with the installation procedures.

Then connect with putty login connect as root user.

Better install the software using Vnc ,it is more advantage because while we are installing the software if any power outage occurs it doesn’t disturbs the installation.

if you are going to use vnc install the following packages,

yum install *gnome*
yum install *vnc*
yum install *desktop*

Stop the firewall using the below command systemctl stop firewall.

Then set the selinux parameter as permissive which is in the vi /etc/selinux/config location.

After that you have to reset the system using init 6 or setenforce 0

Add the following set of lines to the files.

vi /etc/sysctl.conf

vi /etc/security/limits.conf

Next add the groups and users,here i am adding oracle and applmgr users to the newly created dba group.

set the passwords for the oracle and applmgr user.

Examine the locations of ora inventory and change the mod and group of orainst.loc

Create the below mentioned directories that is needed to install the software.

Add and attach the block volumes(here i am adding block volume size of 700GB) after attaching the block volume,view the block volume details and click ISCSI commands and information,once you click that there will be the informations for connecting and disconnecting.

Do the partition for the newly added block volume.Simply just attaching the block volume will not be partitioned.

Download the ebs software version that we are going to install as wget file.And move the file to the EBS directory in the /u01/stage mountpoint where we are going to unzip the software.

Run the given pre install,

yum install oracle-ebs-server-R12-preinstall     --------------------------it is for ebs.
yum install oracle-database-server-12cR2-preinstall ------------------it is for database.

unlink /usr/lib/libXtst.so.6 and link libXtst.so.6.1 with /usr/lib.it is important because it is helpful to load the frontend page.

we are going to create the stage area,then specify the directory which contains the zipped installation media.

Move the downloaded software (ie. wget.sh file) to the stage area location to perform installation.

Here starts the rapid installation process.

In this choose Install Oracle E-business Suite Release 12.2.0

Here provides you a option to receive security updates via My Oracle Support if you want enable the check Box and provide the mail Email ID.

in this window it opts for configuration choice either we can create a new configuration or Load the saved configuration.

Here we can see Global System Settings leave it by default as it is don’t change any values in this window.

Now only we are going to configure the Database Node Configuration,set up those parameters such as database sid,database host name,db operating system.

choose the Licensing Type , suite Licensing or Component Licensing.I have choosen suite licensing.

It shows the License Additional Products,don’t do any change,click Next.

In this choose country out of the available regions which is displayed.

select the character set by specifying the language you are going to use.I choose the language as American_English – US.

 

Next we have to configure the Primary Applications Node Configuration,such as setting the primary host name,operating system,Apps OS User,Apps OS Group,Apps Base Dir,Apps Instance Dir

Provide the Application User Information such as WLS Admin User,Password and proceed further for Installation.

Continue with the Node Information.Database node,primary apps node information should be given here.

Rapid Install Wizard is performing the system checks,once it is fine we can move further.

It shows the list of pre-install tests if and only it satisfies all the condition we can go with the installation process.For us the instance passed all of the pre-install tests.

we are set with the process,installation is in progress it takes some time to install the software.

Depending upon the CPU core that we have specified in the instance creation the installation time may differ.

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Oracle E-Business Suite Installation EBS 12.2.0

Oracle E-Business Suite Installation (EBS 12.2.0).

Now i am going to install Oracle E-Business Suite Installation (EBS),For this I have already created an instance in my cloud account.

I have created an instance in the following specificaions as mentioned below,

OS Version: Oracle Linux 7.9

Shape: VM Standard E 2.4, 4 core CPU and 32 GB Memory.(depends of the CPU, our EBS installation software running time is decided)

Instance name: ANDHRA

Once the instance is created we can proceed with the installation procedures.

Then connect with putty login connect as root user.

Better install the software using Vnc ,it is more advantage because while we are installing the software if any power outage occurs it doesn’t disturbs the installation.

if you are going to use vnc install the following packages,

yum install *gnome*
yum install *vnc*
yum install *desktop*

Stop the firewall using the below command systemctl stop firewall.

Then set the selinux parameter as permissive which is in the vi /etc/selinux/config location.

After that you have to reset the system using init 6 or setenforce 0

Add the following set of lines to the files.

vi /etc/sysctl.conf

vi /etc/security/limits.conf

Next add the groups and users,here i am adding oracle and applmgr users to the newly created dba group.

set the passwords for the oracle and applmgr user.

Examine the locations of ora inventory and change the mod and group of orainst.loc

Create the below mentioned directories that is needed to install the software.

Add and attach the block volumes(here i am adding block volume size of 700GB) after attaching the block volume,view the block volume details and click ISCSI commands and information,once you click that there will be the informations for connecting and disconnecting.

Do the partition for the newly added block volume.Simply just attaching the block volume will not be partitioned.

Download the ebs software version that we are going to install as wget file.And move the file to the EBS directory in the /u01/stage mountpoint where we are going to unzip the software.

Run the given pre install,

yum install oracle-ebs-server-R12-preinstall     --------------------------it is for ebs.
yum install oracle-database-server-12cR2-preinstall ------------------it is for database.

unlink /usr/lib/libXtst.so.6 and link libXtst.so.6.1 with /usr/lib.it is important because it is helpful to load the frontend page.

we are going to create the stage area,then specify the directory which contains the zipped installation media.

Move the downloaded software (ie. wget.sh file) to the stage area location to perform installation.

Here starts the rapid installation process.

In this choose Install Oracle E-business Suite Release 12.2.0

Here provides you a option to receive security updates via My Oracle Support if you want enable the check Box and provide the mail Email ID.

in this window it opts for configuration choice either we can create a new configuration or Load the saved configuration.

Here we can see Global System Settings leave it by default as it is don’t change any values in this window.

Now only we are going to configure the Database Node Configuration,set up those parameters such as database sid,database host name,db operating system.

choose the Licensing Type , suite Licensing or Component Licensing.I have choosen suite licensing.

It shows the License Additional Products,don’t do any change,click Next.

In this choose country out of the available regions which is displayed.

select the character set by specifying the language you are going to use.I choose the language as American_English – US.

 

Next we have to configure the Primary Applications Node Configuration,such as setting the primary host name,operating system,Apps OS User,Apps OS Group,Apps Base Dir,Apps Instance Dir

Provide the Application User Information such as WLS Admin User,Password and proceed further for Installation.

Continue with the Node Information.Database node,primary apps node information should be given here.

Rapid Install Wizard is performing the system checks,once it is fine we can move further.

It shows the list of pre-install tests if and only it satisfies all the condition we can go with the installation process.For us the instance passed all of the pre-install tests.

we are set with the process,installation is in progress it takes some time to install the software.

Depending upon the CPU core that we have specified in the instance creation the installation time may differ.

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

CDB & PDB Manual upgrade 12c to 19c process complete information.

.

[oracle@localhost admin]$ cd $ORACLE_HOME/bin
[oracle@localhost bin]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/bin
[oracle@localhost bin]$ ./dbupgrade

Argument list for [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in                       c = 0
Do not run in                C = 0
Input Directory              d = 0
Echo OFF                     e = 1
Simulate                     E = 0
Forced cleanup               F = 0
Log Id                       i = 0
Child Process                I = 0
Log Dir                      l = 0
Priority List Name           L = 0
Upgrade Mode active          M = 0
SQL Process Count            n = 0
SQL PDB Process Count        N = 0
Open Mode Normal             o = 0
Start Phase                  p = 0
End Phase                    P = 0
Reverse Order                r = 0
AutoUpgrade Resume           R = 0
Script                       s = 0
Serial Run                   S = 0
RO User Tablespaces          T = 0
Display Phases               y = 0
Debug catcon.pm              z = 0
Debug catctl.pl              Z = 0

catctl.pl VERSION: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]


/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0/dbhome_1]
/u01/app/oracle/product/19.0.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.0.0/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0/dbhome_1]

Analyzing file /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql

Log file directory = [/tmp/cfgtoollogs/upgrade20210309075928]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20210309075928/catupgrd_catcon_31562.lst]

catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20210309075928/catupgrd*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20210309075928/catupgrd_*.lst] files for spool files, if any


Number of Cpus = 1
Database Name = EUROPE
DataBase Version = 12.2.0.1.0
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdcdbroot_catcon_31562.lst]

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdcdbroot*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdcdbroot_*.lst] files for spool files, if any


Log file directory = [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944]

PDB Parallel SQL Process Count = [2] is higher or equal to CPU Count = [1]
Concurrent PDB Upgrades defaulting to CPU Count [1]
Parallel SQL Process Count (PDB) = 2
Parallel SQL Process Count (CDB$ROOT) = 4
Concurrent PDB Upgrades = 1
Generated PDB Inclusion:[PDB$SEED ARGENTINA BRAZIL]
Components in [CDB$ROOT]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]

------------------------------------------------------
Phases [0-107] Start Time:[2021_03_09 08:00:10]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [CDB$ROOT] Files:1 Time: 70s
*************** Catalog Core SQL ***************
Serial Phase #:1 [CDB$ROOT] Files:5 Time: 157s
Restart Phase #:2 [CDB$ROOT] Files:1 Time: 4s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [CDB$ROOT] Files:19 Time: 112s
Restart Phase #:4 [CDB$ROOT] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [CDB$ROOT] Files:7 Time: 69s
***************** Catproc Start ****************
Serial Phase #:6 [CDB$ROOT] Files:1 Time: 31s
***************** Catproc Types ****************
Serial Phase #:7 [CDB$ROOT] Files:2 Time: 32s
Restart Phase #:8 [CDB$ROOT] Files:1 Time: 1s
**************** Catproc Tables ****************
Parallel Phase #:9 [CDB$ROOT] Files:67 Time: 63s
Restart Phase #:10 [CDB$ROOT] Files:1 Time: 0s
************* Catproc Package Specs ************
Serial Phase #:11 [CDB$ROOT] Files:1 Time: 150s
Restart Phase #:12 [CDB$ROOT] Files:1 Time: 3s
************** Catproc Procedures **************
Parallel Phase #:13 [CDB$ROOT] Files:94 Time: 20s
Restart Phase #:14 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:15 [CDB$ROOT] Files:120 Time: 31s
Restart Phase #:16 [CDB$ROOT] Files:1 Time: 4s
Serial Phase #:17 [CDB$ROOT] Files:22 Time: 8s
Restart Phase #:18 [CDB$ROOT] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [CDB$ROOT] Files:32 Time: 42s
Restart Phase #:20 [CDB$ROOT] Files:1 Time: 4s
Serial Phase #:21 [CDB$ROOT] Files:3 Time: 17s
Restart Phase #:22 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:23 [CDB$ROOT] Files:25 Time: 180s
Restart Phase #:24 [CDB$ROOT] Files:1 Time: 3s
Parallel Phase #:25 [CDB$ROOT] Files:12 Time: 117s
Restart Phase #:26 [CDB$ROOT] Files:1 Time: 2s
Serial Phase #:27 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:28 [CDB$ROOT] Files:3 Time: 11s
Serial Phase #:29 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:30 [CDB$ROOT] Files:1 Time: 1s
*************** Catproc CDB Views **************
Serial Phase #:31 [CDB$ROOT] Files:1 Time: 6s
Restart Phase #:32 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:34 [CDB$ROOT] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [CDB$ROOT] Files:293 Time: 42s
Serial Phase #:36 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:37 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:38 [CDB$ROOT] Files:6 Time: 9s
Restart Phase #:39 [CDB$ROOT] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:40 [CDB$ROOT] Files:3 Time: 58s
Restart Phase #:41 [CDB$ROOT] Files:1 Time: 4s
****************** Catproc SQL *****************
Parallel Phase #:42 [CDB$ROOT] Files:13 Time: 121s
Restart Phase #:43 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:44 [CDB$ROOT] Files:11 Time: 16s
Restart Phase #:45 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:46 [CDB$ROOT] Files:3 Time: 9s
Restart Phase #:47 [CDB$ROOT] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:48 [CDB$ROOT] Files:1 Time: 12s
Restart Phase #:49 [CDB$ROOT] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:50 [CDB$ROOT] Files:1 Time: 9s
************ Upgrade Component Start ***********
Serial Phase #:51 [CDB$ROOT] Files:1 Time: 7s
Restart Phase #:52 [CDB$ROOT] Files:1 Time: 0s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [CDB$ROOT] Files:2 Time: 324s
***************** Upgrading XDB ****************
Restart Phase #:54 [CDB$ROOT] Files:1 Time: 4s
Serial Phase #:56 [CDB$ROOT] Files:3 Time: 16s
Serial Phase #:57 [CDB$ROOT] Files:3 Time: 10s
Parallel Phase #:58 [CDB$ROOT] Files:10 Time: 13s
Parallel Phase #:59 [CDB$ROOT] Files:25 Time: 16s
Serial Phase #:60 [CDB$ROOT] Files:4 Time: 14s
Serial Phase #:61 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:62 [CDB$ROOT] Files:32 Time: 11s
Serial Phase #:63 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:64 [CDB$ROOT] Files:6 Time: 14s
Serial Phase #:65 [CDB$ROOT] Files:2 Time: 20s
Serial Phase #:66 [CDB$ROOT] Files:3 Time: 29s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [CDB$ROOT] Files:1 Time: 2s
Serial Phase #:69 [CDB$ROOT] Files:1 Time: 9s
Parallel Phase #:70 [CDB$ROOT] Files:2 Time: 42s
Restart Phase #:71 [CDB$ROOT] Files:1 Time: 4s
Parallel Phase #:72 [CDB$ROOT] Files:2 Time: 10s
Serial Phase #:73 [CDB$ROOT] Files:2 Time: 8s
***************** Upgrading SDO ****************
Restart Phase #:74 [CDB$ROOT] Files:1 Time: 2s
Serial Phase #:76 [CDB$ROOT] Files:1 Time: 40s
Serial Phase #:77 [CDB$ROOT] Files:2 Time: 9s
Restart Phase #:78 [CDB$ROOT] Files:1 Time: 3s
Serial Phase #:79 [CDB$ROOT] Files:1 Time: 50s
Restart Phase #:80 [CDB$ROOT] Files:1 Time: 3s
Parallel Phase #:81 [CDB$ROOT] Files:3 Time: 94s
Restart Phase #:82 [CDB$ROOT] Files:1 Time: 3s
Serial Phase #:83 [CDB$ROOT] Files:1 Time: 12s
Restart Phase #:84 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:85 [CDB$ROOT] Files:1 Time: 14s
Restart Phase #:86 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:87 [CDB$ROOT] Files:4 Time: 128s
Restart Phase #:88 [CDB$ROOT] Files:1 Time: 4s
Serial Phase #:89 [CDB$ROOT] Files:1 Time: 8s
Restart Phase #:90 [CDB$ROOT] Files:1 Time: 3s
Serial Phase #:91 [CDB$ROOT] Files:2 Time: 14s
Restart Phase #:92 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:93 [CDB$ROOT] Files:1 Time: 6s
Restart Phase #:94 [CDB$ROOT] Files:1 Time: 1s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [CDB$ROOT] Files:1 Time: 20s
Restart Phase #:96 [CDB$ROOT] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:97 [CDB$ROOT] Files:1 Time: 8s
************* Final Upgrade scripts ************
Serial Phase #:98 [CDB$ROOT] Files:1 Time: 220s
******************* Migration ******************
Serial Phase #:99 [CDB$ROOT] Files:1 Time: 6s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [CDB$ROOT] Files:1 Time: 25s
Serial Phase #:101 [CDB$ROOT] Files:1 Time: 5s
Serial Phase #:102 [CDB$ROOT] Files:1 Time: 74s
***************** Post Upgrade *****************
Serial Phase #:103 [CDB$ROOT] Files:1 Time: 26s
**************** Summary report ****************
Serial Phase #:104 [CDB$ROOT] Files:1 Time: 8s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [CDB$ROOT] Files:1 Time: 12s
Serial Phase #:106 [CDB$ROOT] Files:1 Time: 5s
Serial Phase #:107 [CDB$ROOT] Files:1 Time: 44s

------------------------------------------------------
Phases [0-107] End Time:[2021_03_09 08:47:23]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------

Start processing of PDBs (PDB$SEED)
[/u01/app/oracle/product/19.0.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl -I -i pdb_seed -n 2 -c 'PDB$SEED' -l /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944 /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql]

Argument list for [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in                       c = PDB$SEED
Do not run in                C = 0
Input Directory              d = 0
Echo OFF                     e = 1
Simulate                     E = 0
Forced cleanup               F = 0
Log Id                       i = pdb_seed
Child Process                I = 1
Log Dir                      l = /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944
Priority List Name           L = 0
Upgrade Mode active          M = 0
SQL Process Count            n = 2
SQL PDB Process Count        N = 0
Open Mode Normal             o = 0
Start Phase                  p = 0
End Phase                    P = 0
Reverse Order                r = 0
AutoUpgrade Resume           R = 0
Script                       s = 0
Serial Run                   S = 0
RO User Tablespaces          T = 0
Display Phases               y = 0
Debug catcon.pm              z = 0
Debug catctl.pl              Z = 0

catctl.pl VERSION: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]


/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0/dbhome_1]
/u01/app/oracle/product/19.0.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.0.0/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0/dbhome_1]

Analyzing file /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql

Log file directory = [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdpdb_seed_catcon_6730.lst]

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdpdb_seed*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdpdb_seed_*.lst] files for spool files, if any


Number of Cpus = 1
Database Name = EUROPE
DataBase Version = 19.0.0.0.0
PDB$SEED Open Mode = [MIGRATE] 
Generated PDB Inclusion:[PDB$SEED]
CDB$ROOT Open Mode = [OPEN]
Components in [PDB$SEED]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]

------------------------------------------------------
Phases [0-107] Start Time:[2021_03_09 08:48:10]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [PDB$SEED] Files:1 Time: 42s
*************** Catalog Core SQL ***************
Serial Phase #:1 [PDB$SEED] Files:5 Time: 46s
Restart Phase #:2 [PDB$SEED] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [PDB$SEED] Files:19 Time: 31s
Restart Phase #:4 [PDB$SEED] Files:1 Time: 2s
************* Catalog Final Scripts ************
Serial Phase #:5 [PDB$SEED] Files:7 Time: 25s
***************** Catproc Start ****************
Serial Phase #:6 [PDB$SEED] Files:1 Time: 16s
***************** Catproc Types ****************
Serial Phase #:7 [PDB$SEED] Files:2 Time: 18s
Restart Phase #:8 [PDB$SEED] Files:1 Time: 2s
**************** Catproc Tables ****************
Parallel Phase #:9 [PDB$SEED] Files:67 Time: 42s
Restart Phase #:10 [PDB$SEED] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [PDB$SEED] Files:1 Time: 70s
Restart Phase #:12 [PDB$SEED] Files:1 Time: 2s
************** Catproc Procedures **************
Parallel Phase #:13 [PDB$SEED] Files:94 Time: 16s
Restart Phase #:14 [PDB$SEED] Files:1 Time: 2s
Parallel Phase #:15 [PDB$SEED] Files:120 Time: 37s
Restart Phase #:16 [PDB$SEED] Files:1 Time: 2s
Serial Phase #:17 [PDB$SEED] Files:22 Time: 11s
Restart Phase #:18 [PDB$SEED] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [PDB$SEED] Files:32 Time: 33s
Restart Phase #:20 [PDB$SEED] Files:1 Time: 2s
Serial Phase #:21 [PDB$SEED] Files:3 Time: 15s
Restart Phase #:22 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:23 [PDB$SEED] Files:25 Time: 358s
Restart Phase #:24 [PDB$SEED] Files:1 Time: 2s
Parallel Phase #:25 [PDB$SEED] Files:12 Time: 110s
Restart Phase #:26 [PDB$SEED] Files:1 Time: 2s
Serial Phase #:27 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:28 [PDB$SEED] Files:3 Time: 19s
Serial Phase #:29 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:30 [PDB$SEED] Files:1 Time: 1s
*************** Catproc CDB Views **************
Serial Phase #:31 [PDB$SEED] Files:1 Time: 6s
Restart Phase #:32 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:34 [PDB$SEED] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [PDB$SEED] Files:293 Time: 94s
Serial Phase #:36 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:37 [PDB$SEED] Files:1 Time: 2s
Serial Phase #:38 [PDB$SEED] Files:6 Time: 10s
Restart Phase #:39 [PDB$SEED] Files:1 Time: 0s
*************** Catproc DataPump ***************
Serial Phase #:40 [PDB$SEED] Files:3 Time: 41s
Restart Phase #:41 [PDB$SEED] Files:1 Time: 2s
****************** Catproc SQL *****************
Parallel Phase #:42 [PDB$SEED] Files:13 Time: 128s
Restart Phase #:43 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:44 [PDB$SEED] Files:11 Time: 12s
Restart Phase #:45 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:46 [PDB$SEED] Files:3 Time: 8s
Restart Phase #:47 [PDB$SEED] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:48 [PDB$SEED] Files:1 Time: 14s
Restart Phase #:49 [PDB$SEED] Files:1 Time: 0s
************** Final RDBMS scripts *************
Serial Phase #:50 [PDB$SEED] Files:1 Time: 9s
************ Upgrade Component Start ***********
Serial Phase #:51 [PDB$SEED] Files:1 Time: 7s
Restart Phase #:52 [PDB$SEED] Files:1 Time: 0s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [PDB$SEED] Files:2 Time: 220s
***************** Upgrading XDB ****************
Restart Phase #:54 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:56 [PDB$SEED] Files:3 Time: 14s
Serial Phase #:57 [PDB$SEED] Files:3 Time: 9s
Parallel Phase #:58 [PDB$SEED] Files:10 Time: 11s
Parallel Phase #:59 [PDB$SEED] Files:25 Time: 13s
Serial Phase #:60 [PDB$SEED] Files:4 Time: 15s
Serial Phase #:61 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:62 [PDB$SEED] Files:32 Time: 15s
Serial Phase #:63 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:64 [PDB$SEED] Files:6 Time: 13s
Serial Phase #:65 [PDB$SEED] Files:2 Time: 21s
Serial Phase #:66 [PDB$SEED] Files:3 Time: 28s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:69 [PDB$SEED] Files:1 Time: 9s
Parallel Phase #:70 [PDB$SEED] Files:2 Time: 18s
Restart Phase #:71 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:72 [PDB$SEED] Files:2 Time: 10s
Serial Phase #:73 [PDB$SEED] Files:2 Time: 8s
***************** Upgrading SDO ****************
Restart Phase #:74 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:76 [PDB$SEED] Files:1 Time: 39s
Serial Phase #:77 [PDB$SEED] Files:2 Time: 10s
Restart Phase #:78 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:79 [PDB$SEED] Files:1 Time: 12s
Restart Phase #:80 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:81 [PDB$SEED] Files:3 Time: 73s
Restart Phase #:82 [PDB$SEED] Files:1 Time: 2s
Serial Phase #:83 [PDB$SEED] Files:1 Time: 13s
Restart Phase #:84 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:85 [PDB$SEED] Files:1 Time: 14s
Restart Phase #:86 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:87 [PDB$SEED] Files:4 Time: 121s
Restart Phase #:88 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:89 [PDB$SEED] Files:1 Time: 9s
Restart Phase #:90 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:91 [PDB$SEED] Files:2 Time: 23s
Restart Phase #:92 [PDB$SEED] Files:1 Time: 2s
Serial Phase #:93 [PDB$SEED] Files:1 Time: 6s
Restart Phase #:94 [PDB$SEED] Files:1 Time: 1s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [PDB$SEED] Files:1 Time: 15s
Restart Phase #:96 [PDB$SEED] Files:1 Time: 1s
*********** Final Component scripts ***********
Serial Phase #:97 [PDB$SEED] Files:1 Time: 7s
************* Final Upgrade scripts ************
Serial Phase #:98 [PDB$SEED] Files:1 Time: 130s
******************* Migration ******************
Serial Phase #:99 [PDB$SEED] Files:1 Time: 6s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [PDB$SEED] Files:1 Time: 7s
Serial Phase #:101 [PDB$SEED] Files:1 Time: 30s
Serial Phase #:102 [PDB$SEED] Files:1 Time: 7s
***************** Post Upgrade *****************
Serial Phase #:103 [PDB$SEED] Files:1 Time: 321s
**************** Summary report ****************
Serial Phase #:104 [PDB$SEED] Files:1 Time: 7s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [PDB$SEED] Files:1 Time: 6s
Serial Phase #:106 [PDB$SEED] Files:1 Time: 12s
Serial Phase #:107 [PDB$SEED] Files:1 Time: 0s

------------------------------------------------------
Phases [0-107] End Time:[2021_03_09 09:30:19]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------

Grand Total Time: 2534s [PDB$SEED]

LOG FILES: (/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdpdb_seed*.log)

Upgrade Summary Report Located in:
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/upg_summary.log

Start processing of PDBs (ARGENTINA)
[/u01/app/oracle/product/19.0.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl -I -i argentina -n 2 -c 'ARGENTINA' -l /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944 /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql]

Argument list for [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in                       c = ARGENTINA
Do not run in                C = 0
Input Directory              d = 0
Echo OFF                     e = 1
Simulate                     E = 0
Forced cleanup               F = 0
Log Id                       i = argentina
Child Process                I = 1
Log Dir                      l = /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944
Priority List Name           L = 0
Upgrade Mode active          M = 0
SQL Process Count            n = 2
SQL PDB Process Count        N = 0
Open Mode Normal             o = 0
Start Phase                  p = 0
End Phase                    P = 0
Reverse Order                r = 0
AutoUpgrade Resume           R = 0
Script                       s = 0
Serial Run                   S = 0
RO User Tablespaces          T = 0
Display Phases               y = 0
Debug catcon.pm              z = 0
Debug catctl.pl              Z = 0

catctl.pl VERSION: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]


/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0/dbhome_1]
/u01/app/oracle/product/19.0.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.0.0/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0/dbhome_1]

Analyzing file /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql

Log file directory = [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdargentina_catcon_12866.lst]

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdargentina*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdargentina_*.lst] files for spool files, if any


Number of Cpus = 1
Database Name = EUROPE
DataBase Version = 19.0.0.0.0
ARGENTINA Open Mode = [MIGRATE] 
Generated PDB Inclusion:[ARGENTINA]
CDB$ROOT Open Mode = [OPEN]
Components in [ARGENTINA]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]

------------------------------------------------------
Phases [0-107] Start Time:[2021_03_09 09:31:06]
Container Lists Inclusion:[ARGENTINA] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [ARGENTINA] Files:1 Time: 41s
*************** Catalog Core SQL ***************
Serial Phase #:1 [ARGENTINA] Files:5 Time: 48s
Restart Phase #:2 [ARGENTINA] Files:1 Time: 1s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [ARGENTINA] Files:19 Time: 29s
Restart Phase #:4 [ARGENTINA] Files:1 Time: 0s
************* Catalog Final Scripts ************
Serial Phase #:5 [ARGENTINA] Files:7 Time: 22s
***************** Catproc Start ****************
Serial Phase #:6 [ARGENTINA] Files:1 Time: 14s
***************** Catproc Types ****************
Serial Phase #:7 [ARGENTINA] Files:2 Time: 14s
Restart Phase #:8 [ARGENTINA] Files:1 Time: 1s
**************** Catproc Tables ****************
Parallel Phase #:9 [ARGENTINA] Files:67 Time: 44s
Restart Phase #:10 [ARGENTINA] Files:1 Time: 2s
************* Catproc Package Specs ************
Serial Phase #:11 [ARGENTINA] Files:1 Time: 66s
Restart Phase #:12 [ARGENTINA] Files:1 Time: 2s
************** Catproc Procedures **************
Parallel Phase #:13 [ARGENTINA] Files:94 Time: 15s
Restart Phase #:14 [ARGENTINA] Files:1 Time: 0s
Parallel Phase #:15 [ARGENTINA] Files:120 Time: 19s
Restart Phase #:16 [ARGENTINA] Files:1 Time: 1s
Serial Phase #:17 [ARGENTINA] Files:22 Time: 7s
Restart Phase #:18 [ARGENTINA] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [ARGENTINA] Files:32 Time: 28s
Restart Phase #:20 [ARGENTINA] Files:1 Time: 1s
Serial Phase #:21 [ARGENTINA] Files:3 Time: 15s
Restart Phase #:22 [ARGENTINA] Files:1 Time: 2s
Parallel Phase #:23 [ARGENTINA] Files:25 Time: 185s
Restart Phase #:24 [ARGENTINA] Files:1 Time: 2s
Parallel Phase #:25 [ARGENTINA] Files:12 Time: 107s
Restart Phase #:26 [ARGENTINA] Files:1 Time: 2s
Serial Phase #:27 [ARGENTINA] Files:1 Time: 0s
Serial Phase #:28 [ARGENTINA] Files:3 Time: 9s
Serial Phase #:29 [ARGENTINA] Files:1 Time: 0s
Restart Phase #:30 [ARGENTINA] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:31 [ARGENTINA] Files:1 Time: 7s
Restart Phase #:32 [ARGENTINA] Files:1 Time: 0s
Serial Phase #:34 [ARGENTINA] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [ARGENTINA] Files:293 Time: 26s
Serial Phase #:36 [ARGENTINA] Files:1 Time: 0s
Restart Phase #:37 [ARGENTINA] Files:1 Time: 0s
Serial Phase #:38 [ARGENTINA] Files:6 Time: 8s
Restart Phase #:39 [ARGENTINA] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:40 [ARGENTINA] Files:3 Time: 40s
Restart Phase #:41 [ARGENTINA] Files:1 Time: 2s
****************** Catproc SQL *****************
Parallel Phase #:42 [ARGENTINA] Files:13 Time: 119s
Restart Phase #:43 [ARGENTINA] Files:1 Time: 1s
Parallel Phase #:44 [ARGENTINA] Files:11 Time: 12s
Restart Phase #:45 [ARGENTINA] Files:1 Time: 0s
Parallel Phase #:46 [ARGENTINA] Files:3 Time: 8s
Restart Phase #:47 [ARGENTINA] Files:1 Time: 0s
************* Final Catproc scripts ************
Serial Phase #:48 [ARGENTINA] Files:1 Time: 17s
Restart Phase #:49 [ARGENTINA] Files:1 Time: 2s
************** Final RDBMS scripts *************
Serial Phase #:50 [ARGENTINA] Files:1 Time: 9s
************ Upgrade Component Start ***********
Serial Phase #:51 [ARGENTINA] Files:1 Time: 6s
Restart Phase #:52 [ARGENTINA] Files:1 Time: 1s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [ARGENTINA] Files:2 Time: 206s
***************** Upgrading XDB ****************
Restart Phase #:54 [ARGENTINA] Files:1 Time: 1s
Serial Phase #:56 [ARGENTINA] Files:3 Time: 12s
Serial Phase #:57 [ARGENTINA] Files:3 Time: 10s
Parallel Phase #:58 [ARGENTINA] Files:10 Time: 10s
Parallel Phase #:59 [ARGENTINA] Files:25 Time: 13s
Serial Phase #:60 [ARGENTINA] Files:4 Time: 14s
Serial Phase #:61 [ARGENTINA] Files:1 Time: 0s
Serial Phase #:62 [ARGENTINA] Files:32 Time: 10s
Serial Phase #:63 [ARGENTINA] Files:1 Time: 0s
Parallel Phase #:64 [ARGENTINA] Files:6 Time: 14s
Serial Phase #:65 [ARGENTINA] Files:2 Time: 21s
Serial Phase #:66 [ARGENTINA] Files:3 Time: 28s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [ARGENTINA] Files:1 Time: 1s
Serial Phase #:69 [ARGENTINA] Files:1 Time: 9s
Parallel Phase #:70 [ARGENTINA] Files:2 Time: 14s
Restart Phase #:71 [ARGENTINA] Files:1 Time: 2s
Parallel Phase #:72 [ARGENTINA] Files:2 Time: 10s
Serial Phase #:73 [ARGENTINA] Files:2 Time: 8s
***************** Upgrading SDO ****************
Restart Phase #:74 [ARGENTINA] Files:1 Time: 0s
Serial Phase #:76 [ARGENTINA] Files:1 Time: 37s
Serial Phase #:77 [ARGENTINA] Files:2 Time: 9s
Restart Phase #:78 [ARGENTINA] Files:1 Time: 2s
Serial Phase #:79 [ARGENTINA] Files:1 Time: 11s
Restart Phase #:80 [ARGENTINA] Files:1 Time: 1s
Parallel Phase #:81 [ARGENTINA] Files:3 Time: 60s
Restart Phase #:82 [ARGENTINA] Files:1 Time: 2s
Serial Phase #:83 [ARGENTINA] Files:1 Time: 11s
Restart Phase #:84 [ARGENTINA] Files:1 Time: 1s
Serial Phase #:85 [ARGENTINA] Files:1 Time: 13s
Restart Phase #:86 [ARGENTINA] Files:1 Time: 1s
Parallel Phase #:87 [ARGENTINA] Files:4 Time: 80s
Restart Phase #:88 [ARGENTINA] Files:1 Time: 2s
Serial Phase #:89 [ARGENTINA] Files:1 Time: 8s
Restart Phase #:90 [ARGENTINA] Files:1 Time: 1s
Serial Phase #:91 [ARGENTINA] Files:2 Time: 20s
Restart Phase #:92 [ARGENTINA] Files:1 Time: 1s
Serial Phase #:93 [ARGENTINA] Files:1 Time: 6s
Restart Phase #:94 [ARGENTINA] Files:1 Time: 1s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [ARGENTINA] Files:1 Time: 14s
Restart Phase #:96 [ARGENTINA] Files:1 Time: 2s
*********** Final Component scripts ***********
Serial Phase #:97 [ARGENTINA] Files:1 Time: 7s
************* Final Upgrade scripts ************
Serial Phase #:98 [ARGENTINA] Files:1 Time: 122s
******************* Migration ******************
Serial Phase #:99 [ARGENTINA] Files:1 Time: 7s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [ARGENTINA] Files:1 Time: 6s
Serial Phase #:101 [ARGENTINA] Files:1 Time: 35s
Serial Phase #:102 [ARGENTINA] Files:1 Time: 6s
***************** Post Upgrade *****************
Serial Phase #:103 [ARGENTINA] Files:1 Time: 18s
**************** Summary report ****************
Serial Phase #:104 [ARGENTINA] Files:1 Time: 6s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [ARGENTINA] Files:1 Time: 7s
Serial Phase #:106 [ARGENTINA] Files:1 Time: 4s
Serial Phase #:107 [ARGENTINA] Files:1 Time: 0s

------------------------------------------------------
Phases [0-107] End Time:[2021_03_09 10:01:28]
Container Lists Inclusion:[ARGENTINA] Exclusion:[NONE]
------------------------------------------------------

Grand Total Time: 1822s [ARGENTINA]

LOG FILES: (/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdargentina*.log)

Upgrade Summary Report Located in:
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/upg_summary.log

Start processing of PDBs (BRAZIL)
[/u01/app/oracle/product/19.0.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl -I -i brazil -n 2 -c 'BRAZIL' -l /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944 /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql]

Argument list for [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in                       c = BRAZIL
Do not run in                C = 0
Input Directory              d = 0
Echo OFF                     e = 1
Simulate                     E = 0
Forced cleanup               F = 0
Log Id                       i = brazil
Child Process                I = 1
Log Dir                      l = /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944
Priority List Name           L = 0
Upgrade Mode active          M = 0
SQL Process Count            n = 2
SQL PDB Process Count        N = 0
Open Mode Normal             o = 0
Start Phase                  p = 0
End Phase                    P = 0
Reverse Order                r = 0
AutoUpgrade Resume           R = 0
Script                       s = 0
Serial Run                   S = 0
RO User Tablespaces          T = 0
Display Phases               y = 0
Debug catcon.pm              z = 0
Debug catctl.pl              Z = 0

catctl.pl VERSION: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]


/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0/dbhome_1]
/u01/app/oracle/product/19.0.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.0.0/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0/dbhome_1]

Analyzing file /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql

Log file directory = [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdbrazil_catcon_18583.lst]

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdbrazil*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdbrazil_*.lst] files for spool files, if any


Number of Cpus = 1
Database Name = EUROPE
DataBase Version = 19.0.0.0.0
BRAZIL Open Mode = [MIGRATE] 
Generated PDB Inclusion:[BRAZIL]
CDB$ROOT Open Mode = [OPEN]
Components in [BRAZIL]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]

------------------------------------------------------
Phases [0-107] Start Time:[2021_03_09 10:02:11]
Container Lists Inclusion:[BRAZIL] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [BRAZIL] Files:1 Time: 41s
*************** Catalog Core SQL ***************
Serial Phase #:1 [BRAZIL] Files:5 Time: 47s
Restart Phase #:2 [BRAZIL] Files:1 Time: 1s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [BRAZIL] Files:19 Time: 30s
Restart Phase #:4 [BRAZIL] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [BRAZIL] Files:7 Time: 26s
***************** Catproc Start ****************
Serial Phase #:6 [BRAZIL] Files:1 Time: 14s
***************** Catproc Types ****************
Serial Phase #:7 [BRAZIL] Files:2 Time: 14s
Restart Phase #:8 [BRAZIL] Files:1 Time: 2s
**************** Catproc Tables ****************
Parallel Phase #:9 [BRAZIL] Files:67 Time: 43s
Restart Phase #:10 [BRAZIL] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [BRAZIL] Files:1 Time: 63s
Restart Phase #:12 [BRAZIL] Files:1 Time: 2s
************** Catproc Procedures **************
Parallel Phase #:13 [BRAZIL] Files:94 Time: 15s
Restart Phase #:14 [BRAZIL] Files:1 Time: 1s
Parallel Phase #:15 [BRAZIL] Files:120 Time: 19s
Restart Phase #:16 [BRAZIL] Files:1 Time: 2s
Serial Phase #:17 [BRAZIL] Files:22 Time: 8s
Restart Phase #:18 [BRAZIL] Files:1 Time: 0s
***************** Catproc Views ****************
Parallel Phase #:19 [BRAZIL] Files:32 Time: 28s
Restart Phase #:20 [BRAZIL] Files:1 Time: 2s
Serial Phase #:21 [BRAZIL] Files:3 Time: 15s
Restart Phase #:22 [BRAZIL] Files:1 Time: 1s
Parallel Phase #:23 [BRAZIL] Files:25 Time: 187s
Restart Phase #:24 [BRAZIL] Files:1 Time: 1s
Parallel Phase #:25 [BRAZIL] Files:12 Time: 108s
Restart Phase #:26 [BRAZIL] Files:1 Time: 2s
Serial Phase #:27 [BRAZIL] Files:1 Time: 0s
Serial Phase #:28 [BRAZIL] Files:3 Time: 8s
Serial Phase #:29 [BRAZIL] Files:1 Time: 0s
Restart Phase #:30 [BRAZIL] Files:1 Time: 2s
*************** Catproc CDB Views **************
Serial Phase #:31 [BRAZIL] Files:1 Time: 6s
Restart Phase #:32 [BRAZIL] Files:1 Time: 1s
Serial Phase #:34 [BRAZIL] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [BRAZIL] Files:293 Time: 24s
Serial Phase #:36 [BRAZIL] Files:1 Time: 0s
Restart Phase #:37 [BRAZIL] Files:1 Time: 1s
Serial Phase #:38 [BRAZIL] Files:6 Time: 7s
Restart Phase #:39 [BRAZIL] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:40 [BRAZIL] Files:3 Time: 39s
Restart Phase #:41 [BRAZIL] Files:1 Time: 1s
****************** Catproc SQL *****************
Parallel Phase #:42 [BRAZIL] Files:13 Time: 122s
Restart Phase #:43 [BRAZIL] Files:1 Time: 1s
Parallel Phase #:44 [BRAZIL] Files:11 Time: 11s
Restart Phase #:45 [BRAZIL] Files:1 Time: 1s
Parallel Phase #:46 [BRAZIL] Files:3 Time: 8s
Restart Phase #:47 [BRAZIL] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:48 [BRAZIL] Files:1 Time: 13s
Restart Phase #:49 [BRAZIL] Files:1 Time: 0s
************** Final RDBMS scripts *************
Serial Phase #:50 [BRAZIL] Files:1 Time: 9s
************ Upgrade Component Start ***********
Serial Phase #:51 [BRAZIL] Files:1 Time: 6s
Restart Phase #:52 [BRAZIL] Files:1 Time: 1s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [BRAZIL] Files:2 Time: 11788s
***************** Upgrading XDB ****************
Restart Phase #:54 [BRAZIL] Files:1 Time: 2s
Serial Phase #:56 [BRAZIL] Files:3 Time: 14s
Serial Phase #:57 [BRAZIL] Files:3 Time: 9s
Parallel Phase #:58 [BRAZIL] Files:10 Time: 11s
Parallel Phase #:59 [BRAZIL] Files:25 Time: 12s
Serial Phase #:60 [BRAZIL] Files:4 Time: 14s
Serial Phase #:61 [BRAZIL] Files:1 Time: 0s
Serial Phase #:62 [BRAZIL] Files:32 Time: 11s
Serial Phase #:63 [BRAZIL] Files:1 Time: 0s
Parallel Phase #:64 [BRAZIL] Files:6 Time: 14s
Serial Phase #:65 [BRAZIL] Files:2 Time: 21s
Serial Phase #:66 [BRAZIL] Files:3 Time: 26s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [BRAZIL] Files:1 Time: 0s
Serial Phase #:69 [BRAZIL] Files:1 Time: 9s
Parallel Phase #:70 [BRAZIL] Files:2 Time: 14s
Restart Phase #:71 [BRAZIL] Files:1 Time: 3s
Parallel Phase #:72 [BRAZIL] Files:2 Time: 9s
Serial Phase #:73 [BRAZIL] Files:2 Time: 9s
***************** Upgrading SDO ****************
Restart Phase #:74 [BRAZIL] Files:1 Time: 1s
Serial Phase #:76 [BRAZIL] Files:1 Time: 36s
Serial Phase #:77 [BRAZIL] Files:2 Time: 10s
Restart Phase #:78 [BRAZIL] Files:1 Time: 1s
Serial Phase #:79 [BRAZIL] Files:1 Time: 11s
Restart Phase #:80 [BRAZIL] Files:1 Time: 1s
Parallel Phase #:81 [BRAZIL] Files:3 Time: 69s
Restart Phase #:82 [BRAZIL] Files:1 Time: 2s
Serial Phase #:83 [BRAZIL] Files:1 Time: 11s
Restart Phase #:84 [BRAZIL] Files:1 Time: 0s
Serial Phase #:85 [BRAZIL] Files:1 Time: 13s
Restart Phase #:86 [BRAZIL] Files:1 Time: 1s
Parallel Phase #:87 [BRAZIL] Files:4 Time: 81s
Restart Phase #:88 [BRAZIL] Files:1 Time: 1s
Serial Phase #:89 [BRAZIL] Files:1 Time: 9s
Restart Phase #:90 [BRAZIL] Files:1 Time: 0s
Serial Phase #:91 [BRAZIL] Files:2 Time: 21s
Restart Phase #:92 [BRAZIL] Files:1 Time: 1s
Serial Phase #:93 [BRAZIL] Files:1 Time: 7s
Restart Phase #:94 [BRAZIL] Files:1 Time: 0s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [BRAZIL] Files:1 Time: 16s
Restart Phase #:96 [BRAZIL] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:97 [BRAZIL] Files:1 Time: 8s
************* Final Upgrade scripts ************
Serial Phase #:98 [BRAZIL] Files:1 Time: 126s
******************* Migration ******************
Serial Phase #:99 [BRAZIL] Files:1 Time: 7s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [BRAZIL] Files:1 Time: 6s
Serial Phase #:101 [BRAZIL] Files:1 Time: 36s
Serial Phase #:102 [BRAZIL] Files:1 Time: 6s
***************** Post Upgrade *****************
Serial Phase #:103 [BRAZIL] Files:1 Time: 18s
**************** Summary report ****************
Serial Phase #:104 [BRAZIL] Files:1 Time: 7s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [BRAZIL] Files:1 Time: 6s
Serial Phase #:106 [BRAZIL] Files:1 Time: 4s
Serial Phase #:107 [BRAZIL] Files:1 Time: 0s

------------------------------------------------------
Phases [0-107] End Time:[2021_03_09 13:45:51]
Container Lists Inclusion:[BRAZIL] Exclusion:[NONE]
------------------------------------------------------

Grand Total Time: 13420s [BRAZIL]

LOG FILES: (/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdbrazil*.log)

Upgrade Summary Report Located in:
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/upg_summary.log

Time: 2832s For CDB$ROOT
Time: 17912s For PDB(s)

Grand Total Time: 20744s

LOG FILES: (/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/catupgrdcdbroot*.log)
Upgrade Summary Report Located in:
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/EUROPE/upgrade20210309075944/upg_summary.log

Grand Total Upgrade Time: [0d:5h:45m:44s]

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8