Skip to Content
author's profile photo Former Member
Former Member

ORA-00604: error occurred at recursive SQL level 1

Dear Friends,

I am facing the following SQL error.I am attaching the log of that error.Please suggest me .

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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Mon Apr 18 12:54:22 2011

B create_con (con_name=R/3)

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

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

B Version of 'D:\usr\sap\DR0\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.337)

B New connection 0 created

M sysno 00

M sid DR0

M systemid 562 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 347

M intno 20020600

M make: multithreaded, ASCII, 64 bit

M pid 3428

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 12688 (976)

M DpShMCreate: sizeof(tm_adm) 3267456 (16256)

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: 000000000C040050, size: 3581664)

M DpShMCreate: allocated sys_adm at 000000000C040050

M DpShMCreate: allocated wp_adm at 000000000C041880

M DpShMCreate: allocated tm_adm_list at 000000000C044A10

M DpShMCreate: allocated tm_adm at 000000000C044A38

M DpShMCreate: allocated wp_ca_adm at 000000000C3625B8

M DpShMCreate: allocated appc_ca_adm at 000000000C366C08

M DpShMCreate: allocated comm_adm_list at 000000000C368378

M DpShMCreate: allocated comm_adm at 000000000C368390

M DpShMCreate: allocated vmc_adm_list at 000000000C39BFB0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000C39BFD8

M DpShMCreate: allocated wall_adm at 000000000C39BFE8

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X

X Mon Apr 18 12:54:23 2011

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M tskh_init: rdisp/cleanup_after_crash = 1

M calling db_connect ...

C Prepending D:\oracle\DR1\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 SAPDR0's password

C Connecting as /@DR0 on connection 0 (nls_hdl 0) ... (dbsl 640 210610)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 0000000005D79C30 0000000005D81E60 0000000005D83668

C Attaching to DB Server DR0 (con_hdl=0,svchp=0000000005D83528,srvhp=0000000005D83DE8)

C Starting user session (con_hdl=0,svchp=0000000005D83528,srvhp=0000000005D83DE8,usrhp=0000000005D82678)

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

[dboci.c 4481]

C Detaching from DB Server (con_hdl=0,svchp=0000000005D83528,srvhp=0000000005D83DE8)

C *** ERROR => CONNECT failed with sql error 604.

[dbsloci.c 11479]

C Try to connect with default password

C Connecting as SAPDR0/<pwd>@DR0 on connection 0 (nls_hdl 0) ... (dbsl 640 210610)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 0000000005D79C30 0000000005D81E60 0000000005D83668

C Attaching to DB Server DR0 (con_hdl=0,svchp=0000000005D83528,srvhp=0000000005D83DE8)

C

C Mon Apr 18 12:54:24 2011

C Starting user session (con_hdl=0,svchp=0000000005D83528,srvhp=0000000005D83DE8,usrhp=0000000005D82678)

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

[dboci.c 4481]

C Detaching from DB Server (con_hdl=0,svchp=0000000005D83528,srvhp=0000000005D83DE8)

C *** ERROR => CONNECT failed with sql error 604.

[dbsloci.c 11479]

B ***LOG BY2=> sql error 604 performing CON [dbsh#4 @ 1208] [dbsh 1208 ]

B ***LOG BY0=> ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 2 cannot be read at this time

ORA-01110: data file 2: 'E:\ORACLE\DR0\SAPDATA2\UNDO_1\UNDO.DATA1' [dbsh#4 @ 1208] [dbsh 1208 ]

B ***LOG BY2=> sql error 604 performing CON [dblink#6 @ 430] [dblink 0430 ]

B ***LOG BY0=> ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 2 cannot be read at this time

ORA-01110: data file 2: 'E:\ORACLE\DR0\SAPDATA2\UNDO_1\UNDO.DATA1' [dblink#6 @ 430] [dblink 0430 ]

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

M in_ThErrHandle: 1

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

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 saxo_DR0_00 on host saxo (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Mon Apr 18 12:54:24 2011

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9993

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 735]

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

-


Adya

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Apr 19, 2011 at 05:06 AM

    Hi,

    This is your error, You need to recover this file E:\ORACLE\DR0\SAPDATA2\UNDO_1\UNDO.DATA1

    ERROR => CONNECT failed with sql error 604. [dbsloci.c 11479] B ***LOG BY2=> sql error 604 performing CON [dbsh#4 @ 1208] [dbsh 1208 ] B ***LOG BY0=> ORA-00604: error occurred at recursive SQL level 1 ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: 'E:\ORACLE\DR0\SAPDATA2\UNDO_1\UNDO.DATA1'

    Read this thread

    recover database

    Thanks

    Siva

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.