on 04-18-2011 11:08 PM
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
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
Thanks
Siva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.