so in sqlnet.ora file we should put
NAMES.DEFAULT_DOMAIN = xxxxxx.com
in tnsnames.ora file we can put
TEST.xxxxxx.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.xx)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = test))
)
so we can test in sqlplus using
username----user
password----pwd
host string---we need to put test alone Ami I rght.I tried & it worked.If I am wrong please correct me
Thanks
Suresh