*** 11.2.0.3.0 to 12.1.0.2**

INSTALL 12.1.0 software only
INSTALL EXAMPLES
unzip the time zone for for 12.1.0.2 ***********
check the preupdaig.sql
taken backup of INVALIDS **********
checked the tables spaces rqeutired size especailly temp table space**************
again execute the Preupdaig.sql *********
Executed Gather schema stat
Executed purge reciylce bin
checked the table dba_2pc_pending for distriubted jobs pending status.
check the 11gcompnent versions from dba_registry
upgraded apex from 4.1.0.2 to 4.6.0.2
checked the upgraded apex veresion form dba_registry
bring down the 11g database ***************
sourced 12c.env
strated db with upgrade mode
executed catctl.pl from 12.1.0.2 HOME
executed utl12c.sql for the database upgrade process went fine or not
upgraded TIME ZONE Version 14 to 18
Applied LATEST CPU PATCH for 12.1.0.2
ADD entries for ASO and ANO
POST DB and APPLICATION CheckES

###STEP BY STEP PROCESS###

Contents

Apply the following patches for environments without the In-Memory option enabled:

DST Version Validation

SQL> select VERSION from v$timezone_file;

VERSION

----------

SQL> select TZ_VERSION from registry$database;

TZ_VERSION

----------

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME;

PROPERTY_NAME VALUE

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

DST_PRIMARY_TT_VERSION 14

DST_SECONDARY_TT_VERSION 0

DST_UPGRADE_STATE NONE

Pre-Upgrade steps

Check the integrity of the source database

Run dbupdiag.sql

Ref: Note 556610.1 Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)

Misc Pre-Upgrade Steps

Run the Pre-Upgrade Information Tool from the environment of the database that will be upgraded.
You must analyze your database before upgrading it to the new release.
Note that the database must be running in normal mode in the old release.

SQL> @preupgrd.sql

Loading Pre-Upgrade Package...

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

Executing Pre-Upgrade Checks in OAPCDL7...

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

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

====>> ERRORS FOUND for OAPCDL7 <<====

The following are *** ERROR LEVEL CONDITIONS *** that must be addressed

prior to attempting your upgrade.

Failure to do so will result in a failed upgrade.

You MUST resolve the above errors prior to upgrade

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

====>> PRE-UPGRADE RESULTS for OAPCDL7 <<====

ACTIONS REQUIRED:

1. Review results of the pre-upgrade checks:

/oapcdl7/oracle/cfgtoollogs/oapcdl7/preupgrade/preupgrade.log

2. Execute in the SOURCE environment BEFORE upgrade:

/oapcdl7/oracle/cfgtoollogs/oapcdl7/preupgrade/preupgrade_fixups.sql

3. Execute in the NEW environment AFTER upgrade:

/oapcdl7/oracle/cfgtoollogs/oapcdl7/preupgrade/postupgrade_fixups.sql

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

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

Pre-Upgrade Checks in OAPCDL7 Completed.

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

SQL> create pfile='/tmp/pfile11g.ora' from spfile;

SQL> exit

Emromemove- log placed in other file

Run utlrp

SQL> select count(*) from dba_2pc_pending;

COUNT(*)

----------

SQL> PURGE DBA_RECYCLEBIN

2 ;

DBA Recyclebin purged.

Dependencies on Network Utility Packages

SQL> set lines 200

SQL> set pages 2000

SQL> spool step_4.3_spool.log

SQL> SELECT * FROM DBA_DEPENDENCIES

WHERE referenced_name IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_

INADDR','DBMS_LDAP')

AND owner NOT IN ('SYS','PUBLIC','ORDPLUGINS')

2 3 4 5 /

Database Links with Passwords from Earlier Releases

SQL> set pages 50000

SQL> spool db_links_bef_upg.spool

SQL> SELECT 'CREATE '||DECODE(U.NAME,'PUBLIC','public ')||'DATABASE LINK '||CHR(10)

||DECODE(U.NAME,'PUBLIC',Null, 'SYS','',U.NAME||'.')|| L.NAME||chr(10)

||'CONNECT TO ' || L.USERID || ' IDENTIFIED BY "'||L.PASSWORD||'" USING

'''||L.HOST||''''

2 3 4 5 ||chr(10)||';' TEXT

FROM SYS.LINK$ L, SYS.USER$ U

WHERE L.OWNER# = U.USER#

Optimizer Statistics

$ sqlplus "/as sysdba"
SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

Already completed.

15:22:46 SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

PL/SQL procedure successfully completed.

15:25:58 SQL> exit

Verify That Materialized View Refreshes Have Completed Before Upgrading

SQL> select s.obj#,o.obj#,s.containerobj#,lastrefreshdate,pflags,xpflags,o.name,o.owner#, bitand(s.mflags, 8) from obj$ o, sum$ s

where o.obj# = s.obj# and o.type# = 42 AND bitand(s.mflags, 8) = 8; 2

no rows selected

follow this note id – If you see any rows.( 1442457.1)

Ensure That No Files Need Media Recovery Before Upgrading

SQL> SELECT * FROM v$recover_file;

no rows selected

Ensure That No Files Are in Backup Mode Before Upgrading

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

no rows selected

Resolve Outstanding Distributed Transactions Before Upgrading

SQL> SELECT * FROM dba_2pc_pending;

no rows selected

Purge the Database Recycle Bin Before Upgrading

SQL> PURGE DBA_RECYCLEBIN ;

DBA Recyclebin purged.

Disable all batch and cron jobs

Verify SYS and SYSTEM Default tablespace

Ensure the users SYS and SYSTEM have 'SYSTEM' as their default tablespace.

SQL> SELECT username, default_tablespace

FROM dba_users

WHERE username in ('SYS','SYSTEM'); 2 3

USERNAME DEFAULT_TABLESPACE

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

SYSTEM SYSTEM

SYS SYSTEM

Check whether database has any externally authenticated SSL users

SQL> SELECT name FROM sys.user$

WHERE ext_username IS NOT NULL

AND password = 'GLOBAL'; 2 3

no rows selected

Remove Enterprise Manager Database Control repository

$ emctl status dbcontrol

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

Note: Repository does not exist.

Check the XDB ACLs has start_date and end_date ACE attributes

SQL> select aclid, start_date, end_date from xds_ace where start_date is not null;

no rows selected

APEX upgrade:

SQL> select owner,object_name from dba_objects where object_name = 'WWV_FLOWS';

OWNER OBJECT_NAME

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

APEX_030200 WWV_FLOWS

SQL> select count(*) from APEX_030200.WWV_FLOWS where id= 4000;

COUNT(*)

----------

If the query return 0, it is a runtime and apxtins.sql should be used for upgrade. If query returns 1 this is a development install and apexins.sql should be used.

Here our output is 1 so we need to execute apexins.sql

Download APEX from document id : 1088970.1

sqlplus / as sysdba

SQL> @apexins SYSAUX SYSAUX TEMP /i/

Elapsed: 00:00:00.67

old 1: alter session set current_schema = ^APPUN

new 1: alter session set current_schema = APEX_040200

Session altered.

timing for: Complete Installation

Elapsed: 00:24:51.07

PL/SQL procedure successfully completed.

[ogorappmd1@ogppml3982dv apex]$ cp -r /orpppmd1/backup/staging/apex/apex/images .

[ogorappmd1@ogppml3982dv apex]$ pwd

/orpppmd1/oracle/11.2.0/apex

[ogorappmd1@ogppml3982dv apex]$

Sqlplus ‘/as sysdba’

SQL> @apxldimg.sql /orpppmd1/oracle/11.2.0

PL/SQL procedure successfully completed.

. Loading images directory: /orpppmd1/oracle/11.2.0/apex/images

Directory created.

PL/SQL procedure successfully completed.

Commit complete.

Directory dropped.

timing for: Load Images

Elapsed: 00:02:44.27

SQL> spool off;

SQL> column comp_name format a40

column status format a10

column version format a15

SQL> SQL> SQL>

SQL>

SQL> select comp_name,status,version from dba_registry order by 1;

COMP_NAME STATUS VERSION

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

JServer JAVA Virtual Machine VALID 11.2.0.3.0

OLAP Analytic Workspace VALID 11.2.0.3.0

OLAP Catalog VALID 11.2.0.3.0

OWB VALID 11.2.0.3.0

Oracle Application Express VALID 4.2.6.00.03

Oracle Database Catalog Views VALID 11.2.0.3.0

Oracle Database Java Packages VALID 11.2.0.3.0

Oracle Database Packages and Types VALID 11.2.0.3.0

Oracle Expression Filter VALID 11.2.0.3.0

Oracle Multimedia VALID 11.2.0.3.0

Oracle OLAP API VALID 11.2.0.3.0

COMP_NAME STATUS VERSION

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

Oracle Rules Manager VALID 11.2.0.3.0

Oracle Text VALID 11.2.0.3.0

Oracle Workspace Manager VALID 11.2.0.3.0

Oracle XDK VALID 11.2.0.3.0

Oracle XML Database VALID 11.2.0.3.0

Spatial VALID 11.2.0.3.0

17 rows selected.

Remove or comment out obsolete and deprecated initialization parameters

> *.sec_case_sensitive_logon=FALSE

Removed SEC_CASE_SENSITIVE_LOGON parameter as per recommended.

Cluster_database is set to FALSE.

Shutdown source database

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

Set environment variables

Before Upgrade make sure you have added more temporary tablespace to avoid errors during the upgrade process

Upgrading Database to 12cR1

SQL> startup upgrade pfile='/tmp/pfile.ora'

ORACLE instance started.

Total System Global Area 3154116608 bytes

Fixed Size 2929352 bytes

Variable Size 1996492088 bytes

Database Buffers 1140850688 bytes

Redo Buffers 13844480 bytes

Database mounted.

Database opened.

SQL> select status from v$instance;

STATUS

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

OPEN MIGRATE

Run the catctl.pl script from the new Oracle home.
In this release, the new Upgrade Utility, catctl.pl, replaces catupgrd.sql.

[osapcdl7@ogerpl3914dv product]$ cd -

/oapcdl7/oracle/12.1.0.2/product/rdbms/admin

[osapcdl7@ogerpl3914dv admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 6 -l $ORACLE_HOME/diagnostics catupgrd.sql

Argument list for [catctl.pl]

SQL Process Count n = 6

SQL PDB Process Count N = 0

Input Directory d = 0

Phase Logging Table t = 0

Log Dir l = /oapcdl7/oracle/12.1.0.2/product/diagnostics

Script s = 0

Serial Run S = 0

Upgrade Mode active M = 0

Start Phase p = 0

End Phase P = 0

Log Id i = 0

Run in c = 0

Do not run in C = 0

Echo OFF e = 1

No Post Upgrade x = 0

Reverse Order r = 0

Open Mode Normal o = 0

Debug catcon.pm z = 0

Debug catctl.pl Z = 0

Display Phases y = 0

Child Process I = 0

catctl.pl version: 12.1.0.2.0

Oracle Base = /oapcdl7/oracle

Analyzing file catupgrd.sql

Log files in /oapcdl7/oracle/12.1.0.2/product/diagnostics

catcon: ALL catcon-related output will be written to /oapcdl7/oracle/12.1.0.2/product/diagnostics/catupgrd_catcon_47591.lst

catcon: See /oapcdl7/oracle/12.1.0.2/product/diagnostics/catupgrd*.log files for output generated by scripts

catcon: See /oapcdl7/oracle/12.1.0.2/product/diagnostics/catupgrd_*.lst files for spool files, if any

Number of Cpus = 4

SQL Process Count = 6

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

Phases [0-73]

Serial Phase #: 0 Files: 1 Time: 90s

Serial Phase #: 1 Files: 5 Time: 23s

Restart Phase #: 2 Files: 1 Time: 0s

Parallel Phase #: 3 Files: 18 Time: 4s

Restart Phase #: 4 Files: 1 Time: 0s

Serial Phase #: 5 Files: 5 Time: 10s

Serial Phase #: 6 Files: 1 Time: 6s

Serial Phase #: 7 Files: 4 Time: 5s

Restart Phase #: 8 Files: 1 Time: 0s

Parallel Phase #: 9 Files: 62 Time: 15s

Restart Phase #:10 Files: 1 Time: 0s

Serial Phase #:11 Files: 1 Time: 8s

Restart Phase #:12 Files: 1 Time: 0s

Parallel Phase #:13 Files: 91 Time: 4s

Restart Phase #:14 Files: 1 Time: 0s

Parallel Phase #:15 Files: 111 Time: 8s

Restart Phase #:16 Files: 1 Time: 0s

Serial Phase #:17 Files: 3 Time: 1s

Restart Phase #:18 Files: 1 Time: 0s

Parallel Phase #:19 Files: 32 Time: 10s

Restart Phase #:20 Files: 1 Time: 0s

Serial Phase #:21 Files: 3 Time: 4s

Restart Phase #:22 Files: 1 Time: 0s

Parallel Phase #:23 Files: 23 Time: 51s

Restart Phase #:24 Files: 1 Time: 0s

Parallel Phase #:25 Files: 11 Time: 23s

Restart Phase #:26 Files: 1 Time: 0s

Serial Phase #:27 Files: 1 Time: 0s

Restart Phase #:28 Files: 1 Time: 0s

Serial Phase #:30 Files: 1 Time: 0s

Serial Phase #:31 Files: 257 Time: 15s

Serial Phase #:32 Files: 1 Time: 0s

Restart Phase #:33 Files: 1 Time: 0s

Serial Phase #:34 Files: 1 Time: 2s

Restart Phase #:35 Files: 1 Time: 0s

Restart Phase #:36 Files: 1 Time: 0s

Serial Phase #:37 Files: 4 Time: 33s

Restart Phase #:38 Files: 1 Time: 0s

Parallel Phase #:39 Files: 13 Time: 32s

Restart Phase #:40 Files: 1 Time: 0s

Parallel Phase #:41 Files: 10 Time: 4s

Restart Phase #:42 Files: 1 Time: 0s

Serial Phase #:43 Files: 1 Time: 5s

Restart Phase #:44 Files: 1 Time: 0s

Serial Phase #:45 Files: 1 Time: 3s

Serial Phase #:46 Files: 1 Time: 0s

Restart Phase #:47 Files: 1 Time: 0s

Serial Phase #:48 Files: 1 Time: 73s

Restart Phase #:49 Files: 1 Time: 0s

Serial Phase #:50 Files: 1 Time: 23s

Restart Phase #:51 Files: 1 Time: 0s

Serial Phase #:52 Files: 1 Time: 17s

Restart Phase #:53 Files: 1 Time: 0s

Serial Phase #:54 Files: 1 Time: 106s

Restart Phase #:55 Files: 1 Time: 0s

Serial Phase #:56 Files: 1 Time: 40s

Restart Phase #:57 Files: 1 Time: 0s

Serial Phase #:58 Files: 1 Time: 74s

Restart Phase #:59 Files: 1 Time: 0s

Serial Phase #:60 Files: 1 Time: 168s

Restart Phase #:61 Files: 1 Time: 0s

Serial Phase #:62 Files: 1 Time: 27s

Restart Phase #:63 Files: 1 Time: 0s

Serial Phase #:64 Files: 1 Time: 1s

Serial Phase #:65 Files: 1 Calling sqlpatch with LD_LIBRARY_PATH=/oapcdl7/oracle/12.1.0.2/product/lib; export LD_LIBRARY_PATH;/oapcdl7/oracle/12.1.0.2/product/perl/bin/perl -I /oapcdl7/oracle/12.1.0.2/product/rdbms/admin -I /oapcdl7/oracle/12.1.0.2/product/rdbms/admin/../../sqlpatch /oapcdl7/oracle/12.1.0.2/product/rdbms/admin/../../sqlpatch/sqlpatch.pl -verbose -upgrade_mode_only > /oapcdl7/oracle/12.1.0.2/product/diagnostics/catupgrd_datapatch_upgrade.log 2> /oapcdl7/oracle/12.1.0.2/product/diagnostics/catupgrd_datapatch_upgrade.err

returned from sqlpatch

Time: 31s

Serial Phase #:66 Files: 1 Time: 28s

Serial Phase #:68 Files: 1 Time: 0s

Serial Phase #:69 Files: 1 Calling sqlpatch with LD_LIBRARY_PATH=/oapcdl7/oracle/12.1.0.2/product/lib; export LD_LIBRARY_PATH;/oapcdl7/oracle/12.1.0.2/product/perl/bin/perl -I /oapcdl7/oracle/12.1.0.2/product/rdbms/admin -I /oapcdl7/oracle/12.1.0.2/product/rdbms/admin/../../sqlpatch /oapcdl7/oracle/12.1.0.2/product/rdbms/admin/../../sqlpatch/sqlpatch.pl -verbose > /oapcdl7/oracle/12.1.0.2/product/diagnostics/catupgrd_datapatch_normal.log 2> /oapcdl7/oracle/12.1.0.2/product/diagnostics/catupgrd_datapatch_normal.err

returned from sqlpatch

Time: 41s

Serial Phase #:70 Files: 1 Time: 67s

Serial Phase #:71 Files: 1 Time: 0s

Serial Phase #:72 Files: 1 Time: 0s

Serial Phase #:73 Files: 1 Time: 20s

Grand Total Time: 1074s

LOG FILES: (catupgrd*.log)

Upgrade Summary Report Located in:

/oapcdl7/oracle/12.1.0.2/product/cfgtoollogs/oapcdl7/upgrade/upg_summary.log

Grand Total Upgrade Time: [0d:0h:17m:54s]

Run utlu121s.sql to verify the upgrade process

SQL> spool utlu121s.log

SQL> @utlu121s.sql

PL/SQL procedure successfully completed.

CATCTL REPORT = /oapcdl7/oracle/12.1.0.2/product/cfgtoollogs/oapcdl7/upgrade/upg_summary.log

PL/SQL procedure successfully completed.

Oracle Database 12.1 Post-Upgrade Status Tool 05-03-2018 06:23:12

Component Current Version Elapsed Time

Name Status Number HH:MM:SS

Oracle Server UPGRADED 12.1.0.2.0 00:05:55

JServer JAVA Virtual Machine VALID 12.1.0.2.0 00:01:12

Oracle Workspace Manager VALID 12.1.0.2.0 00:00:32

OLAP Analytic Workspace VALID 12.1.0.2.0 00:00:16

OLAP Catalog OPTION OFF 11.2.0.3.0 00:00:00

Oracle OLAP API VALID 12.1.0.2.0 00:00:17

Oracle XDK VALID 12.1.0.2.0 00:00:22

Oracle Text VALID 12.1.0.2.0 00:00:30

Oracle XML Database VALID 12.1.0.2.0 00:01:14

Oracle Database Java Packages VALID 12.1.0.2.0 00:00:08

Oracle Multimedia VALID 12.1.0.2.0 00:01:13

Spatial UPGRADED 12.1.0.2.0 00:02:47

Oracle Application Express VALID 4.2.6.00.03 00:00:00

Final Actions 00:00:57

Post Upgrade 00:01:05

Total Upgrade Time: 00:16:45

PL/SQL procedure successfully completed.

SQL>

SQL> --

SQL> -- Update Summary Table with con_name and endtime.

SQL> --

SQL> UPDATE sys.registry$upg_summary SET reportname = :ReportName,

2 con_name = SYS_CONTEXT('USERENV','CON_NAME'),

3 endtime = SYSDATE

4 WHERE con_id = -1;

1 row updated.

SQL> commit;

Commit complete.

SQL>

Check for the integrity of the upgraded database by running dbupgdiag.sql script from the below article:
Note 556610.1 Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)

Post Upgrade Steps

Environment Variables and oratab file

Modify initialization parameters

SQL> show parameter REMOTE_LOGIN_PASSWORDFILE

NAME TYPE VALUE

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

remote_login_passwordfile string EXCLUSIVE

SQL> show parameter COMPATIBLE

NAME TYPE VALUE

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

compatible string 12.0.0

Upgrade the Time Zone File Version after Upgrading Oracle Database

SQL> @upg_tzv_check.sql

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 12.1.0.2 .

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 DSTv18 .

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 upg_tzv_apply.sql to do the actual RDBMS DST update.

INFO: Note that the upg_tzv_apply.sql script will

INFO: restart the database 2 times WITHOUT any confirmation or prompt.

SQL>

SQL> @upg_tzv_apply.sql

INFO: If an ERROR occurs the script will EXIT sqlplus.

INFO: The database RDBMS DST version will be updated to DSTv18 .

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.

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 3154116608 bytes

Fixed Size 2929352 bytes

Variable Size 1996492088 bytes

Database Buffers 1140850688 bytes

Redo Buffers 13844480 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 ...

Redo Buffers 13844480 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: "APEX_040200"."WWV_FLOW_WORKSHEET_NOTIFY"

Number of failures: 0

Table list: "APEX_040200"."WWV_FLOW_FEEDBACK_FOLLOWUP"

Number of failures: 0

Table list: "APEX_040200"."WWV_FLOW_FEEDBACK"

Number of failures: 0

Table list: "APEX_040200"."WWV_FLOW_DEBUG_MESSAGES2"

Number of failures: 0

Table list: "APEX_040200"."WWV_FLOW_DEBUG_MESSAGES"

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 DSTv18 .

INFO: The RDBMS DST update is successfully finished.

INFO: Make sure to exit this sqlplus session.

INFO: Do not use it for timezone related selects.

SQL> SELECT version FROM v$timezone_file;

VERSION

----------

1 row selected.

Sanity Checks:

TimeZone Version:

SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES

WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME;

DB Components Version and Status:

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

SET VERIFY OFF

COL comp_name FOR a44 HEA 'Component'

COL version FOR a17 HEA 'Version'

COL status FOR a17 HEA 'Status'

SELECT comp_name, version, status FROM dba_registry

Ensure That No Files Need Media Recovery

SQL> SELECT * FROM v$recover_file;

no rows selected

Ensure That No Files Are in Backup Mode

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

no rows selected

Alert log Verification:

ASO / ANO – Enabling:

Enable below option in sql net.ora:

[orauser@servername admin]$ cat sqlnet.ora

# sqlnet.ora Network Configuration File: /XXX/grcapp/11.2.0/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

#ADR_BASE = /XXX/grcapp

SQLNET.ALLOWED_LOGON_VERSION=8

SQLNET.ENCRYPTION_SERVER=REQUIRED

SQLNET.ENCRYPTION_TYPES_SERVER=(AES256, AES192, 3DES168, RC4_256, 3DES112)

SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED

SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1,MD5)

SQLNET.ENCRYPTION_CLIENT=REQUIRED

SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256)

SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED

SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(MD5)

You have new mail in /var/spool/mail/XXXX

MULTI CLOUD-ORACLE APPLICATIONS

DB UPGRADE

Upgrading Database from 12.1.0.2

Installation

Install the 12c software

Install Examples cd :-

DST Version Validation

Pre-Upgrade steps

Check the integrity of the source database

Misc Pre-Upgrade Steps

Dependencies on Network Utility Packages

Database Links with Passwords from Earlier Releases

Optimizer Statistics

Verify That Materialized View Refreshes Have Completed Before Upgrading

Ensure That No Files Need Media Recovery Before Upgrading

Ensure That No Files Are in Backup Mode Before Upgrading

Resolve Outstanding Distributed Transactions Before Upgrading

Purge the Database Recycle Bin Before Upgrading

Disable all batch and cron jobs

Verify SYS and SYSTEM Default tablespace

Check whether database has any externally authenticated SSL users

Remove Enterprise Manager Database Control repository

Check the XDB ACLs has start_date and end_date ACE attributes

APEX upgrade:

Remove or comment out obsolete and deprecated initialization parameters

Shutdown source database

Set environment variables

Before Upgrade make sure you have added more temporary tablespace to avoid errors during the upgrade process

Upgrading Database to 12cR1

Run utlu121s.sql to verify the upgrade process

Post Upgrade Steps

Environment Variables and oratab file

Upgrade the Time Zone File Version after Upgrading Oracle Database

ASO / ANO – Enabling:

Followers