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

Edit online

View the listener_ecm template file to create a new listener entry, which is exclusive to Content Manager Enterprise Edition, 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.

Before you begin

Requirement: Make sure that:

You understand how an Oracle listener works. For more information, see the Oracle documentation.
You have the patches that are required for your version of Oracle. For more information, see Hardware and software requirements for Content Manager Enterprise Edition.

About this task

Complete the following steps to create a new listener that is exclusive to Content Manager Enterprise Edition. 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.

Procedure

Copy the templates from the Content Manager Enterprise Edition 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.unix (Linux® or AIX®) 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 in the ORACLE_HOME/network/admin or TNS_ADMIN directory, that you intend to use with the Content Manager Enterprise Edition 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 Enterprise Edition 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 Enterprise Edition 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 Enterprise Edition. On Linux and AIX, the default path is /opt/IBM/db2cmv8. On Windows, the default directory is C:\Program Files\IBM\db2cmv8.

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, you must specify a LD_LIBRARY_PATH. For AIX, you must specify a LIBPATH instead.
- For Linux and AIX, the library server shared object library names are ICMPORSP and ICMPORSV. For Windows, the library server DLLs are ICMPORSP.dll and ICMPORSV.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.

Example

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

Linux, AIX

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/12.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/12.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\12.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 =
  )