Oracle Name

[sureshgane]

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

[marist89]

Lets see your TNSNAMES.ORA entry.

You may also want to put a DEFAULT_DOMAIN =xxx.com in your sqlnet.ora file. (See [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817/a76933/params.htm#421916[/url] )

[hinermak]

--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......

[sureshgane]

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