2EETW169 no connect possible: "DBMS = ORACLE ::::::R3trans finished (0012)
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'"