DB error

[Former Member]

Hi Gurus ,

I now installing R/3 4.7 64 bit With Oracle 64 bit , During installation i got the below mentioned error in bold letters .

ERROR 2008-12-24 21:14:44

FRF-00025 Unable to call function. Error message: DB error: SQL error 3106 occurred .

Kindly tell me the solution for this problem .

Regards

Selvan

[Former Member · Accepted solution]

Hi mahesh ,

here below dev_w0

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Fri Dec 26 14:23:53 2008

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' ...

B Library 'E:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' loaded

B Version of 'E:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.101)

B New connection 0 created

M sysno 00

M sid DEV

M systemid 562 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 80

M intno 20020600

M make: multithreaded, ASCII, 64 bit

M pid 3924

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M

M Fri Dec 26 14:23:54 2008

M DpShMCreate: sizeof(wp_adm) 6624 (828)

M DpShMCreate: sizeof(tm_adm) 3021432 (15032)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 212000 (424)

M DpShMCreate: sizeof(vmc_adm) 0 (448)

M DpShMCreate: sizeof(wall_adm) (22440/36712/56/104)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000010620050, size: 3329520)

M DpShMCreate: allocated sys_adm at 0000000010620050

M DpShMCreate: allocated wp_adm at 0000000010621850

M DpShMCreate: allocated tm_adm_list at 0000000010623230

M DpShMCreate: allocated tm_adm at 0000000010623258

M DpShMCreate: allocated wp_ca_adm at 0000000010904CD0

M DpShMCreate: allocated appc_ca_adm at 0000000010909320

M DpShMCreate: allocated comm_adm_list at 000000001090AA90

M DpShMCreate: allocated comm_adm at 000000001090AAA8

M DpShMCreate: allocated vmc_adm_list at 000000001093E6C8

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000001093E6F0

M DpShMCreate: allocated wall_adm at 000000001093E6F8

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M calling db_connect ...

C Prepending D:\oracle\DEV\102 to Path.

C got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 640 310805)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 00000000135050B0 0000000009BD53B0 0000000009BD84F8

C Attaching to DB Server DEV (con_hdl=0,svchp=0000000009BD83B8,svrhp=0000000013515108)

C

C Fri Dec 26 14:23:56 2008

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

[dboci.c 4166]

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

[dbsloci.c 10555]

C Try to connect with default password

C Connecting as SAPDEV/<pwd>@DEV on connection 0 (nls_hdl 0) ... (dbsl 640 310805)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 00000000135050B0 0000000009BD53B0 0000000009BD84F8

C Detaching from DB Server (con_hdl=0,svchp=0000000009BD83B8,srvhp=0000000013515108)

C Attaching to DB Server DEV (con_hdl=0,svchp=0000000009BD83B8,svrhp=0000000013515108)

C

C Fri Dec 26 14:23:57 2008

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

[dboci.c 4166]

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

[dbsloci.c 10555]

B ***LOG BY2=> sql error 12541 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh#2 @ 1200] [dbsh 1200 ]

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

B ***LOG BY0=> ORA-12541: TNS:no listener [dblink#2 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M

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

M *

M * LOCATION SAP-Server eccdev_DEV_00 on host eccdev (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Fri Dec 26 14:23:57 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9672

M * COUNTER 1

M *

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

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

Regards

Palani Selvan

[stefan_koehler · Accepted solution]

Hello Selvan,

> B ***LOG BY2=> sql error 12541 performing CON dbsh#2 @ 1200 dbsh 1200

> B ***LOG BY0=> ORA-12541: TNS:no listener dbsh#2 @ 1200 dbsh 1200

Now you get an ORA-error (ORA-12541) before. Please start your oracle listener via windows services.

Regards

Stefan

[Former Member]

Hi Stefan

I start the listener service , Now its working fine .

Regards

Selvan

[stefan_koehler]

Hello Selvan,

unfortunately you don't tell us your oracle version.

Normally an ORA-03106 (http://ora-03106.ora-code.com/) is caused by a bug. If you search in service market place you will also find some patches, but we we need the exact oracle version to point you to the right one.

Regards

Stefan

[Former Member]

Hi George ,

Thanks , i restart the serevr and continue the installation now installation started . But i got another error . Below mentioned .

RROR 2008-12-26 13:42:46

FRF-00063 RFC logon failed with message: Failed: SAP_CMINIT3 : rc=20 > Connect to SAP gateway failedConnect_PM GWHOST=eccdev, GWSERV=sapgw00, ASHOST=eccdev, SYSNR=00

I check the SAP MMC , The disp+work.exe stopped

So i here below the error log file for your referenvce , Kindly give me the solution .

-

---

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

-

---

Fri Dec 26 13:57:08 2008

kernel runs with dp version 129(ext=102) (@(#) DPLIB-INT-VERSION-129)

length of sys_adm_ext is 312 bytes

sysno 00

sid DEV

systemid 562 (PC with Windows NT)

relno 6400

patchlevel 0

patchno 80

intno 20020600

make: multithreaded, ASCII, 64 bit

pid 2788

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

shared lib "dw_xml.dll" version 80 successfully loaded

shared lib "dw_xtc.dll" version 80 successfully loaded

shared lib "dw_stl.dll" version 80 successfully loaded

shared lib "dw_gui.dll" version 80 successfully loaded

Fri Dec 26 13:57:13 2008

• 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 3884]

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpShMCreate: sizeof(wp_adm) 6624 (828)

DpShMCreate: sizeof(tm_adm) 3021432 (15032)

DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

DpShMCreate: sizeof(comm_adm) 212000 (424)

DpShMCreate: sizeof(vmc_adm) 0 (448)

DpShMCreate: sizeof(wall_adm) (22440/36712/56/104)

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000DDF0050, size: 3329520)

DpShMCreate: allocated sys_adm at 000000000DDF0050

DpShMCreate: allocated wp_adm at 000000000DDF1850

DpShMCreate: allocated tm_adm_list at 000000000DDF3230

DpShMCreate: allocated tm_adm at 000000000DDF3258

DpShMCreate: allocated wp_ca_adm at 000000000E0D4CD0

DpShMCreate: allocated appc_ca_adm at 000000000E0D9320

DpShMCreate: allocated comm_adm_list at 000000000E0DAA90

DpShMCreate: allocated comm_adm at 000000000E0DAAA8

DpShMCreate: allocated vmc_adm_list at 000000000E10E6C8

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000E10E6F0

DpShMCreate: allocated wall_adm at 000000000E10E6F8

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

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

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

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 1228 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG Q0K=> DpMsAttach, mscon ( eccdev) [dpxxdisp.c 9813]

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

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

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

DpMsgAdmin: Set release to 6400, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 80

Release check o.K.

Fri Dec 26 13:57:53 2008

• ERROR => W0 (pid 2912) died [dpxxdisp.c 12264]

• ERROR => W1 (pid 2168) died [dpxxdisp.c 12264]

my types changed after wp death/restart 0xbf --> 0xbe

• ERROR => W2 (pid 3308) died [dpxxdisp.c 12264]

my types changed after wp death/restart 0xbe --> 0xbc

• ERROR => W3 (pid 1996) died [dpxxdisp.c 12264]

my types changed after wp death/restart 0xbc --> 0xb8

• ERROR => W4 (pid 492) died [dpxxdisp.c 12264]

• ERROR => W5 (pid 2604) died [dpxxdisp.c 12264]

my types changed after wp death/restart 0xb8 --> 0xb0

• ERROR => W6 (pid 264) died [dpxxdisp.c 12264]

my types changed after wp death/restart 0xb0 --> 0xa0

• ERROR => W7 (pid 1060) died [dpxxdisp.c 12264]

my types changed after wp death/restart 0xa0 --> 0x80

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

killing W0-2912 (SIGUSR2)

• ERROR => DpWpKill(2912, SIGUSR2) failed [dpxxtool.c 2477]

killing W1-2168 (SIGUSR2)

• ERROR => DpWpKill(2168, SIGUSR2) failed [dpxxtool.c 2477]

killing W2-3308 (SIGUSR2)

• ERROR => DpWpKill(3308, SIGUSR2) failed [dpxxtool.c 2477]

killing W3-1996 (SIGUSR2)

• ERROR => DpWpKill(1996, SIGUSR2) failed [dpxxtool.c 2477]

killing W4-492 (SIGUSR2)

• ERROR => DpWpKill(492, SIGUSR2) failed [dpxxtool.c 2477]

killing W5-2604 (SIGUSR2)

• ERROR => DpWpKill(2604, SIGUSR2) failed [dpxxtool.c 2477]

killing W6-264 (SIGUSR2)

• ERROR => DpWpKill(264, SIGUSR2) failed [dpxxtool.c 2477]

killing W7-1060 (SIGUSR2)

• ERROR => DpWpKill(1060, SIGUSR2) failed [dpxxtool.c 2477]

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=1301

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri Dec 26 13:58:03 2008

NiISelect: TIMEOUT occured (10000 ms)

dump system status

Workprocess Table (long) Fri Dec 26 08:28:03 2008

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

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

-

---

0 DIA 2912 Ended no 1 0 0

1 DIA 2168 Ended no 1 0 0

2 UPD 3308 Ended no 1 0 0

3 ENQ 1996 Ended no 1 0 0

4 BTC 492 Ended no 1 0 0

5 BTC 2604 Ended no 1 0 0

6 SPO 264 Ended no 1 0 0

7 UP2 1060 Ended no 1 0 0

Dispatcher Queue Statistics Fri Dec 26 08:28:03 2008

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

--------

---

+

---

+

---

+

---

+--

---

+

Typ

now

high

max

writes

reads

--------

---

+

---

+

---

+

---

+--

---

+

NOWP

0

3

2000

10

10

--------

---

+

---

+

---

+

---

+--

---

+

DIA

5

5

2000

5

0

--------

---

+

---

+

---

+

---

+--

---

+

UPD

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

ENQ

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

BTC

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

SPO

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

UP2

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

max_rq_id 13

wake_evt_udp_now 0

wake events total 9, udp 8 ( 88%), shm 1 ( 11%)

since last update total 9, udp 8 ( 88%), shm 1 ( 11%)

Dump of tm_adm structure: Fri Dec 26 08:28:03 2008

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

Term uid man user term lastop mod wp ta a/i (modes)

Workprocess Comm. Area Blocks Fri Dec 26 08:28:03 2008

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

Slots: 300, Used: 1, Max: 0

--------

---

+

---

+--

---

+

id

owner

pid

eyecatcher

--------

---

+

---

+--

---

+

0

DISPATCHER

-1

WPCAAD000

NiWait: sleep (5000 msecs) ...

NiISelect: timeout 5000 ms

NiISelect: maximum fd=1301

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri Dec 26 13:58:08 2008

NiISelect: TIMEOUT occured (5000 ms)

Shutdown server ...

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes...

Stop gateway

killing process (696) (SOFT_KILL)

Stop icman

killing process (3204) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives (PID:696 HANDLE:1276)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1301

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri Dec 26 13:58:09 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:696 HANDLE:1276)

[DpProcDied] Process died (PID:3204 HANDLE:1284)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

NiIMyHostName: hostname = 'eccdev'

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 163 bytes

NiBufSend starting

NiIWrite: write 562, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

detach from message server

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

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiSelClear: removed hdl 3 from selectset

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/8

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 19)

MBUF component DOWN

NiBufClose: clear extensions for hdl 3

NiBufSetStat: bufstat of hdl 3 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 3 / socket 1236

MsIDetach: detach MS-system

EsCleanup ....

***LOG Q05=> DpHalt, DPStop ( 2788) [dpxxdisp.c 8541]

Good Bye .....

Regards

Selavn .SP

[Former Member]

HI,

Can you paste the dev_w0 logs..

Mahesh

[Former Member]

Hi Selven ,

Please post last 25 lines of the error message

this is not sufficient and also tell us current phase of the installation

I also reccommend to restart the server and restart the installation

cheers

George