Books for you

(If you??™re using Oracle Names or OID, as described
earlier, youdon??™t need to use the TNSNAMES.ORA file as part of your configuration.)
This file is key to Oracle Net??™s location transparency. If youmove a
database from one machine to another, youcan simply update the TNSNAMES.
68 | Chapter 3: Installing and Running Oracle
ORA files on the various clients to reflect the new machine address for the existing
service name. For example, suppose that clients reach the database using a
service name of SALES. The TNSNAMES.ORA file has an entry for the service
name SALES that decodes to a machine named HOST1 and an Oracle instance
called PROD. If the Oracle database used for the SALES application is moved to
a machine called HOST2, the TNSNAMES.ORA entry is updated to use the
machine name HOST2. Once the TNSNAMES.ORA files are updated, client
connection requests will be routed transparently to the new machine with no
application changes required.
SQLNET.ORA
Provides important defaults and miscellaneous configuration details.


Pages:
144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168