Upgrade Oracle Application Express (APEX) manually.

I facing this error because running this scripts using full path like below example.

SQL>@/u02/app/oracle/product/11/db_home1/apex/apexins.sql SYSAUX SYSAUX temp /i/

(sp2-0310 unable to open file "coreins.sql")

First you have to go the apex directory and then run directly from SQL prompt

 cd /u02/app/oracle/product/11/db_home1/apex

sqlplus / as sysdba

SQL>@apexins.sql SYSAUX SYAAUX TEMP /i/

Recommendation 4: Upgrade Oracle Application Express (APEX) manually.

To upgrade to latest Application Express, download the latest version from the below link here

Upgrading APEX

Check the current APEX Version

SQL> Select Comp_name, status, Version

     From Dba_Registry

     where comp_id='APEX';

 

COMP_NAME                                STATUS       VERSION

---------------------------------------- ------------ ------------------------------

Oracle Application Express               VALID        3.2.1.00.12

 

SQL>

From the directory which holds the APEX unzipped software, connect to sqlplus as SYS user and run apexins.sql

cd /u01/app/oracle/product/11/db_home1/apex

sqlplus /as sysdba

SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/

Preupgrade command Fails with:"ERROR - Unable to run sqlplus due to:" (Doc ID 2246672.1)

 

[oracle@oraerptest19c bin]$ pwd

/u02/app/oracle/product/11.2.0/dbhome_1/jdk/bin

[oracle@oraerptest19c bin]$ /u02/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -jar /u02/softw-ora19c/rdbms/admin/preupgrade.jar FILE DIR /u02/preupgrade/

ERROR - Unable to run preupgrade due to: 

ERROR - the following error has been found: java.io.IOException: sqlplus: not found

Solution:

======

[oracle@oraerptest19c bin]$ export PATH=.:$ORACLE_HOME/bin:$PATH

[oracle@oraerptest19c bin]$ /u02/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -jar /u02/softw-ora19c/rdbms/admin/preupgrade.jar FILE DIR /u02/preupgrade/

==================

PREUPGRADE SUMMARY

==================

  /u02/preupgrade/preupgrade.log

  /u02/preupgrade/preupgrade_fixups.sql

  /u02/preupgrade/postupgrade_fixups.sql

Execute fixup scripts as indicated below:

Before upgrade:

Log into the database and execute the preupgrade fixups

@/u02/preupgrade/preupgrade_fixups.sql

After the upgrade:

Log into the database and execute the postupgrade fixups

@/u02/preupgrade/postupgrade_fixups.sql

Preupgrade complete: 2021-01-16T13:24:52

[oracle@oraerptest19c bin]$ 

ORA-01547 warning: RECOVER succeeded but OPEN RESETLOGS would get error below (Doc ID 1684437.1)

While Oracle DB recover getting below error.

RMAN> recover database;

Starting recover at  01-JAN-19

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

starting media recovery

Oracle Error: 

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u02/oradb/proddata/system01.dbf'

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 01/01/2019 05:09:54

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of archived log for thread 1 with sequence 91550 and starting SCN of 149247095 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 91549 and starting SCN of 149235668 found to restore

I just move some missing archive log files to destination server.

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1

released channel: ORA_DISK_2

released channel: ORA_DISK_3

released channel: ORA_DISK_4

released channel: ORA_DISK_5

released channel: ORA_DISK_6

released channel: ORA_DISK_7

released channel: ORA_DISK_8

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=19 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=20 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=21 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=22 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=23 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=24 device type=DISK

allocated channel: ORA_DISK_7

channel ORA_DISK_7: SID=25 device type=DISK

allocated channel: ORA_DISK_8

channel ORA_DISK_8: SID=26 device type=DISK

validation succeeded for archived log

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_91549_940168479.dbf RECID=90596 STAMP=1061762468

validation succeeded for archived log

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_91550_940168479.dbf RECID=90597 STAMP=1061762775

Crosschecked 2 objects

RMAN> recover database;

Starting recover at 16-JAN-21

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

starting media recovery

unable to find archived log

archived log thread=1 sequence=91551

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 01/16/2021 05:17:16

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 91551 and starting SCN of 149248093

RMAN> alter database open resetlogs;

database opened

RMAN> 

Refer: Oracle (Doc ID 1684437.1)

SOLUTION

The ORA-01547 before database open indicates that Oracle sees the datafiles as inconsistent.  This is resolved by applying more recovery, to make the datafiles consistent.  

1. Check the current status of the datafiles:

set numwidth 30;

set pagesize 50000;

alter session set nls_date_format = 'DD-MON-RRRR HH24:MI:SS';

select status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, count(*), fuzzy from v$datafile_header group by status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, fuzzy;

The goal is to have the above query return 1 row and fuzzy column value as NO.

NOTE:  if checkpoint_change# in query returns 0, this indicates that Oracle cannot read the file header.  This is possibly because the location and name of the datafile within the controlfile is not the one on disk.  

2. Check the archivelog sequence numbers needed to recover the files.  Execute:

select min(fhrba_Seq), max(fhrba_Seq) from X$KCVFH;

This query will show the smallest and largest sequence needed by the datafiles.    To make the datafiles consistent, you must apply all archivelog files within the above range of sequence numbers.  This can be one or many archivelog files.  

NOTE:  This query will not be valid in a RAC environment.  In RAC, find the necessary sequences from all threads using the smallest (and largest) checkpoint_change# returned by the query in #1 and execute:

select thread#, first_change#, next_change# from v$archived_log where <smallest/largest checkpoint_change#> between first_change# and next_change#;

once the above is executed with the smallest and largest checkpoint_change#, you have the sequence range needed to be applied from all threads of the RAC database.  See Note 243760.1 'RMAN: RAC Backup and Recovery using RMAN' for more details.  

3. Once further recovery is applied, confirm the datafiles are consistent with query in #1, above, until the goal is accomplished.  

4. Once all datafiles are consistent and fuzzy=NO, the database can be opened and the ORA-01547 should no longer be returned.  

Error in invoking target 'agent nmhs' of make file ins_emagent.mk while installing Oracle 11.2.0.4 on Linux 7.6

While installation Oracle 11g database getting below 

"error in invoking target 'agent nmhs' of make file ins_emagent.mk while installing Oracle 11.2.0.4 on Linux 7.6"

collect2: error: ld returned 1 exit status

/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:176: recipe for target '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/emdctl' failed

make[1]: Leaving directory '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib'

/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: recipe for target 'emdctl' failed

make[1]: *** [/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/emdctl] Error 1

make: *** [emdctl] Error 2

CHANGE

 This is a new oracle 11.2.0.4 installation on LinuxGES

CAUSE

Link error on "ins_emagent.mk".

SOLUTION

Edit $ORACLE_HOME/sysman/lib/ins_emagent.mk, search for the line

$(MK_EMAGENT_NMECTL)

Then replace the line with

$(MK_EMAGENT_NMECTL) -lnnz11

Then click “Retry” button to continue.

How to change host name in Oracle Linux 7.8

 

Use hostnamectl which is a command-line client to systemd-hostnamed service

=========================================================

[root@localhost sysconfig]# hostnamectl status

   Static hostname: localhost.localdomain

         Icon name: computer-vm

           Chassis: vm

        Machine ID: 12289ebafa0e47dea5171eee463b29aa

           Boot ID: e370b31606ac4f41a6df3b96498ac107

    Virtualization: kvm

  Operating System: Oracle Linux Server 7.8

       CPE OS Name: cpe:/o:oracle:linux:7:8:server

            Kernel: Linux 3.10.0-1127.el7.x86_64

      Architecture: x86-64

Set hostname:

============

[root@localhost sysconfig]# hostnamectl set-hostname oraerptest19c.com

[root@localhost sysconfig]# 

Re-Login terminal session:

===================

[root@localhost sysconfig]# hostnamectl status

   Static hostname: oraerptest19c.com

         Icon name: computer-vm

           Chassis: vm

        Machine ID: 12289ebafa0e47dea5171eee463b29aa

           Boot ID: e370b31606ac4f41a6df3b96498ac107

    Virtualization: kvm

  Operating System: Oracle Linux Server 7.8

       CPE OS Name: cpe:/o:oracle:linux:7:8:server

            Kernel: Linux 3.10.0-1127.el7.x86_64

      Architecture: x86-64

[root@localhost sysconfig]# nmcli general hostname

oraerptest19c.com

[root@localhost sysconfig]# hostname

oraerptest19c.com

[root@localhost sysconfig]# nmcli general hostname oraerptest19c.com

[root@localhost sysconfig]# systemctl restart systemd-hostnamed

[root@localhost sysconfig]# 

[root@localhost sysconfig]# 

[root@localhost sysconfig]# hostname

oraerptest19c.com

[root@localhost sysconfig]# 

[root@localhost sysconfig]# cat /etc/hostname

oraerptest19c.com

Change the listening port of the Oracle database

I changed Oracle database listener default port 1521 to 1529.

1. Log in to the Linux operating system as the oracle user.

2. Check the current listening status.
lsnrctl status PROD

3. Stop the listening service.
lsnrctl stop PROD

4. Change the port number in the files tnsnames.ora and listener.ora.
cd /opt/oracle/product/11.2.0/db_1/network/admin/The listening file listener.ora is used as an example to describe how to change the listening port, for example, 1529 to a new listening port.

vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PROD)
(SID_NAME = PROD)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
(ADDRESS = (PROTOCOL = TCP)(HOST = test12.com)(PORT = 1529))
)
)

SECURE_REGISTER_LISTENER=(IPC)

Note: (Make Sure you are using SPFILE....if you pfile then edit pfile save it restart the database)

5. Modify the initialization parameter local_listener.
sqlplus / as sysdba
show parameter local_listener
alter system set local_listener="(address=(protocol=tcp)(host=test12.com)(port=1529))";
exit

6. Start the listening service.
lsnrctl start PROD

7. After the change is complete, log in and test the new listening port.
a. Check whether the listening port is changed.
netstat -na | grep "1521"
b. Check the listening status.
lsnrctl status PROD

EXPDB with sys without knowing password

 

You can export full database using EXPDB utility with out sys user password

$ expdp "'/as sysdba'" full=y directory=EXP_DIR dumpfile=DB11g.dmp logfile=DB11g.log

...

...

...

. . exported "FXERP"."XFND_CONC"                         30.03 KB      34 rows

. . exported "FXERP"."XFND_CUR"                          32.35 KB     249 rows

. . exported "FXERP"."XFND_FLEXKEY"                      23.41 KB      41 rows

. . exported "FXERP"."XFND_FLEXSET"                      22.53 KB      11 rows

. . exported "FXERP"."XFND_LOC"                          23.21 KB       3 rows

. . exported "FXERP"."XFND_LOOKUPSET"                    28.03 KB      82 rows

. . exported "FXERP"."XFND_MENU"                         20.85 KB      43 rows

. . exported "FXERP"."XFND_OU"                           18.05 KB       2 rows

. . exported "FXERP"."XFND_PARTY_BK"                     26.60 KB      44 rows

. . exported "FXERP"."XFND_PROCESS_H"                    16.80 KB      17 rows

. . exported "FXERP"."XFND_PROCESS_L"                    33.45 KB     197 rows

. . exported "FXERP"."XFND_PROCESS_NXT"                  28.74 KB     471 rows

...

...

...

. . exported "FXERP"."XFA_GL_DIST"                           0 KB       0 rows

. . exported "FXERP"."XFA_RETIRE"                            0 KB       0 rows

. . exported "FXERP"."XFND_ATTN"                             0 KB       0 rows

. . exported "FXERP"."XFND_USR_PREFERENCES"                  0 KB       0 rows

. . exported "FXERP"."XMTL_CATEGORY"                         0 KB       0 rows

. . exported "FXERP"."XMTL_CUST_VEND_ITEM"                   0 KB       0 rows

. . exported "FXERP"."XMTL_DEMAND"                           0 KB       0 rows

. . exported "FXERP"."XMTL_ITEM_CATEGORY"                    0 KB       0 rows

. . exported "FXERP"."XMTL_LPN_NUM"                          0 KB       0 rows

. . exported "FXERP"."XMTL_RELATED_ITEM"                     0 KB       0 rows

. . exported "FXERP"."XMTL_SL_NUM"                           0 KB       0 rows

. . exported "FXERP"."XMTL_TRAN_ACCT_BK"                     0 KB       0 rows

. . exported "FXERP"."XMTL_TRX_REASON"                       0 KB       0 rows

. . exported "FXERP"."XXAKI_WH_VAN_H"                        0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_ANON_ATTRS_WRK"               0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_ANON_RULES_WRK"               0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_ACTION_WRK"                0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_DAREFS_WRK"                0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_LOCATORPATHS_WRK"          0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_MACRO_DEP_WRK"             0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_MACRO_PAR_WRK"             0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_PRED_OPRD_WRK"             0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_PRED_PAR_WRK"              0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_PRED_SET_WRK"              0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_PRED_WRK"                  0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_CT_VLD_MSG"                   0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_DATA_MODEL_WRK"               0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_DICT_ATTRS_WRK"               0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_DOCS_WRK"                     0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_DOC_REFS_WRK"                 0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_MAPPED_PATHS"                 0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_MAPPED_PATHS_WRK"             0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_MAPPING_DOCS_WRK"             0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_PRV_ATTRS_WRK"                0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_RT_PREF_PARAMS_WRK"           0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_STD_ATTRS_WRK"                0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_STORED_TAGS"                  0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_STORED_TAGS_WRK"              0 KB       0 rows

. . exported "ORDDATA"."ORDDCM_UID_DEFS_WRK"                 0 KB       0 rows

. . exported "OUTLN"."OL$"                                   0 KB       0 rows

. . exported "OUTLN"."OL$HINTS"                              0 KB       0 rows

. . exported "OUTLN"."OL$NODES"                              0 KB       0 rows

. . exported "OWBSYS"."OWBRTPS"                              0 KB       0 rows

. . exported "SCOTT"."BONUS"                                 0 KB       0 rows

. . exported "SYSTEM"."DEF$_AQCALL"                          0 KB       0 rows

. . exported "SYSTEM"."DEF$_AQERROR"                         0 KB       0 rows

. . exported "SYSTEM"."DEF$_CALLDEST"                        0 KB       0 rows

. . exported "SYSTEM"."DEF$_DEFAULTDEST"                     0 KB       0 rows

. . exported "SYSTEM"."DEF$_ERROR"                           0 KB       0 rows

. . exported "SYSTEM"."DEF$_LOB"                             0 KB       0 rows

. . exported "SYSTEM"."DEF$_ORIGIN"                          0 KB       0 rows

. . exported "SYSTEM"."DEF$_PROPAGATOR"                      0 KB       0 rows

. . exported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS"             0 KB       0 rows

. . exported "SYSTEM"."MVIEW$_ADV_INDEX"                     0 KB       0 rows

. . exported "SYSTEM"."MVIEW$_ADV_PARTITION"                 0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_AUDIT_COLUMN"                 0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_COLUMN_GROUP"                 0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_CONFLICT"                     0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_DDL"                          0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_EXCEPTIONS"                   0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_EXTENSION"                    0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_FLAVORS"                      0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"               0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_GENERATED"                    0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_GROUPED_COLUMN"               0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_INSTANTIATION_DDL"            0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_KEY_COLUMNS"                  0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_OBJECT_PARMS"                 0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_PARAMETER_COLUMN"             0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_PRIORITY"                     0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_PRIORITY_GROUP"               0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_REFRESH_TEMPLATES"            0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_REPCAT"                       0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_REPCATLOG"                    0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_REPCOLUMN"                    0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_REPGROUP_PRIVS"               0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_REPOBJECT"                    0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_REPPROP"                      0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_REPSCHEMA"                    0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_RESOLUTION"                   0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS"        0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL"          0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS"                0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_SITES_NEW"                    0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_SITE_OBJECTS"                 0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_SNAPGROUP"                    0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"             0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS"               0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS"           0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES"               0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS"             0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"          0 KB       0 rows

. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES"             0 KB       0 rows

. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rows

. . exported "XHRMS"."ADJ_MON_DTL"                           0 KB       0 rows

. . exported "XHRMS"."ATTCH"                                 0 KB       0 rows

. . exported "XHRMS"."ATTN_MISSING"                          0 KB       0 rows

. . exported "XHRMS"."EMP_LEAVE"                             0 KB       0 rows

. . exported "XHRMS"."EMP_TERMS"                             0 KB       0 rows

. . exported "XHRMS"."E_TAX"                                 0 KB       0 rows

. . exported "XHRMS"."E_TAX_SUB"                             0 KB       0 rows

. . exported "XHRMS"."FAMILY_DETAIL"                         0 KB       0 rows

. . exported "XHRMS"."FIN_DETAIL"                            0 KB       0 rows

. . exported "XHRMS"."FIN_MAST"                              0 KB       0 rows

. . exported "XHRMS"."GL_CODE"                               0 KB       0 rows

. . exported "XHRMS"."HRMS_DOC"                              0 KB       0 rows

. . exported "XHRMS"."HRMS_MSG"                              0 KB       0 rows

. . exported "XHRMS"."HRMS_MSG_D"                            0 KB       0 rows

. . exported "XHRMS"."HRMS_TRS"                              0 KB       0 rows

. . exported "XHRMS"."HR_TMP"                                0 KB       0 rows

. . exported "XHRMS"."INVESTMENT"                            0 KB       0 rows

. . exported "XHRMS"."MAIL_SCH"                              0 KB       0 rows

. . exported "XHRMS"."MISC_PAY"                              0 KB       0 rows

. . exported "XHRMS"."PFM_D"                                 0 KB       0 rows

...

...

...

. . exported "XHRMS"."XXHR_DSTAT"                            0 KB       0 rows

. . exported "XHRMS"."XXHUM_TEMP"                            0 KB       0 rows

. . exported "XHRMS"."XX_HRDIST"                             0 KB       0 rows

. . exported "XHRMS"."XX_HRDSGN"                             0 KB       0 rows

. . exported "XHRMS"."XX_HRHIST"                             0 KB       0 rows

. . exported "XHRMS"."XX_HRPAY"                              0 KB       0 rows

Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_FULL_01 is:

  /u02/oradb/expdata/DB11g.dmp

Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Tues Jan 11 13:37:31 2020 elapsed 0 00:06:18

Oracle 19c Database Upgrade From 11.2.0.4 to 19.2.0.0 Using DBUA

 

Oracle 19c Database Upgrade From 11.2.0.4 to 19.3.0.0 Using DBUA

Description:-
There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below:
* Database Upgrade Assistant (DBUA)
* Manual Upgrade
* Transportable Table spaces
* Data pump export/import
* Oracle Streams
* Oracle Golden Gate
Here I am going to choose DBUA to upgrade my database,
DBUA provides a graphical user interface to guide you through the upgrade of Oracle Database.
Oracle Database Releases That Support Direct Upgrade
Review the supported options for direct upgrades to the latest Oracle Database release.
You can perform a direct upgrade to the new release from the following releases:
• 11.2.0.4
• 12.1.0.1 and 12.1.0.2
• 12.2.0.1
Steps for upgrade from 11.2.0.4 to 19.3.0.0 using DBUA :-
Pre-steps for DB upgrade :-
rman target / 
run {
allocate channel test_backup_disk1 type disk format '/u01/backup/%d_%U';
backup incremental level 0 tag 'ORCL_BEFORE_UPG'  database;
backup format  tag 'ORCL_CONTROL_FILE' current controlfile;
release channel test_backup_disk1;
}
Take RMAN full backups before upgrade.

Ensure backup is complete before upgrade.

SQL> SELECT * FROM v$backup WHERE status != 'NOT ACTIVE';

no rows selected

Empty Recycle bin.

SQL> PURGE DBA_RECYCLEBIN ;

DBA Recycle bin purged.

Run Gather statistics to finish upgrade soon.

SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

PL/SQL procedure successfully completed.

Remove EM Database Control :-

Copy the $ORACLE_HOME/rdbms/admin/emremove.sql script from the target 19.3.0.0.0 ORACLE_HOME into the source 11.2.0.4.0 ORACLE_HOME.

[oracle@19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 14 20:56:29 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @$ORACLE_HOME/emremove.sql

old 70: IF (upper('&LOGGING') = 'VERBOSE')

new 70: IF (upper('VERBOSE') = 'VERBOSE')

PL/SQL procedure successfully completed.

Remove OLAP Catalog :-

[oracle@19c ~]$ cd $ORACLE_HOME/olap/admin/
SQL> @catnoamd.sql
Synonym dropped.
……
Type dropped.
……
View dropped.
PL/SQL Procedure successfully completed.

Purge Recyclebin :-
SQL> purge recyclebin;
Recyclebin purged.

Run the preupgrade tool.
The preupgrade.jar Pre-Upgrade Information Tool is supplied with
Oracle Database 19c.

This tool has reside in new oracle home.

/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/preupgrade.jar
oracle@19c ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/preupgrade.jar FILE DIR /u01/preupgrade/
==================
PREUPGRADE SUMMARY
==================
/u02/preupgrade/preupgrade.log
/u02/preupgrade/preupgrade_fixups.sql
/u02/preupgrade/postupgrade_fixups.sql
 
Execute fixup scripts as indicated below:
Before upgrade:
Log into the database and execute the preupgrade fixups
@/u01/preupgrade/preupgrade_fixups.sql
After the upgrade:
Log into the database and execute the postupgrade fixups
@/u01/preupgrade/postupgrade_fixups.sql
Preupgrade complete: 2019-03-14T21:28:55

[oracle@oraerptest19c bin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun Jan 17 08:43:28 2021
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> @/u02/preupgrade/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by:       Oracle Preupgrade Script
                         Version: 19.0.0.0.0 Build: 1
Generated on:            2021-01-16 13:24:46
For Source Database:     PROD
Source Database Version: 11.2.0.4.0
For Upgrade to Version:  19.0.0.0.0
Preup                             Preupgrade
Action                            Issue Is
Number  Preupgrade Check Name     Remedied    Further DBA Action
------  ------------------------  ----------  --------------------------------
    1.  purge_recyclebin          YES         None.
    2.  parameter_min_val         NO          Manual fixup recommended.
    3.  invalid_objects_exist     NO          Manual fixup recommended.
    4.  apex_manual_upgrade       NO          Manual fixup recommended.
    5.  case_insensitive_auth     NO          Manual fixup recommended.
    6.  mv_refresh                NO          Informational only.
                                              Further action is optional.
    7.  mv_refresh                NO          Informational only.
                                              Further action is optional.
    8.  pre_fixed_objects         YES         None.
    9.  tablespaces_info          NO          Informational only.
                                              Further action is optional.
   10.  parameter_deprecated      NO          Informational only.
                                              Further action is optional.
   11.  exf_rul_exists            NO          Informational only.
                                              Further action is optional.
   12.  min_archive_dest_size     NO          Informational only.
                                              Further action is optional.
   13.  rman_recovery_version     NO          Informational only.
                                              Further action is optional.

The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database is not ready
for upgrade.  To resolve the outstanding issues, start by reviewing
the preupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
PL/SQL procedure successfully completed.
SQL> 

Now have to fix all recommendation
     1. parameter_min_val         NO          Manual fixup recommended.
     2. invalid_objects_exist     NO          Manual fixup recommended.
     3. apex_manual_upgrade       NO          Manual fixup recommended.
     4. case_insensitive_auth     NO          Manual fixup recommended.

1. parameter_min_val 
1.Parameter_min_val parameter value was 250 recommendation is 300
=========================
4. case_insensitive_auth
=========================
4.case_insensitive_auth parameter value was false recommendation is TURE
=======================
3. apex_manual_upgrade
========================
To upgrade to latest Application Express, download the latest version from the below link here..
https://www.oracle.com/tools/downloads/apex-downloads.html


Upgrading APEX

Check the current APEX Version

SQL> Select Comp_name, status, Version
     From Dba_Registry
     where comp_id='APEX';

COMP_NAME                                STATUS       VERSION
---------------------------------------- ------------ ------------------------------
Oracle Application Express               VALID        3.2.1.00.12


From the directory which holds the APEX unzipped software, connect to sqlplus as SYS user and run apexins.sql


$ cd /tmp/apex
$ sqlplus / as sysdba

SQL>@apexins.sql sysaux sysaux temp /i/

Thank you for installing Oracle Application Express 20.2.0.00.20

Oracle Application Express is installed in the APEX_200200 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/ords/apex_admin

The structure of the link to the Application Express development interface is as follows:
http://host:port/ords

timing for: Phase 3 (Switch)
Elapsed: 00:01:01.77
timing for: Complete Installation
Elapsed: 00:12:14.02

PL/SQL procedure successfully completed.




[oracle@oraerptest19c apex]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 26 06:36:45 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select comp_name,status,version from dba_registry where comp_id='APEX';

COMP_NAME
--------------------------------------------------------------------------------
STATUS	    VERSION
----------- ------------------------------
Oracle Application Express
VALID	    20.2.0.00.20


SQL> 

=================================
2. invalid_objects_exist 
==========================
SQL> select substr(comp_name,1,30) comp_name,substr(comp_id,1,10) comp_id,substr(version,1,12) version, status from dba_registry;

COMP_NAME		       COMP_ID	  VERSION      STATUS
------------------------------ ---------- ------------ -----------
OWB			       OWB	  11.2.0.4.0   VALID
Oracle Application Express     APEX	  3.2.1.00.12  VALID
Spatial 		       SDO	  11.2.0.4.0   VALID
Oracle Multimedia	       ORDIM	  11.2.0.4.0   VALID
Oracle XML Database	       XDB	  11.2.0.4.0   VALID
Oracle Text		       CONTEXT	  11.2.0.4.0   VALID
Oracle Expression Filter       EXF	  11.2.0.4.0   VALID
Oracle Rules Manager	       RUL	  11.2.0.4.0   VALID
Oracle Workspace Manager       OWM	  11.2.0.4.0   VALID
Oracle Database Catalog Views  CATALOG	  11.2.0.4.0   VALID
Oracle Database Packages and T CATPROC	  11.2.0.4.0   VALID

COMP_NAME		       COMP_ID	  VERSION      STATUS
------------------------------ ---------- ------------ -----------
JServer JAVA Virtual Machine   JAVAVM	  11.2.0.4.0   VALID
Oracle XDK		       XML	  11.2.0.4.0   VALID
Oracle Database Java Packages  CATJAVA	  11.2.0.4.0   VALID
OLAP Analytic Workspace        APS	  11.2.0.4.0   VALID
Oracle OLAP API 	       XOQ	  11.2.0.4.0   VALID

16 rows selected.

SQL> 

SQL> select object_name,status from dba_objects where status = 'INVALID';

OBJECT_NAME                         STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
test01_V                      INVALID
Test01_SALES_PK               INVALID


(Before drop any invalid object in database take copy of object(View, Table, Package body.....etc from toad)


SQL> conn test/test123
Connected.

SQL> drop view Test01_v;
view dropped.

SQL> drop package body Test01_Sales_PK;

Package body dropped.

Below Invalid objects because you installed APEX new version... 

SQL> select object_name,status from dba_objects where status = 'INVALID';

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
WWV_FLOW_CREATE_KEY_PACKAGE                                                                                                      INVALID
WWV_FLOW_FILES                                                                                                                   INVALID
WWV_FLOW_TABSET_VIEW                                                                                                             INVALID
WWV_FLOW_TABSET_VIEW2                                                                                                            INVALID
WWV_FLOW_BIW_APPBLDPREF                                                                                                          INVALID
WWV_FLOW_ASSERT                                                                                                                  INVALID
WWV_CRYPT                                                                                                                        INVALID
BIU_WWV_FLOW_SHARED_QUERIES                                                                                                      INVALID
BIU_WWV_FLOW_SQRY_SQL                                                                                                            INVALID
BIU_WWV_FLOW_REPORT_LAYOUTS                                                                                                      INVALID
WWV_BIU_FND_USER                                                                                                                 INVALID

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
WWV_BIU_FLOW_COLLECTION                                                                                                          INVALID
WWV_BIU_INSTALL_SCRIPTS                                                                                                          INVALID
WWV_BIU_INSTALL_CHECKS                                                                                                           INVALID
WWV_BIU_INSTALL_BUILD_OPT                                                                                                        INVALID
WWV_FLOW_WORKSHEET_ROW_TRIG                                                                                                      INVALID
WWV_FLOW_WORKSHEET_RPTS_TRIG                                                                                                     INVALID
VRN                                                                                                                              INVALID
WWV_FLOW_ASFCOOKIE                                                                                                               INVALID
WWV_META_CLEANUP                                                                                                                 INVALID
APEX_APPLICATION_FILES                                                                                                           INVALID
HTMLDB_APPLICATION_FILES                                                                                                         INVALID

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
WWV_FLOW_SW_PARSER                                                                                                               INVALID
WWV_RENDER_REPORT3                                                                                                               INVALID
WWV_FLOW_API                                                                                                                     INVALID
WWV_FLOW_GEN_API2                                                                                                                INVALID
WWV_FLOW_DML                                                                                                                     INVALID
WWV_FLOW_WORKSHEET                                                                                                               INVALID
WWV_FLOW_WORKSHEET_ATTACHMENT                                                                                                    INVALID
WWV_FLOW_WORKSHEET_FORM                                                                                                          INVALID
WWV_FLOW_CACHE                                                                                                                   INVALID
WWV_FLOW_FORMS                                                                                                                   INVALID
WWV_FLOW_FILE_MGR                                                                                                                INVALID

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
WWV_FLOW_FILE_API                                                                                                                INVALID
WWV_FLOW_IMAGE_API_PRIVATE                                                                                                       INVALID
WWV_FLOW_IMAGE_API                                                                                                               INVALID
WWV_FLOW_CSS_API_PRIVATE                                                                                                         INVALID
WWV_FLOW_CSS_API                                                                                                                 INVALID
WWV_FLOW_HTML_API_PRIVATE                                                                                                        INVALID
WWV_FLOW_HTML_API                                                                                                                INVALID
WWV_FLOW_FND_USER_API                                                                                                            INVALID
WWV_FLOW_CUSTOM_AUTH_STD                                                                                                         INVALID
WWV_FLOW_IMP_PARSER                                                                                                              INVALID
HTMLDB_UTIL                                                                                                                      INVALID

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
WWV_FLOW_THEME_MANAGER                                                                                                           INVALID
WWV_FLOW_SW_SCRIPT                                                                                                               INVALID
WWV_FLOW_SW_PARSER                                                                                                               INVALID
WWV_FLOW_SW_UPGRADE                                                                                                              INVALID
APEX_WORKSPACES                                                                                                                  INVALID
APEX_WORKSPACE_FILES                                                                                                             INVALID
APEX_WORKSPACE_SQL_SCRIPTS                                                                                                       INVALID
WWV_MIG_ACC_LOAD                                                                                                                 INVALID
WWV_MIG_FRM_UPDATE_APX_APP                                                                                                       INVALID
WWV_MIG_FRM_UTILITIES                                                                                                            INVALID
WWV_MIG_FRM_LOAD_XML                                                                                                             INVALID

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
WWV_MIG_FRMMENU_LOAD_XML                                                                                                         INVALID
WWV_MIG_RPT_LOAD_XML                                                                                                             INVALID
WWV_MIG_FRM_OLB_LOAD_XML                                                                                                         INVALID
WWV_FLOW_MODEL_API                                                                                                               INVALID
WWV_FLOW_F4000_UTIL                                                                                                              INVALID
WWV_FLOW_REGION_LAYOUT                                                                                                           INVALID
WWV_FLOW_QUERY_BUILDER                                                                                                           INVALID
WWV_FLOW_SW_OBJECT_FEED                                                                                                          INVALID
WWV_FLOW_LOAD_DATA                                                                                                               INVALID
WWV_FLOW_LOAD_EXCEL_DATA                                                                                                         INVALID
WWV_FLOW_TAB_MGR                                                                                                                 INVALID

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
WWV_FLOW_GENERATE_DDL                                                                                                            INVALID
WWV_FLOW_TABLE_DRILL                                                                                                             INVALID
WWV_FLOW_DOWNLOAD                                                                                                                INVALID
WWV_FLOW_COPY_PAGE                                                                                                               INVALID
WWV_FLOW_GENERATE_TABLE_API                                                                                                      INVALID
WWV_FLOW_GEN_HINT                                                                                                                INVALID
WWV_FLOW_XLIFF                                                                                                                   INVALID
WWV_FLOW_CREATE_MODEL_APP                                                                                                        INVALID
WWV_FLOW_HELP                                                                                                                    INVALID
WWV_FLOW_DATA_QUICK_FLOW                                                                                                         INVALID
WWV_FLOW_THEME_FILES                                                                                                             INVALID

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
WWV_FLOW_SW_PAGE_CALLS                                                                                                           INVALID
WWV_FLOW_WIZ_CONFIRM                                                                                                             INVALID
WWV_FLOW_DRAG_LAYOUT                                                                                                             INVALID
WWV_FLOW_DATALOAD_XML                                                                                                            INVALID
WWV_FLOW_INSTALL_WIZARD                                                                                                          INVALID

82 rows selected.

SQL> 

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2021-01-26 07:15:04

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2021-01-26 07:15:24

DOC> The following query reports the number of objects that have compiled
DOC> with errors.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  0

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0


Function created.


PL/SQL procedure successfully completed.


Function dropped.

...(07:15:33) Starting validate_apex for APEX_200200
...(07:15:34) Checking missing sys privileges
...(07:15:34) Re-generating APEX_200200.wwv_flow_db_version
... wwv_flow_db_version is up to date
...(07:15:34) Checking invalid public synonyms
...(07:15:34) Key object existence check
...(07:15:34) Setting DBMS Registry for APEX to valid
...(07:15:34) Exiting validate_apex

PL/SQL procedure successfully completed.

SQL> 



SQL>  select object_name,status from dba_objects where status = 'INVALID';

no rows selected

SQL> 

===========================
Run DBUA upgrade Utility :
============================
Now run the dbua utility from 19c oracle_home location.

[oracle@19c ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@19c ~]$ export ORACLE_SID=upg19c
[oracle@19c ~]$ export ORACLE_HOME=/u02/softw-ora19c
[oracle@19c ~]$ dbua


select the Upgrade Oracle Database option, then click the “Next” button.
If case Source database not showing you have add entry in /etc/oratab file.

$ORACLE_SID:$ORACLE_HOME:Y/N
PROD:/u02/app/oracle/product/11.2.0/dbhome_1:Y


If the prerequisite checks highlight any issues, take the appropriate action to fix the issues. If all the prerequisite checks are passed, click the “Next” button.


Amend the upgrade options if necessary, then click the “Next” button.

Select the recovery options for use in the event of an upgrade failure, then click the “Next” button.


 If the database is using the 11g listener and you need to upgraded, use existing listener or create new 19c listener


If you want configure EM database express enable it and provide port number or uncheck it.







I getting below error related to time zone...you can skip this configure after upgrade.





POST UPGRADE STEPS:

SQL> @/u02/preupgrade/postupgrade_fixups.sql

Session altered.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Package created.

No errors.

Package body created.


PL/SQL procedure successfully completed.

No errors.





Package created.

No errors.

Package body created.

No errors.
Executing Oracle POST-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script
                         Version: 19.0.0.0.0 Build: 1
Generated on:            2021-01-21 05:14:51

For Source Database:     PROD
Source Database Version: 11.2.0.4.0
For Upgrade to Version:  19.0.0.0.0

Preup                             Preupgrade
Action                            Issue Is
Number  Preupgrade Check Name     Remedied    Further DBA Action
------  ------------------------  ----------  --------------------------------
   14.  awr_dbids_present         YES         None.
   15.  old_time_zones_exist      NO          Manual fixup recommended.
   16.  dir_symlinks              YES         None.
   17.  post_dictionary           YES         None.
   18.  post_fixed_objects        NO          Informational only.
                                              Further action is optional.
   19.  upg_by_std_upgrd          YES         None.

The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database upgrade is not
fully complete.  To resolve the outstanding issues, start by reviewing
the postupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.

PL/SQL procedure successfully completed.


Session altered.



=========================================
Time Zone upgrade 19c
==========================================


SQL> select version from v$timezone_file;

   VERSION
----------
        14     <------------------


 
SQL> @/u02/softw-ora19c/rdbms/admin/utltz_upg_check

Session altered.

INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 19.0.0.0 .
INFO: Database RDBMS DST version is DSTv14 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv32 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run utltz_upg_apply.sql to do the actual RDBMS DST update.
INFO: Note that the utltz_upg_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.

Session altered.

SQL> @/u02/softw-ora19c/rdbms/admin/utltz_upg_apply.sql

Session altered.

INFO: If an ERROR occurs, the script will EXIT SQL*Plus.
INFO: The database RDBMS DST version will be updated to DSTv32 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 1761604576 bytes
Fixed Size                  8897504 bytes
Variable Size             419430400 bytes
Database Buffers         1325400064 bytes
Redo Buffers                7876608 bytes
Database mounted.
Database opened.
INFO: Starting the RDBMS DST upgrade.
INFO: Upgrading all SYS owned TSTZ data.
INFO: It might take time before any further output is seen ...
An upgrade window has been successfully started.
INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 1761604576 bytes
Fixed Size                  8897504 bytes
Variable Size             419430400 bytes
Database Buffers         1325400064 bytes
Redo Buffers                7876608 bytes
Database mounted.
Database opened.
INFO: Upgrading all non-SYS TSTZ data.
INFO: It might take time before any further output is seen ...
INFO: Do NOT start any application yet that uses TSTZ data!
INFO: Next is a list of all upgraded tables:
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_PKG_APP_INSTALL_LOG"
Number of failures: 0
Table list: "APEX_200200"."APEX$ARCHIVE_CONTENTS"
Number of failures: 0
Table list: "APEX_200200"."APEX$ARCHIVE_HISTORY"
Number of failures: 0
Table list: "APEX_200200"."APEX$ARCHIVE_LOG"
Number of failures: 0
Table list: "APEX_200200"."APEX$ARCHIVE_PREF"
Number of failures: 0
Table list: "APEX_200200"."APEX$ARCHIVE_HEADER"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_ISSUE_NOTIFICATIONS"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_WEB_SRC_MODULES"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_AUTOMATION_LOG2$"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_AUTOMATION_MSG_LOG1$"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_AUTOMATION_MSG_LOG2$"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_AUTOMATION_LOG1$"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_WORKSHEET_NOTIFY"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_FEEDBACK"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_FEEDBACK_FOLLOWUP"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_WEBSOURCE_SYNC_LOG1$"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_WEBSOURCE_SYNC_LOG2$"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_ACTIVITY_LOG1$"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_ACTIVITY_LOG2$"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_DEBUG_MESSAGES"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_DEBUG_MESSAGES2"
Number of failures: 0
Table list: "APEX_200200"."WWV_FLOW_AUTOMATIONS"
Number of failures: 0
Table list: "APEX_200200"."WWV_QS_RANDOM_NAMES"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
INFO: Total failures during update of TSTZ data: 0 .
An upgrade window has been successfully ended.
INFO: Your new Server RDBMS DST version is DSTv32 .
INFO: The RDBMS DST update is successfully finished.
INFO: Make sure to exit this SQL*Plus session.
INFO: Do not use it for timezone related selects.

Session altered.

SQL> select version from v$timezone_file;

   VERSION
----------
        32   <-------------------------

1 row selected.

SQL> 


SQL> @/u02/preupgrade/postupgrade_fixups.sql

Session altered.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Package created.

No errors.

Package body created.


PL/SQL procedure successfully completed.

No errors.




1 row selected.


Package created.

No errors.

Package body created.

No errors.
Executing Oracle POST-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script
                         Version: 19.0.0.0.0 Build: 1
Generated on:            2021-01-21 05:14:51

For Source Database:     PROD
Source Database Version: 11.2.0.4.0
For Upgrade to Version:  19.0.0.0.0

Preup                             Preupgrade
Action                            Issue Is
Number  Preupgrade Check Name     Remedied    Further DBA Action
------  ------------------------  ----------  --------------------------------
   14.  awr_dbids_present         YES         None.
   15.  old_time_zones_exist      YES         None.
   16.  dir_symlinks              YES         None.
   17.  post_dictionary           YES         None.
   18.  post_fixed_objects        NO          Informational only.
                                              Further action is optional.
   19.  upg_by_std_upgrd          YES         None.

The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database upgrade is not
fully complete.  To resolve the outstanding issues, start by reviewing
the postupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.

PL/SQL procedure successfully completed.


Session altered.

SQL> 

SQL> select VERSION,name,open_mode from v$instance,v$database;

VERSION 	  NAME	    OPEN_MODE
----------------- --------- --------------------
19.0.0.0.0	  PROD	    READ WRITE

SQL> select  * from v$timezone_file;

FILENAME		VERSION     CON_ID
-------------------- ---------- ----------
timezlrg_14.dat 	     32 	 0

SQL> select TZ_VERSION FROM REGISTRY$DATABASE;

TZ_VERSION
----------
	32