Brarchive fails with ORA-01031: insufficient privileges

[Former Member]

Hi Gurus,

I have a system on which brarchive is failing with the message

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

The oracle version is 11.2.0.2 and we are running on Linux 2.6.18

The SAP<SID> and ora<sid> are included in the dba and oper group .

i have recreated the sapconn role as per the relevant SAP notes and ran the sapdba_role.sql for oracle 11 but still the same issue .

the permissions for brarchive is set correctly .

I have checked the notes 480266 and 1028220 but those didnt help.

What am i missing here ?

sqlplus "/nolog"

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 29 21:50:46 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect as sysoper
Enter user-name: sap<sid>
Enter password:
ERROR:
ORA-01031: insufficient privileges

[Former Member]

Hi,

Check SAP Note 113747 and correct the file permissions.

Regards,

Nick Loy

[Former Member]

Hi Suneeth,

You have to follow the note SNOTE    400241 - Problems with ops$ or sapr3 connect to Oracle.

Recently we had the same problem and solved by the same note.Check once again.

regards,

Suresh Daniel.

[willi_eimler]

Hi Suneeth,

you wrote:

I have checked the notes 480266 and 1028220 but those didnt help.

did you check:

834917 - Oracle Database 10g: New database role SAPCONN

Best regards

Willi Eimler

[chl_supporthotlinerte]

Hi,

its  an OS issue.

<sid>adm must have group sapsys, dba and oper

[Former Member]

Hi

After login the ora<sid> user please check the below command

sqlplus / as sysdba

its worrk or not.

[Former Member]

Its a OS level user: group issue. Check BR related files owner and permission that will fix the issue.

[werner_flamme]

Hi Suneeth,

we had this problem with an incorrect ORACLE_HOME on DB releases 11.2.0.2 and 11.2.0.3. Per default, ORACLE_HOME points to /oracle/SID/112_64. This is a symlink to /oracle/SID/1120{2,3}.

We had to set ORACLE_HOME to /oracle/SID/11203 directly to get BRTOOLS to work again. The reason for this might be (I've been told by the DB admin) the Oracle setup writes /oracle/SID/11203 into some database metadata file, and the variable has to be identical to this entry.

Regards,

Werner

[ashish_mishra2]

Suneeth Pillai wrote:
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

Hi Suneeth,

For above mentioned error point #3 mentioned in SAP : Note 776505 - BR*Tools fail with ORA-01017 / ORA-01031 on Linux is applicable.

Symptom:

3. BRBACKUP or BRARCHIVE fail with ORA-01031 during an attempt to connect to the database using the SYSOPER authorization, for example:BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:'CONNECT / AT PROF_CONN IN SYSOPER MODE'ORA-01031: insufficient privilegesBR0303E Determination of Oracle version failed

Solution: Please refer above mentioned SAP Note.

Cheers !!!

Ashish

[Former Member]

Hi Ashish ,

I compared the permissions for the br* executables with an other system on which the backup is running fine and also ran saproot.sh and oraroot.sh .

The permissions are set fine

Also, the note mentions that

Caution: Only implement this change if you are carrying out RMAN backups under the user <sapsid>adm

We are not using RMAN backups .

[former_member182034]

hi Suneeth,

Please have a look at following note. It might be helpful to resolve the ORA-01031: insufficient privileges

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

Note 91216 - BRBACKUP/SAPDBA: ORA-01031 Insufficient privileges

Note 900525 - BRCONNECT fails with ORA-01031 at location BrDdartRead-1

Regards,

[former_member188883]

Hi Suneeth,

Could you check whether this command works

sqlplus "/as sysdba"

Additionally check this SAP note

361641

Creating OPS$ users on UNIX

Regards,

Deepak Kori

[Former Member]

Hi Deepak ,

Thanks for the reply.

The command works fine .

I also checked the note and the OPS$ users are created correctly

The SAP system works fine, the R3trans -d command doesnt put out any errors.

The backup runs fine if i run it using the SYSTEM user

It seems that the Schema owner is missing the sysoper privelege and a way to add that would be using a oracle password file.

However, there was never a password file created on the system and this problem started recently.

I am curious as to how the schema owner is lacking this privelege and what can be done to fix it

[former_member184473]

Hello Suneeth,

Have you create the ops$ users?

Have you implemented profile SAPUPROF (note 1627312)?

Have you search for old threads?

http://scn.sap.com/thread/3146283

http://scn.sap.com/thread/1192924

Regards,

Eduardo Rezende

[Former Member]

Hi Eduardo,

Thanks for the reply .

The OPS$ users are fine , the SAP system runs fine and R3trans gives a return code 0 .

The dba_users have a non expiring password and are not locked .

I checked the threads you mentioned

The 1st one mentions about SAPDBA role which i have already adjusted

The 2nd one about the Synonyms which are correctly created in my system

What else am i missing ?

Regards,

Suneeth