BRARCHIVE - ORA-01031: insufficient privileges Error

[Former Member]

Hi,

I am getting following error while backing up oracle archive log file.

BR0002I BRARCHIVE 7.00 (22)

BR0006I Start of offline redo log processing: advgvlaz.svd 2007-05-17 00.03.57

BR0484I BRARCHIVE log file: /oracle/BXN/saparch/advgvlaz.svd

BR0477I Oracle pfile /oracle/BXN/102_64/dbs/initBXN.ora created from spfile /oracle/BXN/102_64/dbs/spfi

leBXN.ora

BR0280I BRARCHIVE time stamp: 2007-05-17 00.03.58

BR0301W SQL error -1031 at location BraDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20070517000357', 'svd',

'BXN', 'disk', '9999', ' ', 'advgvlaz', ' ')'

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0101I Parameters

Name Value

oracle_sid BXN

oracle_home /oracle/BXN/102_64

oracle_profile /oracle/BXN/102_64/dbs/initBXN.ora

sapdata_home /oracle/BXN

sap_profile /oracle/BXN/102_64/dbs/initBXN.sap

backup_dev_type disk

archive_copy_dir /oracle/BXN/sapbackup

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

archive_dupl_del only

system_info orabxn/orabxn cpsapv08 HP-UX B.11.23 U ia64

oracle_info BXN 10.2.0.2.0 8192 364 8385422911885 cpsapv08 UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003BXN0011C16913853470013NetWeaver_ORA

make_info hpia64 OCI_102 Jan 20 2007

command_line /usr/sap/BXN/SYS/exe/run/brarchive -p initBXN.sap -u / -c -sd -d disk

BR0280I BRARCHIVE time stamp: 2007-05-17 00.03.58

BR0301W SQL error -1031 at location BraDbLogOpen-6, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, OBJ, RC, ENDE, ACTID) VALUES ('20070516233347', 'sve', 'tape', '999

9', ' ', 'advgvijj')'

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0013W No offline redo log files found for processing

BR0280I BRARCHIVE time stamp: 2007-05-17 00.03.58

BR0301W SQL error -1031 at location BraDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20070517000357', 'svd',

'BXN', 'disk', '9999', ' ', 'advgvlaz', ' ')'

ORA-01031: insufficient privileges

I have already run sapdba_role.sql and sapconn_role.sql on the database for the SAPSID accounts but I am still getting this error. Before it was working fine. This is not working since this database has been system copied from production.

Can somebody please help?

Regards

[Former Member]

Execute the sql script sapdba_role.sql according to sap note 134592.

You can find the script at /oracle/<SID>/102_64/dbs/ or the note.

[Former Member]

Hi,

I'll try to give a some hints to check as a lot of people here are ( IMHO ) giving non correct advice.

you are getting the following error:

<i>BR0301W SQL error -1031 at location BraDbLogOpen-6, SQL statement:

'INSERT INTO <b>SAP_SDBAH</b> (BEG, FUNCT, OBJ, RC, ENDE, ACTID) VALUES ('20070516233347', 'sve', 'tape', '999

9', ' ', 'advgvijj')'

<b>ORA-01031</b>: insufficient privileges</i>

Which is pretty clear. The user does not have authorizations to insert data in <b>SAP_SDBAH</b> ( nothing to do with the user password )

I cannot see who is the user who tries to insert ( how did you started the brarchive? )

nevertheless, <b>SAP_SDBAH</b> is NOT a table but a synonym that points to a SDBAH table ( in one specific schema ). The user does not have authorizations to insert into that table.

I'd advise to check what is the "underline" table.

Is this an MCOD system?

If so, you have to keep in mind that you will have several database users, but the synonym can only point to one of the schemas in the system. This means that you should configure the synonyms and perfom all activities ONLY on one schema ( from only one SAP system, one <sid>adm )

[former_member204746]

I believe that newest path sets of BRTOOLS have this issue.

I had the same issue and added this (on windows):

sqlplus / as sysdba

grant select on SAP_SDBAH to sapr3,sapserviceSID,SIDadm;

[Former Member]

Hi Shailandra,

Before changing the passwords, check if the database backup works and its only archivelog backup that fails. If database backup works, then it uses the same procedure to authenticate for the brarchive process.

Are you using the latest sapdba_role.sql script? The error appears to be related to privileges.

Regards,

Nisch

[Former Member]

Shailandra,

I supose that the problem is the ORA<SID> wasn't adjusted in this database.

Could you check it please?

Regards,

Itamar Marioto

[Former Member]

Hi Shailandra,

Which user are you using to execute the brarchive?

It is possible that this user does not have authorization at the Oracle schema objects level.

Please, check it.

If it do not solve your problem, let me know.

Regards,

Itamar Marioto

[Former Member]

Hi,

I am using orabxn OS userid to run the backup.

Regards

[former_member204746]

how did you execute sapdba_role and sap_conn?

please provide exact steps you took and what outputs you received.

[Former Member]

Hi,

I ran the command like this.

sqlplus /nolog @sapdba_role.sql SAPSR3

sqlplus /nolog @sapdba_role.sql SAPSR3DB

The output from the log file does not have any error.

Regards

[Former Member]

Hi

Is ur db upgraded from 9.2 ? if yes please go through these notes.

834917

91216

Thanks

Prince Jose

[Former Member]

Hi Prince,

This database is not upgraded from 9iR2. This database is already running in QA, Production. This problem is present since I did system copy from production to this database. This database is at 10.2.0.2.

Regards

[Former Member]

Hi,

Redolog files seems to be corrupted.

Try to copy them again to the target system.

If you're doing an ftp, take care to use binary mode for the file transfers.

Regards,

Gokhan

[Former Member]

Hi Gokhan,

Thanks for your reply.

This system copy was done couple of days ago (more than a week). Is it still ok to copy the redologs files from source database to this database.

Also this BXN database is generating archivelogs in /oracle/BXN/sapbackup directory instead of /oracle/BXN/oraarch directory. The log_archive_destination in the database is set to /oracle/BXN/oraarch

Regards

Message was edited by:

Shailandra Vaish

[Former Member]

Hi Shailandra,

I would like to recommend you to reset SAP's oracle users' passwords via brtools.

Regards,

Gökhan

[Former Member]

Hi Gökhan,

Should I change the password using brtools or Java interface..

Regards

[Former Member]

Hi Shailandra,

brtools should be sufficient.

Regards,

Gökhan