Oracle Direct Connect using version 9.1.5 - VisualCron - Forum

Community forum

Matt Peden
2020-02-20T19:36:38Z
Oracle Direct connection has been working since 8.5 for me I migrated to 9.0 and I had to make one change to my direct connection settings. When I upgraded to 9.1 Direct connect worked still. I just upgraded to 9.1.5 and the Direct connect through ORA12514 error at me when trying to do a test connection.
Attached image of configuration that was pulled in from my previous versions.

I tried dropping the connection and creating it from scratch but it did not work.
I have 2 databases that are both the same server versions below (1 Test and 1 Production). The Test Connection seems to be working fine (image attached 4259). The Production connection (image attached 4258) is not working even after recreating it from scratch on new server clean install of 9.1.5.

I tried cloning the Test connection and then changing the DB server parameters to point to Prod and it still fails

Oracle version on server: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Oracleconnection.png
Oracleconnection2.png

Thoughts
Matt Peden
2020-02-20T20:13:28Z
As a follow-up..
Here is the connection from the ver 9.1.0 for the same Oracle database. This connection works. (image attached) .
I also tried Beta version 9.2 for this issue

Oracleconnection4.png
Support
2020-02-21T13:44:53Z
We have not received any other indication from other customer. But what does this error mean to you?

https://stackoverflow.co...e-requested-in-connect-d 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Matt Peden
2020-02-21T13:51:30Z
The error from Stack overflow thread would indicate the Listener on the database is not working. That is not the case here as I have other VisualCron servers using the older version pointed to the same database using the no client connection and it is working fine. When I loaded 9.1.5 it stopped working. When I rolled back to 9.1.0 it started working again. could it have something to do with the Oracle license fix you made as a part of 9.1.5 for some reason? It is odd also that I have other databases same Oracle version that are connecting fine on 9.1.5
Support
2020-02-21T15:04:08Z
So, "only" thing we have done between the versions (which caused license issue) is that we upgraded the Oracle components. We will check with the component provider if they recognize the error after upgrade. So far we need more feedback from other Oracle users and we have not yet received any. It is like a parameter might be missing.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2020-02-21T15:11:57Z
I see now that you have altered the default connection string. I would try recreating a new one because some parts are not existing in default which may cause the error. Please try to recreate - do not add any parameters.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Matt Peden
2020-02-21T15:12:58Z
Is there any sort of logging records I can provide to you from my systems. I turned on enhanced debug logging but for that connection it only shows the connection string
Matt Peden
2020-02-21T20:37:00Z
"I see now that you have altered the default connection string. I would try recreating a new one because some parts are not existing in default which may cause the error. Please try to recreate - do not add any parameters."

I have recreated the link fresh multiple times using the link wizard and the direct connect method.
I was not altering the connection string or adding parameters in anyway from the wizard just updating the parameter values to match my DB.

One other observation here.. The version on the server is version 9.1 and that is where the connection was made. If I use client 9.1.5 on my PC the connection connects and verifies fine. If I create a new connection on the client of 9.1.5 on my PC against a 9.1 server it connects fine (see attached image of 9.1 server and 9.1.5 client). If I connect to the server directly that is running the server version 9.1.5 of VisualCron the connection fails the test connection. with no difference in the configuration process.

  oracle connection.png (420kb) downloaded 14 time(s).
Support
2020-02-26T15:48:43Z
Originally Posted by: Matt Peden 

"I see now that you have altered the default connection string. I would try recreating a new one because some parts are not existing in default which may cause the error. Please try to recreate - do not add any parameters."

I have recreated the link fresh multiple times using the link wizard and the direct connect method.
I was not altering the connection string or adding parameters in anyway from the wizard just updating the parameter values to match my DB.

One other observation here.. The version on the server is version 9.1 and that is where the connection was made. If I use client 9.1.5 on my PC the connection connects and verifies fine. If I create a new connection on the client of 9.1.5 on my PC against a 9.1 server it connects fine (see attached image of 9.1 server and 9.1.5 client). If I connect to the server directly that is running the server version 9.1.5 of VisualCron the connection fails the test connection. with no difference in the configuration process.

  oracle connection.png (420kb) downloaded 14 time(s).



Please remove either SID or Service Name and try again. You must not use both.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Matt Peden
2020-02-26T16:00:35Z
Henrik,

Perfect! The connection now works after removing ServiceName and leaving SID.

It is worth noting though that both of these parameters were automatically added via the Wizard. In addition both parameters are in my connection string on version 9.1 and it seems to work.

I appreciate the support and love the product!
Matt
Support
2020-02-26T17:04:29Z
Originally Posted by: Matt Peden 

Henrik,

Perfect! The connection now works after removing ServiceName and leaving SID.

It is worth noting though that both of these parameters were automatically added via the Wizard. In addition both parameters are in my connection string on version 9.1 and it seems to work.

I appreciate the support and love the product!
Matt



Glad it was resolved! We will try to update the documentation about this!
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top