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