Configuring Oracle Net Conclusion
This module discussed how to configure Oracle Net.
By now, you should have a good idea of how Oracle Net fits into a client-server architecture, and you should feel reasonably comfortable configuring a client PC to access a database. You should know how to perform the following tasks:
- Edit the listener.ora file, and add an entry for another database instance
- Edit the tnsnames.ora file, and add a new service name for use by client software
- Use the ping command to verify connectivity to the host
- Use the tnsping command to verify connectivity to the Oracle Net listener
- Start and stop the Oracle Net listener
- Connect to a remote database over the network
Where can you learn more about Oracle Technology
This is only the beginning. As you work more with Oracle, you will find out that there is much more to Oracle Net than can be presented in this one module. Oracle Net can support several protocols besides TCP/IP. You can use a product called Oracle Names to avoid having to configure tnsnames.ora files on each client PC.
There also are other, more sophisticated, troubleshooting techniques than those discussed in this module.
What you have seen here represents the most common ways that I have seen Oracle Net configured at the various client sites that I have supported.
Oracle Net Glossary
This module introduced you to the following terms:
- internal password: The password that you need to use when you issue a CONNECT INTERNAL command from Server Manager.
- listener: A process that runs on a database server, and listens for incoming requests from clients that want to connect to databases on that server.
- LU6.2: A networking protocol used in IBM mainframe environments.
- Oracle Net: Oracle's generic networking protocol, used to connect two databases to each other, or to connect client software to a database server. Oracle Net insulates Oracle and client applications from the underlying network protocol being used.
- network adaptor: A Oracle Net component that adapts the Oracle Net software for a particular networking protocal.
For example, the Oracle Net TCP/IP adaptor allows you to run Oracle Net over a TCP/IP network.
- ping: A utility used to verify TCP/IP connectivity between two nodes on a network.
- service: service NT.A service under Windows NT is software that runs in the background, independently of any logged on user. ..service Oracle Net. A Oracle Net service is a usually a database instance, but could be some other software, that is accessible via Oracle Net.
- service handler: A Oracle Net related entity that runs in conjunction with the listener to handle connection requests for a database instance.
- SPX/IPX: A networking protocol used on Novel NetWare networks.
- TCP/IP: A networking protocal widely used in the UNIX world, and which happens to be the most commonly used protocol by clients that need to connect to Oracle servers.
- tnsping: A Oracle Net utility used to verify connectivity between a client and a remote listener.
Today, most users choose to create the database with the standard installer interface.
In the next module, you will learn about password files, and about how they enable remote administrative access to a database.
Oracle Net Client Configuration - Quiz