HOW TO SAP

Step by step manual guide with screenshot for Basis, Security Authorization & Abap

Popular Posts

  • HOW TO SAP - STMS transport hang with truck icon
    At times transport will hang with status Truck icon Check https://forums.sdn.sap.com/thread.jspa?threadID=972797&tstart=100 Logi...
  • Webdynpro - User session (HTTP/SMTP/..) closed after timeout
    There are two solution for this. Solution 1: Follow SAP note  1948291 - User session (HTTP/SMTP/..) closed aft by increasing the http...
  • HOW TO SAP - Create RFC TCPIP connection and Register Server Program with RFCEXEC
    Execute SM59 Expand TCP/IP connections > Click Create Enter the following details. Ensure connection type is 'T' Save a...

Blog Archive

  • ►  2019 (14)
    • ►  July (4)
    • ►  June (8)
    • ►  May (2)
  • ►  2018 (1)
    • ►  January (1)
  • ►  2017 (65)
    • ►  December (16)
    • ►  November (18)
    • ►  October (26)
    • ►  September (1)
    • ►  August (3)
    • ►  June (1)
  • ►  2014 (1)
    • ►  August (1)
  • ►  2013 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2012 (5)
    • ►  June (3)
    • ►  February (2)
  • ►  2011 (88)
    • ►  October (3)
    • ►  September (8)
    • ►  August (8)
    • ►  July (4)
    • ►  June (14)
    • ►  May (22)
    • ►  April (11)
    • ►  March (14)
    • ►  February (2)
    • ►  January (2)
  • ►  2010 (1)
    • ►  October (1)
  • ▼  2009 (17)
    • ▼  October (12)
      • Run TP command in background
      • Optimizer and DBchecks
      • TP command and how to check status
      • Install SAP license Unix level
      • Refresh df every 5mins
      • Create control files
      • SQL Alter tabase
      • Change oraarch directory to a larger folder
      • Unix command
      • Manuall import transport from Unix
      • Login to sqlplus
      • Changing user from root
    • ►  September (1)
      • Migration Explained
    • ►  August (3)
      • VNC from Windows to SuSE 10
      • Mount Windows folder to Linux
      • BRTOOLS to turn off archive log
    • ►  June (1)
      • SuSE Linux + Netweaver 2004s installation guide
  • ►  2008 (20)
    • ►  January (20)
2013-2017. Powered by Blogger.
HOW TO SAP

Run TP command in background

October 27, 2009   TRANSPORT, unix,
In Unix,

  • nohup tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128 &
Continue Reading

Optimizer and DBchecks

October 26, 2009   oracle,
In Unix,

 = to run the update stats, use
    brconnect -u / -c -f stats -t ALL
     >> you may also use the above to address the kosima dbverify alert.

 = to run the dbcheck manually again.
    brconnect -u / -c -f check
Continue Reading

TP command and how to check status

October 26, 2009   TRANSPORT,
how to add buffer via TP
tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28
tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128

Check status of the transport
/usr/sap/trans/tmp
tail -f P28IT00687.D28

You may also user ps -ef|grep tp
Continue Reading

Install SAP license Unix level

October 26, 2009   license, unix,
In Unix with SIDADM,

  • saplicense -install
  • enter the system ID
  • enter Hardware key
  • enter installlation no
  • enter expiration date - 99991231
  • enter the license_key
License successfully installed.
Continue Reading

Refresh df every 5mins

October 25, 2009   script, unix,
am2hc181:orad28 253> sh
$ while true
> do
> df -gt | grep archivpool
> sleep 300
> done
C4DEM1SYM62_2324:/vol/ARCHIVE00/SITI2324_archiv_pool/D28_archivpool   1020.00    481.24    538.76   48% /oracle/D28/archivpool
Continue Reading

Create control files

October 24, 2009   oracle,
In DBrefresh, you will need to create controlfile from tracefile.

In sqlplus,
  • alter database backup controlfile to trace resetlogs;
  • this file can be found in /oracle/SID/saptrace/usertrace
Continue Reading

SQL Alter tabase

October 24, 2009   oracle,
During DB refresh, you will need to copy sapdata. Before doing so, you have to alter database backup mode for tablespace to active

In sqlplus,
  • ALTER DATABASE BEGIN BACKUP;
  • once complete the copy of files,
  • ALTER DATABASE END BACKUP;
Continue Reading

Change oraarch directory to a larger folder

October 24, 2009   oracle,
This command does not need to restart db.You can do it at run time
In sqlplus,

SQL> show parameter log_archive_dest;
SQL> startup mount;
SQL> alter system set log_archive_dest='/oracle/D28/oraarch' scope=memory;

* LOCATION will be the new path for your archive log folder.
* you may remove LOCATION word if sqlplus gives error.
Continue Reading

Unix command

October 24, 2009   unix,
mkdir dbxxx            - Make dir dbxxx
df - g .                     - Current folder size
df - g | grep sap       - grep folder with ms.sap
rm -rf exe*              - Remove file and folder with name exe*
cp -r exe /oracle/W91/saptrace/usertrace    - copy folder exe to  /oracle/W91/saptrace/usertrace

sudo /usr/bin/rootsh -i -u root
sudo rootsh -i -u rb4adm  (don't copy paste, type manually)
Continue Reading

Manuall import transport from Unix

October 24, 2009   TRANSPORT,
In unix, execute

  • tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28
  • tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128
P28KT00687 is the transport number
DOMAIN_D28 is the transport domain (you get from stms)
D28 is the target csystem
client300 is the target client
U128 is the combination of below:


0: Called a overtaker; change request can be imported from buffer without deleting it and then uncoditional mode 1 is used to allow another import in the correct location.

1: If U1 is used with the export then it ignores the correct status of the command file; and if it is used with import then it lets the user import the same change request again.

2: When used with tp export, it dictates the program to not to expand the selection with TRDIR brackets. If used in tp import phase, it overwrites the originals.

3: When used with tp import, it overwrites the system-dependant objects.

5: During the import to the consolidation system it permits the source systems other than the integration system.

6: When used in import phase, it helps to overwrite objects in unconfirmed repairs.

8: During import phase it ignores the limitations caused by the table classification.

9: During import it ignores that the system is locked for this kind of transport.
Continue Reading

Login to sqlplus

October 24, 2009   oracle,
From unix, execute

  • sqlplus "/as sysdba"
Continue Reading

Changing user from root

October 24, 2009   unix,
Once login to your ID, you execute

  • sudo su - root
  • then you can change to su -t01adm
  • then you can also change to su - orat01
Continue Reading

Migration Explained

September 29, 2009   migration,
Migration is a synonym for heterogeneous system copy.

UNICODE CONVERSION
Your SAP system is converted from non-Unicode to Unicode. This can also be done as part of a homogeneous or heterogeneous system copy.

DISTRIBUTED SYSTEM
A system that resides on more than one physical or virtual hosts in a network, and can be accessed transparently as an entity.

SOURCE SYSTEM AND TARGET SYSTEM
The SAP system containing the original database is called the source system and the system to which the database copy is to be imported is called the target system.
Continue Reading

VNC from Windows to SuSE 10

August 20, 2009   linux,
  1. Linux, execute yast2 > security and users > Local Security
  2. Custome > next until you see "Allow remote graphical login" (see below)
  3. Check and save.
  4. Terminal > su root
  5. vncserver
  6. Enter a password to access desktop
  7. Once finish go to cd /root/.vnc/
  8. vi xstartup and change the original to
  9. #!/bin/sh xrdb $HOME/.Xresources xsetroot -solid grey xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" & /usr/X11R6/bin/gnome &
  10. Save xstartup
  11. To kill a session, use vncserver -kill 'servername':1 (Eg:test01:~/.vnc # vncserver -kill test01:1)
Continue Reading

Mount Windows folder to Linux

August 20, 2009   linux,
1. SU root
2. Enter below command
3. test01:/ # mount -t cifs //windows/share /media/install -o user=Domain/username
Continue Reading

BRTOOLS to turn off archive log

August 20, 2009  
Firstly you check acrhivelog status

  1. BRTOOLS
  2. 1 = Instance management
  3. 6 - Show instance status
  4. Continue x2
  5. 2 - Show instance status

    Information about the status of database instance R53

     1 - Instance number (number) ........... 1
     2 - Instance thread (thread) ........... 1
     3 - Instance status (status) ........... OPEN
     4 - Instance start time (start) ........ 2009-11-07 02.34.33
     5 - Oracle version (version) ........... 10.2.0.2.0
     6 - Database creation time (create) .... 2009-10-12 04.09.24
     7 - Last resetlogs time (resetlogs) .... 2009-08-20 07.11.28
     8 - Archivelog mode (archmode) ......... ARCHIVELOG
     9 - Archiver status (archiver) ......... STARTED
    10 - Current redolog sequence (redoseq) . 18914
    11 - Current redolog SCN (redoscn) ...... 16310535260
    12 - Number of SAP connections (sapcon) . 26

    Standard keys: c - cont, b - back, s - stop, r - refr, h - help
    -------------------------------------------------------------------------------


  6. To turn achive log off,
  7. Brtools
  8. 1 = Instance management
  9. 3 - Alter database instance
  10. Continue x 2
  11. Now you see the screen below
    BR0280I BRSPACE time stamp: 2009-11-07 02.41.24
    BR0656I Choice menu 207 - please make a selection
    -------------------------------------------------------------------------------
    Alter database instance main menu

     1 - Switch redolog file
     2 - Force database checkpoint
     3 - Set archivelog mode
     4 - Set noarchivelog mode
     5 - Show instance status
     6 * Exit program
     7 - Reset program status

    Standard keys: c - cont, b - back, s - stop, r - refr, h - help
    -------------------------------------------------------------------------------
    BR0662I Enter your choice:
  12. Choose 3 to set achive log, choose 4 to set noacrhivelog
  13. Once done, press C to continue until Brtools will execute alter database command and restart database
  14. Completed


Continue Reading

SuSE Linux + Netweaver 2004s installation guide

June 21, 2009   linux, netweaver, step by step installation guide,
Content


1) Installalling SuSE Linux Enterprise Server 10

2) Installing SAP Netweaver 2004s (ABAP+JAVA)

3) Install SAP GUI (java based)







========================================================================

1) Installing SUSE Linux Enterprise Server 10 for AMD64 and Intel 64

========================================================================

01. Download the required image and burn it into a bootable DVD.

02. Power up the machine with the bootable DVD.

03. Choose boot from CD/DVD

04. Install

05. English/US

06. New Installation

07. Clock - Asia/KL

08. Expert > change > partitioning > create custom partition

09. Choose 2.IDE 457GB.. /dev/sdb ( this may differ on your hardisk)

10. Entire hardisk

11. Expert > Change > Software

12. Select Additional > File server + DHCP + C/C++ compiler

13. Expert > change > booting > finish

14. Accept > Install

15. Install > restar > boot from hardisk

16. Root pwd is "penguin7"

17. Hostname is "test01" , domain is "sapdemo.com"

18. Uncheck "change hostname via DHCP"

19. Disable firewall

20. No skip test

21. Skip configuration

22. Local

23. User/Display name is "tux"

24. Pwd is "penguin7"

25. Next on hardware configuration

26. Don't clone system. Next

27. Login as root:penguin7

28. Yast2 > software > software management

29. Search "java"

20. Select - java1_4_2-ibm

21. Select - java1_4_2-ibm-devel

22. Accept and continue.

23. CHOOSE NO when promt on package window.

24. Completed installation.



--End--

========================================================================

Installing SAP Netweaver 2004s (ABAP+JAVA)

========================================================================

01. Copy all media(installation cd) file to Linux. See below for detail media files

02. > cd /root

03. > mkdir /install/CI

04. > chmod -R 777 install

05. Start install by going to:

06. > cd /media/51033511_8/BS_2005_SR3_SAP_Installation_Master/IM_LINUX_X86_64/

07. > ./sapinst

08. Installation of Sap window will start up

09. Custom settings

10. Select ABAP + JAVA

11. Jave component NW 7.0 dir => /media/51033513

12. Java Dev Kit dir => /usr/lib64/jvm/java-1_4_2-ibm-1.4.2_sr10

13. JRE unrestricted dir => /media/unrestricted.zip

14. SID : T01

15. Pass : penguin7

16. DBSID : T01

17. Prerequisite check - STOPPED Installing now!

18. Go Yast2

19. Search "sap"

20. Select SAP Locale + SAP Locale_32bit (see notes 171356)

21. Install and click no when prompt

22. > rpm -ivh saplocales-2.4-3.i586.rpm

23. Go back to SAPINST and click next

24. Cancel when prompt

25. Installation Export dir => /media/51033493

26. maxDatafilesize "4000"

27. Select only "Advance DB Configuration"

28. Oracle RDMS dir => /media/51031676

29. Select

x SAP Dir Mapping

x DB Instance File Systems

x Create table space

x Auto Extend

31. Remove all SAPDATA number except "SAPDATA1"

32. Change all SAPDATA directory to "SAPDATA1"

33. AutoExtMaxsize "4000" for all

34. Paralled jobs to 4

35. Database statistic skipped both

x create db from ABAP

x create db station java

36. CI :01

37. SCS :11

37. Next, next, next, next

38. Kernal dir => /media/51033508_9/NW7.0... x86

39. Oracle client dir => /media/51033272

40. 41. No SLD destination

41. Diagnostic agent SMDADM with pwd "penguin7"

42. SOL MAN KEY: 64DDF19EB or 65DDAE19EA

47. Now change hosts IP

48. > cd /etc

49. vi hosts

50. change 127.0.0.2 to LAN IP of the machinie

51. SAPINST promt to install database. STOPPED!!

5x. > su - orat01

52. > cd /oracle/stage/102_64/database/SAP/

53. > ./RUNINSTALLER

54. It will failed because only support SuSE-9

55. > cd /oracle/stage/102_64/database/install

56. > vi oraparam.ini

57. Change SuSE-9 to SuSE-10

58. > cd /oracle/stage/102_64/database/SAP/

59. > ./RUNINSTALLER

60. Failed. have to set xwindow

61. > su - (in a new terminal)

62. > xhost +

63. > su - orat01

64. > setenv DISPLAY :0.0

65. > cd /oracle/stage/102_64/database/SAP/

66. > ./RUNINSTALLER

67. Oracle install window will appear

68. Change ora directory to /oracle/T01/oraInventory

69. next next next and when prompt you run:

70. > ./oracle//oraInventory/orainstRoot.sh

71. > ./oracle//102-64/root.sh

72. Now press ok on Oracle installation window.

73. Now patch the Oracle to 10.2.2

74. > cd /oracle/stage/102_64/

75. > mkdir patchset

76. > unzip /media/51031811_3/DVD_ORACLE_10.2.0.2_Patches_LINUX/LINUX_X86_64/p4547817_10202_Linux-x86-64.zip

77. > cd /oracle/stage/102_64/Disk1/install

78. > vi oraparam.ini (like step 57)

79. > cd /oracle/stage/102_64/Disk1

80. > ./runInstaller

81. Oracle install window will apper

82. Start the patch by installing

83. When prompt, run the sh files

84. > cd /oracle//102_64/root.sh

85. Oracle window. OK the installation

86. Go back to SAPINST and press ok.

87. Installation will proceed about 3hours.

88. Completed installation





The media files I have:

drwxrwxrwx 5 0 0 472 2008-03-12 09:45 51033493

drwxrwxrwx 3 0 0 456 2008-03-26 15:19 51033513

-rwxrwxrwx 1 0 0 322237 2008-06-02 21:55 saplocales-2.4-3.i586.rpm

drwxrwxrwx 3 0 0 504 2008-06-27 14:12 51033893_1

drwxrwxrwx 3 0 0 504 2008-06-27 14:13 51033893_2

-rwxrwxrwx 1 0 0 964778 2009-01-12 12:47 BRGUI-EN.zip

-rwxrwxrwx 1 0 0 985 2009-01-12 12:47 Kernel-Change.txt

-rwxrwxrwx 1 0 0 138 2009-01-12 12:47 Readme.txt

-rwxrwxrwx 1 0 0 5150 2009-01-12 12:51 unrestricted.zip

-rwxrwxrwx 1 0 0 219 2009-01-12 12:51 SolManKey.txt

-rwxrwxrwx 1 0 0 693146 2009-01-12 12:51 services

-rwxrwxrwx 1 0 0 1134 2009-01-12 12:51 parameter.sql

-rwxrwxrwx 1 0 0 1133 2009-01-12 12:51 hosts

-rwxrwxrwx 1 0 0 446 2009-01-12 12:51 event.sql

-rwxrwxrwx 1 0 0 3978 2009-01-12 14:10 InsNotes

-rwxrwxrwx 1 0 0 94434415 2009-01-30 09:43 51033517_8.ZIP

-rwxrwxrwx 1 0 0 9112341 2009-01-30 09:43 firefox-3.0.5.tar.bz2

-rwxrwxrwx 1 0 0 4031586 2009-01-30 09:43 flash-plugin-10.0.15.3-release.i386. rpm

-rwxrwxrwx 1 0 0 197707 2009-04-15 11:20 ntfs-3g-200944-el5i686.rpm

drwxrwxrwx 2 0 0 528 2009-05-26 10:19 51031676

drwxrwxrwx 4 0 0 128 2009-05-26 10:23 51031811_3

drwxrwxrwx 3 0 0 96 2009-05-26 10:27 51033512_1

drwxrwxrwx 14 0 0 832 2009-05-26 10:28 51033272

drwxrwxrwx 3 0 0 104 2009-05-26 10:28 51033508_9

drwxrwxrwx 3 0 0 104 2009-05-26 10:28 51033511_8

drwxrwxrwx 14 0 0 1560 2009-05-26 10:52 firefox

drwxrwxrwx 2 0 0======================================================================== \224 2009-05-26 10:53 JAVASAPGUI

drwxrwxrwx 2 0 0 240 2009-05-26 10:53 Notes

drwxrwxrwx 2 0 0 240 2009-05-26 10:54 nvidia

drwxrwxrwx 2 0 0 1080 2009-05-26 10:54 SAP Notes

drwxrwxrwx 2 0 0 1072 2009-05-26 10:54 SAP_Notes

drwxrwxrwx 2 0 0 624 2009-05-26 11:16 Training Material



--END--





========================================================================

Install SAP GUI (java based)

========================================================================

01. Login tux:penguin7

02. > su -

03. > cd /opt

04. > mkdir SAPClients

05. > chmod 777 SAPClients

06. > chown tux:users SAPClients

07. > logout

08. Yast2 > software > software component

09. Search java

10. Add x java-1_5_0-ibm

x java-1_5_0-ibm-32bit

x java-1_5_0-ibm-alsa-32bit

x java-1_5_0-ibm-devel-32bit

11. Open new terminal to change bash file

12. > cd

13. > ls -ltra

14. > vi .bashrc

15. append line after 'export Pilotrate = 115200 as below:

16. export PLATIN_JAVA=java-1_5_0-ibm-1.5.0_sr7/jre/bin/java

17. > echo $PLATIN_JAVA

18. > cd /opt/SAPClients

19. > java -jar PLATINGUILNX_5-10003510.JAR

20. SAPGUI installation will start
Continue Reading
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)
Designed By: Blogger Templates | Templatelib