DB13 jobs errors (ORA-01031: insufficient privileges) after System Copy

[Former Member]

Dear SAP gurus,

I performed an ECC60 System copy from Dev to a sandbox system (Linux-Oracle). When I try to access DB13 all jobs are cancelled:

Example of "check and update optimizer statistics" job log:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000001, user ID TGEPOMA1)

Execute logical command BRCONNECT On host eccsbx01

Parameters: -u / -jid STATS20110720050000 -c -f stats -t ALL

BR0801I BRCONNECT 7.00 (46)

BR0805I Start of BRCONNECT processing: cegkmpzk.sta 2011-07-27 05.00.32

BR0484I BRCONNECT log file: /oracle/SBX/sapcheck/cegkmpzk.sta

BR0280I BRCONNECT time stamp: 2011-07-27 05.00.36

BR0301W SQL error -1031 at location brc_dblog_open-1, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20110727050032', 'sta', 'SBX', 'ALL', '9999', '

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

I read the SAP note 400241 (Problems with ops$ or sapr3 connect to Oracle) and performed the general checks such checking the SAPUSER owner,etc.

If I executed the sapdba_role.sql script I get the following log errors on sapdba_role.log:

old 1: grant ALL on &User..SDBAH to sapdba

new 1: grant ALL on SAPR3.SDBAH to sapdba

grant ALL on SAPR3.SDBAH to sapdba

*

ERROR at line 1:

ORA-00942: table or view does not exist

old 1: grant ALL on &User..SDBAD to sapdba

new 1: grant ALL on SAPR3.SDBAD to sapdba

grant ALL on SAPR3.SDBAD to sapdba

*

ERROR at line 1:

ORA-00942: table or view does not exist

old 1: grant ALL on &User..DBAML to sapdba

new 1: grant ALL on SAPR3.DBAML to sapdba

grant ALL on SAPR3.DBAML to sapdba

........

Should I create those tables in order to allow ops$ user to access Oracle DB in order to execute the DB job from DB13?

Please let me know if anybody can help me or has face a situation before?

Thanks in advance, Marc

[markus_doehr2 · Accepted solution]

Please post the output of

cdexe
ls -l br*

Markus

[Former Member · Accepted solution]

Hi Markus,

I dont think that it is an authorization issue becasue it has the same authorizations than Development:

eccsbx01:/sapmnt/SBX/exe # ls -ltr br*

-rwsr-srw- 1 orasbx dba 4121272 Jul 19 11:55 brarchive

-rwsr-srw- 1 orasbx dba 4227280 Jul 19 11:55 brbackup

-rwsrwxr-x 1 orasbx sapsys 5489731 Jul 19 11:55 brconnect

-rwxr-xr-x 1 sbxadm sapsys 4537880 Jul 19 11:55 brrecover

-rwxr-xr-x 1 sbxadm sapsys 1554379 Jul 19 11:55 brrestore

-rwxr-xr-x 1 sbxadm sapsys 5617510 Jul 19 11:55 brspace

-rwsrwxr-x 1 orasbx sapsys 2289337 Jul 19 11:55 brtools

Regards, Marc

[markus_doehr2 · Accepted solution]

Ok

and the schema name is SAPR3? Or should that be SAPSR3?

Markus

[Former Member · Accepted solution]

SAPSR3

[markus_doehr2 · Accepted solution]

...but you'r executing the sql scripts for SAPR3!!

Markus

[Former Member · Accepted solution]

You were right!!

Thanks a lot!