10-04-2017 11:07 AM - edited 10-04-2017 11:09 AM
we have a working apollo server 2016 connected to Oracle using an SID. Using configuration Wizard, I select database type Oracle and uncheck "Use OCI/TNS" and everything works fine.
We need to change the SID for a service name.
I tried to use tnsnames.ora by checking "Use OCI/TNS" but I always get Ora-12154 error. I can connect through SqlPlus so the problem is not the tnsnames.ora file.
In the past I've changed database user by updating the config files but never to use a service name instead of an SID.
In config.xml, the node containing the SID is called <Name>SID</Name>.
How can I specify a service name instead of an SID ?
Solved! Go to Solution.
10-09-2017 11:46 AM
Have you tried to install 64bit ODAC (oracle ODP.NET dlls) for your Apollo 2016?
hope it helps.
10-10-2017 06:05 AM
thanks for your answer.
I tried installing ODAC 64-bit but it still doesn't work : I still get a ORA-12154 error. I can connect with sqlplus without any problems. I can see that the tnsnames.ora is found and read by DatabaseUpgrader.exe but It seems that it's not able to find the service name in the file.
How can I confirm that ODAC is used ?
10-11-2017 11:22 AM - edited 10-11-2017 11:28 AM
Follow up on this issue ...
I confirm that the tnsnames.ora was read on the network.
I copied the same files (tnsnames.ora and sqlnet.ora) locally (in the configwizard folder) and the configurationwizard got through.
Afterwards, I deleted the local files, restared the services and Apollo still works.
It seems that only the configurationwizard had the problem.
For the config.xml file, the new entry is :
The new connection url is :
Hope it could help hexagon find the problem or help another user.