local oracle database connectivity

[Surekha]

Hi everyone,

I'm unable to connect my local oracle db in thingworx platform.Please find the attachment of connection string for connection.Could please anyone help me out on this...

[hchanana]

Hi @Surekha,

It seems to be an issue in the configuration. Can you please provide the configuration as below and validate :

JDBC Driver Class Name : oracle.jdbc.OracleDriver
JDBC Connection String : jdbc:oracle:thin:@localhost:1521:orcl
connectionValidationString : SELECT sysdate FROM dual

You need to change the localhost and orcl as per IP and SID of your oracle database.

Thanks,

Himanshu

[Surekha]

Hi @hchanana,

    Thank you for your response.I made changes which you have mentioned,but still it doesn't working.

[hchanana · Accepted solution]

Hi @Surekha,

Please validate the below points:

• Make sure that Thing Template is of OracleDBServer type on your thing.
• Oracle Database server is accessible from your thingworx instance. You can validate it by making ping to database server.

If you still face issue please share your error screenshot also. Also let us know to which version of oracle database you are making connection.

Thanks,

Himanshu

[Surekha]

Hi @hchanana,

We have connected to oracle server and changed configuration.Oralce configuration is connected but service is not invoked.

[hchanana]

Hi @Surekha,

Can you please share screenshot of General Information and Configuration tab of your thing.

Thanks,

Himanshu

[Surekha]

Hi @hchanana,

         Please find the attachments of General Information,Properties and Configuration tab.

[hchanana]

Hi @Surekha ,

Can you please confirm if you are still facing the connectivity issue. I have seen you opened support case related to this and solution was provided over the case.

Thanks,

Himanshu

[Surekha]

Hi @hchanana ,

Oracle connectivity issue is cleared by using RDBMS Connectors.

Thanks & Regards,

Surekha N.

[hchanana]

Hi @Surekha ,

Can you please mark the appropriate response as Accepted Solution, for the benefit of others who may have the same question.

Thanks,

Himanshu