backup failure

[Former Member]

Hi All,

i have recently done the oracle database upograde from 9.2.0.8 to 10.2.0.4.I have verified the notes 113747-permissions for SAPDBA tools.Now, while scheduling the backup  via DB13 am getting the below error.

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

Below are the permissions of brtools and i have upgraded the brtools version from 6.40(52) to 7.00(52)

-rwsrwxr-x   1 oraxxx   dba	4707352 Jan 31  2010 brbackup
-rwxr-xr-x   1 oraxxx   dba	2506112 Mar  5  2011 brrestore

-rwsrwxr-x   1 xxxadm   sapsys   5829088 Mar  6  2011 brarchive

-rwsrwxr-x   1 oraxxx  dba	7866080 Mar  6  2011 brconnect
-rwxr-xr-x   1 oraxxx   dba	6351416 Mar  6  2011 brrecover
-rwxr-xr-x   1 oraxxx  dba	8189184 Mar  6  2011 brspace
-rwsr-xr-x   1 oraxxx  dba	3119456 Mar  6  2011 brtools

lrwxrwxrwx   1 xxxadm   sapsys

32 Mar  1  2006 backint -> /usr/openv/netbackup/bin/backint

Kindly provide me your inputs

[JPReyes · Accepted solution]

You need to run the sapdba_role.sql and the sapconn_role.sql to set the permissions

Use,

sqlplus /nolog @sapconn_role.sql <schemaID>

sqlplus /nolog @sapdba_role.sql <schemaID>

Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

Note 834917 - Oracle Database 10g: New database role SAPCONN

Regards,

Juan

[Former Member · Accepted solution]

Hi Juan,

Thanks for your support at the critical phase .I went through the notes given  and it helped me a little bit .Again , i triggered the backup via db13, it failed.

Then referred the note 480266 where it tells exactly on this error ORA -01031 .I have added the ora<sid>,<sid>adm to the oper and dba in /etc/group that is added the domain user  in the local group and started the backup via DB13 and it got completed successfully.

Thanks for valuable support at my critical time

Regards

Ram

[Former Member]

Hi All,

i have changed the permissions as per the note 113747 and tried the backup, but it failed.