I am trying to use SQLPlus to connect to database directly using just the connect string (ie without referencing to tnsnames.ora)
I have this in my tnsnames.ora
(ADDRESS = (PROTOCOL = TCP)(HOST = PODS.GATE.COM)(PORT = 1521))
(SID = ODS)
I can connect to the database if I use the command below, obviously the SQLPlus is refering the tnsnames.ora that I have)
However, if I do this, I will the error shown below.
ORA-12154: TNS:could not resolve the connect identifier specified
Is there any way, I can connect to the database without refering to tnsnames.ora as defined in the TNS_ADMIN system environment variables?
Thanks in advance for your help