Printable View
whenever I am connecting to oracle thry sqlplus i need to type the full qualifier name ie user/[email protected]
I wanted to have only user/[email protected] in sql plus i should type in user in user name
pwd in password & onlt test in host string instead of test.xxx.com.How to have the test alone.The version of Oracle is 8.1.6 & it is running in N/T
Thanks
Suresh
Lets see your TNSNAMES.ORA entry.
You may also want to put a DEFAULT_DOMAIN =xxx.com in your sqlnet.ora file. (See http://technet.oracle.com/docs/produ...ams.htm#421916 )
--SQLNET.ORA
NAME.DEFAULT_ZONE = rkv.datainteraction.com
NAMES.DEFAULT_DOMAIN = rkv.datainteraction.com
-- TNSNAMES.ORA
BADDB.rkv.datainteraction.com =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Production1)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
BADDB1.myworld.com =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Production1)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
sqlplus usr/pwd@BADDB
OR
sqlplus usr/[email protected]
OR
sqlplus usr/[email protected]
The secret is in the sqlnet.ora domain......
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