Connecting to the Oracle Server from Home

Connecting to the Oracle Server from Home using SQL*Plus

In the SQL*Plus Login dialog box, there are three entries:

    User Name
    Password
    Host String

The "Host String" determines which database SQL*Plus will attempt to connect to; if this entry is left empty, SQL*Plus will connect to the local database.

In order to set up the connection to a remote server, you will need to use the "Net Configuration Assistant", located under "Configuration and Migration Tools" on the START/OracleHome menu.

To connect to the server at Algonquin, start the Net Configuration Assistant and enter the following:

On the first window, select: "Local Net Service Name configuration", and click Next
On the next window, select Add and click Next
On the next window, you are asked for the Oracle version you are connecting to, select "Oracle 8i or later database or service", and click Next
On the next window, you enter the service name; enter cp01 and click Next
On the next window, the TCP network protocol should be already selected; click Next
On the next window, enter the Host Name: acaddb.algonquincollege.com; the Port number 1521 should already be selected; click Next
The next window asks if you wish to test the connection or not; click Next to proceed to the next window without testing.
On the next window, enter a name for the service; this can be any name of your choosing. This is the name you will use for the "Host Name" entry in the SQL*Plus Login dialog box to connect to the Woodroffe database server. Click Next
Click Next on the following two windows and Finish to exit

If the connection hasn't been set up properly, you can use the Net Assistant to correct it or delete it entirely.