cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01031: Insufficient Privledges

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Reagan
Advisor
Advisor
0 Kudos

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

0 Kudos

Thanks Reagen for correcting the same.

Regards,

Meenu Hans

0 Kudos

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

former_member188883
Active Contributor
0 Kudos

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