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: 

R3trans -d failing

Go to solution
Former Member

on ‎10-28-2009 8:17 PM

0 Kudos

Hi ,

I have executed R3trans -d .its failing with a return code 12.Pasted the log.This is the error we are getting during the system refresh.

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

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 28.10.2009 - 20:16:01

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] Wed Oct 28 20:16:01 2009 643 0.000643

4 ETW000 [dev trc ,00000] db_con_init called 52 0.000695

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

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

4 ETW000 139 0.001001

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

4 ETW000 42545 0.043546

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

4 ETW000 78 0.043624

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

4 ETW000 92 0.043716

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

4 ETW000 345 0.044061

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

4 ETW000 88 0.044149

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

4 ETW000 124 0.044273

4 ETW000 [dev trc ,00000] New connection 0 created 62 0.044335

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 327 0.044662

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

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

4 ETW000 76 0.044907

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

ax = 255, con_opt = 255, occ = NO

4 ETW000 90 0.044997

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

4 ETW000 715 0.045712

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

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

4 ETW000 77 0.045898

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 5613 0.051511

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSRG's password 81 0.051592

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

4 ETW000 88 0.051680

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

4 ETW000 98 0.051778

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x800000010115d040 0x800000010116fa8

8 0x800000010116f420

4 ETW000 88 0.051866

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

4 ETW000 [dev trc ,00000] Allocating server context handle 62 0.052028

4 ETW000 [dev trc ,00000] Attaching to DB Server SRG (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0)

4 ETW000 150 0.052178

4 ETW000 [dev trc ,00000] Assigning server context 0x80000001011717f0 to service context 0x800000010116f350

4 ETW000 109654 0.161832

4 ETW000 [dev trc ,00000] Allocating user session handle 133 0.161965

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0,usrhp=0x800000010

117a9c0)

4 ETW000 97 0.162062

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

4 ETW000 9573 0.171635

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x80000001011717f0)

4 ETW000 80 0.171715

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0)

4 ETW000 82 0.171797

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x80000001011717f0

4 ETW000 744 0.172541

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

4 ETW000 158 0.172699

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1045 69 0.172768

4 ETW000 [dev trc ,00000] Try to connect with default password 222 0.172990

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

4 ETW000 87 0.173077

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

4 ETW000 89 0.173166

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x800000010115d040 0x800000010116fa8

8 0x800000010116f420

4 ETW000 89 0.173255

4 ETW000 [dev trc ,00000] Allocating server context handle 51 0.173306

4 ETW000 [dev trc ,00000] Attaching to DB Server SRG (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0)

4 ETW000 95 0.173401

4 ETW000 [dev trc ,00000] Wed Oct 28 20:16:02 2009 91263 0.264664

4 ETW000 [dev trc ,00000] Assigning server context 0x80000001011717f0 to service context 0x800000010116f350

4 ETW000 96 0.264760

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

4 ETW000 82 0.264842

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

4 ETW000 128 0.264970

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0,usrhp=0x800000010

117a9c0)

4 ETW000 148 0.265118

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

4 ETW000 10110 0.275228

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

4 ETW000 109654 0.161832

4 ETW000 [dev trc ,00000] Allocating user session handle 133 0.161965

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0,usrhp=0x800000010

117a9c0)

4 ETW000 97 0.162062

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

4 ETW000 9573 0.171635

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x80000001011717f0)

4 ETW000 80 0.171715

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0)

4 ETW000 82 0.171797

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x80000001011717f0

4 ETW000 744 0.172541

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

4 ETW000 158 0.172699

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1045 69 0.172768

4 ETW000 [dev trc ,00000] Try to connect with default password 222 0.172990

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

4 ETW000 87 0.173077

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

4 ETW000 89 0.173166

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x800000010115d040 0x800000010116fa8

8 0x800000010116f420

4 ETW000 89 0.173255

4 ETW000 [dev trc ,00000] Allocating server context handle 51 0.173306

4 ETW000 [dev trc ,00000] Attaching to DB Server SRG (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0)

4 ETW000 95 0.173401

4 ETW000 [dev trc ,00000] Wed Oct 28 20:16:02 2009 91263 0.264664

4 ETW000 [dev trc ,00000] Assigning server context 0x80000001011717f0 to service context 0x800000010116f350

4 ETW000 96 0.264760

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

4 ETW000 82 0.264842

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

4 ETW000 128 0.264970

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x800000010116f350,srvhp=0x80000001011717f0,usrhp=0x800000010

117a9c0)

4 ETW000 148 0.265118

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

4 ETW000 10110 0.275228

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

4 ETW000 88 0.275316

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

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

4 ETW000 649 0.276018

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

4 ETW000 85 0.276103

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

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

sunny_pahuja2
Active Contributor
‎10-28-2009 8:30 PM
0 Kudos

Hi,

Check this [link|http://sap.ittoolbox.com/groups/technical-functional/sap-basis/dispwork-stopping-2864034]

Thanks

Sunny

Show replies
Show replies

Answers (1)

Answers (1)

former_member1190121
Explorer
‎10-28-2009 10:51 PM
0 Kudos

Hi,

This error indicated user authentication problem.

Please check OPS$ & SAP<SID> users in your database.

One of this users might be locked or passoword changed.

Please check the following link.

http://www.cryer.co.uk/brian/oracle/ORA01017.htm

Thanks & Regards,

nagarjun.

Show replies
Show replies
Former Member
‎10-30-2009 8:28 PM
0 Kudos

Issue has been resolved.

Ask a Question