local oracle database connectivity
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
Solved! Go to Solution.
- Labels:
-
Connectivity
-
Troubleshooting
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @hchanana,
Thank you for your response.I made changes which you have mentioned,but still it doesn't working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @hchanana,
We have connected to oracle server and changed configuration.Oralce configuration is connected but service is not invoked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Surekha,
Can you please share screenshot of General Information and Configuration tab of your thing.
Thanks,
Himanshu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @hchanana,
Please find the attachments of General Information,Properties and Configuration tab.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @hchanana ,
Oracle connectivity issue is cleared by using RDBMS Connectors.
Thanks & Regards,
Surekha N.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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