Oracle Upgrade, oracle 10g and oralce 11g to oracle 12c

Описание

SAP On Oracle Database Upgrade, From Oracle 10g to 12c Direct upgrade,

=================================================
TAKE BACKUP OF EXISITNG DB

brbackup -u / -p initGWP-disk-OFF.sap -d disk -t offline -m all -o time

INSTALL ORACLE 12 DATA BASE


- CHANGE THE HOME DIRECTORY PATH IN ENVIRONEMNT
- Not to ADD FULL PERMISSION IN TO ORALCE INSTALLATION USER
- TAKE A COPY OF OLD ORACLE & AND NEW ORACLE HOME BEFORE APPLYING PATCHES
- TAKE COPY OF NETWORK\ADMIN AND DATABASE FOLDER
- DOWNLOADED LATEST OPATCH AND REPLACE OPATCH FOLDER
- APPYL NEEDED PATCHES USING OPATCHS
- STOP ALL SERVICES ORACLE RELATED FOR APPLYINT PATCHES

**PATCHBUNDLE12102P_1702-20012303.zip
**PATCHBUNDLE12102P_1704-20012303.zip
**P9584028GEN12102P_2-20012303.zip

'EG: B:\Patches\P9584028GEN12102P_2-20012303\9584028 C:\oracle\GWP\12102\OPatch\OPATCH APPLY'

'EG: B:\Patches\PATCHBUNDLE12102P_1702-20012303\25433286 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY'

"EG: B:\Patches\PATCHBUNDLE12102P_1704-20012303\25632533 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY"

-START SERVICES AFTER APPLYING PATCHES FOR UPGRADE.

RUN THE PRE UPGRADE SCRIPT AS FOLLOWS.. PRE UPGRADE SCRIPT WILL PROVIDE YOU WHEN YOU UPDATE PATCHES
================================

OS sqlplus / as sysdba
SQL @pre_upgrade_tasks.sql
SQL @pre_upgrade_checks_ora.sql
SQL @pre_upgrade_checks_sap.sql

THEN CREATE RESTORE POINT FOR RECOVERY IF ANY FAILIUR HAPPEND */
=============================================================
/*(ALTER SYSTEM SET db_recovery_file_dest_size='10G G:\oracle\GWP\oraflash' scope=both;
ALTER SYSTEM SET db_recovery_file_dest= 'E:\oracle\GWQ\oraflash scope=both';)*/

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

SQL @grp_create_restore_point.sql
SQL @grp_list_restore_point.sql

===TAKE BACKUP OF NETWORK/ADMIN & ORAHOME\DATABASE

RUN DUBA from new home (oralce 12c) KEEP DATABSE OPEN FOR UPGRADE.
=====================

CREATE RMAN BACKUP DURING THE UPGRADE


\Post upgrade steps 1915315 - Database Upgrade Scripts for 12.1.0.2
======================================================================


After DUB
create Listner or check the listner status

LSNRCTL/

Go to directory 'post_upgrade' to run the post-upgrade scripts.


--SQL @?/rdbms/admin/utlu121s.sql

--SQL @?/rdbms/admin/utluiobj.sql

--SQL @post_upgrade_tasks.sql

Recompile invalid objects

--SQL @?/rdbms/admin/utlrp.sql

Run post-upgrade checks

--SQL @post_upgrade_checks.sql


Check whether guaranteed restore point 'GRP_BEFORE_UPGRADE_12102' exists:

OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade
OS sqlplus / as sysdba

--SQL @grp_list_restore_point.sql

you need to drop this restore point and set 'COMPATIBLE' to the new value.


OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade
OS sqlplus / as sysdba

--SQL @grp_drop_restore_point.sql

OS cd NEW_ORACLE_HOME /sap/ora_upgrade/post_upgrade
OS sqlplus / as sysdba

--SQL @set_compatible.sql

After setting compatible to a new value, 'RESTART THE DATABASE.'

Ensure that parameter 'compatible' is set to '12.1.0.2.0' or '12.1.0.2':

--SQL SHOW PARAMETER COMPATIBLE

SQL show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.1.0.2.0
noncdb_compatible boolean FALSE

--SQL SELECT VALUE "COMPATIBLE" FROM V$PARAMETER WHERE NAME = 'COMPATIBLE';

Before you start the remaining database post-upgrade tasks you can create a new guaranteed restore point
======================================================

--SQL CREATE RESTORE POINT "'GRP_AFTER_UPGRADE_12102'" GUARANTEE FLASHBACK DATABASE ;

--SQL SELECT NAME FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES';

drop V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES';

Check for invalid objects:
===========================

--SQL select owner, object_name, object_type from dba_objects where status = 'INVALID';


If the object 'DBMS_METADATA' (package body) is still invalid (Ref: patch 17871192), run utlrp to recompile the package.
======================================================
--SQL @?\rdbms\admin\utlrp.sql

--SQL select owner, object_name, object_type from dba_objects where status = 'INVALID';

COPY data from OLDorahome\database\ to new database\ FOLLOWING FILES

INIT SID .SAP
INIT SID .UTL
update the kernel

CHEK THE TNS FILE NAME IN NETWORK\ADMIN

brconnect -u / -c -f stats -t system_stats

brconnect -u / -c -f stats -t oradict_stats

brconnect -u / -c -f stats -t all -f collect -p 4

deinstall the 11g

/*if needed */{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}
=================
sqlplus / as sysdba @sapuprof_profile

Insufficent privillege
134592 - Import of SAPDBA role (sapdba_role.sql)
==========================

sqlplus /nolog @sapdba_role SAPSR3

--CHANGE PARAMTER ONCE UPGRADE COMPLETE.

Visit My Blog:http://wrongcodes.blogspot.com/