Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Error: when accessing On-premises DB (OCA)

Received Response
101
Views
5
Comments
Mshakib
Mshakib Rank 2 - Community Beginner
in Oracle Analytics Forum

Summary

Error: when accessing On-premises DB (OCA)

Content

Hi,

We have a requirement to access on-premises database and have configured according to Oracle document but problem is when WebLogic and database were on the same server then it was working perfectly, but when we changed the DB(repoint to the different database server) then encountering below error.

[nQSError: 77031] Error occurs while calling remote service DatasourceService. Details: [JDSError : 77] 942 : ORA-00942: table or view does not exist - Cause: SQLException is thrown from the datasource Action: Check the log (HY000)

Any thought on this ?

Answers

  • Mshakib
    Mshakib Rank 2 - Community Beginner

    Hi,

    Thanks for reply.

    Yes, I have defined static IP address of server.

    Thanks

  • Hany Ezzat Hassan
    Hany Ezzat Hassan Rank 3 - Community Apprentice

    Can you send me a sample of the connection string  , you have to use the following example to call your on-premise objects  "Schema_Owner.Object_name " @tnsnames.ora connection Alias .

  • Hany Ezzat Hassan
    Hany Ezzat Hassan Rank 3 - Community Apprentice

    Hello There ,

    Now you are trying to access via your Cloud DB instance an on -premise DB , am i right ? away from the whole platform setup if this is the case .

    1- have you tried assign Static IP for your On-premise DB as your cloud instance can't access dynamic IP .

    Regards

    Hany Ezzat

  • Mshakib
    Mshakib Rank 2 - Community Beginner

    We have done following steps to resolve problem.

    1>Created TNS Entery.

    2>reconfigured JDBC connection in weblogic.

    3>Reset RPD CP.

  • Mshakib
    Mshakib Rank 2 - Community Beginner

    Thanks for reply. this issue has been sorted out.