cancel
Showing results for 
Search instead for 
Did you mean: 

Restore of PRD to QAS using homogeneous system copy

Former Member
0 Kudos

Hi All,

My current production system is SAP 4.7 Enterprise Ext 110 with 6.40 kernel on Oracle 10.2.0.2.

Operating sytem is RHEL 4.0 .

I am building my QAS system using these installation guides

"SAP Web Applcation Server ABAP 6.40 SR 1 on Linux: Oracle" and "Homogeneous and Heterogeneous System Copy for SAP Systems Based on SAP Web Application Server ABAP 6.40 SR1".

I was able to generate the CONTROL.SQL, CONTROL.TRC and initQAS.ora files using the OraBRCopy tool.

Also successfully restored the PRD database minus the control files using

brrestore -d disk -b <backlog-file>.afd -m all

Wasn't able to do it via BRTools 7.0.

Database is coming up fine after running the CONTROL.SQL script.

However when I try to connect to the database as qasadm user with R3trans -d , I am getting this error.

This is R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"

R3trans finished (0012).

When I look at the dba_users table I am still seeing references still to PRD, and log below indicates an invalid username/password.

Here are the contents of the trans.log

4 ETW000 R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

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

4 ETW000

4 ETW000 date&time : 15.05.2008 - 16:08:50

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu May 15 16:08:50 2008 70 0.000070

4 ETW000 [dev trc ,00000] db_con_init called 16 0.000086

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ...

4 ETW000 26 0.000146

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/QAS/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 12426 0.012572

4 ETW000 [dev trc ,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded

4 ETW000 20 0.012592

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 28 0.012620

4 ETW000 [dev trc ,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.220)

4 ETW000 70 0.012690

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 23 0.012713

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 38 0.012751

4 ETW000 [dev trc ,00000] New connection 0 created 20 0.012771

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 23 0.012794

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

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

4 ETW000 17 0.012825

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 21 0.012846

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/QAS/102_64 from environment

4 ETW000 180 0.013026

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 20 0.013046

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 18 0.013064

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 1321 0.014385

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPQAS's password 21 0.014406

4 ETW000 [dev trc ,00000] Connecting as /@QAS on connection 0 (nls_hdl 0) ... (dbsl 640 070208)

4 ETW000 21 0.014427

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 21 0.014448

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0x6000000000a92fe0 0x6000000000a9c250 0x6000000000a9bbe8

4 ETW000 34 0.014482

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 17 0.014499

4 ETW000 [dev trc ,00000] Allocating server context handle 15 0.014514

4 ETW000 [dev trc ,00000] Attaching to DB Server QAS (con_hdl=0,svchp=0x6000000000a9bb18,srvhp=0x6000000000a9df98)

4 ETW000 37 0.014551

4 ETW000 [dev trc ,00000] Assigning server context 0x6000000000a9df98 to service context 0x6000000000a9bb18

4 ETW000 50581 0.065132

4 ETW000 [dev trc ,00000] Allocating user session handle 28 0.065160

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x6000000000a9bb18,srvhp=0x6000000000a9df98,usrhp=0x6000000000aa79e0)

4 ETW000 26 0.065186

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

4 ETW000 4537 0.069723

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

4 ETW000 21 0.069744

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 15 0.069759

4 ETW000 [dev trc ,00000] Try to connect with default password 13 0.069772

4 ETW000 [dev trc ,00000] Connecting as SAPQAS/<pwd>@QAS on connection 0 (nls_hdl 0) ... (dbsl 640 070208)

4 ETW000 22 0.069794

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 20 0.069814

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0x6000000000a92fe0 0x6000000000a9c250 0x6000000000a9bbe8

4 ETW000 20 0.069834

4 ETW000 [dev trc ,00000] Assigning username to user session 0x6000000000aa79e0

4 ETW000 18 0.069852

4 ETW000 [dev trc ,00000] Assigning password to user session 0x6000000000aa79e0

4 ETW000 27 0.069879

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x6000000000a9bb18,srvhp=0x6000000000a9df98,usrhp=0x6000000000aa79e0)

4 ETW000 19 0.069898

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

4 ETW000 1629 0.071527

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

4 ETW000 20 0.071547

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 11 0.071558

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 428]

4 ETW000 43 0.071601

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 428]

4 ETW000 20 0.071621

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"

Will appreciate some help on the resolution.

Thanks.

Regards,

VKM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi All,

Problem was solved by re-installing QAS using same SCHEMA ID as PRD, applying BRTools Release 700 patch level 33 and letting sapint perform the steps to completion

Markus your help directed me to the solution.

Regards,

VKM..

markus_doehr2
Active Contributor
0 Kudos

You need to re-setup your OPS$-user - see note 400241 - Problems with ops$ or sapr3 connect to Oracle

Markus