on 09-29-2008 12:49 PM
Hi Experts,
I have restore the offline backup on to a new hardware. MMC is not coming up. Please go through the log and help me to resolve this issue.
-
trc file: "dev_w4", trc level: 1, release: "700"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Mon Sep 29 15:44:34 2008
B create_con (con_name=R/3)
B Loading DB library 'E:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'E:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'E:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.107)
B New connection 0 created
M sysno 00
M sid DEV
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 111
M intno 20050900
M make: multithreaded, Unicode, optimized
M pid 888
M
M kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 4 888) [dpxxdisp.c 1301]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M
M Mon Sep 29 15:44:35 2008
M DpShMCreate: sizeof(wp_adm) 18672 (1436)
M DpShMCreate: sizeof(tm_adm) 4232256 (21056)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064
M DpShMCreate: sizeof(comm_adm) 528064 (1048)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (96)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1536)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05F00040, size: 4892312)
M DpShMCreate: allocated sys_adm at 05F00040
M DpShMCreate: allocated wp_adm at 05F02090
M DpShMCreate: allocated tm_adm_list at 05F06980
M DpShMCreate: allocated tm_adm at 05F069B0
M DpShMCreate: allocated wp_ca_adm at 0630FDF0
M DpShMCreate: allocated appc_ca_adm at 06315BB0
M DpShMCreate: allocated comm_adm at 06317AF0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 063989B0
M DpShMCreate: allocated gw_adm at 063989F0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 06398A20
M DpShMCreate: allocated wall_adm at 06398A28
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 4 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 fusedev
M
M Mon Sep 29 15:44:36 2008
M calling db_connect ...
C Prepending E:\usr\sap\DEV\DVEBMGS00\exe to Path.
C Oracle Client Version: '10.2.0.1.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 064E10E8 064E6684 064E5F0C
C Attaching to DB Server DEV (con_hdl=0,svchp=064E5E58,srvhp=064F7A54)
C Starting user session (con_hdl=0,svchp=064E5E58,srvhp=064F7A54,usrhp=06544A68)
C
C Mon Sep 29 15:44:37 2008
C Now '/@DEV' is connected (con_hdl 0, nls_hdl 0).
C Got SAPSR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=064E5E58,usrhp=06544A68)
C Now I'm disconnected from ORACLE
C Connecting as SAPSR3/<pwd>@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 064E10E8 064E6684 064E5F0C
C Starting user session (con_hdl=0,svchp=064E5E58,srvhp=064F7A54,usrhp=06544A68)
C
C Mon Sep 29 15:44:39 2008
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=600
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=064E5E58,srvhp=064F7A54)
C *** ERROR => CONNECT failed with sql error '600'
[dbsloci.c 11042]
B ***LOG BYL=> DBQ action required because of database error [dbsh#2 @ 1193] [dbsh 1193 ]
B ***LOG BY2=> sql error 600 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-00600: internal error code, arguments: [kcfrbd_3], [2], [468570], [1], [384000], [471148], [], [] [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1426]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10283]
M
M Info for wp 4
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 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 req.vm = no VM
M attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server fusedev_DEV_00 on host fusedev (wp 4)
M * ERROR ThInit: db_connect
M *
M * TIME Mon Sep 29 15:44:39 2008
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10486
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 720]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]
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 4 888) [dpnttool.c 327]
-
trc file: "dev_w6", trc level: 1, release: "700"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Mon Sep 29 15:44:34 2008
B create_con (con_name=R/3)
B Loading DB library 'E:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'E:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'E:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.107)
B New connection 0 created
M sysno 00
M sid DEV
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 111
M intno 20050900
M make: multithreaded, Unicode, optimized
M pid 12268
M
M kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 6 12268) [dpxxdisp.c 1301]
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) 18672 (1436)
M DpShMCreate: sizeof(tm_adm) 4232256 (21056)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064
M DpShMCreate: sizeof(comm_adm) 528064 (1048)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (96)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1536)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05F00040, size: 4892312)
M DpShMCreate: allocated sys_adm at 05F00040
M DpShMCreate: allocated wp_adm at 05F02090
M DpShMCreate: allocated tm_adm_list at 05F06980
M DpShMCreate: allocated tm_adm at 05F069B0
M DpShMCreate: allocated wp_ca_adm at 0630FDF0
M DpShMCreate: allocated appc_ca_adm at 06315BB0
M DpShMCreate: allocated comm_adm at 06317AF0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 063989B0
M DpShMCreate: allocated gw_adm at 063989F0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 06398A20
M DpShMCreate: allocated wall_adm at 06398A28
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 6 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Mon Sep 29 15:44:35 2008
M ThInit: running on host fusedev
M
M Mon Sep 29 15:44:36 2008
M calling db_connect ...
C Prepending E:\usr\sap\DEV\DVEBMGS00\exe to Path.
C Oracle Client Version: '10.2.0.1.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 064E10E8 064E6684 064E5F0C
C Attaching to DB Server DEV (con_hdl=0,svchp=064E5E58,srvhp=064F7A54)
C Starting user session (con_hdl=0,svchp=064E5E58,srvhp=064F7A54,usrhp=06544A68)
C
C Mon Sep 29 15:44:37 2008
C Now '/@DEV' is connected (con_hdl 0, nls_hdl 0).
C Got SAPSR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=064E5E58,usrhp=06544A68)
C Now I'm disconnected from ORACLE
C Connecting as SAPSR3/<pwd>@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 064E10E8 064E6684 064E5F0C
C Starting user session (con_hdl=0,svchp=064E5E58,srvhp=064F7A54,usrhp=06544A68)
C
C Mon Sep 29 15:44:41 2008
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=600
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=064E5E58,srvhp=064F7A54)
C *** ERROR => CONNECT failed with sql error '600'
[dbsloci.c 11042]
B ***LOG BYL=> DBQ action required because of database error [dbsh#2 @ 1193] [dbsh 1193 ]
B ***LOG BY2=> sql error 600 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-00600: internal error code, arguments: [kcfrbd_3], [2], [464520], [1], [384000], [471148], [], [] [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1426]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10283]
M
M Info for wp 6
M
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_VBWP
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 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 req.vm = no VM
M attachedVm = no VM
and the trans.log is as below.
4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 29.09.2008 - 16:46:47
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Mon Sep 29 16:46:50 2008 0 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 36158 0.036158
4 ETW000 [dev trc ,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTI386\dboraslib.dll"
4 ETW000 33 0.036191
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 16 0.036207
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 24 0.036231
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.107)
4 ETW000 9733 0.045964
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 28 0.045992
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 37 0.046029
4 ETW000 [dev trc ,00000] New connection 0 created 27 0.046056
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 43 0.046099
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 20 0.046119
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 22 0.046141
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 32 0.046173
4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or
4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 2008 0.048181
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 58467 0.106648
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 28 0.106676
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2135 0.108811
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 26 0.108837
4 ETW000 [dev trc ,00000] Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 31 0.108868
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 702 0.109570
4 ETW000 [dev trc ,00000] 0 UTF8 1 0243E020 02443554 02442DDC
4 ETW000 121 0.109691
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 7103 0.116794
4 ETW000 [dev trc ,00000] Allocating server context handle 344 0.117138
4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=02442D28,srvhp=0245459C)
4 ETW000 75 0.117213
4 ETW000 [dev trc ,00000] Assigning server context 0245459C to service context 02442D28
4 ETW000 12856 0.130069
4 ETW000 [dev trc ,00000] Allocating user session handle 30 0.130099
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02442D28,srvhp=0245459C,usrhp=0248FAC0)
4 ETW000 43 0.130142
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034
4 ETW000 33803 0.163945
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0245459C) 18 0.163963
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02442D28,srvhp=0245459C)
4 ETW000 25 0.163988
4 ETW000 [dev trc ,00000] Deallocating server context handle 0245459C 375 0.164363
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'
4 ETW000 38 0.164401
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 19 0.164420
4 ETW000 [dev trc ,00000] Try to connect with default password 92 0.164512
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 27 0.164539
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 29 0.164568
4 ETW000 [dev trc ,00000] 0 UTF8 1 0243E020 02443554 02442DDC
4 ETW000 30 0.164598
4 ETW000 [dev trc ,00000] Allocating server context handle 15 0.164613
4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=02442D28,srvhp=0245459C)
4 ETW000 34 0.164647
4 ETW000 [dev trc ,00000] Assigning server context 0245459C to service context 02442D28
4 ETW000 10230 0.174877
4 ETW000 [dev trc ,00000] Assigning username to user session 0248FAC0 23 0.174900
4 ETW000 [dev trc ,00000] Assigning password to user session 0248FAC0 23 0.174923
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02442D28,srvhp=0245459C,usrhp=0248FAC0)
4 ETW000 29 0.174952
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034
4 ETW000 33874 0.208826
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0245459C) 18 0.208844
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02442D28,srvhp=0245459C)
4 ETW000 25 0.208869
4 ETW000 [dev trc ,00000] Deallocating server context handle 0245459C 8375 0.217244
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'
4 ETW000 47 0.217291
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 16 0.217307
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1034 performing CON [dblink#3 @ 431]
4 ETW000 8442 0.225749
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01034: ORACLE not available 19 0.225768
4 ETW000 ORA-27101: shared memory realm does not exist [dblink#3 @ 431]
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"
Sometimes error is shown as sql error '1034'
Waiting for the solution.
Hari mohan
Your Oracle database is probably in a bad state:
ORA-00600: internal error code, arguments: kcfrbd_3, [2], 468570, [1], 384000, 471148], [, []
so, check alert_DEV.log file for more info and search SAP notes and Oracle Metalink.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ashok,
The installation of Oracle was from setup so the number of services were more than the services of the system from which offline backup was taken. So I am reinstalling Oracle from SAPServer.cmd hope I will succeed in this attempt.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ashok,
In sql after startup open I am getting an message as ORA-08103: Object no longer exists.
Thanks for prompt replies, hope to resolve it soon.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashok,
There is no error it says Oracle mounted.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hari,
Looks oracle is down.
Open a command prompt and start oracle.
sqlplus "/as sysdba"
shutdown immediate
startup
Check oracle coming up or showing any error.
Open a new command prompt and execute command
r3trans -d
it will create a logfile trans.log
you anslyze it for further error or paste it here,.
Regards
Ashok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.