on 06-14-2014 7:48 AM
Please find below my dev_w0 log
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Fri Jun 13 23:52:39 2014
B create_con (con_name=R/3)
B Loading DB library 'F:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'F:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'F:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.144)
B New connection 0 created
M sysno 00
M sid PRD
M systemid 562 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 144
M intno 20050900
M make: multithreaded, Unicode, 64 bit, optimized
M pid 1180
M
M kernel runs with dp version 232000(ext=109000) (@(#) DPLIB-INT-VERSION-232000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 1180) [dpxxdisp.c 1305]
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) 25168 (1480)
M DpShMCreate: sizeof(tm_adm) 5652128 (28120)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (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: 000000000ED60050, size: 6348592)
M DpShMCreate: allocated sys_adm at 000000000ED60050
M DpShMCreate: allocated wp_adm at 000000000ED62150
M DpShMCreate: allocated tm_adm_list at 000000000ED683A0
M DpShMCreate: allocated tm_adm at 000000000ED68400
M DpShMCreate: allocated wp_ca_adm at 000000000F2CC2A0
M DpShMCreate: allocated appc_ca_adm at 000000000F2D2060
M DpShMCreate: allocated comm_adm at 000000000F2D3FA0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 000000000F35AC30
M DpShMCreate: allocated gw_adm at 000000000F35ACB0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 000000000F35ACE0
M DpShMCreate: allocated wall_adm at 000000000F35ACF0
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
M Fri Jun 13 23:52:40 2014
M ThInit: running on host sapserverprd
M
M Fri Jun 13 23:52:41 2014
M calling db_connect ...
C Prepending F:\usr\sap\PRD\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 /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 0000000012D6C0C0 0000000012D742F0 0000000012D90B18
C Attaching to DB Server PRD (con_hdl=0,svchp=0000000012D909D8,srvhp=0000000012D92E08)
C Starting user session (con_hdl=0,svchp=0000000012D909D8,srvhp=0000000012D92E08,usrhp=0000000012D74B08)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=0000000012D909D8,srvhp=0000000012D92E08)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11044]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 0000000012D6C0C0 0000000012D742F0 0000000012D90B18
C Attaching to DB Server PRD (con_hdl=0,svchp=0000000012D909D8,srvhp=0000000012D92E08)
C Starting user session (con_hdl=0,svchp=0000000012D909D8,srvhp=0000000012D92E08,usrhp=0000000012D74B08)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=0000000012D909D8,srvhp=0000000012D92E08)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11044]
B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 1199] [dbsh 1199 ]
B ***LOG BY2=> sql error 1033 performing CON [dblink#5 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#5 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1440]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10468]
M
M Info for wp 0
M
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source =
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 0
M control_flag = 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 attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server sapserverprd_PRD_00 on host sapserverprd (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Fri Jun 13 23:52:41 2014
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10688
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 724]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
M Entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 1180) [dpnttool.c 327]
_________________________________________________________________________
when i try to start DATABASE it is showing error:
please suggest me a solution with your experience
Thanks.
Hi,
Execute "alter database end backup" then "alter database open"
Try to start SAP after that.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Was there a backup in progress and the system was shutdown ?
Check whether there are files in backup mode.
select * from v$backup;
If there is/are, then remove the backup flag.
alter database end backup;
Open the database.
alter database open;
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Possible reason for the ORA-1113 is occuring because the database was shutdown during the
online backup. This situation lead to the fact, that some tablespace are in "BACKUP MODE".
Please reed this note to solve the issue:
#4162 - Missing "end backup"
Regards, Gabriella Kiss
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.