Set up Oracle Networking

Introduction:

Another layer of networking sits above the home Ethernet network. This layer is what Oracle uses to connect to the database.

Aim:

Configure Oracle networking.

Requirements:

At lease one Oracle instance is built and running.

Procedure:

Configure networking using the Network Configuration Assistant:

• Log in as oracle.
• Open Terminal.
• Start an xterm window:
• $ xterm &
• In the xterm window:
• netca &
• The Oracle Net Configuration Assistant starts:
• Welcome:
• Naming Methods configuration
• [Next]
  
• Select Naming Methods:
• -Local Naming-, > (i.e. add 'Local Naming' to the list on the right)
  
• [Next]
• [Next]
• Welcome:
• Local Net Service Name configuration
• [Next]
• Net Service Name Configuration:
• Add
• [Next]
• Service Name:
• Service Name: sta
• [Next]
• Select Protocols:
• -TCP-
• [Next]
• TCP/IP Protocol:
• Host name: lisa
• Use the standard port number of 1521
• [Next]
• Test:
• No, do not perform a test
• [Next]
• Net Service Name:
• Net Service Name: sta
• [Next]
• Another Net Service Name?
• Yes
• [Next]
• Service Name:
• Service Name: whs
• [Next]
• Select Protocols:
• -TCP-
• [Next]
• TCP/IP Protocol:
• Host name: lisa
• Use the standard port number of 1521
• [Next]
• Test:
• No, do not perform a test
• [Next]
• Net Service Name:
• Net Service Name: whs
• [Next]
• Another Net Service Name?
• No
  
• [Next]
• Net Service Name Configuration Done:
• [Finish]
• [Finish]

Testing:

• Reboot the server to re-initialise Oracle.
• Log in as oracle.
• Open Terminal.
• Start a SQL*PLUS session on sta:
• sqlplus system/*********@sta (where ********* is system's password - you set this up here [under 'Database Credentials] and made a note of it, right?)
• SQL*PLUS starts with the following:
  

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 2 23:39:10 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL>

• SQL> exit
• Start a SQL*PLUS session on whs:
• sqlplus system/*********@whs
• SQL*PLUS starts similar to the above.
• SQL> exit