Error ORA-00942 in db13 -> UpdateStats

[Former Member]

Hello Guys,

we experience one Error in two (QAS and Prod) of our ERP Systems.

When scheduling job UpdateStats in DB13 we got following error:

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

'SELECT COUNT(*) FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'GATHER_STATS_JOB' AND ENABLED = 'TRUE''

ORA-00942: table or view does not exist

I searched the notes but found only DBA_SCHEDULER_JOBS in association with Oracle 10g, but this is a Oracle 9.

Here are some additional informations :

Name Value

oracle_sid EAC

oracle_home /oracle/EAC/920_64

oracle_profile /oracle/EAC/920_64/dbs/initEAC.ora

sapdata_home /oracle/EAC

sap_profile /oracle/EAC/920_64/dbs/initEAC.sap

system_info eacadm/oraeac sap-eac-01 Linux 2.6.5-7.312-smp #1 SMP Fri Jun 6 13:44:33 UTC 2008 x86_64

oracle_info EAC 9.2.0.7.0 8192 925 114166660 sap-eac-01 UTF8 UTF8

sap_info 640 SAPSR3 EAC G0753333288 R3_ORA 0020103415

make_info linuxx86_64 OCI_102 Aug 19 2006

command_line brconnect -u / -jid STATS20081120112652 -c -f stats -t ALL

stats_table ALL

stats_change_threshold 50

stats_parallel_degree 1

[Former Member · Accepted solution]

Hi Macro,

Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

Action: Check each of the following:

the spelling of the table or view name.

that a view is not specified where a table is required.

that an existing table or view name exists.

Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.

Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.

Regards,

Rahul.

[Former Member · Accepted solution]

Hello Rahul,

Thanks for the answer, but this is the standart Updatestats which you can select in the DB13.

Nothing is changed.

So the question is, why use the brtools the DBA_SCHEDULER_JOBS Table, when it's only recognized in Oracle 10 (I think so)

Thanks

Marco

[Former Member]

Hu Guys,

OPS$ user was correct.

But we've found an incorrect installation of the whole systems.

We've exported both systems and imported them again (homogenous Systemcopy).

Now both systems are OK.

Thanks

a lot

[JPReyes]

Seems like an error with the OPS$ Users.... read SAP Note 400241

Regards

Juan