Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 7: Enabling Other Computers to Access Oracle Server
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
On the client side, we have to create the tnsnames.ora file. Creating tnsnames.ora file is actually the configuration of Oracle Net on the client side. tnsnames.ora is nothing but contains the resolution of “service name” that we will use to connect to Oracle server.

Figure 48: Oracle Instance knows how to speak with
Oracle Net layer whereas Oracle Net deals with different network
protocols.
________________________________________

Figure 49: Accessing Oracle Net Manager (ONM): Java
based program, completely independent of Operating System.
________________________________________
Chapter 7: Enabling Other Computers to Access Oracle Server
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Share with others: