Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Brconnect failed with error ORA-01031: insufficient privileges

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 (12652 B)
Tags:
Not what you were looking for? View more on this topic or Ask a question