DX Unified Infrastructure Management

 View Only
  • 1.  Oracle ORA-00942

    Posted Jul 20, 2010 09:56 PM

    Hi,

    When I try to test conection with oracle server this error were recieved ORA-00942

     

    Any idea.

    Omar



  • 2.  Re: Oracle ORA-00942

    Posted Jul 22, 2010 05:50 PM

    Hi Omar,

     

    A quick google give this, though I'm not sure how helpful it is. It looks like there's a problem with the client installation, but I am in no way, shape or form a database guy so I may be totally wrong :smileywink:

     

    ORA-00942:table or view does not exist
    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.

     

     

    Cheers,

    Stian



  • 3.  Re: Oracle ORA-00942

    Posted Jul 22, 2010 09:10 PM

    Hi,

     

    We solved this by grant full access to the user user in Oracle probe.
    Which level of security or role are required to proper probe configuration.


    Omar