Connect without an entry in tnsname.ora
Each client has its own tnsname.ora on the local PC. Let say I want to connect to a new location instead from the tnsname. How can I connect?
I used 'sqlplus system/admin@172.20.21.15:1521:orcl' where orcl is the service name. I got an error ORA-06401: NETCMN: invalid driver designator. Pls help on how to connect without a tnsname entry. Tks.
Re: Connect without an entry in tnsname.ora
Quote:
Originally posted by richyip
Each client has its own tnsname.ora on the local PC.
Why? Make one tnsnames.ora file, place it on a shared network drive, and set TNS_ADMIN environment variable (System Properties>Environment)to the shared directory location. Add sqlnet.ora there too if you are using it.