cancel
Showing results for 
Search instead for 
Did you mean: 

BR0301E SQL error -1031

former_member239281
Participant
0 Kudos

Hi all,

we get this error aftter importing sapdba role according note 134592, all requirements according note 834917 are met. It works with ops$, with ORASID, but not for SIDADM !

brconnect -u / -f check works also

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

BR0002I BRARCHIVE 7.20 (6)

BR0006I Start of offline redolog processing: aeeicwva.svd 2010-10-12 16.49.46

BR0484I BRARCHIVE log file: /oracle/SOL/saparch/aeeicwva.svd

BR0280I BRARCHIVE time stamp: 2010-10-12 16.49.47

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

BR0007I End of offline redolog processing: aeeicwva.svd 2010-10-12 16.49.47

BR0280I BRARCHIVE time stamp: 2010-10-12 16.49.47

BR0005I BRARCHIVE terminated with errors

Thanks in advance

Thomas

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

your brconnect -u / -f check will not work if you run as <SID>adm. please check note 400241

former_member239281
Participant
0 Kudos

Hi Sunil,

brconnect -u / -f check works fine as SIDADM

Kind regards

Thomas

Former Member
0 Kudos

have you executed the sapdba_role.sql as below?

sqlplus /nolog @sapdba_role.sql <SID> <- -- For ABAP sceham

sqlplus /nolog @sapdba_role.sql <SID>DB <- - -For Java Schema

former_member239281
Participant
0 Kudos

Yes I did

Kind regards

Thomas

Former Member
0 Kudos

which OS?

looks like you have configured your redo log backup from DB13. Just for testing can you please run the same command from OS?

former_member204746
Active Contributor
0 Kudos

add user "sidadm" in group "dba" in file /etc/group.

then, try again.

former_member239281
Participant
0 Kudos

cscappwin024:/etc # cat SuSE-release

SUSE Linux Enterprise Server 10 (x86_64)

VERSION = 10

PATCHLEVEL = 3

cscappwin024:soladm 52> brarchive -u / -c force -p initSOL.sap -sd

BR0002I BRARCHIVE 7.20 (6)

BR0006I Start of offline redolog processing: aeeirbat.svd 2010-10-15 13.58.23

BR0484I BRARCHIVE log file: /oracle/SOL/saparch/aeeirbat.svd

BR0280I BRARCHIVE time stamp: 2010-10-15 13.58.23

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

BR0007I End of offline redolog processing: aeeirbat.svd 2010-10-15 13.58.23

BR0280I BRARCHIVE time stamp: 2010-10-15 13.58.23

BR0005I BRARCHIVE terminated with errors

Kind regards

Thomas

former_member239281
Participant
0 Kudos

Hi Eric,

SIDADM is allready in group dba.

Kind regards

Thomas

Former Member
0 Kudos

Do you have the same issue for brbackup?

former_member239281
Participant
0 Kudos

yes, the same

kind regards

Thomas

Former Member
0 Kudos

Try Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

former_member239281
Participant
0 Kudos

Allready tried without success

Kind regards

Thomas

Former Member
0 Kudos

oh! I suggest rasie SAP OSS message.

former_member204746
Active Contributor
0 Kudos

set BR_TRACE to 15 (OS level)

run brarchive again

you will have tons of detailed logs.

find the SQL request that fails.

former_member239281
Participant
0 Kudos

no success at all - raised OSS Call

thanks all for supporting me

Kind regards /Thomas

Former Member
0 Kudos

When you get response from SAP then please poste the resolution here, so that others can help.

Mean time you make sure you trigger the online backup manually.

former_member239281
Participant
0 Kudos

$ORACLE_HOME/rdbms/lib/config.c was not properly set

#define SS_OPER_GRP "dba"

according note 480266 / 8 solved

Thanks all for supporting me

Thomas

Former Member
0 Kudos

Hi Thomas,

If you are trying to start the brconnect from the user SIDADM it is not recomended by SAP.

Always oracle related activities you have run using the oraSID user only.

But only when you are scheduling from the DB13 that time if you are getting pelase make sure that do u have set the environment variable ORACLE_SID=SID is set for the user SIDADM or not.

If not please set it correctly and the try to run once again.

thanks,

Chaitanya

former_member239281
Participant
0 Kudos

Hi Chaitanya,

ORACLE_SID is set for SIDADM.

Kind regards

Thomas

Former Member
0 Kudos

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