on 11-20-2008 12:10 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Seems like an error with the OPS$ Users.... read SAP Note 400241
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.