Skip to content

Connect the Client to the Database

Now it's time to connect the client to the database server. You'll need the database name (service) that you setup in step 8 of the server installation guide. You'll also need the database server name and/or IP address.

Tip

If you are setting up multiple user stations you may want to copy the net/TNSNAMES.ora file for duplication.

Net Manager

Open the Network Manager by selecting the Windows key Windows Key

Then search for Net Manager

Net Manager

Start Menu

You can also Scroll down to the Oracle Folder, expand the folder and select Net Manager.

Create a new service

  • Highlight the Service Naming
  • Select the + symbol to add a new service

Create Service

Step 1 - Net Service Name

Define the database name.

In the Net Service Name field enter the database name (SID) you created in step 8 of the database install.

  • Select Next

Define Database

Step 2 - Select Protocol

Select TCP/IP (Internet Protocol) and NEXT.

Port ID

Step 3 - Protocol Settings

Define the server name or IP address and Port

Host Name: is the server IP address or name.

Port Number: default is 1521.

  • Select Next

Server IP

Step 4 - Service

In the Service Name field enter the global database name you created in step 8 of the database install.

Use the default connection type.

Connection Type: Database Default

  • Select Next

Service

Step 5 - Test Connection

  • Select TEST.

Test Connection

Change Login

  • Change the login

Change Username Password

User Name and Password

The user name and password we will use to test with are what we specified in Step 13 of the server installation.

  • Select OK
  • Test Successful!

Test Success

Step 6 - Save Configuration

Select FileSave Network Configuration and close the Oracle Net Manager window.

Save Config

The Oracle client is now able to connect to the server database!