COMMENTS IN TNSNAMES.ORA
Be careful when commenting tnsnames.ora file:
Both DB1 and DB2 does not work:
DB1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = DB1) ) ) #DB2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = DB2) ) )
This works:
DB1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = DB1) ) ) #DB2 = #(DESCRIPTION = #(ADDRESS_LIST = #(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521)) #) #(CONNECT_DATA = #(SERVICE_NAME = DB2) #) #)
To comment out the whole thing (one/single tns entry), can I use /* before */ after ?
Unfortunately, you can not.