Installing Oracle Connection Manager on Ubuntu

 Installing Oracle Connection Manager (CMAN) on Ubuntu Linux involves several steps, primarily focused on preparing the environment and then using the Oracle Universal Installer (OUI) with a response file.

1. Prepare the Ubuntu Environment:

• Create Oracle User and Groups: Create a dedicated Oracle user and necessary groups like oinstall and dba.

Code

    sudo addgroup oinstall
    sudo addgroup dba
    sudo useradd -g oinstall -G dba oracle
    sudo passwd oracle

• Create Directories: Create the Oracle Base, Oracle Home, and Oracle Inventory directories.

Code

    sudo mkdir -p /opt/oracle/base/product/cman_home
    sudo mkdir -p /opt/oracle/oraInventory
    sudo chown -R oracle:oinstall /opt/oracle

• Install Prerequisites: Ensure necessary libraries are installed.

Code

    sudo apt-get update
    sudo apt-get install -y libaio1

• Configure Kernel Parameters (Optional but Recommended): Adjust kernel parameters in /etc/sysctl.conf for optimal Oracle performance. For CMAN, these might be less critical than for a full database, but good practice.

Code

    # Example values, adjust as needed
    fs.aio-max-nr = 1048576
    fs.file-max = 6815744
    kernel.shmall = 2097152
    kernel.shmmax = 2147483648
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    net.ipv4.ip_local_port_range = 9000 65500
    net.core.rmem_default = 262144
    net.core.rmem_max = 4194304
    net.core.wmem_default = 262144
    net.core.wmem_max = 1048576

Apply changes: sudo sysctl -p

2. Download Oracle Database Client and CMAN:

• Download the Oracle Database Client installation files that include CMAN (e.g., client_cman_home.zip) from the Oracle website.
• Transfer the files to the designated Oracle Home directory (e.g., /opt/oracle/base/product/cman_home).
• Unzip the files as the oracle user.

3. Create a Response File:

• Create a response file (e.g., cman_install.rsp) as the oracle user in the Oracle Home directory.

Code

    oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v19.0.0
    ORACLE_HOSTNAME=your_cman_hostname
    UNIX_GROUP_NAME=oinstall
    INVENTORY_LOCATION=/opt/oracle/oraInventory
    ORACLE_HOME=/opt/oracle/base/product/cman_home
    ORACLE_BASE=/opt/oracle/base
    oracle.install.client.installOption=CUSTOM
    oracle.install.client.customComponents="oracle.cman:19.0.0.0.0"

Note: Adjust version numbers and paths as per your specific Oracle Client version.

4. Run the Oracle Universal Installer (OUI):

• Log in as the oracle user.
• Navigate to the unzipped client directory containing runInstaller.
• Execute the installer in silent mode using the response file.

Code

    /path/to/runInstaller -silent -responseFile /opt/oracle/base/product/cman_home/cman_install.rsp

5. Execute Root Scripts:

• After the installation completes, the OUI will prompt you to run specific scripts as the root user.

Code

    sudo /opt/oracle/oraInventory/orainstRoot.sh
    sudo /opt/oracle/base/product/cman_home/root.sh

6. Configure CMAN:

• Create and configure the cman.ora file in $ORACLE_HOME/network/admin to define CMAN parameters, listener addresses, and access control rules.
• Create sqlnet.ora if required for specific network configurations like SSL.

7. Start CMAN Services:

• Use cmctl to start and manage the CMAN listener.

Code

    cmctl start cman