cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Instance not up after restoring database using BRTOOL , BRRESTORE

Former Member

on ‎12-13-2011 10:04 AM

0 Kudos

Hellow,

Plz give me some hint , i trouble after restore database from live server to my testing server (Configuration are same ), My Instance not going to up or initlize.below is my control file


---------------------------------------------------
trc file: "dev_w2", trc level: 1, release: "701"
---------------------------------------------------
*
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, MJ
*
M sysno      00
M sid        PRD
M systemid   562 (PC with Windows NT)
M relno      7010
M patchlevel 0
M patchno    122
M intno      20020600
M make:      multithreaded, Unicode, 64 bit, optimized
M pid        2704
M 
M  
M Tue Dec 13 01:49:49 2011
M  kernel runs with dp version 244000(ext=110000) (@(#) DPLIB-INT-VERSION-244000-UC)
M  length of sys_adm_ext is 576 bytes
M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 2 2704) [dpxxdisp.c   1349]
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)           29792  (1752)
M  DpShMCreate: sizeof(tm_adm)           5912704       (29416)
M  DpShMCreate: sizeof(wp_ca_adm)        24064  (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: 000000000E2C0050, size: 6614144)
M  DpShMCreate: allocated sys_adm at 000000000E2C0050
M  DpShMCreate: allocated wp_adm at 000000000E2C2270
M  DpShMCreate: allocated tm_adm_list at 000000000E2C96D0
M  DpShMCreate: allocated tm_adm at 000000000E2C9730
M  DpShMCreate: allocated wp_ca_adm at 000000000E86CFB0
M  DpShMCreate: allocated appc_ca_adm at 000000000E872DB0
M  DpShMCreate: allocated comm_adm at 000000000E874CF0
M  DpShMCreate: system runs without slock table
M  DpShMCreate: system runs without file table
M  DpShMCreate: allocated vmc_adm_list at 000000000E8FB980
M  DpShMCreate: allocated gw_adm at 000000000E8FBA00
M  DpShMCreate: system runs without vmc_adm
M  DpShMCreate: allocated ca_info at 000000000E8FBA30
M  DpShMCreate: allocated wall_adm at 000000000E8FBA40
M  
M Tue Dec 13 01:49:50 2011




M  DpRqQInit: Parameter rdisp/queue_lock_level = 2
M  rdisp/queue_size_check_value :  -> on,50,30,40,500,50,500,80
M  ThTaskStatus: rdisp/reset_online_during_debug 0
X  EmInit: MmSetImplementation( 2 ).
X  MM global diagnostic options set: 0
X  <ES> client 2 initializing ....
X  Using implementation view
X  <EsNT> Using memory model view.
M  <EsNT> Memory Reset disabled as NT default
X  ES initialized.
X  mm.dump: set maximum dump mem to 96 MB
M  ThInit: rdisp/cleanup_after_crash = 1
M  ThInit: running on host PROPER
M  
M Tue Dec 13 01:49:51 2011
M  calling db_connect ...
B  Loading DB library 'D:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' ...
B  Library 'D:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' loaded
B  Version of 'D:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.110)
C  Prepending D:\usr\sap\PRD\DVEBMGS00\exe to Path.
C  Oracle Client Version: '10.2.0.4.0', (dbsl 701 140910)
C  application info callback registered
C  Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'
C  Logon as OPS$-user to get SAPSR3's password
C  Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 701 140910)
C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch
C    0 UTF8                                                      0000000007F53760 0000000007F5B2B0 0000000007F5CAC8
C  Attaching to DB Server PRD (con_hdl=0,svchp=0000000007F5C988,srvhp=0000000007F5DC18)
C  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000007F5C988, srvhp=0000000007F5DC18, usrhp=0000000007F6AB30)
C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1033:

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

sunny_pahuja2
Active Contributor
‎12-13-2011 10:08 AM
0 Kudos

Hi,

Check SAP note 655240. Please paste log of R3trans -d.

Thanks

Sunny

Show replies
Show replies
Former Member
‎12-13-2011 10:14 AM
0 Kudos

Hi Thanks fro your replay below is my R3trans Log


C:\Users\prdadm>R3trans -d
This is R3trans version 6.14 (release 701 - 19.11.10 - 18:10:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_o
ra_tnsname = 'PRD'"
R3trans finished (0012).

sunny_pahuja2
Active Contributor
‎12-13-2011 10:25 AM
0 Kudos

please paste trans.log which is the output of R3trans -d.

Thanks

Sunny

Former Member
‎12-13-2011 10:42 AM
0 Kudos

Part1


4 ETW000 R3trans version 6.14 (release 701 - 19.11.10 - 18:10:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000 
4 ETW000 date&time   : 13.12.2011 - 02:40:46
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]  Tue Dec 13 02:40:48 2011                                                   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]  DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 00000001872D0000
4 ETW000                                                                                108  0.000108
4 ETW000  [dev trc     ,00000]      using "D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\dboraslib.dll"               16  0.000124
4 ETW000  [dev trc     ,00000]  Library 'dboraslib.dll' loaded                                            19  0.000143
4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dboraslib.dll                    20  0.000163
4 ETW000  [dev trc     ,00000]  Version of 'dboraslib.dll' is "700.08", patchlevel (0.110)               128  0.000291
4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dboraslib.dll                   19  0.000310
4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dboraslib.dll                  28  0.000338
4 ETW000  [dev trc     ,00000]  New connection 0 created                                                  23  0.000361
4 ETW000  [dev trc     ,00000]  000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO 
4 ETW000                                                                                48  0.000409

Former Member
‎12-13-2011 10:43 AM
0 Kudos

Part2



4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                                             24  0.000433
4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:                16  0.000449
4 ETW000  [dev trc     ,00000]  000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO 
4 ETW000                                                                                44  0.000493
4 ETW000  [dev trc     ,00000]  CLIENT_ORACLE_HOME is not set as environment variable or                 207  0.000700
4 ETW000                        DIR_CLIENT_ORAHOME is not set as profile parameter.
4 ETW000                          assuming using instant client with unspecified location.
4 ETW000  [dev trc     ,00000]  -->oci_init1                                                              48  0.000748
4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.4.0', (dbsl 701 140910)                  3679  0.004427
4 ETW000  [dev trc     ,00000]    Default connection: tnsname ='PRD'                                      25  0.004452
4 ETW000  [dev trc     ,00000]  -->oci_initialize(con_hdl=0, char='', nchar='')                           23  0.004475
4 ETW000  [dev trc     ,00000]  application info callback registered                                      17  0.004492
4 ETW000  [dev trc     ,00000]  (-) OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000                                                                                1515  0.006007
4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=000000000AA27B80)
4 ETW000                                                                                89  0.006096
4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=0000000003BCCD78)
4 ETW000                                                                                53  0.006149

Former Member
‎12-13-2011 10:44 AM
0 Kudos

Part3



4 ETW000  [dev trc     ,00000]  NLS env. settings: lang=41004D00450052004900430041004E0000000000000000000000000000000000
4 ETW000                                                                                152  0.006301
4 ETW000  [dev trc     ,00000]                     terr=41004D0045005200490043004100000000000000000000000000000000000000
4 ETW000                                                                                34  0.006335
4 ETW000  [dev trc     ,00000]                     char=5500540046003100360000000000000000000000000000000000000000000000
4 ETW000                                                                                34  0.006369
4 ETW000  [dev trc     ,00000]  Client character set UTF16 -> UTF8                                        15  0.006384
4 ETW000  [dev trc     ,00000]  Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'
4 ETW000                                                                                27  0.006411
4 ETW000  [dev trc     ,00000]  charset='', chset='UTF8', UNI_ASC=FALSE/FALSE                             17  0.006428
4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPSR3's password                               17  0.006445
4 ETW000  [dev trc     ,00000]  Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 701 140910)
4 ETW000                                                                                28  0.006473
4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch
4 ETW000                                                                                36  0.006509
4 ETW000  [dev trc     ,00000]    0 UTF8                                                      000000000AA20090 000000000AA27B80 0000000003BCCD78

Former Member
‎12-13-2011 10:46 AM
0 Kudos

part 4


4 ETW000                                                                                33  0.006542
4 ETW000  [dev trc     ,00000]  Allocating service context handle for con_hdl=0                           24  0.006566
4 ETW000  [dev trc     ,00000]  Allocating server context handle                                          21  0.006587
4 ETW000  [dev trc     ,00000]  Attaching to DB Server PRD (con_hdl=0,svchp=0000000003BCCC38,srvhp=000000000AA2CE08)
4 ETW000                                                                                51  0.006638
4 ETW000  [dev trc     ,00000]  Tue Dec 13 02:40:49 2011                                              121345  0.127983
4 ETW000  [dev trc     ,00000]  Assigning server context 000000000AA2CE08 to service context 0000000003BCCC38
4 ETW000                                                                                26  0.128009
4 ETW000  [dev trc     ,00000]  Allocating user session handle                                            39  0.128048
4 ETW000  [dev trc     ,00000]  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000003BCCC38, srvhp=000000000AA2CE08, usrhp=000000000AA399F0)
4 ETW000                                                                                45  0.128093
4 ETW000  [dev trc     ,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR               25093  0.153186
4 ETW000  [dev trc     ,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:               78  0.153264
4 ETW000  [dev trc     ,00000]     ORA-01034: ORACLE not available                                        27  0.153291
4 ETW000                        ORA-27101: shared memory realm does not exist                                             
4 ETW000  [dev trc     ,00000]  server_detach(con_hdl=0,stale=1,svrhp=000000000AA2CE08)                   29  0.153320
4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=0000000003BCCC38,srvhp=000000000AA2CE08)
4 ETW000                                                                                29  0.153349



4 ETW000  [dev trc     ,00000]  Deallocating server context handle 000000000AA2CE08 from con_hdl=0      1304  0.154653
4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1034'                         43  0.154696
4 ETW000  [dev trc     ,00000]     set_ocica() -> SQL error code 1034                                     21  0.154717
4 ETW000  [dev trc     ,00000]  -->oci_get_errmsg (con_hdl=0, rc=1034)                                    17  0.154734
4 ETW000  [dev trc     ,00000]     OCIErrorGet -> SQL error code: 1034                                    57  0.154791
4 ETW000  [dev trc     ,00000]     ORA-01034: ORACLE not available                                        25  0.154816
4 ETW000                        ORA-27101: shared memory realm does not exist                                             
4 ETW000  [dev trc     ,00000]  SAPUSER or connect error 99=DBSL_ERR_DB, oerr=1034.                       40  0.154856
4 ETW000  [dblink      ,00433]  ***LOG BY2=>sql error 1034   performing CON [dblink#4 @ 433]              42  0.154898
4 ETW000  [dblink      ,00433]  ***LOG BY0=>ORA-01034: ORACLE not available                               28  0.154926
4 ETW000                        ORA-27101: shared memory realm does not exist [dblink#4 @ 433]
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'PRD'"

sunny_pahuja2
Active Contributor
‎12-13-2011 11:35 AM
0 Kudos

Hi,

Check SAP note 491174.

Thanks

Sunny

nicholas_chang
Active Contributor
‎12-13-2011 12:55 PM
0 Kudos

Is your listener up and running?

Former Member
‎12-13-2011 1:35 PM
0 Kudos

running

nicholas_chang
Active Contributor
‎12-13-2011 1:47 PM
0 Kudos

Hi,

Please check the oracle alert.log and there should have some hints there.

What's your backup mode? Offline? Online?

If online, do you perform recovery?

Ask a Question