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


Next

No

SAP Create PDF by Print Preview of Smartform

** Myself

Go to from and choose  print preview

Select OutputDevice & Print preview

!! OutputDevice Need to use   PDF device   = PDFUC  (Thai format need to upload thai font to PDFUC)

Sol1

select

Print Preview > Menu: Goto > PDF Preview

Smartform display in window show content by IE  preview (smicm port  80XX)

The smartform will be displayed as PDF in the PDF preview window.

Sol2

select

OK prompt > pdf!

New window popup to show to convert smartform to PDF file

Save to a PDF format

Change Password of SAP User TMSADM

** Myself

1.Add record TMSCROUTE all system dev,qas,prd

As mentioned in note 749977 you must create an entry in TMSCROUTE table with:

     sysnam = ,TRGCLI

     rfcroute = 000

2.Update from DEV 000 se38->TMS_UPDATE_PWD_OF_TMSADM all password

3. change sm59 all system dev,qas,prd

TMSADM@DEV.DOMAIN_DEV

4.Distribute configuration

Note 1568362 - TMSADM password change

Environment Database and operating system independent. SAP releases 46B (SAP_BASIS) and higher. Cause Missing function Security requirements Resolution When someone needs to have more stringent password rules, user TMSADM is affected by the new restrictions. In order to be able to enter a password for TMSADM user different from the standard one that complies with the password restrictions that have been set to the system, the following steps must be performed. These are manual steps and are ideal for a system landscape that is small. 1. Apply the source code correction of notes 713622 and 749977 into all the domain systems. We can say that it will "enable" the functionality of modifying the TMSADM password. Should your support package level already contain the correction instructions from these notes, please proceed to step 2. 2. As mentioned in note 749977 you must create an entry in TMSCROUTE table with:      sysnam = ,TRGCLI      rfcroute = where is the client number that the customer wants to have in the logon screen. If you want to use the default client, you must leave the rfcroute field empty for sysid=,TRGCLI As explained in note 761637, we recommend to set the client to 000. 3. Proceed as explained in note 761637. That is,    A. Create an entry in table TMSCROUTE with:         sysnam = ,ADMPWD         rfcroute = USER       It will change the TMSADM behaviour, so password for that user can be modified B. Now you must go to SM59, open the 'R/3 connections' node and delete the TMS* RFC connections. After that you must regenerate the RFC connections doing the following:       STMS   > Overview   > Systems   > Extras   >                   > Generate RFC Destinations This will create the new RFC connections for the Transport Management System where the TMSADM password can be changed. C. Now you should be able to maintain the passwords of the TMSADM users and the TMSADM@. RFC destinations in all the systems. You can choose the new password in a way that follows the new stringent password rules, and it won't be changed by automatically by the system.  Should the system landscape be large then we can automate the process. For this we implement SAP note # 1414256 (for releases <= 640 manual steps in SAP note # 761637 must still be applied) The note 1414256 contains report TMS_UPDATE_PWD_OF_TMSADM which must be run in the DC (domain controller) client 000. It should be noted that this report in itself does not support domain links. Should domain links exist then use SAP # note 1515926. The note should be applied to all systems of the connected domains. Once the note is applied start the report that is described in Note 1414256 on all of the domain controllers of the connected domains. That means executing TMS_UPDATE_PWD_OF_TMSADM in client 000 on all domain controllers.

How to check SAP Standard SAP*, DDIC, SAPCPIC and EARLYWATCH user use default password or not

** Myself

SE38

-> RSUSR003

-> uncheck “Display Profile Parameters”

-> execute

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
จากนั้นจะปรากฎขั้นตอนต่อไปดังนี้

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

Oracle11G New Diagnostic directory for alert log and Listener log with SAP directory structure

** Myself
#New directory for alert log
#Oracle 8,9,10G Alert log
/oracle/<SID>/saptrace/background/alert_<SID>.log
/oracle/DEV/saptrace/background/alert_DEV.log


#Oracle 11G Alert log
/oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/trace/alert_<SID>.log
/oracle/DEV/saptrace/diag/rdbms/dev/DEV/trace/alert_DEV.log






#New directory for Listener log
#Oracle 8,9,10G Listener log
/oracle/<SID>/<VERSION 3Digit>_<BIT>/network/log/listener.log
/oracle/DEV/817_32/network/log/listener.log
/oracle/DEV/920_64/network/log/listener.log
/oracle/DEV/102_64/network/log/listener.log


#Oracle 11G Listener log
/oracle/<SID>/saptrace/diag/tnslsnr/<server name>/listener/trace/listener.log
/oracle/DEV/saptrace/diag/tnslsnr/sever1/listener/trace/listener.log

Reset password of SAP* user back to "pass" default password (DB level)

** Myself
for MS SQL   -> SQL Analyzer  (Example user SAP* client 000)

delete from SAPSR3.USR02 where  bname='SAP*' and mandt='000' ;

SAP security Note definition

** Myself

Security Note Information

http://service.sap.com/securitynotes

->SAP Security Notes

 -> Security Notes Search

# Some Security Note level 2/3 may be upgrade to HotNews level

# Automatic check in EWA [Report yellow and red traffic light]

Security Note Level

Level

1  HotNews

2  Correction with high priority

3  Correction with medium priority

4  Correction with low priority

6  Recommendations/additional info

SAP HotNews are priority 1 (very high priority) SAP Notes for customers.

They tell you how to resolve problems that can cause the SAP system to shut down or lose data.

If such problems affect you, you must ensure that you comply with these SAP Notes

Security Note with The EWA report shows the following three sections:

"Missing recommendations"

This section shows the required security-relevant SAP Notes and HotNews.

HotNews are flagged with a red traffic light and notes are flagged with a yellow traffic light.

"Manually confirmed recommendations"

Report messages can also be confirmed manually.  This should only happen in exceptional cases that require it.

For example: You cannot implement a specific note using transaction SNOTE because you manually changed the affected program beforehand.  In this case, implement the corrections manually and confirm the message.

"Successfully implemented recommendations"

This section shows the security-relevant notes and HotNews that are required for the system and that are implemented successfully.

A note or a HotNews is no longer required if your system release or Support Package level already contains the correction. After the system is upgraded or Support Packages are imported, a note that was implemented earlier may no longer be listed.

How to find smartforms object class and object in Requests/Task

** Myself
Check Object class
smartforms
-> form <form name>
-> menu item Go to -> object directory entry
  -> Show object
Object R3TR SSFO <Object name>
Package <Package name>



 
Check Transport Request/Task
se03
-> R3TR SSFO <Object name>
-> execute
  -> Show history of request and Task

SAP Test barcode

** Myself
System barcode
se73
-> system bar codes

 
Test barcode
so10
->SAPSCRIPT-BARCODETEST

Preview or Print to spool



Or
Spad-> Utilitiesà For device typesà Test data(SAPscript).