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
The purpose of making Oracle network is to have an environment where users from all over the city or country or even world can access the database as if it’s residing on their machine. Establishing an Oracle network is very simple. All you have to do is to configure Oracle Net layer on both server and client side.
Figure 47: Oracle Net needs to be configured on server
as well as on each client.
________________________________________
Oracle Net gets installed on the server at the time
of installation of Oracle Server software but for each client we have to
select the option of client installation in Oracle Universal Installer.
The way it works is first we create the listener.ora file on the server
then we start the listener. The development of listener.ora file is
actually the configuration of Oracle Net for the server. Once we have
started the listener process, it listens to the users connection
requests. The job of the listener process is to bequeath the connection
to the dispatcher in case the Oracle server is running under shared
server mode or to the dedicated server process in case Oracle is running
under dedicated mode.
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: