Knowledge Management IT for you: May 2011

Shell Script Example Oracle Export dumpfile(exp or expdp)

**Myself

#!/usr/bin/sh
######### ENV ##############
backup_dir=/backup/expdump #Dumpfile directory
blog=/backup/expdump/backup_expdump.log
orasid[0]=orcl1 #oracle sid1

orasid[1]=orcl2    #oracle sid2
orasid[2]=orcl3    #oracle sid3
orauser[0]=oraorcl1
orauser[1]=oraorcl2
orauser[2]=oraorcl1
orahome[0]=/app/oracle/orcl1/10g
orahome[1]=/app/oracle/orcl2/10g
orahome[2]=/app/oracle/orcl3/10g
############### Main ##################
export i=0
while (( i < ${#orasid[*]} ))
do
    su - ${orauser[${i}]} << BOF >> ${blog}
        export ORACLE_SID=${orasid[${i}]}
        echo ${orasid[${i}]} >> ${blog}
        ${orahome[${i}]}/bin/exp system/system file='${backup_dir}/${orasid[${i}]}.dmp' full=y
    BOF
(( i = i + 1 ))
done

Shell Script Menu for Start up/Shutdown SAP with Oracle and other process (saposcol,sapstartsrv,hostctl for NW7.1)

** Myself

#====================================================================
#
# MAIN PROGRAM: Operator Menu
#
# PURPOSE: Checks for system instances and
#           startup/shutdown system instances
#
#====================================================================
#====================================================================
# Environment
#====================================================================
#
#
#
# oracle user ,Please change
orasid=dev
# sap user ,Please change
sapsid=dev
# SAP StartSRV MC Console Instant Name ,Please change ,for more instant add array
SAPINST[0]=DVEBMGS02
SAPINST[1]=ASCS00
SAPINST[2]=SCS01
#
#====================================================================
#====================================================================
# Main
#====================================================================
operation_menu=0
while [[ ! "x${operation_menu}x" = "x99x" ]] ; do
clear
echo "========================================"
echo "|--- Operation Menu (`hostname`) "
echo "========================================"
echo "(1) Start SAP"
echo "(2) Shutdown SAP"
echo "(99) Exit"
echo "Please select a number from the Operation Menu: "
read operation_menu
case ${operation_menu} in
        1)
                su - ora${orasid} -c "lsnrctl start"
                su - ${sapsid}adm -c "startsap"
                echo "SAP Startup"
                echo "Please key to Main Menu: "

SAP BASIS Install SAP Gui 7.20 with Patches [Thai] (Update)

** Myself
ขั้นตอนการติดตั้ง SAPGUI

Part I

Pre installation step SAPGUI

1) ถ้ามี SAPGui Version เก่า
ควรทำการ uninstall SAPGUI ก่อนป้องกันerror ที่จะเกิดขึ้นระหว่าง install โดยต้องปิด SAP Logon
ถ้าไม่ uninstall จะทำให้ เกิด error ต่างๆจากการ load library dll ไม่ขึ้นเช่น sapfewut.dll
“The procedure entry point sap load library could not be locate in the dynamic link library”

2) สำหรับเครื่องที่ยังไม่เคย Install SAPGui มาก่อน
ก่อน install SAPGUI ควรมีการ reboot machine ก่อนเพื่อป้องกันerror ที่จะเกิดขึ้นระหว่าง install โดยต้องปิด SAP Logon
หรือทำการปิด MS office กรณีเลือก บาง component ของSAPGui ที่มีความเกี่ยวข้องกัน

3) สำหรับเครื่องที่ Install software จาก shared drive อาจมีปัญหาในการ Install SAPGui เพราะLoad library มาได้ไม่ครบ
ควร Copy Install software จาก shared drive มาไว้ที่เครื่อง ตัวเองก่อน Install

Part II

Install Step SAPGUI

จากนั้นทำการติดตั้ง SAPGUI
1.ให้เข้าไปยัง Folder
NW_7.0_Presentation\PRES1\GUI\WINDOWS\WIN32
2. เลือก SetupAll

จะปรากฎขั้นตอนต่อไปดังนี้

กด Next
จากนั้นจะปรากฎขั้นตอนต่อไปดังนี้

** Myself
For SAPGUI solve by replace font Window XP for Display
For SAPLPD solve by replace font Window XP and Substitution for printing

Font Substitution	Result
Sub cordiaUPC font win7	OK.
Sub cordiaUPC font winXP # Copy XP font replace win7 C:\windows\fonts	OK.
Sub cordiaNew font win7	no OK. Can’t translate อ่านไม่ออก
Sub cordiaNew font winXP # Copy XP font replace win7 C:\windows\fonts	no OK. Can’t translate อ่านไม่ออก
Sub angsanaUPC font win7	no OK. สระลอย
Sub angsanaUPC font winXP # Copy XP font replace win7 C:\windows\fonts	OK.
Add /eH (control unicode to thsapwin) & sub angsanaUPC font win7	no OK. สระลอย
Add /eH (control unicode to thsapwin) & sub angsanaUPC font winXP # Copy XP font replace win7 C:\windows\fonts	OK.
No Sub courierNew font win7	no OK. Can’t translate อ่านไม่ออก

Oracle 10g RAC Administration Simulators

** Credit Vladimir Grigorian (http://vgrigorian.com)
10g RAC Administration Simulators

- Basic RAC Administration
- RAC Backup in Grid Control
- RAC TAF and Load Balancing
- Basic RAC Performance Tuning

Fix SAPGUI problem thai font ่ ้ ำ ี ๋ ์ ๋ ๊ for Window Vista/7 [Thai]

** Myself
่ ้ ำ ี ๋ ์ ๋ ๊
แก้ปัญหาการชดเชยสระ รวมถึงตำแหน่งของ space หรือ สระลอย เช่น ที่ถูก สีน้ำ ที่ผิด ส ี น้ ำ

Sol1
Copy font from Window XP Replace Vista/7 to C:\Windows\Fonts

AngsanaUPC,Angsana New,Cordia New,CordiaUPC,Courier New,Courier Regular [Regular/Bold/Italic]

Sol2
Install New SAPGUI 720 with newer patch (after patch 8 up to 1X)

Oracle 10g RAC Installation Simulators

** Credit Vladimir Grigorian (http://vgrigorian.com)

- Installing 10g OCFS
- Installing 10g CRS
- Installing Oracle 10g RAC
- Creating 10g RAC Database

Shell Script Mass Change filename (Rename pattern file)

** Myself

#Create 10,000 file from CCC00001.JPG to CCC10000.JPG
#file name=CCC00001.JPG ,CCC00002.JPG ....
mkdir -p /tmp/test
for i in {1..10000}
do
touch /tmp/test/CCC`printf "%05d" $i`.JPG
done

#Rename 10,000 file from CCC00001.JPG to A00001.JPG
#Result file name=A00001.JPG ,A00002.JPG ....

for T in *.JPG
do
U=$(printf $T | sed -e "s/CCC/A/g")
[[ $T != $U ]] && mv $T $U
done

Install Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files (SAP include)

** Myself

JCE IBM Product	JCE SUN Product
File name: unrestricted.zip	File name: jce_policy-<version>.zip jce_policy-1_4_2.zip

Content of file
· README.txt
· COPYRIGHT.html Copyright information [No file for IBM product]
· local_policy.jar Unlimited strength local policy file
· US_export_policy.jar Unlimited strength US export policy file

1) Download from SUN(ORACLE) or IBM product
unrestricted.zip or jce_policy-<version>.zip
2) Extract/Install to JRE path (check java home path)

Window	Unix
<java-home>\lib\security	<java home>/lib/security
D:\j2sdk1.6\jre\lib\security	/usr/java/jre/lib/security # SUN Solaris /opt/java1.4/jre/lib/security # HP-UX /usr/lib64/jvm/java-1_4_2-ibm-1.4.2_sr10/jre/lib/security # Linux64 bit

# For SAP ,SSL protocol, will be extract during installation phase
# Example SAP unix JAVA_HOME=/opt/java1.4
# JCE install at /opt/java1.4/jre/lib/security

Oracle Clear data block (logical) corrupt from dbverify

** Myself

dbverify report (dbv) detect corrupt blocks but no physical corrupt.
for 10g

Verify after dbv
check v$database_block_corruption or v$backup_corruption (from rman verfity)

run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup check logical validate database;
release channel c1;
release channel c2;
}

Fix
1) run analyze object for check integrity and run dbv again
analyze <xxx> validate structure [ONLINE]
2) or flush db buffer cache and run dbv again
alter system flush buffer_cache

SAP Launch Java Tools

** Myself

Config Tool

Windows launch tool	Unix [by Gui] launch tool logon <sid>adm
<Drive>:\sap\<SID>\<central instance>\j2ee\admin\go.bat	/sap/<SID>/<central instance>/j2ee/admin/go

Visual Admin Tool

Windows launch tool	Unix [by Gui] launch tool logon <sid>adm
<Drive>:\sap\<SID>\<central instance>\j2ee\configtool\configtool.bat	/sap/<SID>/<central instance>/j2ee/configtool/configtool
Entry for connection #SAP instance number 2 digit=$$	Entry for connection #SAP instance number 2 digit=$$
Direct Connection to Dispatcher Node User Name: j2ee_admin Host: localhost Port: 5SS04	Direct Connection to Dispatcher Node User Name: j2ee_admin Host: localhost Port: 5SS04

NetWeaver Administrator (NWA)

Browser launch tool #SAP instance number 2 digit=$$
http://<hostname>.<suffix>:5$$00/nwa
# for Dual stack refer j2ee_admin on client001	# for Jav stack refer Administrator
logon j2ee_admin	logon administrator

Java with Telnet.

Windows launch tool #SAP instance number 2 digit=$$	Unix [by Textmode] launch tool #SAP instance number 2 digit=$$
start->run->cmd	logon <sid>adm
telnet localhost 5SS08	telnet localhost 5SS08

How to start one node Veritas cluster(VCS) other nodes failed

** Myself

Case start only one Node (because all Heartbeat other nodes lost connection or totally other nodes failed)
# Start Group Membership and Atomic Broadcast
gabconfig -cx
# Start cluster
hastart -onenode
# Option Start resource by command
hagrp –online <resource_name> -sys <server_Node_name>

date_replace('5.31.2011');

date_replace('5.30.2011');

date_replace('5.27.2011');

date_replace('5.26.2011');

date_replace('5.23.2011');

date_replace('5.18.2011');

date_replace('5.11.2011');

date_replace('5.09.2011');