Cluster Server 7.4.2 Database Agent for Oracle Configuration Guide - Windows

To associate the database with the listener

1. Configure a new attribute listener_alias. The listener_alias value should be unique; it should be different from the listener name.

   Run the following SQL commands.

   • Set the SID name.

     Type the following on the command prompt:

     C:\>set ORACLE_SID=<SID NAME>
     
     

   • Log on to the Oracle database as an administrator.

     Type the following on the command prompt:

     C:\>sqlplus "/nolog"
     C:\>sqlplus "/as sysdba"
     

   • Configure listener_alias.

     Type the following on the command prompt:

     SQL> ALTER SYSTEM SET LOCAL_LISTENER='<listener_alias>' 
     scope=spfile;
     

   If you are using a pfile, add the following entry to the initialization parameter file (pfile):

   LOCAL_LISTENER = <listener_alias>
   

2. Define the parameter listener_alias. If your Oracle configuration uses the file tnsnames.ora, edit the file as instructed below. The default location of tnsnames.ora is <ORACLE_HOME>\NETWORK\ADMIN.

   Add the following to tnsnames.ora file:

   <listener_alias>=
   (DESCRIPTION = 
   (ADDRESS=(Protocol=TCP)(HOST=virtual_IP_address)(Port=port))
   )
   

   Here, virtual IP address is the IP address you assigned to the IP resource in the temporary service group and port is the port number you specified while creating the listener. You can check the listener.ora file to find out the port number used. The default value is 1521.

3. Stop and restart the database.

   The listener_alias parameter gets appended by the default domain name specified in the file sqlnet.ora.