Problem with Oracle 10.1.0.5 and Brarchive

[Former Member]

When I try to start an archive run using dataprotector, I get the following output:

BR0002I BRARCHIVE 7.00 (18)

BR0006I Start of offline redo log processing: adtsqkfw.sve 2006-10-16 15.59.28

BR0280I BRARCHIVE time stamp: 2006-10-16 15.59.29

BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:

'CONNECT system/********* AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0007I End of offline redo log processing: adtsqkfw.sve 2006-10-16 15.59.29

BR0280I BRARCHIVE time stamp: 2006-10-16 15.59.29

BR0005I BRARCHIVE terminated with errors

Does anybody know what causes this error? As far as I can see, the SAPDBA_ROLE is okay. User system has DBA, SAPDBA, CONNECT, RESOURCE, MGNT_USER and AQ_ADMINISTRATOR_ROLE assigned. A straight connect from SQLPlus with user SYSTEM and it's password is successfull:

SQL> connect system/********

Connected.

SQL>

SQL>

SQL> connect system/********@<SID>

Connected.

Please let me know when you've seen this before and know how to fix this.

Best regards, Wilbert

[oliver_wriedt · Accepted solution]

Create the group oper on OS and add user <SID>ora to it.

This solved the problem for me.

Regards

Oliver

[Former Member · Accepted solution]

Thanx Oliver, I switched from one node of the cluster to another and there it was... I had no synchronized /etc/group files and on the active node the group oper was missing... Thanx for your help...

[Former Member · Accepted solution]

Adding oper group to <SID>adm user did solve my problem. I also had to apply note 917293 for the next error message I got

[Former Member]

Hi,

Are you trying to start brarchive with the oraSID user?

If yes, then this user doesnt seem to have the correct rights.

Please check the /etc/groups file to make sure that oraSI belongs to teh right group.

[Former Member]

Brarchive is started with user system from dataprotector. User SIDADM is member of all the ORA_* and SAP_* groups on OS level (platform is Windows).