Quick Start to Oracle Net Services

Help novice users set up and test a simple but common network configuration, such as one between a client application and a database over a TCP/IP network.

• Prerequisites for Establishing Connectivity The tasks in this chapter show a TCP/IP connection between a database server and a client computer.

• Confirming Network Availability Before using Oracle Net to connect a client computer to a database server, confirm that the client computer can successfully communicate with the database server computer. Evaluating network connectivity can eliminate network-based errors.

• Starting Oracle Net Listener and the Oracle Database Server Oracle Net Listener and the Oracle Database server must be running in order for the database server to receive connections.

• Starting Oracle Connection Manager If Oracle Connection Manager is installed, then follow these steps to start Oracle Connection Manager.

• Using Easy Connect to Connect to a Database Easy Connect extends the functionality of the host naming method by enabling clients to connect to a database server with an optional port and service name in addition to the host name of the database.

• Viewing Connection Strings Using the connstr Utility You can run the Oracle Database Connection String command-line utility (connstr) to display Oracle Database connect strings for all the available network service names.

• Connecting to the Database There are several methods for connecting to Oracle Database.