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

 

Creating Listener

Step 1:

The next step would be to start the Oracle Net Manger. With this single tool we can create both listener.ora and tnsnames.ora files. ONM can be accessed under Unix using the netmgr command under ORACLE_HOME/bin directory and the same software can be found in window under Start>All Programs > Oracle.

 

Figure 50: Expanding “Listeners” shows no listener process.
________________________________________



 

Figure 51: Oracle Net Manager showing no Service Name.
________________________________________

 

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: