SAP: ECC 6 EhP 5 Installation

Product: SAP Module: ERP/ECC 6.0 Enhance Package 5

This post is for beginner who need to know how to prepare and install SAP ECC 6.0 with EhP 5 in Oracle Linux environment, using NetWeaver 7.02, kernel 7.20

I am going to use "Distributed System" installation, which one server will be Oracle database, and another server will be SAP. The installation order will be

1. Global Host Preparation (in database server)
2. Database Instance (in database server)
3. Central Instance

If this is going to be simple active/passive cluster (not SAP High-Availability System seup), then step 1 install in both nodes, while the rest just need to ensure virtual hostname and shared mount points are mounted (recommend to mount all in node 1 during installation).

RedHat Kernel Setup
1. Hostname restriction
Hostname or virtual hostname MUST NOT exceed 13 characters Only contain alphanumeric and hyphen. Underscore is not accepted Either all lowercase (prefer) or uppercase. CANNOT mix case

2. RedHat package selection during install
Servers/Printing Support Base System/Base Base System/X Window System Development/Legacy Software Development Development Libraries Development Tools

3. Swap space
If less than 32 GB, then it is 2 times RAM. If more than 32 GB, then see note 1597355. Basically it says follow
upto 63 GB -- 64 GB swap upto 127 GB -- 96 GB upto 255 GB -- 128 GB upto 51 GB -- 160 GB upto 1023 GB -- 192 GB

4. RPM install
compat-openldap uuidd sysstat libXp java-1.4.2-ibm-sap-devel 64-bit
binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3 (32 bit) elfutils-libelf-0.125 elfutils-libelf-devel-0.125 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-24 glibc-2.5-24 (32 bit) glibc-common-2.5 glibc-devel-2.5 glibc-devel-2.5 (32 bit) glibc-headers-2.5 ksh-20060214 libaio-0.3.106 libaio-0.3.106 (32 bit) libaio-devel-0.3.106 libaio-devel-0.3.106 (32 bit) libgcc-4.1.2 libgcc-4.1.2 (32 bit) libstdc++-4.1.2 libstdc++-4.1.2 (32 bit) libstdc++-devel 4.1.2 make-3.81 sysstat-7.0.2 libhugetlbfs

5. Verify command "hostname" and "hostname -s" return short hostname
6. Verify commnd "hostname -f" return full hostname with domain
7. Kernel configuration for server with 256 GB RA
kernel.shmmax 100 GB
kernel.shmall 256 GB - 1 byte
kernel.msgmni 1024
kernel.sem 1250 256000 100 1024
vm.max_map_count 1000000
semmsl 250 (minimum)
semmns 3200
semopm 100
semmni 128
shmmni 4096
fs.file-max 6815744
net.ipv4.ip_local_port_range 9000 65500
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 1048576
fs.aio-max-nr 1048576
vm.nr_hugepages 51200

8. /etc/security/limits.conf

@sapsys    hard    nofile    32800
@sapsys    soft    nofile    32800
@dba       hard    nofile    32800
@dba       soft    nofile    32800
@dba       soft memlock    102400
@dba       hard memlock    102400

9. Ensure command "locale -a" contain language "en_US"

10. Append following to /etc/services
sapdp00 = 3200/tcp
sapdp00s = 4700/tcp
sapgw00 = 3300/tcp
sapgw00s = 4800/tcp
sapms[SID] = 3600/tcp

SAP Media Download
You must have S-ID account and support from SAP to download (certainly authorization must be granted, or it will show empty browser after click download). SAP software is not free download like Oracle
There are 3 areas where to download the software

1. SAP NetWeaver kernel and Oracle 10g client (10.2.0.5)
2. SAP ECC 6 with Oracle 11g Rel 2 RDBMS (11.2.0.2)
3. Oracle patches
4. Patch R3load, R3szchk, R3ldctl

SAP does not group all the software under ECC 6 folder. It does not contain Oracle patch, nor NetWeaver kernel, so they have to download from other path

Reserves 30 GB of space to download all medias. Some are in ZIP, while some are in RAR format. Any media which is larger than 1,000 MB will be in multi part RAR file. Please note that the first RAR file is always in EXE extension, but it does not need to extract from Windows. This is because rarlab (the company who create rar utility) uncompress utility (called unrar) can skip through the Windows EXE binary header and uncompress the multi part files. This is not well documented in SAP

1. Media for SAP ECC 6 EhP 5
Navigation path http://service.sap.com/swdc SAP Software Download Center
- Installations and Upgrades
- My Company's Application Components
- My Company's Software
- SAP ERP
- SAP ERP ENHANCE PACKAGE
- EHP5 FOR SAP ERP 6.0
- Installation
- DB System based on
- ORACLE Database
- based on SAP NetWeaver 7.02
Media name and media ID
BS7i2010 Installation Master Linux on x86_64 64bit 51043618_8
- Contains sapinst executable (runs by root) to extract all the other media SAP ERP 6.0 EHP5 Installation Export 1 of 12 51039090_1 to SAP ERP 6.0 EHP5 Installation Export 12 of 12 51039090_12
- Contains database import dump to load into new Oracle database
- Used by "Database Instance" install
SAP Enh. Package 5 for SAP ERP 6.0 1 of 7 51036979_1 to SAP Enh. Package 5 for SAP ERP 6.0 5 of 7 51036979_5
- Contains Enhance Package 5
- Used by "Central Instance" install
SAP ERP 6.0 EHP5 Language 1 of 11 51039096_1 to SAP ERP 6.0 EHP5 Language 11 of 11 51039096_11
- Contain many different languages
- Used by "Central Instance" install

2. Media for SAP EHP2 for NetWeaver 7.0 and Oracle
SAP Software Download Center
- Installations and Upgrades
- My Company's Application Components
- My Company's Software
- SAP ERP
- SAP ERP ENHANCE PACKAGE
- EHP5 for SAP ERP 6.0
- Installation
- Linux
- Oracle database
BS7i2010 UC-Kernel 7.20 Linux on x86_64 64bit 51039103_10
- Need by "Database Instance" and "Central Instance" install
ORACLE Client 10.2.0.5 V3 51042929
- Need by "Database Instance" install

3. Media for latest Oracle patch
Navigation Path:
http://service.sap.com/swdc
Click on "Database Patches" on top menu
- Oracle
- 11.2.0.2
- Oracle RDBMS
- Linux x86_64

SAP_112026_201207_LINX8664.zip
- Just choose the latest zip file
- SAP provide file monthly
- The homepage only keep last 2 months patch. Older patches are purged
Click on "Database Patches" on top menu

- Oracle
- 11.2.0.2
- OPatch
mopatch-2_1_12.zip
opatch-112019.zip
- opatch used by mopatch, so both are required

5. Free unrar utility
Download from rarlab directly. SAP does not provide this info clearly in any of their ECC download page. Please remember that the complete RAR utility is NOT free. rarlab only provide unrar utility below free
http://www.rarlab.com/rar/unrar-linux-x64.gz

Unpack Procedure
Files can upload to server (Linux) as regular UNIX account. Unpack the files using the same user account as well

For zip file, use following syntax
unzip 51033500_1.ZIP

- Most file contains a sub-directory, so no need to create it manually
If want to see it before unpack (to verify it contains a sub-directory), use following syntax
unzip -t 51033500_1.ZIP
For .gz file (unrar utility), uncompress using following syntax
gunzip unrar-linux-x64.gz
mv unrar-linux-x64 unrar

For rar file, use following syntax (after gunzip unrar)

unrar x 51039090_1.EXE

Must unpack with the 1st file. Although you may interested in a specific files in other RAR part file, you still have to specify file #1

Launch SAPinst Installer
Login as root, or sudo as root into database server Ensure X Windows is working, or set "export DISPLAY=IP:0.0" I will not cover this here

cd /Download/Install._Mst._BS7i2010___ORACLE_11.2_/IM_LINUX_X86_64
export SAPINST_USE_HOSTNAME=[virtual hostname of database]
./sapinst

A graphical interface will appear. If you see blank screen, then the X Windows utility is not compatible. If using MobaXterm, then see my other blog about the solution. Otherwise, use VNC, which does not emulate X Windows at all, and not going to have any problem viewing

Navigate to
Enhancement Package 5 for SAP ERP 6.0
- SAP Application Server ABAP
- Oracle
- Distributed System
- Global Host Preparation (1st time choose this)
- Database Instance (2nd time choose this to install further)
- Central Instance (choose from when install from central instance server)

Kindly donate $1 if this post help

SAP: Unpack multiple rar file with unrar in Linux

Product: SAP, RARLab

SAP provide many download DVD as rar files. The file 1 always with .exe extension.

This gives people an impression that it must be unpack in Windows first, which is not true.

RAR file with exe extension can be unpacked directly with RAR Lab's provided unrar in Linux or any UNIX flavor

1. Download unrar from http://www.rarlab.com/rar/unrar-linux-x64.gz. RAR Lab provided this utility as free command line, which only contain 1 program. The full rar utility is not free, however

Reference: http://www.rarlab.com/rar_add.htm

2. In most Linux, e.g. RedHat, in UNIX prompt, it can download with command below

wget http://www.rarlab.com/rar/unrar-linux-x64.gz

3. The file will download to local directory

4. Type following command to uncompress. After uncompress, the extension .gz will disable

gunzip unrar-linux-x64.gz

5. Rename it to unrar

mv unrar-linux-x64 /usr/bin/unrar (for example I want to move to /usr/bin)

6. Now change to SAP software download directory, and uncompress the .exe rar files

/usr/bin/unrar x 51039090_part01.exe (this series of file is from 51039090_part01.exe to 51039090_part11.rar)

7. The program will unpack into current directory. All SAP rar files contain sub-directory, so it is not required to create a sub-directory to extract to

SAP: ECC or Solution Manager Installation - sapinst shows blank

Product: SAP
Module: X Windows emulation with any SAP module which use sapinst to install

It if found that sapinst will display a blank page in certain X Windows emulator.

This could happen to X Manager, MobaXterm, cygwin, Hummingbird

Solution 1: MobaXterm
Only applicable to MobaXterm (free trial version works as well)

1. Click on Settings icon and change "X11 server display mode" to "Windowed mode with Fvwm"
2. Restart X11
3. Ensure X11 running

See following screen shots

Solution 2

Certain people found resizing the windows will make it display its content

Solution 3

Use VNC (vncserver in server end, and vncviewer in PC end) to run sapinst (as root).

This software can be upload to server as regular user account, so it does not need to install, or owned by root. It does not need to reside in /usr/bin/, but it can be in /home/scchen/vnc/, for example.

If there is firewall, then need to open port 5900. If you do not want to ask network team to open it, or too much work, then identify a network port which already open, such as Oracle listener port 1521 - 1590, SAP GUI port, SAP ICM port 80, or 8080.

Then when launch vncserver command, specify the port as those, e.g. 1521, 8080.

Please note that if use port lower than 80, then must run vncserver as user root only. This is standard security limitation for all OS, especially UNIX

Solution 4
Uses commercial version of Reflection X

Solution 5
Install free Linux in your PC, and set DISPLAY=:0.0 in remote sapinst server. Local Linux needs to allow remote X display by typing "xhost +"

Solution 6
Install free Oracle Solaris, and follow steps in #5 above


Side Notes

Don't listen to anyone who tell you below
1. Install Java JRE
2. Install Java JDK
3. Your Java is not 32-bit or 64-bit
4. Installation media corrupted
5. No privilege to execute sapinst (program already running, so privilege is there)
6. Must run as root (root only required when installation start, displaying it does not need root)
7. Insufficient free space in /tmp (if you found /tmp is full, then clean it up and run again. It is unlikely)
8. Use ssh only (I assume ssh with X11 forward is correctly configure as you can display the blank screen already)

As long as you can run xclock, xeye, or any X application, then it means your setup is correct. The sapinst binary won't display a blank windows if it is corrupted, because it won't even able to reach that section of the code

Oracle: Alter Index Online by Other Owner and Get "insufficient privileges" Error

Product: Oracle RDBMS
Version: 11.2.0.2 and above

I have a customer who has following maintenance require, which is common for major corporate

1. Create another partition administration account with minimum privilege to move partition table and index to archive tablespace
2. This Oracle account is not the schema owner of table or index it is moving
3. The table move operation needs to be online
4. The index rebuild operation needs to be online
5. Grant minimum privilege to the partition administrator account

So this mainly to do with Oracle database privilege, and I encountered great challenge when doing #4

I though rebuild index only need "grant alter any index" privilege, but I am wrong. Due to the "ONLINE" syntax, Oracle database will create additional tables and indexes under original schema owner, so following are additional privileges require to grant to partition administrator account

grant create any table to sysman;
grant create any index to sysman;

Surprisingly, I don't need to give any quote on tablespace, or "grant unlimited tablespace" to partition administrator.

In summary, following is the solution

grant alter any index to [partition_admin];
grant create any table to [partition_admin];
grant create any index to [partition_admin];

Sample error message,

SQL> ALTER INDEX SCOTT.IDX_PRICELIST_1 REBUILD PARTITION P_20120425 NOCOMPRESS TABLESPACE users PARALLEL 2 online;
ALTER INDEX SCOTT.IDX_PRICELIST_1 REBUILD PARTITION P_20120425 NOCOMPRESS TABLESPACE users PARALLEL
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
 ---------------
Complete Privilege. Assume partition administrator is SYSMAN:

select * from dba_sys_privs where grantee= 'SYSMAN';

GRANTEE PRIVILEGE            ADM
------- -------------------- ---
SYSMAN  ALTER ANY INDEX      NO
SYSMAN  CREATE ANY TABLE     NO
SYSMAN  ALTER ANY TABLE      NO
SYSMAN  CREATE TABLE         NO
SYSMAN  CREATE ANY INDEX     NO

Genesys: Why Get Duplicate Agent/Queue in Custom Reports?

Product: Genesys
Module: DMA, CCA, Brio, Crystal Report, Hyperion

Many report designers do not understand the reason of primary key index, which is not limited to Genesys product.

As such, when the reports designed using other fields which could have duplicate, then it is possible to get duplicate username, queue, route point, agent group, etc.

In this example, I will use agent report. Many call centers use other fields for agent, such as Genesys login ID, phone login ID, Genesys Employee ID, etc. In the reporting, especially for CCA (DMA), the primary key is Object_ID, which shows agent's name, and Genesys login ID (username).

In directly, many designers use the human name, and username as filtering criteria, which will trigger duplicate records in following situation:
1. Agent re-created. For example seasonal worker, and people re-join the company
2. Agent change its name, may be typo in the name, or title
3. Agent Genesys login ID changed

Solution
1. Join the report between O_, V_, T_, S_ using column OBJECT_ID
2. Speak to user/manager if they are asking something which can't meet with standard CCA tables, such as join with cfg_ tables in CONFIG database
3. Confirmed with user whether want to display DELETED user. If they don't want to display DELETED user, then this is another way to quickly fix the duplicate record without joining with OBJECT_ID. The solution is to add additional filter (WHERE) to say "...and delete_ts is null"

SAP C_TADM70_40 Version 064 OS/DB Migration Questions

Product: SAP
Module: OS/DB Migration
Exam Name: SAP System: Operating System and Database Migration
Exam Code: C_TADM70_40
Last Updated: 2013-12-30

Due to low appreciation in this post. I am removing the content

S1mpl2 q52st34ns 94r p24pl2 wh4 3nt2r2st28 1645t 18v1n72 OS/DB m3gr1t34n 2x1m, 1n8 72rt39371t34n

1) Wh37h 49 th2 94ll4w3ng st1t2m2nts 3s tr52? R2g1r83ng 3n7r2m2nt1l m3gr1t34n

- M5st h1v2 2n45ght sp172 94r l4gg3ng t16l2s 3n s45r72 81t161s2
- L1rg2 t16l2s 71n 62 2xp4rt 4nl3n2, 65t r2m13n3ng t16l2s 2xp4rt 499l3n2
- D1t161s2 tr3gg2rs w3ll 62 7r21t28 3n s45r72 81t161s2

2) Wh1t 3s 5s28 t4 r2st1rt th2 2xp4rt?

- F4r r3l418 <= 4.6D, l4g, t47 93l2
- F4r r3l418 >= 6.1, tsk 93l2s (t47 93l2 3s r218 t4 93n8 th2 l1st wr3t2 p4s3t34n 4nly, 1n8 n4t r2q53r28 39 842s n4t n228 t4 r2s5m2 9r4m l1st p4s3t34n)
- F4r r3l418 <= 4.6D, -r 4pt34n 3s r2q53r28, 65t 39 r3s2t5p 71lls r3l418, th2n 3t w3ll 15t4m1t371lly 71lls w3th -r 4pt34n

3) Wh37h m5st 62 th2 r2l21s2 49 R3l418 94r th2 r2q52st 49 th2 m3gr1t34n k2y, 3n 1 syst2m 4.6D?

-  R3l418 m5st h1s th2 s1m2 k2rn2l r2l21s2 1s SAP k2rn2l r2l21s2. Ch27k w3th "r3l418 -v2rs34n"

4) Wh37h pr4gr1ms 7r21t2 th2 CMD 93l2s?

- r3s2t5p, s1p3nst, m3gm4n

5) Wh37h 49 th2 94ll4w3ng st1t2m2nts 3s tr52 1645t TABART?

- E17h t16l2 1ss3gn28 t4 4n2 TABART
- TABART 3s m13nt13n28 3n ABAP D37t34n1ry

- C5st4m2r 81t1 m5st 1ss3gn TABART USER

6) F4r v2r39y 39 th2 2x3st3ng 46j27ts 3n th2 *.STR 93l2s 1r2 4n DB wh37h 74ntr4l m5st t4 62 84?

- T-C8 SE11 t4 7h27k 81t161s2 46j27t (DBA_TABLES) 74ns3st2n7y, 1n8 r5nt3m2 46j27t (NAMETAB) 74ns3st2n7y

7) Wh1t 1r2 q52st34n28 4n Pr4j27t A583t S2ss34n?

- M3gr1t34n 74ns5lt1nt n1m2
- T3m2 s7h285l2 94r (1) t2st m3gr1t34n (2) 93n1l m3gr1t34n
- T1rg2t 81t2 94r OS/DB M3gr1t34n Ch27k An1lys3s
- T1rg2t 81t2 94r OS/DB M3gr1t34n Ch27k V2r39371t34n
- T27hn371l 921s363l3ty, 2.g. h1r8w1r2, OS, SAP v2r, DB v2r

D42s n4t 1sk 94ll4w3ng (th3s 3s 3n M3gr1t34n Ch27k An1lys3s)
- M1x3m5m syst2m 84wnt3m
- Or82r 49 syst2m m3gr1t34n
- Syst2m l1n8s71p2
- SAP pr4857ts 3nst1ll28
- S45r72 81t161s2 s3z2
- L1rg2st t16l2s/3n82x2s
- C482 p1g2
- In74ns3st2nt DDIC 1n8 DB t16l2s
- Ext2rn1l 9172s & 3nt2r9172s
- Fr22 st4r1g2
- M2831 t4 x'92r 85mp 93l2s

8) Wh1t 3s p17k1g2.TSK 93l2?

- 3ntr485728 4n v2rs34n 6.10
- 7r21t28 6y r3l418 9r4m p17k1g2.str 93l2s
- E1s32r t4 r2st1rt 2xp4rt/3mp4rt 6y 7h1ng3ng th2 2ntry t4 2rr, 4r x2q
- It 842s n4t 74nt13n r3l418 2x275t34n p1r1m2t2rs
- I9 2xp4rt/3mp4rt s5772ss95l, 3ts st1t5s w3ll 7h1ng28 t4 4k
- M1n51lly 7h1ng2 st1t5s t4 3gn t4 94r72 r3l418 t4 sk3p th2 t1sk
- F3rst 74l5mn 3s 81t1 typ2, 2.g. T, D, P, I, V


9) Wh1t 74nt13ns 3n 7m8 93l2s?

- tpl
- str
- t47- 2xt
- tsk (r3l418 >= 6.10)
- m5lt3pl2 85mp 83r
- 6l47k s3z2
- m1x 93l2 s3z2

10) In wh37h s3t51t34n 1n OS/DB m3gr1t34n 74ns5lt1nt r2q53r28?

P2r94rm3ng H2t2r4g2n245s Syst2m C4py 3n 2v2ry 2nv3r4nm2nt, 2.g. DEV, TST, QAS, PROD


11) In p17k1g2.tsk 93l2, 39 th2 st1t5s 49 1n 2ntry 7h1ng28 9r4m "4k" t4 "2rr," wh1t w3ll h1pp2n 1t r2st1rt th2 3mp4rt w3th R3l418?

- r3l418 w3ll st1rt 9r4m n2xt (93rst) 2ntry w3th x2q 4r 2rr
- D2l2t2/8r4p 46j27ts 94r t1sks w3th st1t5s 2rr
- F4r <= 4.60D, 4pt34n -r 3s r2q53r28 94r r2st1rt

12) Wh37h 49 94ll4w3ng r2q53r2 H2t2r4g2n245s Syst2m C4py?

- AIX  DB2 t4 HP-UX Or17l2
- S4l1r3s Or17l2 t4 AIX Or17l2
- S4l1r3s In94rm3x t4 AIX Or17l2

13) Wh37h pr4gr1m/t16l2 pr48572 th2 DBSIZE.TPL 4r DBSIZE.XML?

- DBSIZE.TPL - r3s2t5p 6294r2 6.10
- DBSIZE.XML - r3sz7hk s3n72 6.10
- D1t161s2 t16l2 DDLOAD, wh37h st4r2s th2 r2s5lts 49 t16l2/3n82x s3z2 71l75l1t34n


14) P17k1g2.STR 93l2 71n 94r72 R3l418 t4 4r82r th2 2xp4rt/3mp4rt. Wh37h 49 th2 94ll4w3ng 3s tr52

- M4v2 2ntry t16 1n8 3n8 t4 th2 t4p 49 p17k1g2.STR t4 l418 th2 81t1 93rst
- N4 n228 t4 7h1ng2 PACKAGE.EXT 93l2
- I9 PACKAGE.STR 4r82r 7h1ng28 w3th m5lt3pl2 85mp 93l2s, th2n 3mp4rt 745l8 thr4w 2rr4r 1s r3l418 71n't r218 pr2v345s 85mp 93l2s wh37h h1v2 p1ss28
- P17k1g2 SAPNTAB.STR (39 5s28 P17k1g2 Spl3tt2r), 4r SAPSDIC.STR (3s n2v2r 5s2 P17k1g2 Spl3tt2r) w3ll 1lw1ys th2 93rst STR t4 l418 t4 2ns5r2 N1m2t16 t16l2 1r2 3mp4rt28 3n r3ght 4r82r
- P17k1g2 SAP0000.STR (ABAP L418) sh45l8 n4 62 3mp4rt28, 1n8 5s2 T-C8 SGEN (>=4.6B) 4r SAMT (< 4.6B), 4r r2p4rt RDDGENLD (< 4.6B) t4 r2g2n2r1t2/r274mp3l2 1ll ABAP. ABAP L418 3s OS 82p2n81nt, 1n8 3t w4n't 82l2t2 wh2n n2w SGEN r5n


15) Wh37h pr4gr1m pr48572s th2 EXT 93l2s 4n 6.X m3gr1t34ns?

- R3sz7hk (>= 4.5A)
- R3l87tl (< 4.5A)

16) Wh37h pr4gr1m pr48572 th2 DDL[DBS].TPL?

- pr4gr1m r3l87lt


17) Wh1t 1r2 th2 29927ts 49 r3l418 -m2rg2_67k 4pt34n?

- Imp4rt 15t4m1t371lly st1rt 19t2r s5772ss 49 [PACKAGE].TSK m2rg28
- Ch1ng2 th2 st1t5s x2q 49 1ll 2ntr32s t4 2rr
- D5r3ng r2-3mp4rt, t16l2/3n82x w3ll 62 8r4p/82l2t2 6294r2 7r21t3ng 3t
- [PACKAGE].l4g w3ll sh4wn w1rn3ng m2ss1g2 85r3ng r2-3mp4rt 852 t4 8r4p 2rr4r, 65t 71n 3gn4r2

18) A9t2r POWER FAILURE 3n 1 SAP 4.X, h4w t4 r2s5m2 th2 l418?

D2l2t2 TOC, DUMP 1n8 LOG 93l2s 9r4m th2 p17k1g2 th1t w1s 3nt2rr5pt28 1t 7r1sh t3m2

19) Un82r wh1t s72n1r34, m3gr1t28 h2t2r4g2n245s syst2m 3s n4t s5pp4rt28 6y SAP

- T-C8 ICNV h1s 622n st1rt28
- T-C8 PREPARE h1s 622n st1rt28
- 3r8 p1rty 81t161s2 t44ls 3s 5s28, 2.g. RMAN's 74mm1n8 CONVERT DATABASE ON TARGET PLATFORM...


21) In wh37h 83r27t4ry 93l2 DDL[DBS].TPL 7r21t28?

- 3mp4rt: 3nst1ll1t34n 83r
- 2xp4rt: [85mp]/DB 83r

22) Wh37h pr4gr1m 7r21t2 tsk 93l2?

- r3l418 (>= 6.10)

23) Wh1t 71n MIGMON 84?

<= NW 04
- C1lls r3l418 t4 7r21t2 tsk 93l2 (2xp4rt/3mp4rt), 65t w4n't 4v2rwr3t2 39 2x3sts
- C1lls r3l418 t4 7r21t2 7m8 93l2 (2xp4rt/3mp4rt), 65t w4n't 4v2rwr3t2 39 2x3sts
- C1lls r3l418 t4 2xp4rt/3mp4rt 85mp 93l2s
- C4py 85mp 93l2s w3th r7p 74mm1n8
- X'92r p17k1g2
- S3gn1l 3mp4rt s2rv2r th1t p17k1g2 r218y
- Us2r 2rr4r n4t39371t34n
- W1t7h r3l418 2xp4rt st1t5s
- C1ll r3l418 t4 3mp4rt 1s s44n 1s p17k1g2 3s 1v13l16l2 (3mp4rt s2rv2r m482)
- D293n2 # 49 p1r1ll2l r3l418 (2xp4rt/3mp4rt)
- C4n93g5r2 tr172 l2v2l

>= NW 04S
- C1lls s1p3nst t4 p2r94rm p4st m3gr1t34n t1sks, 2.g. m3g7h27k, 5p81t2 st1t, 83pgnt16, RFC 2x27 t1sk
- C4ntr4l 3mp4rt 4r82r


24) 39 t16l2 m4v28 t4 83992r2nt t16l2sp172 w3th 81t161s2 t44l w3th45t 5p81t2 TABART, wh37h 49 th2 94ll4w 3s tr52

A) Th2 2xp4rt R3LOAD 3s 3nt2rr5pt28 62715s2 842snt 945n8 th2 74rr27t t16l2sp172.
B) R3SZCHK 71n 62 16l2 t4 71l75l1t2 th2 s3z2 w3th45t 1ny pr46l2m

25) Wh1t 93l2s n228 t4 tr1ns92r t4 t1rg2t syst2m?

- /DATA/PACKAGE. 85mp 93l2s
- /DATA/*.STR
- /DATA/*.TOC
- /DB//*.EXT
- /DB//DBSIZE.*
- /DB//*.SQL, 39 2x3sts
- /DB/DDL[DBS].TPL
- /LABEL.ASC
- D42s n4t n228 t4 x'92r *.CMD, *.TSK, *.LOG (3n )

26) S4m2 t16l2s 1r2 3n ABAP 837t34n1ry, n4t 3n th2 81t161s2. Wh37h 49 th2 94ll4w3ng 3s tr52?



27) Wh1t 842s pr4gr1m DIPGNTAB 84?

- A9t2r 3mp4rt 74mpl2t28, s1p3nst/r3s2t5p w3ll 71ll 3t t4 5p81t2 17t3v2 NAMETAB (ABAP D37t34n1ry/DDIC) 9r4m 81t161s2 837t34nry
- L4g t4 93l2 83pgnt16.l4g

28) Wh37h 49 th2 94ll4w3ng 1645t r3l87tl 3s tr52?

- D1t161s2 1n8 pl1t94rm sp273937
- It 3s NOT SAP k2rn2l sp273937
- Cr21t2 STR 93l2
- Cr21t2 SAPVIEW.STR 93l2
- Cr21t2 DDL.TPL 93l2
- H1s SAP 653l8-3n kn4wl28g2 1645t sp273937 t16l2s

29) H4w t4 82t27t wr4ng m3gr1t34n k2y?

- /m3gk2y.l4g 7r21t28 6y "R3LOAD -K" 3n t1rg2t syst2m

-  s1p3nst r2p4rts 3n 1 w3n84w

30) I9 [PACKAGE].2xt 842s n4t 2x3sts 85r3ng 3mp4rt, wh1t w3ll h1pp2n?

31) I9 2xp4rt 85mp 83r27t4ry 95ll, wh1t 3s th2 st2p t4 r2s4lv2 3t?


31) I9 1n 2ntry m4v2 t4 t4p 49 STR 93l2, wh1t 2rr4r w3ll 4775r?

32) A9t2r 3nt2rr5pt28 3mp4rt 94r v4.6B, h4w t4 r2s5m2 th2 3mp4rt?

30) I9 r3l418 913l28 t4 7r21t2 3n82x 852 t4 t2mp4r1ry t16l2sp172 95ll 3n 81t161s2, wh1t w3ll h1pp2n wh2n r2st1rt r3l418 t4 r2s5m2 3mp4rt

F4ll4w3ng w3ll h1pp2n
1. r3l418 r218s  SAPOOL.TSK (>= 6.10) 4r SAPOOL.LOG (<= 4.6D) 1n8 945n8 2ntry 94r wh37h 3n82x 913l28 w3th st1t5s "2rr"
2. r3l418 w3ll tr5n71t2 th2 t16l2 94r th2 r2sp27t3v2 3n82x. It w3ll 5s2 th2 tr5n71t2 st1t2m2nt 3n DDL[DBS].TPL 5n82r s27t34n "tr781t:" I9 th3s s27t34n 3s m3ss3ng, th2n r3l418 w3ll 5s2 DELETE st1t2m2nt, wh37h w3ll 62 v2ry sl4w, 1n8 5s28 1 l4t 49 4nl3n2 r284 l4g (Or17l2)
3. r3l418 w3ll 7r21t2 th2 3n82x

31) C4nt2nt 49 .nnn

1. Its 74nt2nt 3s 74mpr2ss28
2. S3n72 r3l418 4.5A, 3t 74nt13ns 93l2 7h27ks5m 1t 6l47k l2v2l
3. F4r r3l418 164v2 4.5A, 3t w3ll 74mp1r2 s45r72 syst2m 3n OS 1n8 DB. I9 83992r2nt, th2n 1 m3gr1t34n k2y 3s n272ss1ry
4. Its m1x3m5m s3z2 3s 8293n28 3n [PACKAGE].7m8
5. F3l2 94rm1t 3s n4t pl1t94rm sp273937, s4 74mp1t36l2 w3th 1ny OS (HP-UX, L3n5x, AIX)
6. S3n72 4.5A, 3t 74nt13ns 2xp4rt syst2m 3n94, 3.2. 81t161s2, OS n1m2, wh37h st4r2s 3n 1st 6l47k (1ls4 71ll28 h2182r 6l47k, wh37h n4t 1v13l16l2 pr34r 49 r3l418 4.5A)


F4ll4w3ng t4p37s 1r2 n4t 3n th2 t2st
1. JLOAD 4r J1v1's 81t1
2. Un37482 74nv2rs34n


Pl21s2 84n1t2 CAD0 t4 1ppr2731t2 my 2994rt 1n8 sh1r3ng my 2x1m 2xp2r32n72 w3th 2v2ry4n2. Th3s t1k2s gr21t 2994rt t4 p5t 5p 1n 1rt37l2, 1n8 pr4v383ng y45 v1l516l2 1r21 t4 9475s pr34r 49 th2 2x1m

Please donate CAD$10 to appreciate my effort and sharing my exam experience with everyone. I can share the context on demand. This post takes great effort to put up an article, and providing you valuable area to focus prior of the exam

ISP: Acanac SSH Tunnel and VPN Setup

ISP: Acanac DSL

This post is about various free services Acanac is giving free to their Internet subscriber. It should works for Acanac cable internet customer as well, but the domain name could be @cable.acanac.net instead of @acanac.net

SSH Tunneling (SOCKS 5)
Pros: It allows browsers, torrent, FTP download to run with faster respond time most of the time
Cons: Certain time, it is slower, but you just don't use it

Common practice is to use port 8080 for local proxy server

For Linux, or Apple OS X
No software installation required, as all UNIX comes with ssh command. Run following to establish ssh tunneling.

Please note that I put in "-v" to display verbose information. This helps any reader to e-mail me with useful information, so that I can help

[hacker@homer3 ~]$ sudo ssh -D 8080 phla8hiu@tunnel.acanac.net -v
[sudo] password for hacker:
...
...cut...
...
The authenticity of host 'tunnel.acanac.net (67.55.0.175)' can't be established.
RSA key fingerprint is ef:ef:00:07:80:9b:89:88:50:c3:63:5a:90:79:f3:a8.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'tunnel.acanac.net,67.55.0.175' (RSA) to the list of known hosts.
...
...cut...
...
phla8hiu@tunnel.acanac.net's password:
...
...cut...
...
debug1: Local connections to LOCALHOST:8080 forwarded to remote address socks:0
debug1: Local forwarding listening on ::1 port 8080.
debug1: channel 0: new [port listener]
debug1: Local forwarding listening on 127.0.0.1 port 8080.
debug1: channel 1: new [port listener]
debug1: channel 2: new [client-session]
debug1: Entering interactive session.
debug1: Sending environment.
debug1: Sending env LANG = zh_TW.utf8

At this point, leave the console running. It will display new entries whenever any SOCKS 4 or 5 clients has activities


For Windows (Windows 3.1 to 8 or higher)
1. Download Bitvise Tunnelier or any ssh client with tunneling capability
2. Configure
2.1. ssh server: Tunnel.Acanac.net
2.2. ssh server port: 22
2.3. Method: password (so that we can enter password)
2.4. Username: DSL login without @acanac.net
2.5. Password: DSL password
3. Enable SOCKS 5 (or SOCKS 4) proxy forwarding
4. Listener host: localhost (or 127.0.0.1 both are the same, means this PC)
5. Listener port: 8080 which is commonly used as SOCK proxy server

This will setup the PC as SOCKS 5 proxy server. Next, configure any software, like IE, Firefox, uTorrent, eMule, FTP, e-mail with SOCKS 5 proxy server. Example:
1. Proxy server type: SOCKS 4 or SOCKS 5 (recommend)
2. Proxy server: localhost
3. Proxy port: 8080 (or whatever value configured in Step 5 above)

Any device in the LAN can configure to use SOCKS 5 server (above configured PC), such as BlackBerry phone, Android phone, Android tablet, Apple iPad, Samsung TV, Sony TV, VoIP phone, IPTV, etc. Specify the SOCKS 5 server as the IP of above PC, with port 8080. No need username and password in the device

Additional guide provided in Acanac Forum below
https://community.acanac.com/acanac/viewtopic.php?f=21&t=11264
https://community.acanac.com/acanac/viewtopic.php?f=21&t=11696
https://community.acanac.com/acanac/viewtopic.php?f=21&t=11692
https://community.acanac.com/acanac/viewtopic.php?f=92&t=16963


VPN
Pros: Same as ssh tunneling above
Cons:Same as ssh tunneling above

VPN Web Server Address: https://vpn.acanac.net
VPN Username: phla8hiu@acanac.net (this is sample value)
VPN Password: DSL password

1. Browse to above VPN web server address using any browser
2. Click on "Continue to this web site" and ignore warning "There is a problem with this website's security certificate

3. Download OpenVPN when it prompts. The file name is openvpn-connect-1.8.3.msi
4. Run the MSI file and install into PC
5. Launch program "OpenVPN Connect"
6. Enter login information

7. The PC will connect to VPN, and all the applications will enjoy faster respond time

For Linux (Fedora), click on the upper right hand network icon
1. Specify OpenVPN
2. Specify type as Password
3. Specify server as 67.55.0.106, username, and password

Following web page shows additional steps which you can install OpenVPN server into DD-WRT compatible WiFi router, so that you can connects to your own home network using OpenVPN client

http://www.howtogeek.com/64433/how-to-install-and-configure-openvpn-on-your-dd-wrt-router/

Please use following PayPal donate if post helped

Oracle: Advance Configuration of Linux HugePages

Product: Oracle RDBMS
OS: Linux in Intel x86 64-bit
Version: Any version supports hugepages

Although Oracle and many others document about Linux kernel hugepages, but none talk about other implication of hugepages, which I am quite upset about going through cycle of argument with DBA.

Guideline summary:
1. This setting applies to any Linux distribution
2. kernel value hugepages is in number of memory block in 2 MB size
3. Kernel parameter file, and value

Kernel setting file: /etc/sysctl.conf
Value: vm.nr_hugepages =

4. It will stop Linux from paging Oracle process memory to swap file
5. 60 GB of target Oracle SGA will need 30,720 huge pages (60 GB / 2 MB = 30,720 huge page)
6. Very Oracle shadow process (1 process spawn for every Oracle client connection, except using Oracle Shared Server)
7. Number of private page table per Oracle shadow process with hugepage = 60 GB / 2 MB = 30,720 pages
8. Page Table Entry (PTE) size per Oracle shadow process = 30,720 * 8 byte = 240 KB
9. If there are 300 Oracle client connections (like CRM, SAP, Tomcat with JDBC), with every Oracle shadow process need 240 KB of overhead = 240 KB * 300 = 70 MB

Most DBA use estimate on target Oracle SGA to derive, following example show the most accurate method to calculate the kernel hugepage value

1. Set Oracle SGA without setting huge page
2. Startup Oracle database. If multiple database, then start up all databases
3. Type: ipcs -m | grep oracle (where this is the UNIX user who start up Oracle process). Following shown 2 Oracle databases each allocated about 20 GB memory

# ipcs -m | grep oracle
0x38671d2c 3997702    oracle    660        21476933632 30

0x41271ab1 3997702    oracle    660        21476933632 30


4. If there is another Oracle process using different Oracle UNIX user, then grep with that username, e.g. oraias, orasap, oraweb

# ipcs -m | grep -e oraias -e orasap -e oraweb

5. Value 21476933632 byte is the actual memory allocated to Oracle database. Use calculator to sum up all the memory used


6. To activate huge page immediately, run this command as root: sysctl -w vm.nr_hugepages=
7. Started up database, and run following as normal user to confirm huge page is used:


grep HugePages /proc/meminfo


Note:
File: /etc/security/limits.conf


Following lines are assumed has been configured as per Oracle document

oracle          soft    memlock        unlimited
oracle          hard    memlock        unlimited

If there are other Orale UNIX user who will start the database, there there will be additional lines configure



Please use following PayPal donate if this post helped