DB13 jobs are failing

[Former Member]

Hi all,

The DB13 job checkdb is failing with the below mentioned error.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000040, user name INAMI3)

Execute logical command BRCONNECT On host sapdo14

Parameters: -u / -c -f check

BR0801I BRCONNECT 7.00 (18)

BR0805I Start of BRCONNECT processing: cdylxgqr.chk 2008-07-29 08.20.25

BR0280I BRCONNECT time stamp: 2008-07-29 08.20.25

BR0301E SQL error -942 at location db_connect-4, SQL statement:

'SELECT NAME FROM V$DATABASE WHERE ROWNUM = 1'

ORA-00942: table or view does not exist

BR0310E Connect to database instance O14 failed

BR0280I BRCONNECT time stamp: 2008-07-29 08.20.25

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

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20080729082025', 'chk', 'O14', 'DATABASE', '9999

ORA-00942: table or view does not exist

BR0324W Insertion of database log header failed

BR0806I End of BRCONNECT processing: cdylxgqr.chk2008-07-29 08.20.25

BR0280I BRCONNECT time stamp: 2008-07-29 08.20.25

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Specification:

Oracle :10.2.0.2.0

R/3 release 4.6C

SAP R/3 Kernel 46D_EXT

Support package number 2341

We checked for the error on the database level and found both the tables are existing in the database.

.SQL> SELECT NAME FROM V$DATABASE WHERE ROWNUM = 1;

NAME

-

---

O14

-

---

SQL> select object_name from dba_objects where object_name like '%SAP_SDBAH%';

OBJECT_NAME

-

---

SAP_SDBAH

Ran the command brconnect -u / -c -f check from Unix level as o14adm and it ran successfully.

Anybody has an idea why it is failing at SAP level...?

[JPReyes]

This seems to be an issue with the OPS$ Users...

Basically this problem happen when the Owner of the SAPUSER table is incorrect.

Read

SAP Note 400241 Problem with ops$ or sapr3 connect to oracle

SAP Note 361641 Creating OPS$ users on UNIX

SAP Note 50088 Creating OPS$ users on Windows NT/Oracle

regards

Juan

[Former Member]

Hi

Juan is correct it is issue with OPS$ user.

Please check the Roles of OPS$ORA<SID> user at database level using query

select granted_role, default_role from dba_role_privs where  grantee='OPS$<DOMAIN>\SAPSERVICE<SID>'

Roles SAPCONN & SAPDBA must be assigned to the user id OPS$<DOMAIN>\SAPSERVICE<SID>.

Then try.

Thanks,

Shambo

[fidel_vales]

Hi,

IMHO, the previous answers miss totally the point and updating the tolls will provide no help.

> Ran the command brconnect -u / -c -f check from Unix level as o14adm and it ran successfully.

Are you sure that the command was executed as as <sid>adm?

well, it is 4.6C therefore no MCOD.

I'd like to know

1) how exactly your SAP system was started?

2) your DB server is a standalone one?

3) what is the OS user that is running SAP (go to SE38, report RSBDCOS0 and run command "id")

[Former Member]

Hi

Kaushal is correct Check the Note 12741

Upgrade the kernel and try.

Regards

Bhaskar

Edited by: bhaskar1818 on Jul 31, 2008 10:24 AM

[Former Member]

Hi,

Use the latest patch of BRTOOLS.

check Note 12741 - Current versions of BR*Tools and SAPDBA

check following note as reference Note 662644 - Composite SAP Note: ORA-00942

regards,

kaushal