7 Replies Latest reply: Sep 16, 2010 2:11 PM by Eric Brunelle RSS

Brconnect fails :ORA-01017: invalid username/password; logon denied

Chitrangda Kandagal
Currently Being Moderated

Hi,

 

BRtools not working.

C:\Documents and Settings\r47adm>sqlplus /

 

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 14 14:31:44 2010

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

ERROR:

ORA-01017: invalid username/password; logon denied

 

Sap is able to connect with default password for schema id.

Tried the Note 400241 - Problems with ops$ or sapr3 connect to Oracle

still the brtools are failing with  ora 1017

 

Trans.log;

Logon as OPS$-user to get SAPR47's password           18  0.019364

4 ETW000  [dev trc     ,00000]  Connecting as /@R47 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000                                                                              27  0.019391

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

4 ETW000                                                                              27  0.019418

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1 000000000755F090 00000000003157A0 000000000031AF68

4 ETW000                                                                              95  0.019513

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

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

4 ETW000  [dev trc     ,00000]  Attaching to DB Server R47 (con_hdl=0,svchp=000000000031AE28,srvhp=000000000757E0E8)

4 ETW000                                                                              47  0.019598

4 ETW000  [dev trc     ,00000]  Assigning server context 000000000757E0E8 to service context 000000000031AE28

4 ETW000                                                                           35921  0.055519

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

4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=000000000031AE28,srvhp=000000000757E0E8,usrhp=0000000000315FB8)

4 ETW000                                                                              34  0.055585

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

4 ETW000                                                                           60400  0.115985

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

4 ETW000                                                                              35  0.116020

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

4 ETW000  [dev trc     ,00000]  Try to connect with default password                  56  0.116093

4 ETW000  [dev trc     ,00000]  Connecting as SAPR47/<pwd>@R47 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

Actions