Skip to Content
0
Former Member
Jun 16, 2009 at 04:52 AM

2EETW169 no connect possible: "DBMS = ORACLE ::::::R3trans finished (0012)

2439 Views

Hello All,

I am unable to login to my System because of some issue. Please read the below trans.log file summary and let me know the problem solution.

bsdadm> more trans.log

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

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

4 ETW000

4 ETW000 date&time : 16.06.2009 - 10:03:10

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] Tue Jun 16 10:03:10 2009

110 0.000110

4 ETW000 [dev trc ,00000] db_con_init called

12 0.000122

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

61 0.000183

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/BSD/SYS/exe/run/dbo

raslib.o' ...

4 ETW000

48 0.000231

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/BSD/SYS/exe/run/db

oraslib.o), hdl 0

4 ETW000

13075 0.013306

4 ETW000 [dev trc ,00000] Library '/usr/sap/BSD/SYS/exe/run/dboraslib.o' l

oaded

4 ETW000

22 0.013328

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sa

p/BSD/SYS/exe/run/dboraslib.o

4 ETW000

51 0.013379

4 ETW000 [dev trc ,00000] Version of '/usr/sap/BSD/SYS/exe/run/dboraslib.o

' is "640.00", patchlevel (0.220)

4 ETW000

114 0.013493

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/s

ap/BSD/SYS/exe/run/dboraslib.o

4 ETW000

20 0.013513

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/

sap/BSD/SYS/exe/run/dboraslib.o

4 ETW000

41 0.013554

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

16 0.013570

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCO

NNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, oc

c = NO

4 ETW000

24 0.013594

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

52 0.013646

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

for reuse:

4 ETW000

38 0.013684

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCON

NECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ

= NO

4 ETW000

21 0.013705

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/BSD/920_64 from environm

ent

4 ETW000

450 0.014155

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

78 0.014233

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

ronment

4 ETW000

35 0.014268

4 ETW000 [dev trc ,00000] Tue Jun 16 10:03:11 2009

4342 0.018610

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

20 0.018630

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

34 0.018664

4 ETW000 [dev trc ,00000] Connecting as /@BSD on connection 0 (nls_hdl 0)

... (dbsl 640 070208)

4 ETW000

53 0.018717

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet

C EnvHp ErrHp ErrHpBatch

4 ETW000

54 0.018771

4 ETW000 [dev trc ,00000] 0 WE8DEC

1 110ca9920 110cb2b60 110cb2418

4 ETW000

41 0.018812

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

13 0.018825

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

42 0.018867

4 ETW000 [dev trc ,00000] Attaching to DB Server BSD (con_hdl=0,svchp=110c

b5838,srvhp=110cb5a58)

4 ETW000

77 0.018944

4 ETW000 [dev trc ,00000] Assigning server context 110cb5a58 to service co

ntext 110cb5838

4 ETW000

62387 0.081331

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

23 0.081354

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110cb5838

,srvhp=110cb5a58,usrhp=110cbf590)

4 ETW000

48 0.081402

4 ETW000 [dev trc ,00000] Assigning user session 110cbf590 to service cont

ext 110cb5838

4 ETW000

8258 0.089660

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:

A0, :A1); END;

4 ETW000

53 0.089713

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_IN

FO (:A0); END;

4 ETW000

59 0.089772

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000

959 0.090731

4 ETW000 [dev trc ,00000] Connected to session 10.

694 0.091425

4 ETW000 [dev trc ,00000] Now '/@BSD' is connected: con_hdl=0, nls_hdl=0,

session_id=10.

4 ETW000

42 0.091467

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000

25 0.091492

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE U

SERID IN (:A0, :A1)

4 ETW000

601 0.092093

4 ETW000 [dev trc ,00000] Got SAPBSD's password from OPS$-user

974 0.093067

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ...

32 0.093099

4 ETW000 [dev trc ,00000] Rolling back transaction ...

52 0.093151

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=110cb5838,us

rhp=110cbf590)

4 ETW000

327 0.093478

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE

511 0.093989

4 ETW000 [dev trc ,00000] Connecting as SAPBSD/<pwd>@BSD on connection 0 (

nls_hdl 0) ... (dbsl 640 070208)

4 ETW000

23 0.094012

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet

C EnvHp ErrHp ErrHpBatch

4 ETW000

22 0.094034

4 ETW000 [dev trc ,00000] 0 WE8DEC

1 110ca9920 110cb2b60 110cb2418

4 ETW000

41 0.094075

4 ETW000 [dev trc ,00000] Assigning username to user session 110cbf590

30 0.094105

4 ETW000 [dev trc ,00000] Assigning password to user session 110cbf590

16 0.094121

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110cb5838

,srvhp=110cb5a58,usrhp=110cbf590)

4 ETW000

20 0.094141

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

rc = 1017

4 ETW000

11649 0.105790

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

'

4 ETW000

23 0.105813

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

33 0.105846

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1017 performing CON [dbl

ink#3 @ 428]

4 ETW000

52 0.105898

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-01017: invalid username/password

; logon denied [dblink#3 @ 428]

4 ETW000

19 0.105917

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'BSD'"