Oracle 9i Database Administration in 10 Minutes

- Asim Abbasi (Author)

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: