cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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'"

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

It seems you need to change the password of DB user id from BRTools. Have you tried to change password of DB user id from SQL? If yes then you need to change it from BRtools so that it will get updated it SAPUSER table.

Check Below link.It may help you

Refer SAP note 400241 & 50088

Hope it helps

Thanks

Sushil

Former Member
0 Kudos

Hi Sushil,

through BRtools i tried to change the password but i am getting

the below error for this.

1 - BRCONNECT profile (profile) ............... [initBSD.sap]

2 - Database user/password (user) ............. [/]

3 ~ Database owner to change password (owner) . [sapbsd]

4 - Message language (language) ............... [E]

5 - BRCONNECT command line (command) .......... [-p initBSD.sap -l E -f chpass -o sapbsd]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2009-06-16 14.43.15

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRCONNECT will be started with options '-p initBSD.sap -l E -f chpass -o sapbsd'

BR0280I BRTOOLS time stamp: 2009-06-16 14.43.15

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2009-06-16 14.43.17

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

exec(): 0509-036 Cannot load program brconnect because of the following errors:

0509-150 Dependent module /usr/lib/libclntsh.a(shr.o) could not be loa ded.

0509-124 The program is a discontinued 64-bit object file.

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 255

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRTOOLS time stamp: 2009-06-16 14.43.17

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

Please let me know how to resolve the issue

Former Member
0 Kudos

Hi,

Please follow belw path

Brtools>8 - Additional functions>4 - Change password of database user-->

3 ~ Database owner to change password (owner)>Here Put your Schema Owner ( SAPBSD or SAPR3 etc)> C ( Continue)>Enter new password>C

Check below link which explain same error

May be you need to upgrade you Brtools patch level.

What is your DB release & What is your BRtools patch level.?

If your OS is AIX check Note 454050 - AIX: Member ansi_64.o is not found in archive

Thanks

Sushil

Edited by: Sushil Suryawanshi on Jun 16, 2009 4:14 PM

Former Member
0 Kudos

Hi

Try this

SQL> select username, account_status from dba_users;

if password change is required, use BR*tools only.

brconnect -c -u / -f chpass -o SYSTEM -password WhaTeVeR

It explain the use of OPS$ user

http://www.sap-img.com/basis/information-on-how-the-ops-users-work.htm

Read,

http://help.sap.com/saphelp_nw70/helpdata/en/fa/bc883989676778e10000000a11402f/frameset.htm

follow the note 400241,you will be able to solve the issue,also refer to 951167

Note:Also check all your oracle services are running fine and listner service also

Regards

Uday

Uday

former_member105207
Active Participant
0 Kudos

hi Prasad,

The problem is with the OPS$-user password

ORA-01017: invalid username/password ; logon denied

check the note 400241 - Problems with ops$ or sapr3 connect to Oracle

Regards,

Chandru.