on 08-27-2014 10:07 AM
Hi,
When attempting to run a Check DB via DB13 I get the following error:
BR0801I BRCONNECT 7.20 (22)
BR0805I Start of BRCONNECT processing: ceoppnld.chk 2014-08-27 09.55.25
BR0484I BRCONNECT log file: N:\oracle\bwq\sapcheck\ceoppnld.chk
BR0280I BRCONNECT time stamp: 2014-08-27 09.55.26
BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:
'CONNECT / AT PROF_CONN IN SYSOPER MODE'
ORA-01031: insufficient privileges
BR0303E Determination of Oracle version failed
BR0806I End of BRCONNECT processing: ceoppnld.chk 2014-08-27 09.55.26
BR0280I BRCONNECT time stamp: 2014-08-27 09.55.26
BR0804I BRCONNECT terminated with errors
I have followed Note 134592: Importing the SAPDBA role (sapdba_role.sql) but problem still exists.
There are plenty of other examples of ORA-01031 errors online but as yet I haven't found a solution.
I'm far from an expert on this subject so was hoping for a little bit of assistance from someone.
Thanks
Oracle: 11.2.0.1.0
You have a Windows system so permission of the BR*Tools files does not apply here.
Try updating the BR*Tools and then execute the sapdba_role.sql
Check this SAP note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role
I would check whether the OPS$ users are created properly.
Refer this SAP note 400241 - Problems with ops$ or sapr3 connect to Oracle
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Paul,
Kindly check the permissions in the kernel for executing the brtools operations.
The permissions should be like below:
-rwsrwxr-x 1 ora<SID> sapsys brarchive
-rwsrwxr-x 1 ora<SID> sapsys brbackup
-rwsrwxr-x 1 ora<SID> sapsys brconnect
-rwxrwxr-x 1 <SID>adm sapsys brrecover
-rwxrwxr-x 1 <SID>adm sapsys brrestore
-rwxrwxr-x 1 <SID>adm sapsys brspace
-rwsrwxr-x 1 ora<SID> sapsys brtools
Regards,
Meenu Hans
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Paul,
To begin with use below SAP notes to troubleshoot
Note 776505 - BR*Tools fail with ORA-01017 / ORA-01031 on Linux
Note 480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect
Regards,
Deepak Kori
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 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.