Power by


Freeze & Unfreeze Package (Unmoinitoring Resource) MCSG ServiceGuard cluster

# Not monitoring package example Oracle,SAP,DB2,nfs...etc

# for Legacy MCSG package (all package & extension)
##Freeze monitoring
touch  /etc/cmcluster/debug
##Unfreeze monitoring
rm /etc/cmcluster/debug

for SAP package (SAP extension)
##Freeze monitoring
touch  /etc/cmcluster/{package_name}/debug
##Unfreeze monitoring
rm /etc/cmcluster/
{package_name}/debug

for Oracle ( Oracle extension)
##Freeze monitoring
touch /etc/cmcluster/{package_name}/oracle.debug
##Unfreeze monitoring
rm /etc/cmcluster/
{package_name}/oracle.debug

for DB2 (DB2 extension)
##Freeze monitoring
touch  /etc/cmcluster/{package_name}/db2.debug
##Unfreeze monitoring
rm  /etc/cmcluster/
{package_name}/db2.debug

Install DB2 10.5 on Unix

db2setup

clip_image001


install new
clip_image002
clip_image003
clip_image004



Database
SAP Shortcut
Service Name
Default Port
Range Port
Oracle
ORA
tlisrv
1527/TCP
!New 1521/TCP
Free
MS SQL Server
MSS
ms-sql-s
1433/TCP
1024-5000/TCP
DB2 
(DB6 Unix,Linux,Win)
DB6
sapdb2
sapdb2i
 500000/TCP
(*conflict J2ee)
5912/TCP (SAP)

Free

DB2 
(DB4 i-series ,OS/400)
DB2 
(DB2 z/OS ,OS/390 )
DB4

DB2
as-edrsq
4402/TCP
963/TCP
Free

Sybase ASE
SYB
Inst
backup server
job scheduler
4901/TCP
4902/TCP
4903/TCP
Free
HANA(by SAP)
HDB
315/TCP
Free
MAXDB/ADABAS/SAP DB (by SAP)
ADA
sql30
sql6
sapdni72
sdbnissl76
SDB
7200/TCP
7210/TCP
7269/TCP
7270/TCP
7575/TCP
Free
Informix
INF
sapinf
3800/TCP
Free

Manual upgrade Oracle Database from 9i to 11g with bundle patch and DBAtool (For SAP)

** Myself

Objective: Manual Upgrade Oracle Database from 9.2.0.4 to 11.2.0.3

Preparation of 9i for Upgrade 11g
Up oracle9i timezone patch for upgrade to oracle 11g
Command Detail
cd /sapbackup/UPECC6/ORABUNDLE/5878965
/oracle/SOD/920*/OPatch/opatch apply
Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)
Oracle Home : /oracle/SOD/920_64
Oracle Home Inventory : /oracle/SOD/920_64/inventory
Central Inventory : /oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OUI location : /oracle/SOD/920_64/oui
OUI shared library : /oracle/SOD/920_64/oui/lib/hpunix/liboraInstaller.sl
Java location : /oracle/SOD/920_64/jdk/jre/bin/java
Log file location : /oracle/SOD/920_64/.patch_storage/<patch ID>/*.log
Creating log file "/oracle/SOD/920_64/.patch_storage/5878965/Apply_5878965_10-11-2013_15-26-32.log"
Invoking fuser to check for active processes.
Invoking fuser on "/oracle/SOD/920_64/bin/oracle"
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: lek
Invalid email address.
Email address/User Name: coco@coco.co.th
Provide your My Oracle Support password to receive security updates via your My Oracle Support account.
Password (optional):
Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
[<proxy-user>@]<proxy-host>[:<proxy-port>]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specificatio
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /oracle/SOD/920_64)
Is this system ready for updating?
Please respond Y|N >
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /oracle/SOD/920_64)
Is this system ready for updating?
Please respond Y|N >
y
Applying patch 5878965...
Patching copy files...
Inventory is good and does not have any dangling patches.
Updating inventory...
Verifying patch...
Backing up comps.xml ...
OPatch succeeded.gfux031:orasod 1


Step Upgrade Oracle 11g
Extract software to $ORACLE_STAGE/11203/database

Installing Software Oracle 11.2.0.3
$ORACLE_STAGE/11203/database/SAP/RUNINSTALLER

clip_image002
Next
clip_image004
No

Loading