We have migrated our database to 12.2 Enterprise.
Now we no longer use SID's for the databases. Instead we have a Service_Name.
So far I red the documentation and thought the correct way to do now is using a tnsnames.ora file for defining the database connection instead of the set of jdbc_host, jdbc_port and jdbc_sid.
We added a Export for TNS_ADMIN to /home/glasfish/.bashrc for the path to /var/opt/oracle/tnsnames.ora (OS is Red hat Linux and we use a glasfish at the moment).
I also thought the jdbc_user and jdbc_Password has to stay for the logon and we added jdbc_tns_name to the defined database inside tnsnames.ora.
The first curiose Thing is taht in some cases we need ConnectionName in the tnsnames.ora file some programms like to find ConnectionName.world (even if you use ConnectionName inside the Programm). For this reason both versions are inside the file.
Final Information, there is no Oracle Client installed on the Linux Server because we thought the TNS_ADMIN envireoment variable is enough to find the file.
Thx for your help
Markus