Error: when accessing On-premises DB (OCA)

Mshakib

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 ?

Mshakib

Hi,

Thanks for reply.

Yes, I have defined static IP address of server.

Thanks

Hany Ezzat Hassan

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

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

We have done following steps to resolve problem.

1>Created TNS Entery.

2>reconfigured JDBC connection in weblogic.

3>Reset RPD CP.

Mshakib

Thanks for reply. this issue has been sorted out.