Question:
Hello everybody,
I have been trying to perform system copy (homogenous copy) of our development system(DEV) to create a sandbox(SBX). DEV is ECC5, Oracle 9.2.6.0 on Solaris
9. I have successfully restored the data files of DEV on SBX, create the control file from DEV and bring up the DEV's db on SBX using sqlplus. So far so good..
Now when I run the script startsap as <SID>ADM account it gives me an error "Database startup failed" and i am unable to start SAP. I have tried to find the cause.
I have checked oracle processes (after database startup), oracle listener and finally ran R3trans. The process are running, listener is running but the problem seems to be that SAP is unable to communicate with/access oracle. R3TRANS is unable to connect to database.
I tried "R3trans -d" and got RC =12
I tried "R3trans -x" and got RC =0
The trans.log file outputs three errors from where other errors start. This the contents of trans.log (R3trans-d)
1)*** ERROR => ORA-1578 occured when executing SQL statement (parse error offset = 0)
4 ETW000 15192 0.230754
4 ETW000 [dev trc ,00000] sc_p=0x101389a38,no=1,idc_p=(nil),con=0,act=1,slen=27,smax=256,#vars=0,stmt=0x1015f4790,table=DDNTT
2)NTAB: SELECT COMPCNT FROM DDNTT FAILED 83 0.231843
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1578 occured when executing SQL statement (parse error offset = 0)
4 ETW000 1238 0.233081
4 ETW000 [dev trc ,00000] sc_p=0x101389ad0,no=2,idc_p=(nil),con=0,act=1,slen=27,smax=256,#vars=0,stmt=0x1015f9190,table=DDNTT
4 ETW000 352 0.233433
4 ETW000 [dev trc ,00000] prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=(nil),ocistmth_p=0x1015faa88
4 ETW000 74 0.233507
4 ETW000 [dev trc ,00000] IN : cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=0,vmax=0,bound=0,iobuf_p=(nil),vda_p=(nil)
4 ETW000 114 0.233621
4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0
4 ETW000 74 0.233695
4 ETW000 [dev trc ,00000] OUT: cols=1,rmax=16250,xcnt=1,rpc=0,rowi=0,rtot=0,upto=1,rsize=2,vmax=32,bound=1,iobuf_p=0x10135db30,vda_p=0x1015fb020
4 ETW000 79 0.233774
4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0
3) SELECT DBASE FROM "DDNTT"; 44 0.237062
4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED
I was able to start the DB and connect using SAPDEV. I executed the query SELECT VERSION/DBASE FROM "DDNTT", and the got error message table/view does not exist.
Did the same on the Devlopment system and got the same result. I dont seem to understand why is tha query being executed?
Here is the detailed log of trans.log
4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 16.07.2006 - 10:36:34
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] Sun Jul 16 10:36:34 2006 377 0.000377
4 ETW000 [dev trc ,00000] db_con_init called 73 0.000450
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 211 0.000661
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SBX/SYS/exe/run/dboraslib.so' ...
4 ETW000 240 0.000901
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/SBX/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 84743 0.085644
4 ETW000 [dev trc ,00000] Library '/usr/sap/SBX/SYS/exe/run/dboraslib.so' loaded
4 ETW000 152 0.085796
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/SBX/SYS/exe/run/dboraslib.so
4 ETW000 89 0.085885
4 ETW000 [dev trc ,00000] Version of '/usr/sap/SBX/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.32)
4 ETW000 376 0.086261
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/SBX/SYS/exe/run/dboraslib.so
4 ETW000 79 0.086340
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/SBX/SYS/exe/run/dboraslib.so
4 ETW000 144 0.086484
4 ETW000 [dev trc ,00000] New connection 0 created 180 0.086664
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 97 0.086761
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 114 0.086875
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 73 0.086948
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 79 0.087027
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/SBX/920_64 from environment
4 ETW000 1288 0.088315
4 ETW000 [dev trc ,00000] -->oci_initialize 84 0.088399
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 8674 0.097073
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDEV's password 71 0.097144
4 ETW000 [dev trc ,00000] Connecting as /@SBX on connection 0 ... 54 0.097198
4 ETW000 [dev trc ,00000] Allocating service context handle 121 0.097319
4 ETW000 [dev trc ,00000] Allocating server context handle 81 0.097400
4 ETW000 [dev trc ,00000] Attaching to DB Server SBX (con_hdl=0,svchp=0x101429748,svrhp=0x10142bbe8)
4 ETW000 221 0.097621
4 ETW000 [dev trc ,00000] Assigning server context 0x10142bbe8 to service context 0x101429748
4 ETW000 74581 0.172202
4 ETW000 [dev trc ,00000] Allocating user session handle 190 0.172392
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101429748,srvhp=0x10142bbe8,usrhp=0x1014345b0)
4 ETW000 101 0.172493
4 ETW000 [dev trc ,00000] Assigning user session 0x1014345b0 to service context 0x101429748
4 ETW000 20112 0.192605
4 ETW000 [dev trc ,00000] Now I'm connected to ORACLE 3351 0.195956
4 ETW000 [dev trc ,00000] Got SAPDEV's password from OPS$-user 2851 0.198807
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 62 0.198869
4 ETW000 [dev trc ,00000] Rolling back transaction ... 100 0.198969
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x101429748,usrhp=0x1014345b0)
4 ETW000 542 0.199511
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 1357 0.200868
4 ETW000 [dev trc ,00000] Connecting as SAPDEV/<pwd>@SBX on connection 0 ...
4 ETW000 85 0.200953
4 ETW000 [dev trc ,00000] Assigning username to user session 0x1014345b0 51 0.201004
4 ETW000 [dev trc ,00000] Assigning password to user session 0x1014345b0 63 0.201067
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101429748,srvhp=0x10142bbe8,usrhp=0x1014345b0)
4 ETW000 83 0.201150
4 ETW000 [dev trc ,00000] Assigning user session 0x1014345b0 to service context 0x101429748
4 ETW000 7478 0.208628
4 ETW000 [dev trc ,00000] Now I'm connected to ORACLE 1174 0.209802
4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.UTF8 1876 0.211678
4 ETW000 [dev trc ,00000] Database instance SBX is running on hqsun7 with ORACLE version 9.2.0.6.0 since 20060716
4 ETW000 1784 0.213462
4 ETW000 [dev trc ,00000] Connection 0 opened 2100 0.215562
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1578 occured when executing SQL statement (parse error offset = 0)
4 ETW000 15192 0.230754
4 ETW000 [dev trc ,00000] sc_p=0x101389a38,no=1,idc_p=(nil),con=0,act=1,slen=27,smax=256,#vars=0,stmt=0x1015f4790,table=DDNTT
4 ETW000 394 0.231148
4 ETW000 [dev trc ,00000] prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=(nil),ocistmth_p=0x101432d70
4 ETW000 110 0.231258
4 ETW000 [dev trc ,00000] IN : cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=0,vmax=0,bound=0,iobuf_p=(nil),vda_p=(nil)
4 ETW000 84 0.231342
4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0
4 ETW000 68 0.231410
4 ETW000 [dev trc ,00000] OUT: cols=1,rmax=10833,xcnt=1,rpc=0,rowi=0,rtot=0,upto=1,rsize=4,vmax=32,bound=1,iobuf_p=0x10135db30,vda_p=0x1015f49b0
4 ETW000 79 0.231489
4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0
4 ETW000 67 0.231556
4 ETW000 [dev trc ,00000] SELECT COMPCNT FROM "DDNTT"; 204 0.231760
4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM DDNTT FAILED 83 0.231843
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1578 occured when executing SQL statement (parse error offset = 0)
4 ETW000 1238 0.233081
4 ETW000 [dev trc ,00000] sc_p=0x101389ad0,no=2,idc_p=(nil),con=0,act=1,slen=27,smax=256,#vars=0,stmt=0x1015f9190,table=DDNTT
4 ETW000 352 0.233433
4 ETW000 [dev trc ,00000] prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=(nil),ocistmth_p=0x1015faa88
4 ETW000 74 0.233507
4 ETW000 [dev trc ,00000] IN : cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=0,vmax=0,bound=0,iobuf_p=(nil),vda_p=(nil)
4 ETW000 114 0.233621
4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0
4 ETW000 74 0.233695
4 ETW000 [dev trc ,00000] OUT: cols=1,rmax=16250,xcnt=1,rpc=0,rowi=0,rtot=0,upto=1,rsize=2,vmax=32,bound=1,iobuf_p=0x10135db30,vda_p=0x1015fb020
4 ETW000 79 0.233774
4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0
4 ETW000 66 0.233840
4 ETW000 [dev trc ,00000] SELECT VERSION FROM "DDNTT"; 43 0.233883
4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT FAILED 47 0.233930
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-904 occured when executing SQL statement (parse error offset = 7)
4 ETW000 2345 0.236275
4 ETW000 [dev trc ,00000] sc_p=0x101389b68,no=3,idc_p=(nil),con=0,act=1,slen=25,smax=256,#vars=0,stmt=0x1015fb740,table=DDNTT
4 ETW000 354 0.236629
4 ETW000 [dev trc ,00000] prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=(nil),ocistmth_p=0x1015fc458
4 ETW000 74 0.236703
4 ETW000 [dev trc ,00000] IN : cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=0,vmax=0,bound=0,iobuf_p=(nil),vda_p=(nil)
4 ETW000 79 0.236782
4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0
4 ETW000 67 0.236849
4 ETW000 [dev trc ,00000] OUT: cols=1,rmax=16250,xcnt=1,rpc=0,rowi=0,rtot=0,upto=1,rsize=2,vmax=32,bound=1,iobuf_p=0x10135db30,vda_p=0x1015fc9f0
4 ETW000 100 0.236949
4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0
4 ETW000 69 0.237018
4 ETW000 [dev trc ,00000] SELECT DBASE FROM "DDNTT"; 44 0.237062
4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED
4 ETW000 73 0.237135
4 ETW000 [dbntab ,01274] ***LOG BZY=>unexpected return code 99 calling NTAB [dbntab#7 @ 12744]
4 ETW000 227 0.237362
4 ETW000 [dev trc ,00000] NTAB: standalone processing 307 0.237669
4 ETW000 [dev trc ,00000] NTAB: read profile 89 0.237758
4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 50 0.237808
4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 46 0.237854
4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 44 0.237898
4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 43 0.237941
4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 117 0.238058
4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 60 0.238118
4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 45 0.238163
4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 44 0.238207
4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 43 0.238250
4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 64 0.238314
4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 80. 46 0.238360
4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 64. 44 0.238404
4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 45 0.238449
4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 43 0.238492
4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 44 0.238536
4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 43 0.238579
4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 80. 43 0.238622
4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 64. 43 0.238665
4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 42 0.238707
4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 60 0.238767
4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 46 0.238813
4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 44 0.238857
4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 80. 43 0.238900
4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 64. 42 0.238942
4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 43 0.238985
4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 42 0.239027
4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 43 0.239070
4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 43 0.239113
4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 184. 43 0.239156
4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 40. 42 0.239198
4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 60 0.239258
4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 256 45 0.239303
4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 44 0.239347
4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 256000. 44 0.239391
4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 10155e7d0, hh_len 80 3879 0.243270
4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 1015fd180, aa_len 16024 63 0.243333
4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 101601030, ia_len 64000 48 0.243381
4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 101610a40, dat_len 512000 46 0.243427
4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 10168da50, hh_len 80 44 0.243471
4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 10168dab0, aa_len 16024 44 0.243515
4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 101691960, ia_len 16000 195 0.243710
4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 1016957f0, dat_len 102400 49 0.243759
4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 1016ae800, hh_len 80 45 0.243804
4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 1016ae860, aa_len 16024 46 0.243850
4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 1016b2710, ia_len 16000 44 0.243894
4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 1016b65a0, dat_len 102400 45 0.243939
4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 1016cf5b0, hh_len 184 44 0.243983
4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 1016cf680, aa_len 16024 43 0.244026
4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 1016d3530, ia_len 40000 45 0.244071
4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 1016dd180, dat_len 256000 44 0.244115
4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 1016cf5b0, ntab_mp_p 1016cf5b0, ntab_proc_id 0
4 ETW000 108 0.244223
4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 10155e7d0, ha_list 1015fd180, hi_list 101601030, buffer 101610a40
4 ETW000 794 0.245017
4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 10168da50, ha_list 10168dab0, hi_list 101691960, buffer 1016957f0
4 ETW000 69 0.245086
4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 1016ae800, ha_list 1016ae860, hi_list 1016b2710, buffer 1016b65a0
4 ETW000 68 0.245154
4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 1016cf618, ha_list 1016cf680, hi_list 1016d3530, buffer 1016dd180
4 ETW000 69 0.245223
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0
4 ETW000 163 0.245386
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1
4 ETW000 179 0.245565
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2
4 ETW000 185 0.245750
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3
4 ETW000 183 0.245933
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 3036 0.248969
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1530 0.250499
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1433 0.251932
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1424 0.253356
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1401 0.254757
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1400 0.256157
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1423 0.257580
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1401 0.258981
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1400 0.260381
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1397 0.261778
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1471 0.263249
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1426 0.264675
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1398 0.266073
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1402 0.267475
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1399 0.268874
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 1423 0.270297
4 ETW000 [dbntab ,01000] ***LOG BZY=>unexpected return code 103 calling DbSlRead [dbntab#7 @ 10007]
4 ETW000 2188 0.272485
2EETW000 sap_dext called with msgnr "2":
2EETW000 ---- db call info ----
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 tabname: TADIR
2EETW000 len (char): 5
2EETW000 key: TADIR
2EETW000 retcode: 2
4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)
4 ETW000 501 0.272986
4 ETW000 ROLLBACK (0).
I need the help of my peers and gurus to get the system going.
Thanks in advance
Alf
p.s: I was able to restore the DB of SBX from the backup using same system copy process.
Answer:
What is your schema name? Is it SAPDEV? That's ok, but you have to tell SAP that's SAPDEV and not SAPSBX. Therefore have look at SAP Note 562863
Answer:
Thanks for your reply,
The Schema name is SAPDEV which is the same through out the landscape.
The note gives detail info about users and how SAP accesses Oracle using various users. I will find out what needs to be done in my case in accordance with the note...
Answer:
Can you check if the correct OPS$ users have been created in table DBA_USERS..
Regards,
Mark
Answer:
Have a look at SAP Note 700548
Answer:
Here is the list of users
SQL> SELECT USERNAME FROM DBA_USERS;
USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
OPS$SBXADM
SAPDEV
PERFSTAT
FSONG
SAPDEVSHD
OPS$ORASBX
Answer:
ERROR => ORA-1578 occured when executing SQL statement (parse error offset = 0)
This error can mean that there is an Oracle block corruption in your database.. You might have to check note 23345 to check the consistency of your database.
Regards,
Mark
Answer:
Thanks everybody for your help.
The reason why I was not able to successfully complete the process was due corrupt datafiles. I used "dbv" to perfrom the check on the data fiels that were copied from DEV. A few datafiles had a large number of corrupt data blocks.
Performed a fresh offline backup and all set to go.
Thanks once again for your prompt help!
Alf