Steps to upgrade 11.2.0.3 to 12.1.0.1 using Manual Method

-

Manual Up-gradation by Amar Jadhav 
Pre-requisite from 11.2.0.3 to 12.1.0.1
CREATE a USER with DBA group
Example: #useradd –g dba upgrade
#passwd upgrade
Create required directory structure for ORACLE-HOME11G,ORACLE-BASE & ORACLE-HOME 12C by single user like (upgrade) .
NOTE:            (Use SPFILE for oracle 11g database)
Step-1: Create 11.2.0.3 Oracle software and create database using DBCA (Please don’t install Oracle Enterprise Manager), if already installed remove it.
Step-2: Create 12.1.0.1 Oracle software only.
Step-3: STARTUP oracle 11g database.
Step-4: copy three scripts (utlu121i.sql, utluppkg.sql, preupgrd.sql) from ORACLE-HOME12C/rdbms/admin To ORACLE-BASE location.
Step-5: execute it from SQL> utlu121i.sql then preupgrd.sql (preupgrd.sql script create one log file and two scripts ( preupgrd_fixups.sql & postupgrd_fixups.sql ).
Step-6: Go to preupgrd_fixups.sql location and execute it on SQL>.
Step-7: Shutdown 11g Database properly copy SPFILE from ORACLE-HOME11G/dbs/ location to ORACLE-HOME12C/dbs/ location.
Step-8: Edit .bash_profile of upgrade user comment ORACLE_HOME11G, uncomment ORACLE_HOME12C save it and execute.
Step-9: Now startup 12c like (STARTUP UPGRADE)
Step-10: Go to ORACLE_HOME12C/rdbms/admin/ location and execute catupgrd.sql parallel=NO on SQL> (it will take much time please wait to complete it)
Step-11: Now execute postupgrd_fixups.sql on SQL>.
Step12: check how many database objects are invalid from dba_objects views.
SQL> SELECT COUNT(*) FROM DBA_OBJECTS where status=’INVALID’
Step-13: Go to ORCLE_HOME12C/rdbms/admin/ location &execute utlrp.sql and again check invalid objects using above SQL statement
(Successfully up-gradation completed)


Comments

Post a Comment

Popular posts from this blog

Compression Tools in Linux[TAR,gzip]

-
Compression Tools: tar: to compress files compress files: ``````````````` syn: tar -cvf <tarfilename> <file(s)> ex: tar -cvf files.tar hello.txt hi.txt raj.txt -c: create -v: verbose -f: tar file name Uncompress files: ````````````````` syn: tar -xvf files.tar tar with GZIP feature: `````````````````````` compress: tar -czvf files.tar.gz file1 file2 file3 file4 uncompress: tar -xzvf files.tar.gz -------------------------------------------------------------------------- gzip & gunzip: gzip: to compress file(s) ex: gzip hello.txt gunzip: to uncompress the file(s) ex: gunzip hello.txt.gz ----------------------------------------------------------------------- Storing and Analysing Logs: What is a log file: A log file is that which have information about all activities done on a linux serer. By default log files will be available under /var/log/ folder. Files: messages: Contains most of the information about different activites secure : contains securi...
Read more

All about DataInstaller & Hrglobal.drv in Oracle Applications R12

-
All about DataInstaller & Hrglobal.drv in Oracle Applications All about DataInstaller & Hrglobal.drv in Oracle Applications This posts covers what is datainstaller & hrglobal.drv and when do we need to run them. DataInstaller and hrglobal.drv are used for installing legislative data into Oracle Applications,For example a company operates in multiple counntries and payroll and HR practices are different in each countires, So they need to have all the legislative regulations (Taxation and HR rules and regulations) of the all the countries they run their business. To achive this Oracle provides a set of patches, which need to applied to the Oracle applications. These patches are country specific, The patch matrix can be found from Latest Oracle HRMS Legislative Data Patch Available (HR Global / hrglobal) [ID 145837.1] To Install the legislative data please follow the below 4 steps: 1) PER & PAY modules need to be licenced ( This is madantory requirement) ...
Read more

PSU Patching step by step on RAC

-
OPatch utility version 12.1.0.1.7 or later to apply this patch. Grid Patch:---------------------------------------------------------------------------------------------------------------- From Oracle Home as oracle user:- /o001/home/oracle/product/12.1.0/db_1/OPatch/opatch lsinventory -detail -oh /o001/home/oracle/product/12.1.0/db_1 From Grid Home as grid user:- /o001/home/12.1.0/grid/OPatch/opatch lsinventory -detail -oh /o001/home/12.1.0/grid As root user:- /o001/home/12.1.0/grid/OPatch/opatchauto apply /o002/Oct_PSU_Patch/26635815 -analyze export PATH=/o001/home/12.1.0/grid/OPatch:$PATH opatchauto apply <UNZIPPED_PATCH_LOCATION>/27010872 Check Oracle permission $ORACLE_HOME/lib/libsqlplus.so --- Should be 644 From both oracle and grid users:- opatch lsinventory col ACTION_TIME for a30 col BUNDLE_SERIES for a15 select ACTION_TIME,PATCH_ID,PATCH_UID,VERSION,ACTION,STATUS,BUNDLE_SERIES,BUNDLE_ID from dba_registry_sqlpatch; ###################################Amar Jadhav ######...
Read more