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