bw db copy

[Former Member]

Hi all,

We are rebuilding our DEV BW environment from a copy of the Production

environment.I have successfully restored the Oracle 9.2 database.

R3trans -x is also working. However when I run startsap, it executes

R3trans -d and fails the database check and also cannot start the

database. (I can, however, start the database from sqlplus. )

Following is the R3trans -d

R3trans -d

This is R3trans version 6.13 (release 640 - 21.10.05 - 15:04:00).

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len: 5

2EETW000 key: TADIR

2EETW000 retcode: 2

R3trans finished (0012).

Following is the extract of Trans.log

4 ETW000 [dev trc ,00000] Now 'SAPGBD/<pwd>@GBD' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 354 0.189960

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC 663 0.190623

4 ETW000 [dev trc ,00000] Database instance GBD is running on unknown with ORACLE version 9.2.0.6.0 since 20060718

4 ETW000 398 0.191021

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 697 0.191718

4 ETW000 [dblink ,01281] ***LOG BZA=>table SVERS does not exist on database [dblink#2 @ 1281]

4 ETW000 3880 0.195598

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM DDNTT FAILED 636 0.196234

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT FAILED 339 0.196573

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED

4 ETW000 348 0.196921

4 ETW000 [dbntab ,01274] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#7 @ 12744]

4 ETW000

20 0.196941

Thnx in advance,

[Former Member · Accepted solution]

Try to set the environment variable dbs_ora_schema=SAP<SID> where SAP<SID> is the owner of the tables in the database.

Regards,

ben

[Former Member · Accepted solution]

Dear All,

We are also facing the same problem. We have done a Oracle DB Restore on Windows 2000 Adv. Server. Please let us know if you have already a solution for this.

Environment variable is set to dbs_ora_schema=SAP<SID>

which is SAPPRD.

Log details:

ETW000 R3trans version 6.13 (release 620 - 03.06.05 - 17:04:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 21.09.2006 - 14:44:43

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] Thu Sep 21 14:44:45 2006 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 0.000000

4 ETW000 [dev trc ,00000] using "K:\usr\sap\PRD\SYS\exe\run\dboraslib.dll"

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 0.000000

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "620.02", patchlevel (0.1910)

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 1 0.000001

4 ETW000 [dev trc ,00000] New connection 0 created 28 0.000029

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 32 0.000061

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 20 0.000081

4 ETW000 [dev trc ,00000] find_con found the following connection for reuse:

4 ETW000 26 0.000107

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 29 0.000136

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=K:\oracle\PRD\920 from environment

4 ETW000 209 0.000345

4 ETW000 [dev trc ,00000] -->oci_initialize 22 0.000367

4 ETW000 [dev trc ,00000] Thu Sep 21 14:44:47 2006 1345950 1.346317

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 26 1.346343

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPPRD's password 51 1.346394

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 ... 19 1.346413

4 ETW000 [dev trc ,00000] Allocating service context handle 27 1.346440

4 ETW000 [dev trc ,00000] Allocating server context handle 20 1.346460

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=01E1D4C4,svrhp=02B354E4)

4 ETW000 52 1.346512

4 ETW000 [dev trc ,00000] Thu Sep 21 14:44:49 2006 2310981 3.657493

4 ETW000 [dev trc ,00000] Assigning server context 02B354E4 to service context 01E1D4C4

4 ETW000 43 3.657536

4 ETW000 [dev trc ,00000] Allocating user session handle 44 3.657580

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=01E1D4C4,srvhp=02B354E4,usrhp=02B3DC84)

4 ETW000 52 3.657632

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 4401 3.662033

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 39 3.662072

4 ETW000 [dev trc ,00000] Try to connect with default password 26 3.662098

4 ETW000 [dev trc ,00000] Connecting as SAPPRD/<pwd>@PRD on connection 0 ...

4 ETW000 28 3.662126

4 ETW000 [dev trc ,00000] Assigning username to user session 02B3DC84 20 3.662146

4 ETW000 [dev trc ,00000] Assigning password to user session 02B3DC84 24 3.662170

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=01E1D4C4,srvhp=02B354E4,usrhp=02B3DC84)

4 ETW000 33 3.662203

4 ETW000 [dev trc ,00000] Assigning user session 02B3DC84 to service context 01E1D4C4

4 ETW000 3050 3.665253

4 ETW000 [dev trc ,00000] Now I'm connected to ORACLE 693 3.665946

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC 415 3.666361

4 ETW000 [dev trc ,00000] Database instance prd is running on HSTPRDS with ORACLE version 9.2.0.4.0 since 20060921

4 ETW000 432 3.666793

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 948 3.667741

4 ETW000 [dblink ,01292] ***LOG BZA=>table SVERS does not exist on database [dblink#1 @ 1292]

4 ETW000 6275 3.674016

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM DDNTT FAILED 1344 3.675360

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT FAILED 449 3.675809

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED

4 ETW000 427 3.676236

4 ETW000 [dbntab ,01274] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#17 @ 12742]

4 ETW000 38 3.676274

4 ETW000 [dev trc ,00000] NTAB: standalone processing 45 3.676319

4 ETW000 [dev trc ,00000] NTAB: read profile 17 3.676336

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 16 3.676352

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 16 3.676368

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 15 3.676383

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 16 3.676399

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 30 3.676429

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 30 3.676459

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 17 3.676476

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 15 3.676491

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 15 3.676506

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 15 3.676521

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 44. 15 3.676536

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 36. 22 3.676558

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 19 3.676577

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 16 3.676593

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 15 3.676608

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 16 3.676624

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 44. 15 3.676639

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 36. 15 3.676654

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 16 3.676670

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 14 3.676684

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 16 3.676700

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 15 3.676715

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 44. 15 3.676730

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 36. 15 3.676745

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 16 3.676761

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 14 3.676775

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 16 3.676791

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 15 3.676806

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 148. 15 3.676821

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 24. 15 3.676836

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 15 3.676851

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 152 15 3.676866

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 16 3.676882

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 152000. 15 3.676897

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 2b3e558, hh_len 44 971 3.677868

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 2b7b9d0, aa_len 8012 20 3.677888

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 30d0fb0, ia_len 36000 17 3.677905

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 30d9c58, dat_len 512000 18 3.677923

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 2b43fa8, hh_len 44 16 3.677939

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 2b7d928, aa_len 8012 17 3.677956

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 2b7f880, ia_len 9000 17 3.677973

4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 3156c60, dat_len 102400 17 3.677990

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 2b81bb8, hh_len 44 16 3.678006

4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 316fc68, aa_len 8012 17 3.678023

4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 3171bc0, ia_len 9000 16 3.678039

4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 3173ef8, dat_len 102400 17 3.678056

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 2b98230, hh_len 148 17 3.678073

4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 318cf00, aa_len 8012 16 3.678089

4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 318ee58, ia_len 24000 17 3.678106

4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 3194c20, dat_len 152000 17 3.678123

4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 2b98230, ntab_mp_p 2b98230, ntab_proc_id 0

4 ETW000 31 3.678154

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 2b3e558, ha_list 2b7b9d0, hi_list 30d0fb0, buffer 30d9c58

4 ETW000 73 3.678227

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 2b43fa8, ha_list 2b7d928, hi_list 2b7f880, buffer 3156c60

4 ETW000 29 3.678256

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 2b81bb8, ha_list 316fc68, hi_list 3171bc0, buffer 3173ef8

4 ETW000 28 3.678284

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 2b98298, ha_list 318cf00, hi_list 318ee58, buffer 3194c20

4 ETW000 28 3.678312

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000 40 3.678352

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1

4 ETW000 42 3.678394

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000 42 3.678436

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000 39 3.678475

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 1083 3.679558

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 44 3.679602

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 455 3.680057

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 41 3.680098

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 439 3.680537

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 39 3.680576

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 430 3.681006

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 39 3.681045

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 426 3.681471

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 40 3.681511

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 427 3.681938

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 40 3.681978

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 425 3.682403

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 39 3.682442

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 435 3.682877

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 44 3.682921

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 428 3.683349

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 40 3.683389

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 426 3.683815

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 40 3.683855

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 436 3.684291

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 42 3.684333

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 426 3.684759

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 40 3.684799

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 427 3.685226

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 39 3.685265

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 426 3.685691

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 40 3.685731

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 425 3.686156

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 39 3.686195

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXF 450 3.686645

4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#17 @ 10280]

4 ETW000 40 3.686685

4 ETW000 [dev trc ,00000] NTAB: tabname = XXXXT 918 3.687603

4 ETW000 [dbntab ,01000] ***LOG BZY=>unexpected return code 103 calling DbSlRead [dbntab#17 @ 10006]

4 ETW000 42 3.687645

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len: 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 850 3.688495

4 ETW000 ROLLBACK (0).

Best Regards,

Sita Ram

[Former Member]

Hi Mudassir,

What SAP version do you have?

[Former Member]

Hi Mudassir,

Did you drop the old OPS$ADM user and create the new OPS$ADM user in the restored database?

[Former Member]

If yours restoration is OS level restoration..then...

Have you changed the host name of the DEV system to the same as PRD system?

If not have you modified the startprofiles?

If you restored it through oracle utilities..then...

Have you changed the DBSID in the relevant profiles?