cancel
Showing results for 
Search instead for 
Did you mean: 

SQL error -1017 at location db_connect-2

Former Member
0 Kudos

I scheduled Check and update optimizer statistics job in DB13 and I get this error msg.

BR0301E SQL error -1017 at location db_connect-2

ORA-01017: invalid username/password; logon denied

Connect to database instance BQ1 failed.........

............................................

BRCONNECT returned error status E

However, when i run the stats through BRTOOLS from the O.S. level it runs fine.

Any help would be appreciated.

Thanks.

Shawn

Message was edited by:

shahid kizilbash

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

answered

Former Member
0 Kudos

Hello Shawn,

Besides the previous comments, you can also check if the ownership and permissions of the BR*Tools are correct on OS level (note 113747 for reference).

Regards,

Alfonso

Former Member
0 Kudos

Alfanso,

The permissions are set right. I checked that.

Thanks though..

Former Member
0 Kudos

400241 This note talks about the error which u have.

The following three SAP Notes already mentioned describe the cause

and solution for ORA-01017 and setting up the OPS$ mechanism.

400241 Problems with ops$ or sapr3 connect to Oracle

134592 Importing the SAPDBA role ( sapdba_role.sql)

50088 Creating OPS$ users on Windows NT/Oracle

You run the sapdba_role.sql (as mentioned in the note 134592) once you

have created the OPS$ user.

Thanks

Subbu

Former Member
0 Kudos

Thanks a lot Subbiah.

l am going through all these notes. Hopefully i should be able to fix it.

shahid.

former_member204746
Active Contributor
0 Kudos

search this forum to know how to run oradbusr.sql if previous answer fails.