To Edit the tnsnames.ora File

To allow multiple clients to connect to the database over a network, edit the file tnsnames.ora.

1. Go to the directory Oracle-base/product/10.1.0/db_1/network/admin/.

2. Open the file tnsnames.ora in a text editor.

3. At the end of the file, append the following:

   SOAR =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = host.domain)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = SHARED)
         (SERVICE_NAME = soar)
       )
     )

   For host.domain, substitute the full domain name of the system where the database is installed.