#Oracle--Configuration of client and server

I. DB instance

First, you have to have a db instance that you can create without using the following tools:

The database instance created is as follows:

Two. Server-side listener configuration

The following database configuration listener is configured to listen for connection requests made by the client to the database server side:

Open the server-side net Manager, listener configuration (primarily "Listening location" and "database Service" configuration)

Last: "File" "Save network Configuration"

Three. Client Service naming configuration

Service naming is used to connect to the server-side database for the client's net Manager service naming configuration:

The "Network Service name" is used when logging in to "host string", when entered, the casing can be

Next, then do a "connect" test. If unsuccessful, it is possible that the default user is locked out, optionally "change login" and use the system user to test.

Add:

The above "listener" and "service naming" are configured in a visual interface, which describes the non-visual configuration:

Get ready:

Oracle Installation path: E:\oracle\product\10.2.0\client_1\network\ADMIN

Locate the following file on the path:

tnsnames.ora--Service-named configuration file

Listener.ora configuration file for---listener

#Oracle--Configuration of client and server