increased oracle activity

Hi Friends,

I have installed IDES abap stack on oracle and I noticed a strange behevior of oracle when starting transaction RSA1.

When I start Administrator workbench or anything else reagrding BI the oracle process in the task manager is increasing up to 69%.

Normaly it is 5% or less.

And the status of the dispatcher process in the Sap console is getting yellow, means it is restarting.

Can some body explain this behavior?

Thanks Jimbob.

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

Hello,

my guess is that you have a SQL statements with a very high ressource consumption here that finally slows down the system so much that the dispatcher is no longer able to do his work (iterating on his queues) on time so that the MMC turns yellow.

It would be helpful if you could capture the Oracle ressource consumption by creating for example an ASH report for the time the problem occured (see note #853576 regarding this).

But at any case, make sure that the Oracle parameters are properly adjusted for BI before (use the check script from note #1171650 for this).

Best Regards,

Michael

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

> I have installed IDES abap stack on oracle and I noticed a strange behevior of oracle when starting transaction RSA1.

> When I start Administrator workbench or anything else reagrding BI the oracle process in the task manager is increasing up to

69%.

Yes - because the database is working on your request.

> Normaly it is 5% or less.

> And the status of the dispatcher process in the Sap console is getting yellow, means it is restarting.

Does it?

Check dev_disp and dev_w0

What Oracle version (and patchlevel) are you running? What IDES are you running?

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Markus,

the Oracle version is 10.2.0 patch level 4.

OS is windows 2003 standard rs2 sp2 and ides is erp ehp4.

I noticed now the increased CPU usage is when I login to the system.

And the dispatcher process shows "running but bad dialog time"

RG. Jimbob

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

sysno 05

sid S04

systemid 562 (PC with Windows NT)

relno 7010

patchlevel 0

patchno 32

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 3508

Thu Oct 08 14:35:13 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 (05 3508) [dpxxdisp.c 1286]

shared lib "dw_xml.dll" version 32 successfully loaded

shared lib "dw_xtc.dll" version 32 successfully loaded

shared lib "dw_stl.dll" version 32 successfully loaded

shared lib "dw_gui.dll" version 32 successfully loaded

shared lib "dw_mdm.dll" version 32 successfully loaded

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

use internal message server connection to port 3905

Thu Oct 08 14:35:18 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 5529]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: start server >compi2_S04_05 <

DpShMCreate: sizeof(wp_adm) 29792 (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: 000000000B2B0050, size: 6614144)

DpShMCreate: allocated sys_adm at 000000000B2B0050

DpShMCreate: allocated wp_adm at 000000000B2B2270

DpShMCreate: allocated tm_adm_list at 000000000B2B96D0

DpShMCreate: allocated tm_adm at 000000000B2B9730

DpShMCreate: allocated wp_ca_adm at 000000000B85CFB0

DpShMCreate: allocated appc_ca_adm at 000000000B862DB0

DpShMCreate: allocated comm_adm at 000000000B864CF0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 000000000B8EB980

DpShMCreate: allocated gw_adm at 000000000B8EBA00

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000B8EBA30

DpShMCreate: allocated wall_adm at 000000000B8EBA40

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.

<ES> Info: em/initial_size_MB( 24567MB) not multiple of em/blocksize_KB( 4096KB)

<ES> Info: em/initial_size_MB rounded up to 24568MB

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 6141 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

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

***LOG Q0K=> DpMsAttach, mscon ( compi2) [dpxxdisp.c 12483]

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

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

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

DpMsgAdmin: Set release to 7010, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 32

Release check o.K.

Thu Oct 08 14:35:19 2009

MBUF state ACTIVE

Thu Oct 08 14:35:20 2009

DpModState: change server state from STARTING to ACTIVE

Thu Oct 08 14:36:40 2009

WARNING => DpRqServiceQueue: timeout of HIGH PRIO msg, return DP_CANT_HANDLE_REQ

Thu Oct 08 14:38:02 2009

WARNING => DpRqServiceQueue: timeout of HIGH PRIO msg, return DP_CANT_HANDLE_REQ

Thu Oct 08 14:38:37 2009

WARNING => DpRqServiceQueue: timeout of HIGH PRIO msg, return DP_CANT_HANDLE_REQ

Thu Oct 08 14:38:45 2009

WARNING => DpRqServiceQueue: timeout of HIGH PRIO msg, return DP_CANT_HANDLE_REQ
WARNING => DpRqServiceQueue: timeout of HIGH PRIO msg, return DP_CANT_HANDLE_REQ

> the Oracle version is 10.2.0 patch level 4.

Ok. So you run 10.2.0.4. did you also apply the latest minipatch?

> And the dispatcher process shows "running but bad dialog time"

What are your hardware specs? You have enough memory? Is this a 32bit system?

Markus

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

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ

B Thu Oct 08 14:35:18 2009

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\S04\DVEBMGS05\exe\dboraslib.dll' ...

B Library 'C:\usr\sap\S04\DVEBMGS05\exe\dboraslib.dll' loaded

B Version of 'C:\usr\sap\S04\DVEBMGS05\exe\dboraslib.dll' is "700.08", patchlevel (0.25)

B New connection 0 created

M sysno 05

M sid S04

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 32

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 7684

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 7684) [dpxxdisp.c 1348]

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) 29792 (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: 000000000B2B0050, size: 6614144)

M DpShMCreate: allocated sys_adm at 000000000B2B0050

M DpShMCreate: allocated wp_adm at 000000000B2B2270

M DpShMCreate: allocated tm_adm_list at 000000000B2B96D0

M DpShMCreate: allocated tm_adm at 000000000B2B9730

M DpShMCreate: allocated wp_ca_adm at 000000000B85CFB0

M DpShMCreate: allocated appc_ca_adm at 000000000B862DB0

M DpShMCreate: allocated comm_adm at 000000000B864CF0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000B8EB980

M DpShMCreate: allocated gw_adm at 000000000B8EBA00

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000B8EBA30

M DpShMCreate: allocated wall_adm at 000000000B8EBA40

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.

M ThInit: running on host compi2

M calling db_connect ...

C Prepending C:\usr\sap\S04\DVEBMGS05\exe to Path.

C Oracle Client Version: '10.2.0.4.0'

C Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'

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

C Connecting as /@D04 on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 0 000000000CFAA8C0 00000000024BF1C0 0000000002D482A8

C Attaching to DB Server D04 (con_hdl=0,svchp=0000000002D48168,srvhp=000000000CFB2918)

C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000002D48168, srvhp=000000000CFB2918, usrhp=0000000002E96790)

C CbApplInfoGet() failed! Ignore, but uninstall callback to avoid more erroneous calls

C Now '/@D04' is connected: con_hdl=0, nls_hdl=0, session_id=36.

C Got SAPSR4's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=0000000002D48168,usrhp=0000000002E96790)

C Now I'm disconnected from ORACLE

C Connecting as SAPSR4/<pwd>@D04 on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 0 000000000CFAA8C0 00000000024BF1C0 0000000002D482A8

C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR4/<pwd>, svchp=0000000002D48168, srvhp=000000000CFB2918, usrhp=0000000002E96790)

C Now 'SAPSR4/<pwd>@D04' is connected: con_hdl=0, nls_hdl=0, session_id=36.

C Database NLS settings: AMERICAN_AMERICA.UTF8

C DB instance D04 is running on COMPI2 with ORACLE version 10.2.0.4.0 since OCT 08, 2009, 11:11:54

B Connection 0 opened (DBSL handle 0)

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

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20091008 143518 COMPI2

C build_stmt: reallocating stmt buffer: 256 -> 2000 characters

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif,.swc,.swf

08 143828 COMPI2

I Thu Oct 08 14:35:19 2009

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0000000010090050, size: 4400000)

M SHM_ROLL_AREA (addr: 000007FFDDA80050, size: 268435456)

M SHM_PAGING_AREA (addr: 00000000104D0050, size: 134217728)

M SHM_ROLL_ADM (addr: 000000000FC40050, size: 2678942)

M SHM_PAGING_ADM (addr: 000000000FED0050, size: 525344)

M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 000000000FF60050

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12176 bytes (50 server) at 000000000FFF0050

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X ES initialized.

B dbntab: NTAB buffers attached

B dbntab: Buffer FTAB(hash header) (addr: 00000000185700E0, size: 584)

B dbntab: Buffer FTAB(anchor array) (addr: 0000000018570330, size: 320072)

B dbntab: Buffer FTAB(item array) (addr: 00000000185BE580, size: 1280000)

B dbntab: Buffer FTAB(data area) (addr: 00000000186F6D80, size: 30720000)

B dbntab: Buffer IREC(hash header) (addr: 000000001A4500E0, size: 584)

B dbntab: Buffer IREC(anchor array) (addr: 000000001A450330, size: 320072)

B dbntab: Buffer IREC(item array) (addr: 000000001A49E580, size: 320000)

B dbntab: Buffer IREC(data area) (addr: 000000001A4EC780, size: 6144000)

B dbntab: Buffer STAB(hash header) (addr: 000000001AAD00E0, size: 584)

B dbntab: Buffer STAB(anchor array) (addr: 000000001AAD0330, size: 320072)

B dbntab: Buffer STAB(item array) (addr: 000000001AB1E580, size: 320000)

B dbntab: Buffer STAB(data area) (addr: 000000001AB6C780, size: 3072000)

B dbntab: Buffer TTAB(hash header) (addr: 000000001AE600E0, size: 2360)

B dbntab: Buffer TTAB(anchor array) (addr: 000000001AE60A20, size: 320072)

B dbntab: Buffer TTAB(item array) (addr: 000000001AEAEC70, size: 800000)

B dbntab: Buffer TTAB(data area) (addr: 000000001AF72170, size: 5840000)

B db_con_shm_ini: WP_ID = 0, WP_CNT = 17, CON_ID = -1

B dbstat: TABSTAT buffer attached (addr: 000000001B51D0B0)

B dbtbxbuf: Buffer TABL (addr: 000000001E450160, size: 30000000, end: 00000000200EC4E0)

B dbtbxbuf: Buffer TABLP (addr: 00000000200F0160, size: 10240000, end: 0000000020AB4160)

B dbexpbuf: Buffer EIBUF (addr: 0000000020AD0170, size: 4194304, end: 0000000020ED0170)

B dbexpbuf: Buffer ESM (addr: 0000000020EE0170, size: 4194304, end: 00000000212E0170)

B dbexpbuf: Buffer CUA (addr: 00000000212F0170, size: 3072000, end: 00000000215DE170)

B dbexpbuf: Buffer OTR (addr: 00000000215E0170, size: 4194304, end: 00000000219E0170)

B dbcalbuf: Buffer CALE (addr: 00000000219F0050, size: 500000, end: 0000000021A6A170)

M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

S *** init spool environment

S TSPEVJOB updates inside critical section: event_update_nocsec = 0

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 000000000D0E08B0

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 000000002AD000D0

S doing lock recovery

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at 000000002AD00610

S using messages for server info

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

S size of open spool request entry: 2272 bytes

S immediate print option for implicitely closed spool requests is disabled

A **GENER Trace switched on ***

A ~~-PXA~~--

A PXA INITIALIZATION

A PXA: Locked PXA-Semaphore.

A System page size: 4kb, total admin_size: 20832kb, dir_size: 20764kb.

A Attached to PXA (address 000007FFEDAB0050, size 300000K)

A abap/pxa = shared protect gen_remote

A PXA INITIALIZATION FINISHED

A ~~-PXA~~--

A ABAP ShmAdm attached (addr=000007FF35EC1000 leng=20955136 end=000007FF372BD000)

A >> Shm MMADM area (addr=000007FF36369F00 leng=247168 end=000007FF363A6480)

A >> Shm MMDAT area (addr=000007FF363A7000 leng=15818752 end=000007FF372BD000)

A RFC Destination> destination compi2_S04_05 host compi2 system S04 systnr 5 (compi2_S04_05)

A RFC Options> H=compi2,S=05,d=2,

A RFC FRFC> fallback activ but this is not a central instance.

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: 2

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

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

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

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 35354 bytes at 000000002AEA0050

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

N === SSF INITIALIZATION:

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

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

N ===...SSF library is C:\usr\sap\S04\DVEBMGS05\exe\sapsecu.dll .

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

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

N ===...completed with return code 5.

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

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

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

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

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 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 = STD / <none>:-,

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

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

W ITS Plugin: Path dw_gui

W ITS Plugin: Description ITS Plugin - ITS rendering DLL

W ITS Plugin: sizeof(SAP_UC) 2

W ITS Plugin: Release: 701, [7010.0.32.20020600]

W ITS Plugin: Int.version, [33]

W ITS Plugin: Feature set: [20]

W ===... Calling itsp_Init in external dll ===>

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

N VSI: WP init in ABAP VM completed with rc=0

E Replication is disabled

E EnqCcInitialize: local lock table initialization o.k.

E EnqId_SuppressIpc: local EnqId initialization o.k.

E EnqCcInitialize: local enqueue client init o.k.

A Thu Oct 08 14:35:20 2009

A **GENER Trace switched off ***

S found spool memory service RSPO-ACTIONS at 000000002AD0A350

M SosICreateNewAnchorArray: sos_search_anchor_semantics = 1

C build_stmt: reallocating stmt buffer: 2000 -> 3002 characters

M Thu Oct 08 14:35:25 2009

M SecAudit(RsauShmInit): WP attached to existing shared memory.

M SecAudit(RsauShmInit): addr of SCSA........... = 0000000002F70050

M SecAudit(RsauShmInit): addr of RSAUSHM........ = 0000000002F707C0

M SecAudit(RsauShmInit): addr of RSAUSLOTINFO... = 0000000002F70800

M SecAudit(RsauShmInit): addr of RSAUSLOTS...... = 0000000002F7080C

B Thu Oct 08 14:35:41 2009

B dbmyclu : info : my major identification is 3232236133, minor one 5.

B dbmyclu : info : Time Reference is 1.12.2001 00:00:00h GMT.

B dbmyclu : info : my initial uuid is DEB40711386D72F19AF80019996A0A95.

B dbmyclu : info : current optimistic cluster level: 0

B dbmyclu : info : pessimistic reads set to 2.

H Thu Oct 08 14:38:27 2009

H *** ERROR => HTTP> ThPlgGetInbuf: failed (10) [abhttpio.c 10152]

{7907B4DE-2961-F138-9AF8-0019996A0A95}

[icftrace.c 398]

B 188 seconds passed since last buffsync

B Thu Oct 08 14:38:28 2009

B create_con (con_name=R/3*WEBFLOWTRACE)

B New connection 1 created

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

C Connecting as /@D04 on connection 1 (nls_hdl 0) ... (dbsl 700 151208)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 0 000000000CFAA8C0 00000000024BF1C0 0000000002D482A8

C Starting user session: OCISessionBegin(con_hdl=1, usr='/',svchp=000000002B0883C8, srvhp=000000000CFB2918, usrhp=000000002B1E5EB0)

C Now '/@D04' is connected: con_hdl=1, nls_hdl=0, session_id=57.

C Got SAPSR4's password from OPS$-user

C Disconnecting from connection 1 ...

C Closing user session (con_hdl=1,svchp=000000002B0883C8,usrhp=000000002B1E5EB0)

C Now I'm disconnected from ORACLE

C Connecting as SAPSR4/<pwd>@D04 on connection 1 (nls_hdl 0) ... (dbsl 700 151208)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 0 000000000CFAA8C0 00000000024BF1C0 0000000002D482A8

C Starting user session: OCISessionBegin(con_hdl=1, usr=SAPSR4/<pwd>, svchp=000000002B0883C8, srvhp=000000000CFB2918, usrhp=000000002B1E5EB0)

C Now 'SAPSR4/<pwd>@D04' is connected: con_hdl=1, nls_hdl=0, session_id=57.

C DB instance D04 is running on COMPI2 with ORACLE version 10.2.0.4.0 since OCT 08, 2009, 11:11:54

B Connection 1 opened (DBSL handle 1)

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

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20091008 143518 COMPI2

B 000 001 R/3*WEBFLOWTRACE 000000001 ACTIVE NO NO NO 004 255 255 200910

Thanks Markus,

Hardware is 2 intel xeon 2.1, 24gb ram, 64 bit windows.

I'm not very sure about the mini patch, I found 1 like this OPatch_10204_Generic_v5.zip and two like 10204_Patch20_MSWIN-x86-64.zip and 10204_Patch22_MSWIN-x86-64.zip. Is it one of them I have to install?

RG. Jimbob

you need to install OPatch_10204_Generic_v5.zip first,

then, install 10204_Patch22_MSWIN-x86-64.zip

docs should be included in the zip files.

Thanks Eric, I applied the patch but still thr same.

Any other suggestions?

RG. Jimbob

This might not help, But I see that you are using a kernel in version 7,01 but still are using a DB library of 7.00:

C:\usr\sap\S04\DVEBMGS05\exe\dboraslib.dll' is "700.08", patchlevel (0.25)

go get sapEXEDB*.SAR in the 7.01 version sectoin in SAPNET. See if that helps.

Ask a Question

Top Q&A Solution Author

User

Count