Saturday, February 18, 2012

Oracle up grade Or patch upgrade


Oracle up grade Or patch upgrade
1. Download Oracle patches from SAP Service Marketplace.
Refer SAP Note 509314 - Downloading Oracle patches from SAP Market Place
2.Stop SAP, Oracle Database and listener services
3.Start the Installer. Use the Oracle Universal Installer 10.2.0.4.0
4.after installation execute following command from SQL:

from command prompt. sqlplus /nolog
Sql>conn /as sysdba
sql>startup upgrade
sql>spool patch.log
sql>shutdown
sql>startup
SQL>@?/rdbms/admin/catupgrd.sql

NOTE: When the 10.2.0.4 patch set is applied to an Oracle Database 10g Standard Edition database, there may be 42 invalid objects after the utlrp.sql script runs. These objects belong to the unsupported components and do not affect the database operation. Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:
BIN$4lzljWIt9gfgMFeM2hVSoA==$0

sql>shutdown immediate
sql>startup
start the lisner service and sap services
Applying opatches is also highly recommended for 10.2.0.4 because the opatches are meant to fix bugs and performance issues with 10.2.0.4.

If you download the opatches from the OSS please check the mopatch tool provided and check the attached SAP notes and readmes carefully. They explain exactly what steps are necessary to update the db correctly.

Follow below to Upgrade/apply patchset in Oracle
- Upgrade the db server to 10.2.0.4 using patchset
- Install the latest interim patch for 10.2.0.4
- Install the latest generic patches
- Upgrade instance client to 10.2.0.4

ORACLE UPGRADE FROM 10.2.0.2 TO 10.2.0.4
========================================================
Upgrade the db server to 10.2.0.4 using patchset
==========================================================

Change Directory: /oracle/<SID>/102_64/OPatch

# opatch lsinventory -all

Download and Extract the Installation Softwar
$ unzip p6810189_10204_LINUX-x86-64.zip
$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/bin/OPatch:$PATH:
$ ORACLE_HOME=/oracle/CRJ/102_64
$ ORACLE_SID= CRJ
$ export ORACLE_HOME ORACLE_SID

Stopping All Processes for a Single Instance Installation
Login as ora<SID> and type below commands
# emctl stop dbconsole
# isqlplusctl stop
# lsnrctl stop
# $ srvctl stop service -d db_name [-s service_name_list -i inst_name](For multiple nodes)

- start Oracle Universal Installer, where patchset_directory is the directory where you unpacked the patch set software:

# cd patchset_directory/Disk1
# ./runInstaller

Post Installation Task
======================

Change directory to /oracle/<SID>/102_64

# Run the Script “root.sh”

Updating Oracle Time Zone Definitions
SQL> SELECT version FROM v$timezone_file;
Upgrading Oracle Database Upgrade Assistant
• Log in as the Oracle software owner user.
• Set the values for the environment variables $ORACLE_HOME, $ORACLE_SID and $PATH.
• For single-instance installations, if you are using Automatic Storage Management, start the Automatic Storage Management instance.
• For Oracle single-instance installations, start the listener as follows:
$ lsnrctl start
• Run Oracle Database Upgrade Assistant either in the interactive or noninteractive mode:

# dbua

Edit the file /etc/oratab
Make a entry of <SID>:/oracle/<SID>/102_64:Y
After installation finished
Login to Oracle as sysdba with sys user.
Shutdown the dbShut abort
Start the db startup
SQL> STARTUP UPGRADE

Run the Pre-Upgrade Information Tool
====================================
If you are upgrading database manually, then you should analyze it by running the Pre-Upgrade Information Tool.
The Pre-Upgrade Information Tool is a SQL script that ships with Oracle Database 10.2. Complete the following procedure to run the Pre-Upgrade Information Tool:
1. Start the database in the UPGRADE mode:
2. SQL> STARTUP UPGRADE
3. Set the system to spool results to a log file for later analysis:
4. SQL> SPOOL upgrade_info.log
5. Run the Pre-Upgrade Information Tool:
6. SQL> @?/rdbms/admin/utlu102i.sql
7. Turn off the spooling of script results to the log file:
8. SQL> SPOOL OFF

Upgrading a Release 10.2 Database
-================================
For single-instance installations, start the listener as follows:
$ lsnrctl start
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
@?/rdbms/admin/utlrp.sql

#:ora<SID> > emca -upgrade db

Running changePerm.sh Script on an Oracle Database Server Home
===============================================================
cd $ORACLE_HOME/install

#ora<SID> changePerm.sh

Install the latest interim patch for 10.2.0.4
=============================================
Patch number : 4695511

#ora<SID> opatch apply /oracle/<SID>/Desktop/patch/4695511

Install the latest generic patches
==================================
Patch number :
6862947
6705635
9254968

# opatch apply /oracle/CRJ/Desktop/patch/6862947

Upgrade instance client to 10.2.0.4
===================================
We install patches 6944036, 6826661, 6775231
# SAPCAR –xvf OCL_BASIC_10204_64_V2.SAR
Then copy the output to /oracle/client/10x_64/
ln -s /oracle/client/10x_64/instantclient_10204 /oracle/client/10x_64/instantclient

Reactions:

1 comments:

Mark Hurd Oracle clearly feels this pressure of companies moving to cloud services and is trying to drum up any momentum it can to its own cloud services to offset the declines of its core business of selling software licenses and databases…..

Post a Comment