Who Me Too'd this solution

Showing results for 
Search instead for 
Do you mean 
Frequent Contributor
Posts: 76
Registered: ‎03-08-2017
Re: Oracle use service name instead of SID
[ Edited ]

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 :

 

<Database>
<DriverName>QOCI</DriverName>
<Username>User</Username>
<Name>Service_name</Name>
<Password>Password</Password>
</Database>

 

The new connection url is : 

jdbc:oracle:oci:user/password@service_name

 

Hope it could help hexagon find the problem or help another user.

 

 

View solution in original post

Who Me Too'd this solution