Skip to Content
0
Mar 16, 2012 at 02:02 PM

Brconnect failed with error ORA-01031: insufficient privileges

1495 Views

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

Attachments

trans.txt.zip (12.7 kB)