cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

local oracle database connectivity

SOLVED
Amethyst

local oracle database connectivity

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...

1 ACCEPTED SOLUTION

Accepted Solutions

Re: local oracle database connectivity

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

 

9 REPLIES 9

Re: local oracle database connectivity

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

 

Re: local oracle database connectivity

Hi @hchanana,

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

Re: local oracle database connectivity

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

 

Highlighted

Re: local oracle database connectivity

Hi @hchanana,

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

Re: local oracle database connectivity

Hi @Surekha,

 

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

 

Thanks,

Himanshu

Re: local oracle database connectivity

Hi @hchanana,

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

Re: local oracle database connectivity

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

Re: local oracle database connectivity

Hi @hchanana ,

Oracle connectivity issue is cleared by using RDBMS Connectors.

 

Thanks & Regards,

Surekha N.

Re: local oracle database connectivity

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