on 03-16-2012 2:02 PM
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
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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:
Regards,
Marcos
Hi,
check this note
Note 534765 - db connect fails because of wrong db schema in environment
Regards,
Venkata S Pagolu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.