Basic Oracle Net Services Client-Side Configuration
- The tnsnames.ora file is used for local naming method. Host naming method, TCP/IP procotol has to be installed on both the client and the server. And identifies only one SID per node.
- An Oracle9i database’s service name refer to its global database name, which comprises the database name and the domain name.
- The local naming method can be configured by using Oracle Net Configuration Assistant. For Oracle versions 9i onwards, support for the SPX protocol is suspended.
- Oracle Names will not be supported as a valid naming method after 9i, Directory naming method is used.