IBM Content Manager, Version 8.5 Platform: Oracle

Configuring the listener.ora file for a dedicated Content Manager EE Oracle listener

View the listener_ecm template file to create a new listener entry, which is exclusive to Content Manager EE, that configures the necessary extproc and environment variables settings. If you plan to install the library server and resource manager on separate machines, create one listener on the library server and one listener on the resource manager.

Requirement: Your Oracle version must be 11.2.0.2 patch set 4 or later for Windows or patch 10259620 and 9860769 and 11895652 for other operating systems, and you understand how an Oracle listener works. See Oracle documentation for details.

Complete the following steps to create a new listener that is exclusive to Content Manager EE. You do not need to modify any preexisting listeners. After you complete these steps, create a tnsnames.ora entry by using the directions in the next section.

Copy the templates from the Content Manager EE directory AdvSetup/Oracle to ORACLE_HOME/assistants/dbca/templates.
In the ORACLE_HOME/assistants/dbca/templates directory, view listener_ecm.win (Windows) or listener_ecm.<O/S> (Linux, AIX®, Solaris ) in a text editor.
Recommendation: View these listener templates in read-only mode so that you can see them again if you need to re-create the listener.
Append all uncommented lines in the listener template to the end of the listener.ora file, which is located in your ORACLE_HOME/network/admin or TNS_ADMIN directory, that you intend to use with the Content Manager EE repositories. These lines identify the new listener. Note that listeners require unique names. For example, if you already named a listener LISTENER_ECM, you must rename the dedicated Content Manager EE listener to a unique name.
Using the comments for guidance, replace the following %text strings% with actual values:
<FULL_HOSTNAME>

Fully qualified host name or IP of your Oracle server.

<LISTENER_PORT>

Oracle listener port for your Content Manager EE library server instance.
Recommendation: For security reasons, do not use the default Oracle port (1521) for the new listener.

<EXTPROC>

Set to "extproc".

<ORACLE_HOME>

Fully qualified path to your Oracle server installation.

<IBMCMROOT>

Fully qualified, case-sensitive path of where you plan to install Content Manager EE. The default directories are /opt/IBM/db2cmv8 (Linux), (AIX , Solaris or C:\Program Files\IBM\db2cmv8 (Windows).

As you edit the template, remember the following tips:
- Oracle treats all values as case-sensitive, even on Windows platforms.
- Do not use any environment variables. Paths must be fully qualified.
- For (Linux), (AIX , Solaris 64-bit Oracle 11g installations, it is not necessary to set LIBPATH (AIX) or LD_LIBRARY_PATH (Linux, AIX, Solaris ).
- For Solaris and Linux, you must specify a LD_LIBRARY_PATH. For AIX, you must specify a LIBPATH instead.
- For (Linux), (AIX , Solaris, the library server shared object library name is ICMPORSP. For Windows, the library server DLL is ICMPORSP.dll.
If your resource manager is stand-alone, you can delete the SID_DESC stanza which defines the extproc service and the ADDRESS line which defines the IPC protocol because only the library server uses Oracle external procedures.
Save your changes to the listener.ora file and exit.

The following lines show what the modified listener.ora entry for a library server must look like:

Linux, AIX, Solaris

LISTENER_ECM =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = ICMLSEXTPROC))
      (ADDRESS = (PROTOCOL = TCP)(HOST = host.mydomain.com)(PORT = 1522))
    )
  )

SID_LIST_LISTENER_ECM =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ICMLSExtProc)
      (ORACLE_HOME = /opt/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
      (ENVS="EXTPROC_DLLS=ONLY:/opt/IBM/db2cmv8/lib/ICMPORSP:
/opt/IBM/db2cmv8/lib/ICMPORSV,IBMCMROOT=/opt/IBM/db2cmv8,LD_LIBRARY_PATH=
/opt/app/oracle/product/11.2.0/dbhome_1/lib:/opt/IBM/db2cmv8/icc64/lib64:
$LD_LIBRARY_PATH")

Windows

LISTENER_ECM =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = ICMLSEXTPROC))
      (ADDRESS = (PROTOCOL = TCP)(HOST = winhost.mydomain.com)(PORT = 1522))
    )
  )

SID_LIST_LISTENER_ECM =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ICMLSExtProc)
      (ORACLE_HOME = C:\oracle\product\11.2.0\db)
      (PROGRAM = extproc)
      (ENVS="EXTPROC_DLLS=ONLY:C:\Program Files\IBM\db2cmv8\lib\
ICMPORSP.dll:C:\Program Files\IBM\db2cmv8\lib\ICMPORSV.dll,IBMCMROOT=
C:\Program Files\IBM\db2cmv8,PATH=%IBMCMROOT%\icc64\lib64;%PATH%")
    )
  )

The following lines show what the modified listener.ora file entry for a resource manager must look like.

LISTENER_ECM =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.mydomain.com)(PORT = 1522))
    )
  )

SID_LIST_LISTENER_ECM =
  (SID_LIST =
  )

Feedback