SAP 4.7 Installation Error - PLEASE HELP.

[Former Member]

Hi Gurus,

I have installed 4.7 on my laptop having XP OS and oracle database.

The installation was successful and I got the final confirmation window also saying that " SAP Installation successful" and immediately after that I opened sap MMC and saw that the instance was up and all the work processes were in WAIT state. Then I stopped the instance and installed sap gui and again restarted the instance, but the instance did not come up and all the work processes died.

I have attached the developers trace for one of the work process:

-

---

-

---

trc file: "dev_w0", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Wed Jan 23 12:05:42 2008

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\DAD\SYS\exe\run\dboraslib.dll' ...

B Library 'D:\usr\sap\DAD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'D:\usr\sap\DAD\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 2676

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2676) [dpxxdisp.c 1016]

I MtxInit: -2 0 0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Wed Jan 23 12:05:48 2008

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora81 from environment

C

C Wed Jan 23 12:05:50 2008

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPDAD's password

C Connecting as /@MOM on connection 0 ...

C Attaching to DB Server MOM (con_hdl=0,svchp=06E68D08,svrhp=06E68B14)

C

C Wed Jan 23 12:06:19 2008

C Starting user session (con_hdl=0,svchp=06E68D08,srvhp=06E68B14,usrhp=06EAA71C)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3718]

C *** ERROR => CONNECT failed with sql error '1017'

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPDAD/<pwd>@MOM on connection 0 ...

C Starting user session (con_hdl=0,svchp=06E68D08,srvhp=06E68B14,usrhp=06EAA71C)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3718]

C *** ERROR => CONNECT failed with sql error '1017'

[dboci.c 9536]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1098]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8277]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server mandeep_DAD_00 on host mandeep (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Wed Jan 23 12:06:19 2008

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

M *****************************************************************************

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 235]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2676) [dpnttool.c 345]

-

---

Please help me find the problem. I will really appreciate any suggestions. MAXIMUM rewards points will be awarded.

Regards,

Sandeep

[Former Member · Accepted solution]

Hi,

the problem seems to be with your Oracle - database.

Logon to your OS using <sid>adm user.

open command prompt and execute "brtools utility" by typing brtools and press enter.

Go to instance management and select the option Instance status and press C to continue and check the database instance status. It should be OPEN for valid operations and application connections.

Also make sure the environment variable are set properly for <sid>adm user.

Regards,

Prem

[Former Member]

Hi kaul,

I would like to know about the prerequisities you have made fpr the 4.7 version ,have you done all the prerequisites?

1.OS Support pack - If it is Windows 2003 -SP1

2.Memory Settings- Cache memory 3/4 size of your Ram

3.The :usr\sap\ installation drive should be having ample space 100gb needed for 4.7 IDES

4.Disable the Noetwork connection and install Microsoft Loopback Adapter and give the IP parameters

5.Install Oracle and after that install oracle patch set (while doing this u have to stop hte running Oracle instance using services.msc)

6.then u have to install the kernel 4.7 as central instance installation

7.after the completion of CI installation start the Database Installation

8.Goto to the folder C:programfiles/Sap/sapinst/ copy the files in the inst and paste it in hte Sap folder and strat clicking the sapinst.exe

try with this XP check the latest SP level my sugesstion is to install windows 2003 sp1 u can use dual boot OS: and use 2003 for SAP

regards,

S.Rajeshkumar

Reward points welcome!

[Former Member]

Kaul,

The work processes failing is usually a sign that something else is wrong before things got started. From what I can see in the wp trace, the dispatcher is not healthy yet. Can you provide the dev_disp log from the work directory? That should let us know what occured during the startup with the dispatcher.

Thanks - there may be a lot of garbage in here so if you can stop the system (just R3), delete everything in the 'work' directory (/usr/sap/<SID>/DVEBMGS<NR>/work) and then try to start the system again.

You may want to reboot your system before attempting to do this so you can make sure all the memory is cleaned-up as the start probably left a lot of memory in a questionable state (I only recommend the re-boot to clear-up memory if it is something like a laptop install).

Edited by: David Milliken on Jan 25, 2008 4:23 AM

[Former Member]

Hi Experts,

I have again repeated the installation...and the same result.

After the completion of the installation all the work processes are in healthy state and are in WAIT mode. Then I stop the instance, install sapgui and reboot the system. Now the dispatcher is not comming up because all the work processes have died.

The dev trace of work process immediately after installation:

-

---

-

---

trc file: "dev_w0", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Thu Jan 24 10:37:55 2008

B create_con (con_name=R/3)

B

B Thu Jan 24 10:37:56 2008

B Loading DB library 'F:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B

B Thu Jan 24 10:37:57 2008

B Library 'F:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'F:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 2184

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2184) [dpxxdisp.c 1016]

I MtxInit: -2 0 0

X

X Thu Jan 24 10:37:58 2008

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M calling db_connect ...

C Got ORACLE_HOME=c:\oracle\ora81 from environment

C

C Thu Jan 24 10:37:59 2008

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPPRD's password

C Connecting as /@NEW on connection 0 ...

C Attaching to DB Server NEW (con_hdl=0,svchp=06538D08,svrhp=06538B14)

C

C Thu Jan 24 10:38:00 2008

C Starting user session (con_hdl=0,svchp=06538D08,srvhp=06538B14,usrhp=0657AFDC)

C Now I'm connected to ORACLE

C Got SAPPRD's password from table SAPUSER

C Got SAPPRD's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=06538D08,usrhp=0657AFDC)

C Now I'm disconnected from ORACLE

C Connecting as SAPPRD/<pwd>@NEW on connection 0 ...

C Starting user session (con_hdl=0,svchp=06538D08,srvhp=06538B14,usrhp=0657AFDC)

C Now I'm connected to ORACLE

C Database NLS settings: AMERICAN_AMERICA.WE8DEC

C Database instance new is running on MANDEEP with ORACLE version 8.1.7.0.0 since 20080124

B Connection 0 opened

B Wp Hdl ConName ConId ConState TX PRM RCT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 20080124 103758 MANDEEP

M db_connect o.k.

I

I Thu Jan 24 10:38:17 2008

I MtxInit: 0 0 0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

X ES initialized.

B db_con_shm_ini: WP_ID = 0, WP_CNT = 15

M rdisp/reinitialize_code_page -> 0

S *** init spool environment

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 06652A50

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 1 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S found spool memory service RSPO-RCLOCKS at 14490098

S doing lock recovery

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at 14490418

S using messages for server info

S size of spec char cache entry: 164980 bytes (timeout 100 sec)

S size of open spool request entry: 1144 bytes

S immediate print option for implicitely closed spool requests is disabled

A

A -PXA--

---

A PXA INITIALIZATION

A Attached to PXA (address 687D0040, size 150000K)

A abap/pxa = shared gen_remote

A PXA INITIALIZATION FINISHED

A -PXA--

---

A

A RFC Destination> destination mandeep_PRD_00 host mandeep system PRD systnr 0 (mandeep_PRD_00)

A RFC Options> H=mandeep,S=00

B table logging switched off for all clients

A

A Thu Jan 24 10:38:18 2008

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 1

A RFC Method> initialize RemObjDriver for ABAP Objects

N SsfSapSecin: putenv(SECUDIR=F:\usr\sap\PRD\DVEBMGS00\sec): ok

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is F:\usr\sap\PRD\SYS\exe\run\sapsecu.dll .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...sucessfully completed.

N =================================================

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

B

B Thu Jan 24 10:38:25 2008

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:620.02]):

B max_blocking_factor = 15, max_in_blocking_factor =1000,

B min_blocking_factor = 10, min_in_blocking_factor = 10,

B prefer_union_all = 0, prefer_union_for_select_all = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding =SBCS / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

M

M Thu Jan 24 10:38:38 2008

M *** WARNING ==> ThCheckReqInfo: req_info & DP_CANT_HANDLE_REQ

M

M Thu Jan 24 10:38:46 2008

M *** WARNING ==> ThCheckReqInfo: req_info & DP_CANT_HANDLE_REQ

E

E Thu Jan 24 10:39:03 2008

E Replication is disabled

M

M Thu Jan 24 10:54:39 2008

M in_ThErrHandle: 1

M ThIErrHandle: I'm during shutdown

M Entering ThSetStatError

M ThIErrHandle: don't try rollback again

M ThIErrHandle: normal shutdown

M ThCallHooks: call hook >ASTAT-collect commit handling< for event BEFORE_COMMIT

M ThCallHooks: call hook >rsts_before_commit< for event BEFORE_COMMIT

M ThCallHooks: call hook >rsts_after_commit< for event AFTER_COMMIT

M ThCallHooks: call hook >ThNoClearPrevErr< for event AFTER_COMMIT

M ThCallHooks: call hook >SpoolHandleHook< for event AFTER_COMMIT

M ThCallHooks: call hook >ASTAT-collect commit handling< for event BEFORE_COMMIT

M ThCallHooks: call hook >rsts_before_commit< for event BEFORE_COMMIT

M ThCallHooks: call hook >rsts_after_commit< for event AFTER_COMMIT

M ThCallHooks: call hook >ThNoClearPrevErr< for event AFTER_COMMIT

M ThCallHooks: call hook >SpoolHandleHook< for event AFTER_COMMIT

M Entering ThReadDetachMode

M call ThrShutDown (1)...

B Disconnecting from ALL connections:

B Wp Hdl ConName ConId ConState TX PRM RCT Date Time DBHost

B 000 000 R/3 000000000 INACTIVE NO YES NO 20080124 103758 MANDEEP

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=06538D08,usrhp=0657AFDC)

C Detaching from DB Server (con_hdl=0,svchp=06538D08,srvhp=06538B14)

C Now I'm disconnected from ORACLE

B Disconnected from connection 0

B statistics db_con_commit (com_total=476, com_tx=260)

B statistics db_con_rollback (roll_total=0, roll_tx=0)

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2184) [dpnttool.c 345]

-

---

Dev trace of the work process after reeboot.

-

---

-

---

trc file: "dev_w0", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Thu Jan 24 11:14:25 2008

B create_con (con_name=R/3)

B Loading DB library 'F:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B Library 'F:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'F:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 3436

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3436) [dpxxdisp.c 1016]

I MtxInit: -2 0 0

X

X Thu Jan 24 11:14:26 2008

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M calling db_connect ...

C Got ORACLE_HOME=c:\oracle\ora81 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPPRD's password

C Connecting as /@NEW on connection 0 ...

C Attaching to DB Server NEW (con_hdl=0,svchp=06538D08,svrhp=06538B14)

C

C Thu Jan 24 11:14:27 2008

C Starting user session (con_hdl=0,svchp=06538D08,srvhp=06538B14,usrhp=0657AFDC)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3718]

C *** ERROR => CONNECT failed with sql error '1017'

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPPRD/<pwd>@NEW on connection 0 ...

C Starting user session (con_hdl=0,svchp=06538D08,srvhp=06538B14,usrhp=0657AFDC)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3718]

C *** ERROR => CONNECT failed with sql error '1017'

[dboci.c 9536]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1098]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8277]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server mandeep_PRD_00 on host mandeep (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Thu Jan 24 11:14:27 2008

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

M *****************************************************************************

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 235]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3436) [dpnttool.c

-

---

I am puzzeled now why a reboot can have such a bad effect on the setup. Please help me resolve this problem.

Thanks in advance.

Sandeep

[Former Member]

HI ,

Sandeep

u have to do 2 things

1)go to services.msc, choose sap<sid>_<nr> and saposcol ,goto the properties for both services,then choose logon tab,over there check the username and password ( 2nd option--."for this account" should be choosen)

2)just copy and past all the environment variable for user to here , so we can check if anyone is missing for database, i will send missing

then it should start, i had same prob and i solved in this way ,now it work very well

if this will help reward point

Regards

Saumin

[Former Member]

Hi,

two quick ways to fix the connection to the oracle DB. Run oradbusr.sql script which will initialise the OPS$ mechanism.

As it's a laptop could also change the oracle SYSTEM user password to 'manager'.

cheers

[Former Member]

Hi all....Thanks a lot for your response. I have reformatted my system and again doing a clean installation. Lets me see how it goes this time.

Thanks a lot for ur time.

Regards,

Mandeep

[Former Member]

looks, DB couldn't be connected to. Did you install Oracle / SAP instance as a different user than the user who is logged in when you got the error? Make sure that the Database is up and running. You could also try connecting to the database through SQL also.

BMG