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
Configuring Oracle Net on client-side
Step 1:
Since now we have created the listener.ora file and started the listener
process. Next thing we will do is to create the Net Service Name on this
machine. Net Service Name is basically a short & easy to remember name
for a long set of parameters that helps client applications to connect
to server. Select the “Service Naming” item in the tree on the left pane
of ONM and click the “+” sign to add the Net Service Name.
Figure 60: Click the “Service Name” item and then
click the “+” icon to add a new service name to the tree.
________________________________________
Figure 61: Net Service Name will be the nick name on
this machine for the Oracle database we want to connect to. It can be
any name.
________________________________________
In the popped up window write the Net Service Name as “asim”. Now we are going to define what the word “asim” means on this machine by clicking “Next” button.
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: