SAP AS Java Dispatcher & Administrative Ports

** Credit SAP

AS Java Dispatcher & Administrative Ports
Function
Service Name
Port Number
Default Value
Range (min-max)
SAP NW AS Java (&NWA)
HTTP
5NN00
50000
50000-59900
SAP NW AS Java (&NWA)
HTTP over SSL
5NN01
50001
50001-59901

IIOP
5NN07
50007
50007-59907
IIOP Initial Context
IIOP Initial Context
5NN02
50002
50002-59902
IIOP over SSL
IIOP over SSL
5NN03
50003
50003-59903
JAVA Visual Administrator
P4
5NN04
50004
50004-59904

P4 over HTTP
5NN05
50005
50005-59905

P4 over SSL
5NN06
50006
50006-59906
JAVA Shell Console Administrator
Telnet
5NN08
50008
50008-59908
JMS
JMS
5NN10
50010
50010-59910
SAPMC(sapstartsrv)
Start service HTTP
5NN13
50013
50010-59910
SAPMC(sapstartsrv)
Start service HTTPS
5NN14
50014
50010-59910
SAP SDM
SDM
5NN17
5NN18
5NN19
50017
50018
50019
50010-59910

Set up SAPGUI Single Sign-On (SSO) using Microsoft Kerberos with SAP Window Server

** Myself
Server Information
Host: SERVER1  
SID:   DEV
INST NO:   10
Domain: ABC.COM
Configuring the SAP Instance Procedure
...
       1.      Determine which variant of the library is appropriate for your application server platform. See the table below.
Kerberos Wrapper Library According to Platform
Platform
Library 2003/XP
Library 2000
32-bit Windows NT (Intel x86)
gssntlm.dll
gsskrb5.dll
64-bit Windows NT (x86_64)
gx64ntlm.dll
gx64krb5.dll
64-bit Windows NT (ia64/Itanium)
gi64ntlm.dll
gi64krb5.dll
For more information about how to get the library, see SAP Note 352295.

§         Choose gx64ntlm.dll
       2.      Copy the library to the appropriate Windows system directory on the primary application server instance:
       Drive:\%windir%\system32\
       Drive:\%windir%\SysWOW64\
Or
       D:\usr\sap\DEV\DVEBMGS10\exe\

§         Copy gx64ntlm.dll  to D:\usr\sap\DEV\DVEBMGS10\exe\

 3.      In the instance profile of the primary application server instance, set the profile parameters and  allow users to be able to log on to the SAP system using user ID and password.
Rz10-> DEFAULT
§         snc/enable = 1
§         snc/gssapi_lib = D:\usr\sap\DEV\DVEBMGS10\exe\gx64ntlm.dll
§         snc/identity/as = p:ABC.COM\SAPServiceDEV
§         snc/accept_insecure_cpic = 1
§         snc/accept_insecure_gui =1
§         snc/accept_insecure_rfc = 1
§         snc/permit_insecure_start = 1

4.      Stop and restart the SAP system so that the profile parameters take effect.

Unix Extending LV_Vol and file system Unix Linux HP-UX AIX VXFS

** Myself
Extending LV will not make the space available for file system. You must update the file system.

AIX

Extending existing LV with FS
chfs -a size=2000m /mount_point

# extend lv and file system online 
Extending existing LV
Extending File system
chlv -x LPs testvol
chfs -a size=2000m /mount_point

Veritas Storage foundation

Extending existing Vol
Extending File system
vxassist -g oradg growto testvol 2G

fsadm -F vxfs -b 2000m /mount_point

HP-UX

Extending existing LV
Extending File system
lvextend -L 2000 /dev/datavg/testvol
#or
lvextend -L 2000 /dev/datavg/testvol /dev/dsk/c0t13d0
#or specify disk

lvextend -L 2000 /dev/datavg/testvol dev/disk/disk15
#For HP-UX 11.3
fsadm -F vxfs -b 2000m /mount_point
#for online extend file system with online jfs license (veritas file system)

#or

umount /dev/datavg/testvol
extendfs -F hfs /dev/datavg/rtestvol
mount /dev/datavg/testvol
#for offline


Linux

Extending existing LV with FS  Ext2/3 (LVM)
e2fsadm -L 2G /mount_point
# extend lv and file system online 
Extending existing LV (LVM)
Extending File system
lvextend -L 2G /dev/datavg/testvol
ext2online /dev/datavg/testvol
#for online extend file system

#or 


umount /dev/datavg/testvol
resize_reiserfs  /dev/datavg/rtestvol
mount /dev/datavg/testvol
#for offline

Extending existing file system  (RHEL 4.X) ext2/3
Extending File system
lvextend -L 2G /dev/datavg/testvol
ext2online -f /dev/datavg/testvol
#for online


Extending existing file system  (RHEL 5.X/SUSE 10,11) ext3/4
Extending File system
lvextend -L 2G /dev/datavg/testvol
resize2fs -f /dev/datavg/testvol
#for online

Oracle database RMAN example command

** Credit Web
#rman_delete_archvie_old_2day#
########################################################################
rman target / << EOF
run
{
allocate channel D1 type disk;
delete noprompt archivelog until time 'SYSDATE-2';
release channel D1;
}




#rmanArchive#
########################################################################
export ORACLE_SID=TEST2
sqlplus /nolog <<EOF
connect / as sysdba
alter system switch logfile;
EXIT
EOF
rman <<EOF
connect target rman/rman_oracledba@test2
connect catalog rman/rman_oracledba@test1
run { allocate channel d1 type disk
format '/data/oracle8/BACKUP/rman_ARC_%s_%p_%t.bus';
# backup archivelog until time 'sysdate-1/24' delete input;
backup archivelog from time 'sysdate-1/24';
}

Job Control on UNIX systems (Foreground,Background process) and Running Processes While Logged Out

** Credit Web
Job control facilities allow you to have the system work on a job in the background while you do something else at the keyboard.
This article covers the following:
·                           Useful Commands--Synopsis
·                           Foreground vs. Background
·                           Putting a Job in the Background
·                           Monitoring Background Jobs
·                           Bringing a Background Job to the Foreground
·                           Terminating Background Jobs
·                           Impact on System Performance
If you are simply trying to get logged out, but have encountered the "There are stopped jobs" message, see the discussion of terminating background jobs below.
Useful Commands--Summary
control-z
Stop (don't kill) the foreground job, and then return to the shell
jobs
Check the status of jobs in the current session
ps -u username
Check the status of processes, including those from other sessions. On BSD systems, use 'ps -gx'.
kill -9 %1
Kill a job, by specifying its job number after the percent sign
kill -9 123
Kill a process, by specifying its process id (PID) number
bg
Run the most recently stopped job in the background
fg
Bring most recently backgrounded job to the foreground
fg %1
Bring a job to foreground by specifying its job number after the percent sign
Foreground vs. Background

Problem oracle Instance crash Bug 7662491 ORA-600 OERI[kghstack_free1] [kddummy_blkchk]

** Myself,team,Note
Cause
ORA-00600: internal error code, arguments: [kghstack_free1], [context for tx CR rollback], [], [], [], [], [], []
Result if Don’t apply
#Instance crash database down and write to alert log and oracle shadow process
#DB writer trace
#Oracle shadow process trace
Result After apply Patch 7662491
#Instance No crash but oracle server process die
#Pointer in memory is overwritten in error by a software problem
#No DB writer trace
#Oracle shadow process log=/oracle/PRD/saptrace/usertrace/PRD_ora_27810.trc

Step apply Interim patch
1. Stop database and listener (by ora<sid> user)
SQL>shutdown immediate;
lsnrctl stop
2. Install interim patch 7662491 on (by ora<sid> user)
#$ORACLE_HOME/OPatch/opatch apply /<Patch_Base_Path>/7662491
3. Check interim inventory report
#$ORACLE_HOME/OPatch/opatch lsinventory
4. Startup database (by ora<sid>user)
SQL>startup;
5. Startup listener (by ora<sid>user)
lsnrctl start
6. Check oracle process and listener
ps -ef|grep smon
ps -ef|grep tns
7. Check listener
tnsping <SID>

Problem oracle query access slow from install oracle interim patch 9558995

** Myself,team,Note
Cause
For inserts in LOB segments, long wait events "enq: HW contents" occur if the relevant table and the LOB segments are created in an ASSM tablespace (TBS) Table TST03,VBDATA.
Change the storage option of the LOB from RETENTION to PCTVERSION.
SQL> alter table <OWNER>.<TABLE NAME> modify lob (<LOB NAME>) (pctversion 10);
For
example, for table TST03:
SQL> alter table SAPSR3.TST03 modify lob (DCONTENT) (pctversion 10);
Result if Don’t apply
# long wait events and slow write table TST03,VBDATA

Result After rollback Patch and reduce pctversion storage option
# Normal operation

Step remove Interim patch
1. Stop database and listener (by ora<sid> user)
SQL>shutdown immediate;
lsnrctl stop
2. Deinstall interim patch 9558995 on (by ora<sid> user)
#cd /<Patch_Base_Path>/SAP_102044_201005/9558995
#$ORACLE_HOME/OPatch/opatch rollback -id 9558995

HP-UX Monitoring kernel (kcusage) and Tuning kernel command

** Credit Book
# for monitoring kernel usage see part kcusage

Kernel Commands
A new set of kernel-related commands has been developed that have a common behavior. This section covers all the commands and provides examples of using some of them.
kcmodule
kcmodule queries and changes kernel modules in the currently running kernel configuration or a saved kernel configuration that you are staging for future use. Hundreds of modules are present in an HP-UX kernel that consists of device drivers, kernel subsystems, and other kernel code.
kcmodule with no options provides the modules in your system and both their current state and the state on next boot if any changes are pending, as shown in this abbreviated example:
# kcmodule
Module State Cause Notes
DeviceDriver unused
KeyboardMUX unused
LCentIf static best
MouseMUX unused
UsbBootKeyboard unused
UsbBootMouse unused
UsbHub unused
UsbMiniBus unused
UsbOhci unused
acpi_node static best
arp static depend
asio0 static best
audio static best
autofsc static best
azusa_psm static best
beep static depend
Loading