Brconnect failed with error ORA-01031: insufficient privileges

[former_member117942]

Hi all,

I've migrated our SAP Netweaver System 7.0 on W2003 64 bit Oracle 10g to the new platform W2008R2 and Oracle 11.2.0.3.

SAP system is working fine but sometimes from DB13 we got errors from BRCONNECT (checkdb or update statistics) like this reported below:

Detail log:                    ceicohwe.chk

BR0801I BRCONNECT 7.20 (22)
BR0805I Start of BRCONNECT processing: ceicohwe.chk 2012-03-16 07.30.36
BR0484I BRCONNECT log file: O:\oracle\BWP\sapcheck\ceicohwe.chk
BR0280I BRCONNECT time stamp: 2012-03-16 07.30.40
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
BR0806I End of BRCONNECT processing: ceicohwe.chk 2012-03-16 07.30.40
BR0280I BRCONNECT time stamp: 2012-03-16 07.30.40
BR0804I BRCONNECT terminated with errors

Error is random; sometimes it goes fine sometimes no.

I've checked notes regarding this error but it seems well configured.

Kernel is updated --> patch level 333

S:\>disp+work

--------------------
disp+work information
--------------------

kernel release                700

kernel make variant          700_REL

compiled on                  NT 5.2 3790 Service Pack 2 x86 MS VC++ 14.00 for NTAMD64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  Dec 23 2011 23:11:37

update level                  0

patch number                  333

source id                    0.333

---------------------
supported environment
---------------------

database (SAP, table SVERS)  700

operating system
Windows NT 5.0
Windows NT 5.1
Windows NT 5.2
Windows NT 6.0
Windows NT 6.1

I've also attached the trans.log where it seems working fine.

Any idea ?

Thanks

  Maurizio Manera

trans.txt.zip

[Former Member]

Hello.

I had the same error but I ran this grant and my problems was solved, the Oracle versión that I have is 11.2.0.3

The roles are:.

grant ALL on SAPP10.SDBAH to
sapdba;

grant ALL on SAPP10.SDBAD to
sapdba;

grant ALL on SAPP10.DBAML to
sapdba;

grant ALL on SAPP10.DBARCL to sapdba;

grant ALL on SAPP10.DBAFID to
sapdba;

grant ALL on SAPP10.DBAEXTL to sapdba;

grant ALL on SAPP10.DBAREOL to
sapdba;

grant ALL on SAPP10.DBABARL to
sapdba;

grant ALL on SAPP10.DBADFL to
sapdba;

grant ALL on SAPP10.DBAOPTL to
sapdba;

grant ALL on SAPP10.DBASPAL to
sapdba;

grant ALL on SAPP10.DBABD to
sapdba;

grant ALL on SAPP10.DBABL to
sapdba;

grant ALL on SAPP10.DBATL to
sapdba;

grant ALL on SAPP10.DBAOBJL to
sapdba;

grant ALL on SAPP10.DBAPHAL to
sapdba;

grant ALL on SAPP10.DBAGRP to
sapdba;

grant ALL on SAPP10.DBAERR to
sapdba;

grant ALL on SAPP10.DBATRIAL to sapdba;

grant ALL on SAPP10.DBSTATC to
sapdba;

grant ALL on SAPP10.DBSTATTORA
to sapdba;

grant ALL on SAPP10.DBSTATIORA
to sapdba;

grant ALL on SAPP10.DBSTATHORA
to sapdba;

grant ALL on SAPP10.DBSTAIHORA
to sapdba;

grant ALL on SAPP10.DBMSGORA
to sapdba;

[Former Member]

Hi,

Check this notes as well

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

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

Note 761745 - Oracle 9: ORA-01031 and ORA-06512 with DBMS_STATS

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

Regards,

Venkata S Pagolu

[former_member117942]

Hi all,

I've already checked these notes.

If you analyze trans.log you can see a correct configuration of SAP /Oracle Environment and OPS$ user.

For a  test I've scheduled every our a checkdb from DB13 and all job work fine but sometimes return errror reported in the message:

JOB LOG

18.03.2012 13:00:13 Job started

18.03.2012 13:00:13 Step 001 started (program RSDBAJOB, variant &0000000000421, user ID SMADMIN)

18.03.2012 13:00:13 Execute logical command BRCONNECT On host sapvbwp

18.03.2012 13:00:13 Parameters: -u / -jid CHECK20120317130000 -c -f check

18.03.2012 13:00:14 BR0801I BRCONNECT 7.20 (22)

18.03.2012 13:00:14 BR0805I Start of BRCONNECT processing: ceiczgsz.chk 2012-03-18 13.00.13

18.03.2012 13:00:14 BR0484I BRCONNECT log file: O:\oracle\BWP\sapcheck\ceiczgsz.chk

18.03.2012 13:00:14 BR0280I BRCONNECT time stamp: 2012-03-18 13.00.14

18.03.2012 13:00:14 BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:

18.03.2012 13:00:14 'CONNECT / AT PROF_CONN IN SYSOPER MODE'

18.03.2012 13:00:14 ORA-01031: insufficient privileges

18.03.2012 13:00:14 BR0303E Determination of Oracle version failed

18.03.2012 13:00:14

18.03.2012 13:00:14 BR0806I End of BRCONNECT processing: ceiczgsz.chk2012-03-18 13.00.14

18.03.2012 13:00:14 BR0280I BRCONNECT time stamp: 2012-03-18 13.00.14

18.03.2012 13:00:14 BR0804I BRCONNECT terminated with errors

18.03.2012 13:00:14 External program terminated with exit code 3

18.03.2012 13:00:14 BRCONNECT returned error status E

18.03.2012 13:00:14 Job finished

ACTION LOG

Detail log:                    ceiczgsz.chk

BR0801I BRCONNECT 7.20 (22)
BR0805I Start of BRCONNECT processing: ceiczgsz.chk 2012-03-18 13.00.13
BR0484I BRCONNECT log file: O:\oracle\BWP\sapcheck\ceiczgsz.chk
BR0280I BRCONNECT time stamp: 2012-03-18 13.00.14
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
BR0806I End of BRCONNECT processing: ceiczgsz.chk 2012-03-18 13.00.14
BR0280I BRCONNECT time stamp: 2012-03-18 13.00.14
BR0804I BRCONNECT terminated with errors

Do you know the reason for which sometimes job does not run ?

Thanks.

Maurizio

[prego]

Hello,

I had this problem too, on a system which was moved to a new hardware. It seems that during the move some steps were forgotten or failed and I needed to rerun the scripts sapdba_role.sql and sapconn_role.sql, which solved the problem.

For additional info about the sql scripts check following notes:

• Note 134592 - Importing the SAPDBA role (sapdba_role.sql)
• Note 834917 - Oracle Database 10g: New database role SAPCONN

Regards,

Marcos

[Former Member]

Hello,

1. You did not create the SAPDBA role during an SAP/Oracle upgrade, as

outlined in the upgrade instructions.

2.  the database authorizations have not been adjusted.

3. The database grants were deleted.

so implement the sap note 134592 to over come the db problems.

thanks

Muralidhar

[Former Member]

Hi,

check this note

Note 534765 - db connect fails because of wrong db schema in environment

Regards,

Venkata S Pagolu