HOW TO SAP

BRTOOLS to turn off archive log

August 20, 2009

Firstly you check acrhivelog status

BRTOOLS
1 = Instance management
6 - Show instance status
Continue x2
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
-------------------------------------------------------------------------------
To turn achive log off,
Brtools
1 = Instance management
3 - Alter database instance
Continue x 2
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:
Choose 3 to set achive log, choose 4 to set noacrhivelog
Once done, press C to continue until Brtools will execute alter database command and restart database
Completed

SuSE Linux + Netweaver 2004s 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