What are the simplest entries in sqlnet.ora and tnsnames.ora files that will make the connection to SID named ISGDB3 listening on port 10000 on host sjomir.eng.stsj.jafa.com?
Requires Free Membership to View
Your SQLNET.ORA configuration file does not need any entries in it. The defaults are enough to get you going.
The TNSNAMES.ORA configuration file needs a TNS entry to point to this remote database. At the minimum, that entry should look like the following:
ISGDB3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sjomir.eng.stsj.jafa.com)(PORT = 10000))
)
(CONNECT_DATA =
(SERVICE_NAME = ISGDB3)
)
)
It is my convention that the TNS alias name is the same name as the SERVICE_NAME parameter. But the TNS alias can be anything you choose. Once you have the TNS alias defined, you can use it in the userid/password@tns_alias construct to connect to a remote database.
This was first published in July 2006
Join the conversationComment
Share
Comments
Results
Contribute to the conversation