cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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)

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi

1. Check R3trans -d is working or not . If you get RC 12 , then check the trans.log for error.

2. Check dba_users , if sapr3 ( or sapsr3 ) user is locked.

Are you able to login as 'sqlplus /as sysdba'

Thanks

Rishi

Former Member
0 Kudos

I faced Issue with OPS$ user mechanism in two scenario

Unable to create/delete user as identifier exceeds 30 characters

1. The installation terminates when you create the OPS$ users (step

ORADBUSER_NT_ORA)

As per SAP Note 314671 - Long WINDOWS domain names and Oracle 8.1.x or higher

Set the parameter os_authent_prefix = "" In parameter file initR47.ora

Restart the DB for parameter to take effect then continue with installation

2. the system does not start because the OPS$ users were not created correctly.

You can set the default password for SCHEMAID (SAP<SID>) in table sapuser table. Hence the work process connects with default password and you can run the system smoothly.but the brtools (brconnect DB13) will fail as they try to connect using (Connect /) ops$ user

By setting the parameter os_authent_prefix = "" and running the ORADBUSR.SQL SQL did not work.

We can avoid this by setting parameter os_authent_prefix = O$

This reduces the username by two characters (OPS$CTSGVCSAPBL09\SAPSERVICER47 to O$CTSGVCSAPBL09\SAPSERVICER47)

former_member204746
Active Contributor
0 Kudos

your hostname/server name must not be over 12 characters when on Windows.

so, you will need to change your hostname which might be easier to re-install from scratch.

audunlea_hansen
Active Participant
0 Kudos

When You are loged in as sysdba ( sqlplus /nolog conn / as sysdba ), do a check to see if some accounts are locked.

select * from dba_users where account_status!='OPEN';

Unlock the sap-account that are locked timed with:

alter user &db_user account unlock;

As <sid>adm, test 'R3trans -d -v' Hopefully You'll get returncode 00 -> OK

Regards

Audun

former_member204746
Active Contributor
0 Kudos

1. make sure that Windows servcie ORacleSErviceR47 is started

2. does this command work:

sqlplus / as sysdba

Former Member
0 Kudos

Hello,

Just try importing the latest SAPDBA role accroding to SAP Note 134592.

Also check the permissions of BR*Tools accroding to SAP Note 113747.

Regards,

Yoganand.V

Former Member
0 Kudos

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

I think that's the right approach.

But what exactly do you mean by Tried ?

For example, the note will direct you to other notes, like

Note 50088 - Creating OPS$ users on Windows NT/Oracle

Did you try that as well ?

(And yes, the note is valid, even if your Windows isn't NT.)