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
Once you expand the <Service Naming> and <Listeners> items in the tree, you will see nothing. There is no listener running moreover there is no tnsnames.ora file.
Figure 52: Click the “Listener” and then the “+” icon
to create new listener process.
________________________________________
Figure 53: Assign the name to the listener process.
________________________________________
Select the Listener item from the tree in ONM and then click the ‘+’ sign shown in the slide to create the listener. In the popped up window write the Listener Name. If you use the default name of the listener than the Oracle Instance registers itself with the listener dynamically and it’s called dynamic service registration. That’s why we are sticking with the default name of the listener i.e. LISTENER. Not only listener name has to be default but we have to use default protocol i.e. TCP/IP and default port i.e. 1521 or 1520 if we want to go with dynamic service registration.
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: