on 08-02-2007 10:26 PM
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
answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.