partner sapdp00 not reached

[Former Member]

Dear All,

After Installation the Test Server , Database : Oracle 10.2.0.1 , OS : Hp Unix 11.11, SAP Appl: ECC 6.0

Database is up , SAP Instance is Started . While login from SAP GUI system shows following Error message.

Partner not reached

Error Number : 10061

Error Text : WSAECONNREFUSED:Connection refused.

Where I have check & correct the above error.

Regards,

Santosh

[markus_doehr2 · Accepted solution]

It seems your system is not started.

Check

dev_disp

dev_w0

in the systems work directory.

Markus

[Former Member]

Hi KJ,

After add the parameter in INSTANCE profile but same error observed.

Shall i add this parameter in START profile ?

Regards,

Santosh

[Former Member]

Hi KJ,

Following logs are received

ERPDEV:t02adm 21> sappfpar check pf = T02_DVEBMGS00_ERPDEV

sappfpar=>sapparam(1c): No Profile used.

sappfpar=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

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

== Checking profile: <no_profile>

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

***ERROR: Size of shared memory pool 10 too small

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

SOLUTIONS: (1) Locate shared memory segments outside of pool 10

with parameters like: ipc/shm_psize_<key> =0

SOLUTION: Increase size of shared memory pool 10

with parameter: ipc/shm_psize_10 =108000000

***ERROR: Size of shared memory pool 40 too small

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

SOLUTIONS: (1) Locate shared memory segments outside of pool 40

with parameters like: ipc/shm_psize_<key> =0

SOLUTION: Increase size of shared memory pool 40

with parameter: ipc/shm_psize_40 =112000000

Shared memory disposition overview

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

Shared memory pools

Key: 10 Pool

Size configured.....: 19880000 ( 19.0 MB)

Size min. estimated.: 104095554 ( 99.3 MB)

Advised Size........: 108000000 ( 103.0 MB)

Key: 40 Pool for database buffers

Size configured.....: 14250000 ( 13.6 MB)

Size min. estimated.: 108776088 ( 103.7 MB)

Advised Size........: 112000000 ( 106.8 MB)

Shared memories inside of pool 10

Key: 11 Size: 500000 ( 0.5 MB) Factory calender buffer

Key: 12 Size: 6000000 ( 5.7 MB) TemSe Char-Code convert Buf.

Key: 13 Size: 40500000 ( 38.6 MB) Alert Area

Key: 14 Size: 4400000 ( 4.2 MB) Presentation buffer

Key: 16 Size: 22400 ( 0.0 MB) Semaphore activity monitoring

Key: 17 Size: 2672386 ( 2.5 MB) Roll administration

Shared memories inside of pool 40

Key: 42 Size: 7232992 ( 6.9 MB) DB TTAB buffer

Key: 43 Size: 32534392 ( 31.0 MB) DB FTAB buffer

Key: 44 Size: 7958392 ( 7.6 MB) DB IREC buffer

Key: 45 Size: 4886392 ( 4.7 MB) DB short nametab buffer

Key: 46 Size: 20480 ( 0.0 MB) DB sync table

Key: 47 Size: 3073024 ( 2.9 MB) DB CUA buffer

Key: 48 Size: 300000 ( 0.3 MB) Number range buffer

Key: 49 Size: 2769392 ( 2.6 MB) Spool admin (SpoolWP+DiaWP)

Shared memories outside of pools

Key: 1 Size: 2500 ( 0.0 MB) System administration

Key: 2 Size: 4916724 ( 4.7 MB) Disp. administration tables

Key: 3 Size: 13714400 ( 13.1 MB) Disp. communication areas

Key: 4 Size: 503248 ( 0.5 MB) statistic area

Key: 6 Size: 159744000 ( 152.3 MB) ABAP program buffer

Key: 7 Size: 14838 ( 0.0 MB) Update task administration

Key: 8 Size: 67108964 ( 64.0 MB) Paging buffer

Key: 9 Size: 134217828 ( 128.0 MB) Roll buffer

Key: 18 Size: 917604 ( 0.9 MB) Paging adminitration

Key: 19 Size: 30000000 ( 28.6 MB) Table-buffer

Key: 30 Size: 3072 ( 0.0 MB) Taskhandler runtime admin.

Key: 31 Size: 1806000 ( 1.7 MB) Dispatcher request queue

Key: 33 Size: 10240000 ( 9.8 MB) Table buffer, part.buffering

Key: 41 Size: 25010000 ( 23.9 MB) DB statistics buffer

Key: 51 Size: 3200000 ( 3.1 MB) Extended memory admin.

Key: 52 Size: 40000 ( 0.0 MB) Message Server buffer

Key: 54 Size: 4202496 ( 4.0 MB) Export/Import buffer

Key: 55 Size: 8192 ( 0.0 MB) Spool local printer+joblist

Key: 57 Size: 1048576 ( 1.0 MB) Profilparameter in shared mem

Key: 58 Size: 4096 ( 0.0 MB) Enqueue ID for reset

Key: 62 Size: 85983232 ( 82.0 MB) Memory pipes

Key: 63 Size: 409600 ( 0.4 MB) ICMAN shared memory

Key: 64 Size: 4202496 ( 4.0 MB) Online Text Repository Buf.

Key: 65 Size: 4202496 ( 4.0 MB) Export/Import Shared Memory

Key: 1002 Size: 400000 ( 0.4 MB) Performance monitoring V01.0

Key: 58900100 Size: 4096 ( 0.0 MB) SCSA area

Nr of operating system shared memory segments: 28

Shared memory resource requirements estimated

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

Total Nr of shared segments required.....: 28

System-imposed number of shared memories.: 200

Shared memory segment size required min..: 159744000 ( 152.3 MB)

System-imposed maximum segment size......: 1073741824 (1024.0 MB)

Swap space requirements estimated

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

Shared memory....................: 738.1 MB

..in pool 10 19.0 MB, 523% used !!

..in pool 40 13.6 MB, 763% used !!

..not in pool: 526.3 MB

Processes........................: 25.9 MB

Extended Memory .................: 4092.0 MB

-

---

Total, minimum requirement.......: 4856.0 MB

Process local heaps, worst case..: 1907.3 MB

Total, worst case requirement....: 6763.3 MB

Errors detected..................: 2

Warnings detected................: 0

Regardsn

santosh

[Former Member]

Hi Markus.

I have remove rf* logs from /work directory

Followin g is trans.log details

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 20.09.2011 - 17:20:13

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections:

603 0.000603

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ...

96 0.000699

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=8000000100

a51698,usrhp=8000000100a4e618)

4 ETW000

551 0.001250

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=800000

0100a51698,srvhp=8000000100a53990)

4 ETW000

1183 0.002433

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE

807 0.003240

4 ETW000 [dev trc ,00000] Disconnected from connection 0

33 0.003273

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000

38 0.003311

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_t

x=0)

4 ETW000

36 0.003347

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 20.09.2011 - 17:20:13000 [twdydbacc.c ,00612] i:2

Regards,

Santosh

[Former Member]

Santosh,

Thanks, I know you will get error. Please follow the steps I mentioned and your issue will be resolved.

Add these 2 parameters to your instance profile and repeat sappfpar check. Repeat the steps for START profile, if you have one.

ipc/shm_psize_10 =108000000

ipc/shm_psize_40 =112000000

Thanks,

KJ.

[Former Member]

Hi Markus,

In the system dev_w0 and dev_disp logs files are shown old dated. this files are not update.

When I saw ps -ef |grep sap* , no sap services display.

Please reply how to start above services ?

Regards,

Santosh

[markus_doehr2]

> When I saw ps -ef |grep sap* , no sap services display.

Try the following as user <sid>adm:

cdD
cd work
rm -rf *

then issue an

Rtrans -d

and post the resulting "trans.log" file.

Markus

[Former Member]

Hi Santosh,

Please try the below, it should be quick and easy:

1.) Login as <sid>adm and then issue "cdpro". Stop SAP using "stopsap".

2.) Run "sappfpar check pf=<profile files>". Depending on your NW version, it should be either just DEFAULT and Instance profile files or the Start profile as well.

3.) Make sure that any or all the errors reported by the error is corrected by the IPC parameters.

4.) Run the sappfpar again to ensure there are ZERO errors.

5.) The issue "cleanipc <instance no.> remove". Issue this command for all instances in case of a multi-instance setup.

6.) Kill any orphan'd SAP process running under <sid>adm as owner.

7.) Issue "ipcs | grep <sid>adm". In case there are any seamphores owned by by <sid>adm, remove it using "ipcrm -s|-m <no.>"

8.) When all is clear, issue "R3trans -d".

9.) If the retuen code is 0000, start SAP.

If you face any issue in the steps above, paste the detailed error log.

Thanks,

KJ

[Former Member]

Hi Markus.. following is the deatil log for dev_wo

RFC rfc/signon_error_log = -1

RFC rfc/dump_connection_info = 0

RFC rfc/dump_client_info = 0

RFC rfc/cp_convert/ignore_error = 1

RFC rfc/cp_convert/conversion_char = 23

RFC rfc/wan_compress/threshold = 251

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

RFC rfc/delta_trc_level not set, use default value: 0

RFC rfc/no_uuid_check not set, use default value: 0

RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

RFC Method> initialize RemObjDriver for ABAP Objects

ThrCreateShObjects allocated 13562 bytes at c0000000000f8000

SsfSapSecin: putenv(SECUDIR=/usr/sap/T02/DVEBMGS00/sec): ok

RFC rfc/signon_error_log = -1

RFC rfc/dump_connection_info = 0

RFC rfc/dump_client_info = 0

RFC rfc/cp_convert/ignore_error = 1

RFC rfc/cp_convert/conversion_char = 23

RFC rfc/wan_compress/threshold = 251

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

RFC rfc/delta_trc_level not set, use default value: 0

RFC rfc/no_uuid_check not set, use default value: 0

RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

RFC Method> initialize RemObjDriver for ABAP Objects

ThrCreateShObjects allocated 13562 bytes at c0000000000f8000

SsfSapSecin: putenv(SECUDIR=/usr/sap/T02/DVEBMGS00/sec): ok

A ** RABAX: level LEV_RX_STANDARD entered.

C *** ERROR => Failed to register application info: orc=24909

[dboci.c 2922]

C *** ERROR => Unregistering application info callback

[dboci.c 2923]

C *** ERROR => ORA-24909 occurred when executing SQL statement (parse error off

set=0)

Regards

Santosh

[markus_doehr2]

You have an issue with your database - you get ORA-24909.

Are you running 10.2.0.1? This version is not supported for installations (and never was). If you run that version I highly suggest you go through the installation guide. You should install the latest patchset and then the latest PSU patches before you start the import of the data.

Markus

[Former Member]

Please reply me How to cleanup the worprocess resources ?

Since dev_w0 log size is big so inable to send .

Regards,

[markus_doehr2]

Open the file and scroll up until you see the first error. Then post the content from there.

We can't tell you how to read logfiles...

Markus

[Former Member]

dev_wo logs as below :

M Mon Sep 12 14:49:49 2011

M in_ThErrHandle: 1

M ThIErrHandle: new stat of W0 is WP_SHUTDOWN

M ThIErrHandle: I'm during shutdown

M PfStatDisconnect: disconnect statistics

M Entering ThSetStatError

M ThIErrHandle: don't try rollback again

M ThShutDownServer: shutdown server

M PfStatIndInit: Initializing Index-Record

M PfWriteIntoFile: copied shared buf (86664 bytes) to local buf

M PfWriteIntoFile: write 86664 bytes into stat-file

M PfWriteIntoFile: writing Index

M min. start :1315818003/897585

M min. end :1315818003/909170

M max. end :1315819135/701548

M wpid

M tasktypes :49370

M max. resp :1035643

M max. cpu :950000

M max.db

M no. of recs :479

M no. of bytes :86664

M PfFileIndUpd: hyperindex needs to be resorted

M PfWriteIntoFile: updated fileindex for file stat with endtime 1315819135 (12:

9:2011 9:18:55)

M PfWriteIntoFile: updated fileindex

M PfStatIndInit: Initializing Index-Record

M PfWriteIntoFile: wrote buffer to file

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

B Disconnecting from ALL connections:

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date

Time DBHost

B 000 000 R/3 000000000 INACTIVE NO YES NO 000 255 255 20110

909 154707 ERPDEV

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=80000001028c2e98,usrhp=80000001028bfdd8

)

C Detaching from DB Server (con_hdl=0,svchp=80000001028c2e98,srvhp=80000001028c

51d8)

C

C Mon Sep 12 14:49:50 2011

C Now I'm disconnected from ORACLE

B Disconnected from connection 0

B statistics db_con_commit (com_total=17518, com_tx=2125)

B statistics db_con_rollback (roll_total=15, roll_tx=4)

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 16676) [dpuxtool.c 259]

Regards,

Santosh

[markus_doehr2]

This is still not the full log... it does not contain the actual error but just the cleanup of the workprocesses resources...

Markus

[Former Member]

Hi. Markus.

Following is the dev_wo , and dev_disp logs

1) cat dev_w0

M Mon Sep 12 14:49:49 2011

M in_ThErrHandle: 1

M ThIErrHandle: new stat of W0 is WP_SHUTDOWN

M ThIErrHandle: I'm during shutdown

M PfStatDisconnect: disconnect statistics

M Entering ThSetStatError

M ThIErrHandle: don't try rollback again

M ThShutDownServer: shutdown server

M PfStatIndInit: Initializing Index-Record

M PfWriteIntoFile: copied shared buf (86664 bytes) to local buf

M PfWriteIntoFile: write 86664 bytes into stat-file

M PfWriteIntoFile: writing Index

M min. start :1315818003/897585

M min. end :1315818003/909170

M max. end :1315819135/701548

M wpid

M tasktypes :49370

M max. resp :1035643

M max. cpu :950000

M max.db

M no. of recs :479

M no. of bytes :86664

M PfFileIndUpd: hyperindex needs to be resorted

M PfWriteIntoFile: updated fileindex for file stat with endtime 1315819135 (12:

9:2011 9:18:55)

M PfWriteIntoFile: updated fileindex

M PfStatIndInit: Initializing Index-Record

M PfWriteIntoFile: wrote buffer to file

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

B Disconnecting from ALL connections:

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date

Time DBHost

B 000 000 R/3 000000000 INACTIVE NO YES NO 000 255 255 20110

909 154707 ERPDEV

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=80000001028c2e98,usrhp=80000001028bfdd8

)

C Detaching from DB Server (con_hdl=0,svchp=80000001028c2e98,srvhp=80000001028c

51d8)

C

C Mon Sep 12 14:49:50 2011

C Now I'm disconnected from ORACLE

B Disconnected from connection 0

B statistics db_con_commit (com_total=17518, com_tx=2125)

B statistics db_con_rollback (roll_total=15, roll_tx=4)

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 16676) [dpuxtool.c 259]

2) cat dev_disp

Mon Sep 12 14:50:00 2011

DpStartStopMsg: send stop message (myname is >ERPDEV_T02_00

<)

DpStartStopMsg: stop msg sent

Mon Sep 12 14:50:01 2011

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 11899]

MBUF state OFF

MBUF component DOWN

cleanup EM

cleanup event management

cleanup shared memory/semaphores

Mon Sep 12 14:50:02 2011

removing request queue

***LOG Q05=> DpHalt, DPStop ( 9695) [dpxxdisp.c 10519]

• shutdown completed - server stopped ***

3) Startsap logs

ERPDEV:t02adm 21> startsap

Checking T02 Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

13:43:11 19.09.2011 LOG: Effective User Id is root

********************************************************************

• This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.2

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• Starting collector (create new process)

********************************************************************

saposcol on host ERPDEV started

Running /usr/sap/T02/SYS/exe/run/startdb

Trying to start T02 database ...

Log file: /home/t02adm/startdb.log

T02 database started

/usr/sap/T02/SYS/exe/run/startdb completed successfully

Starting SAP Instance DVEBMGS00

-

---

Startup-Log is written to /home/t02adm/startsap_DVEBMGS00.log

Instance Service on host ERPDEV started

Instance on host ERPDEV started

Please reply me How to corrct the same?

Regards,

santosh

[Former Member]

Hi,

Could you paste "full" dev_w0 trace into the message?

It is obvious that the instance is stopping after a while.

Best regards,

Orkun Gedik

[Former Member]

Hi,

Check whether the sapdp00 (tcp/3200) port is open on firewall.

Best regards,

Orkun Gedik

[Former Member]

Check the database status, R3 trans connectivity, find out the error in trans.log or dev_w0 as mentioned by Markus and then resolve the issue (Or you may paste the ERROR lines from the log file).

Oracle 10.2.0.1

Suggestion - Its not a Recommended/Supported version by SAP, Apply the patch set.

Plan your Oracle upgrade from 10G to 11gR2 as the support for the version 10G is out.

Regards,

Nick Loy