I want to add two service names in one tnsnames.ora file and getting error in below 2 image in "Microsoft ODBC Driver Configuration".
If the sqlnet. ora file does not exist or does not specify a resolution method, then Oracle Net uses tnsnames. ora. If you fix the naming issues, but you still see the ORA-12154 error, check the Oracle service to confirm that it's available for connections.
Connect identifiers are defined and stored in a file called tnsnames. ora located in $ORACLE_HOME/network/admin/ directory.
One trick which help me is, when you fill:
Data Source Name Test
TNS Service Name 10.1.1.105:1521/ALXTEST
so you need to specify the hostname:port/servicename
, then it should work
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With