How to do it!!
--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/pwd@BADDB.rkv.datainteraction.com
OR
sqlplus usr/pwd@BADDB.myworld.com
The secret is in the sqlnet.ora domain......
Ken Hinerman
Data Interaction
DBASupport@datainteraction.com