Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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)

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question