Solved: connect /@SID hangs

Former Member · ‎09-15-2009

Dear Team,

Dispatcher show yellow--ABAP processes all in RUN status and tried connecting to oracle conn /@SD2 it hangs.

Not able to find as why the oracle hangs and that is the reason as why the logs dev_w0 does not show anything.

Any idea guys??

dev_disp

-

trc file: "dev_disp", trc level: 1, release: "700"

-

sysno 00

sid SD2

systemid 562 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 185

intno 20050900

make: multithreaded, Unicode, 64 bit, optimized

pid 12124

Tue Sep 15 19:07:14 2009

kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)

length of sys_adm_ext is 576 bytes

SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (00 12124) [dpxxdisp.c 1285]

shared lib "dw_xml.dll" version 185 successfully loaded

shared lib "dw_xtc.dll" version 185 successfully loaded

shared lib "dw_stl.dll" version 185 successfully loaded

shared lib "dw_gui.dll" version 185 successfully loaded

shared lib "dw_mdm.dll" version 185 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3900

Tue Sep 15 19:07:19 2009

WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5418]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >MB1ES1018_SD2_00 <

DpShMCreate: sizeof(wp_adm) 19280 (1752)

DpShMCreate: sizeof(tm_adm) 5912704 (29416)

DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

DpShMCreate: sizeof(comm_adm) 552080 (1088)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (104)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1864)

DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000F0B0050, size: 6603504)

DpShMCreate: allocated sys_adm at 000000000F0B0050

DpShMCreate: allocated wp_adm at 000000000F0B21F0

DpShMCreate: allocated tm_adm_list at 000000000F0B6D40

DpShMCreate: allocated tm_adm at 000000000F0B6DA0

DpShMCreate: allocated wp_ca_adm at 000000000F65A620

DpShMCreate: allocated appc_ca_adm at 000000000F660420

DpShMCreate: allocated comm_adm at 000000000F662360

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 000000000F6E8FF0

DpShMCreate: allocated gw_adm at 000000000F6E9070

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000F6E90A0

DpShMCreate: allocated wall_adm at 000000000F6E90B0

MBUF state OFF

DpCommInitTable: init table for 500 entries

rdisp/queue_size_check_value : -> off

ThTaskStatus: rdisp/reset_online_during_debug 0

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 511 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

J2EE server info

start = TRUE

state = STARTED

pid = 17500

argv[0] = E:\usr\sap\SD2\DVEBMGS00\exe\jcontrol.EXE

argv[1] = E:\usr\sap\SD2\DVEBMGS00\exe\jcontrol.EXE

argv[2] = pf=E:\usr\sap\SD2\SYS\profile\SD2_DVEBMGS00_MB1ES1018

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=64999

argv[5] = -DSAPSYSTEM=00

argv[6] = -DSAPSYSTEMNAME=SD2

argv[7] = -DSAPMYNAME=MB1ES1018_SD2_00

argv[8] = -DSAPPROFILE=E:\usr\sap\SD2\SYS\profile\SD2_DVEBMGS00_MB1ES1018

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1692]

***LOG Q0K=> DpMsAttach, mscon ( MB1ES1018) [dpxxdisp.c 12429]

DpStartStopMsg: send start message (myname is >MB1ES1018_SD2_00 <)

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

CCMS: Checking Downtime Configuration of Monitoring Segment.

CCMS: start to initalize 3.X shared alert area (first segment).

DpJ2eeLogin: j2ee state = CONNECTED

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1050]

DpMsgAdmin: Set patchno for this platform to 185

Release check o.K.

-

dev_w0

-

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

-

*

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ

*

B

B Tue Sep 15 19:07:19 2009

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\SD2\DVEBMGS00\exe\dboraslib.dll' ...

B Library 'E:\usr\sap\SD2\DVEBMGS00\exe\dboraslib.dll' loaded

B Version of 'E:\usr\sap\SD2\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.167)

B New connection 0 created

M sysno 00

M sid SD2

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 185

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 12428

M

M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)

M length of sys_adm_ext is 576 bytes

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

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 19280 (1752)

M DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000110B0050, size: 6603504)

M DpShMCreate: allocated sys_adm at 00000000110B0050

M DpShMCreate: allocated wp_adm at 00000000110B21F0

M DpShMCreate: allocated tm_adm_list at 00000000110B6D40

M DpShMCreate: allocated tm_adm at 00000000110B6DA0

M DpShMCreate: allocated wp_ca_adm at 000000001165A620

M DpShMCreate: allocated appc_ca_adm at 0000000011660420

M DpShMCreate: allocated comm_adm at 0000000011662360

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 00000000116E8FF0

M DpShMCreate: allocated gw_adm at 00000000116E9070

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 00000000116E90A0

M DpShMCreate: allocated wall_adm at 00000000116E90B0

M rdisp/queue_size_check_value : -> off

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M ThInit: running on host MB1ES1018

M calling db_connect ...

C Prepending E:\usr\sap\SD2\DVEBMGS00\exe to Path.

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

C Connecting as /@SD2 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 000000000ADD90C0 000000000ADE12F0 000000000ADFDB18

C Attaching to DB Server SD2 (con_hdl=0,svchp=000000000ADFD9D8,srvhp=000000000ADFFE08)

-

Regards

Former Member · ‎09-16-2009

The output of the trace

-

Dump file h:\oracle\sd2\saptrace\usertrace\sd2_ora_6884.trc

Wed Sep 16 18:23:27 2009

ORACLE V10.2.0.2.0 - 64bit Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 8 - type 8664, 2 Physical Cores

Process Affinity : 0x0000000000000000

Memory (Avail/Total): Ph:28518M/32762M, Ph+PgF:110650M/133853M

Instance name: sd2

Redo thread mounted by this instance: 1

Oracle process number: 21

Windows thread id: 6884, image: ORACLE.EXE (SHAD)

opiino: Attach failed! error=-1 ifvp=0000000000000000*

Dump file h:\oracle\sd2\saptrace\usertrace\sd2_ora_6884.trc

Wed Sep 16 19:02:46 2009

ORACLE V10.2.0.2.0 - 64bit Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 8 - type 8664, 2 Physical Cores

Process Affinity : 0x0000000000000000

Memory (Avail/Total): Ph:29124M/32762M, Ph+PgF:114263M/133853M

Instance name: sd2

Redo thread mounted by this instance: 1

Oracle process number: 13

Windows thread id: 6884, image: ORACLE.EXE (SHAD)

SERVICE NAME:(SYS$USERS) 2009-09-16 19:02:46.367
SESSION ID:(85.3) 2009-09-16 19:02:46.367

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)*

tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)

-

LISTENER output*

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SD2.WORLD))

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 10.2.0.2.0 - Produ

ction

Start Date 16-SEP-2009 16:24:05

Uptime 0 days 2 hr. 40 min. 9 sec

Trace Level support

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File f:\oracle\SD2\102\network\admin\listener.ora

Listener Log File f:\oracle\SD2\102\network\log\listener.log

Listener Trace File f:\oracle\SD2\102\network\trace\listener.trc

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\SD2.WORLDipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\SD2ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MB1ES1018)(PORT=1527)))

Services Summary...

Service "SD2" has 1 instance(s).

Instance "SD2", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

-

SQL> select username, account_status from dba_users;

USERNAME ACCOUNT_STATUS

-

OPS$MB1ES1018\SAPSERVICESR3 OPEN

OPS$MB1ES1018\SD2ADM OPEN

OPS$MB1ES1018\SAPSERVICESD2 OPEN

SYS OPEN

SYSTEM OPEN

SAPSR3 OPEN

SAPSR3DB OPEN

OUTLN LOCKED

TSMSYS EXPIRED & LOCKED

DIP EXPIRED & LOCKED

DBSNMP EXPIRED & LOCKED

11 rows selected.

SQL> conn SAPSR3/sap@SD2

ERROR:

ORA-03113: end-of-file on communication channel

-

SQL> conn /@SD2 hangs

Is there something to do with the user *OPS$MB1ES1018\SD2ADM *. I have changed its password to windows login of sd2adm and also to sap, but no luck..

Any help would be appreciated.

Regards

Former Member · ‎09-15-2009

We had this a couple of times, when the listener forked a second process. You might want to restart the listener to check that.

Regards, Michael

markus_doehr2 · ‎09-15-2009

Check if the database is in quiesce mode (e. g. if you installed/configured enterprise manager) using

sqplus / as sysdba
select * from v$instance;

Markus

anindya_bose · ‎09-15-2009

From OS level check "oraarch" directory.

Is that directory full? if yes, then make some space there.

connect /@SID hangs

Accepted Solutions (1)

Accepted Solutions (1)

Answers (3)

Answers (3)

Re: Query does not work in Procurement Price Speci...

Re: Integrate an external task system to Cloud ALM...

Re: error during install SAP S/4HANA Server 2022

Re: Mass Update Zfield in Std Table with Split & J...

Re: Unable to connect to Datasphere using the CLI