Install and configure CMAN 19c in the Oracle Cloud, step by step

Installing and configuring CMAN is a trivial activity, but having the steps in one place is better than reinventing the wheel.

Prepare for the install

Download the Oracle Client 19.3.0.0 in the Oracle Database 19c download page.

Choose this one: LINUX.X64_193000_client.zip (64-bit) (1,134,912,540 bytes) , not the one named “LINUX.X64_193000_client_home.zip” because it is a preinstalled home that does not contain the CMAN tools.

Access the OCI Console and create a new Compute instance. The default configuration is OK, just make sure that it is Oracle Linux 7

Do not forget to add your SSH Public Key to access the VM via SSH!

Access the VM using

ssh opc@{public_ip}

1	ssh opc@{public_ip}

Copy the Oracle Client zip in /tmp using your favorite scp program.

Install CMAN

Follow these steps to install CMAN:

# become root
sudo su - root

# install some prereqs (packages, oracle user, kernel params, etc.):
yum install oracle-database-preinstall-19c.x86_64

# prepare the base directory:
mkdir /u01
chown oracle:oinstall /u01

# become oracle
su - oracle

# prepare the Oracle Home dir
mkdir -p /u01/app/oracle/product/cman1930

# unzip the Client install binaries
mkdir -p $HOME/stage
cd $HOME/stage
unzip /tmp/LINUX.X64_193000_client.zip

# prepare the response file:
cat <<EOF > $HOME/cman.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v19.0.0
ORACLE_HOSTNAME=$(hostname)
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle/product/cman1930
ORACLE_BASE=/u01/app/oracle
oracle.install.client.installType=Custom
oracle.install.client.customComponents="oracle.sqlplus:19.0.0.0.0","oracle.network.client:19.0.0.0.0","oracle.network.cman:19.0.0.0.0","oracle.network.listener:19.0.0.0.0"
EOF

# install!
$HOME/stage/client/runInstaller -silent -responseFile $HOME/cman.rsp  ORACLE_HOME_NAME=cman1930

# back as root:
exit

# finish the install
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/cman1930/root.sh

# become root

sudo su - root

# install some prereqs (packages, oracle user, kernel params, etc.):

yum install oracle-database-preinstall-19c.x86_64

# prepare the base directory:

mkdir /u01

chown oracle:oinstall /u01

# become oracle

su - oracle

# prepare the Oracle Home dir

mkdir -p /u01/app/oracle/product/cman1930

# unzip the Client install binaries

mkdir -p $HOME/stage

cd $HOME/stage

unzip /tmp/LINUX.X64_193000_client.zip

# prepare the response file:

cat <<EOF > $HOME/cman.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v19.0.0

ORACLE_HOSTNAME=$(hostname)

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/u01/app/oracle/product/cman1930

ORACLE_BASE=/u01/app/oracle

oracle.install.client.installType=Custom

oracle.install.client.customComponents="oracle.sqlplus:19.0.0.0.0","oracle.network.client:19.0.0.0.0","oracle.network.cman:19.0.0.0.0","oracle.network.listener:19.0.0.0.0"

EOF

# install!

$HOME/stage/client/runInstaller -silent -responseFile $HOME/cman.rsp ORACLE_HOME_NAME=cman1930

# back as root:

exit

# finish the install

/u01/app/oraInventory/orainstRoot.sh

/u01/app/oracle/product/cman1930/root.sh

Basic configuration

# as oracle:

mkdir -p /u01/app/oracle/network/admin
export TNS_ADMIN=/u01/app/oracle/network/admin

cat <<EOF > $TNS_ADMIN/cman-test.ora
cman-test = (configuration=
  (address=(protocol=tcp)(host=$(hostname))(port=1521))
  (parameter_list =
    (log_level=ADMIN)
    (max_connections=1024)
    (idle_timeout=0)
    (registration_invited_nodes = *)
    (inbound_connect_timeout=0)
    (session_timeout=0)
    (outbound_connect_timeout=0)
    (max_gateway_processes=16)
    (min_gateway_processes=2)
    (remote_admin=on)
    (trace_level=off)
    (max_cmctl_sessions=4)
    (event_group=init_and_term,memory_ops)
  )
  (rule_list=
    (rule=
       (src=*)(dst=*)(srv=*)(act=accept)
       (action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
  ) )
)
EOF

echo "IFILE=${TNS_ADMIN}/cman-test.ora" >> $TNS_ADMIN/cman.ora

# as oracle:

mkdir -p /u01/app/oracle/network/admin

export TNS_ADMIN=/u01/app/oracle/network/admin

cat <<EOF > $TNS_ADMIN/cman-test.ora

cman-test = (configuration=

(address=(protocol=tcp)(host=$(hostname))(port=1521))

(parameter_list =

(log_level=ADMIN)

(max_connections=1024)

(idle_timeout=0)

(registration_invited_nodes = *)

(inbound_connect_timeout=0)

(session_timeout=0)

(outbound_connect_timeout=0)

(max_gateway_processes=16)

(min_gateway_processes=2)

(remote_admin=on)

(trace_level=off)

(max_cmctl_sessions=4)

(event_group=init_and_term,memory_ops)

)

(rule_list=

(rule=

(src=*)(dst=*)(srv=*)(act=accept)

(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))

) )

)

EOF

echo "IFILE=${TNS_ADMIN}/cman-test.ora" >> $TNS_ADMIN/cman.ora

This will create a CMAN configuration named cman-test. Beware that it is very basic and insecure. Please read the CMAN documentation if you want something more secure or sophisticated.

The advantage of having the TNS_ADMIN outside the Oracle Home is that if you need to patch CMAN, you can do it out-of-place without the need to copy the configuration files somewhere else.

The advantage of using IFILE inside cman.ora, is that you can manage easily different CMAN configurations in the same host without editing directly cman.ora, with the risk of messing it up.

Preparing the start/stop script

Create a file /u01/app/oracle/scripts/cman_service.sh with this content:

#!/bin/bash -l

LOCAL_PARSE_OPTIONS="a:c:o:"

Usage () {
        cat <<EOF

        Purpose   : Start/stop a CMAN configuration

        Usage: `basename $0` -a {start|stop|reload|restart|status} -c <config_name> -o <oracle_home>

        Options:
                -a action           One in start|stop|reload|restart|status
                -c config_name      Name of the cman instance (e.g. ais-prod, gen-prod, etc.)
                -o oracle_home      The ORACLE_HOME path that must be used for the operation (e.g. cman1930)
EOF
}


CENTRAL_CONFIG_DIR=/ORA/dbs01/oracle/network/admin

while getopts ":${LOCAL_PARSE_OPTIONS}" opt ; do
        case $opt in
                a)
                        L_Action=$OPTARG
                        ;;
                c)
                        L_Config=$OPTARG
                        ;;
                o)
                        L_OH=$OPTARG
                        ;;
                \?)
                        eerror "Invalid option: -$OPTARG"
                        exit 1
                        ;;
                :)
                        eerror "Option -$OPTARG requires an argument."
                        exit 1
                        ;;
        esac
done

if [ ! $L_Config ] ; then
    Usage
        eerror "Please specify a configuration name with -c. Possible values are: "
        ls -1 $CENTRAL_CONFIG_DIR | sed -e "s/\.ora//" | grep -v cman
        exit 1
fi


## if the install step was OK, we should have a valid OH installed with this name:
export ORACLE_HOME=$L_OH
if [ ! -f $ORACLE_HOME/bin/cmctl ] ; then
        Usage
        echo "Please set a valid ORACLE_HOME name with -o."
        exit 1
fi


export TNS_ADMIN=$CENTRAL_CONFIG_DIR
case $L_Action in
        start)
                $OH/bin/cmctl startup -c $L_Config
                ;;
        stop)
                $OH/bin/cmctl shutdown -c $L_Config
                ;;
        reload)
                $OH/bin/cmctl reload -c $L_Config
                ;;
        restart)
                $OH/bin/cmctl shutdown -c $L_Config
                sleep 1
                $OH/bin/cmctl startup -c $L_Config
                ;;
        status)
                $OH/bin/cmctl show status -c $L_Config
                # do it again for the exit code
                $OH/bin/cmctl show status -c $L_Config | grep "The command completed successfully." >/dev/null
                ;;
        *)
                echo "Invalid action"
                exit 1
                ;;
esac

#!/bin/bash -l

LOCAL_PARSE_OPTIONS="a:c:o:"

Usage () {

cat <<EOF

Purpose : Start/stop a CMAN configuration

Usage: `basename $0` -a {start|stop|reload|restart|status} -c <config_name> -o <oracle_home>

Options:

-a action One in start|stop|reload|restart|status

-c config_name Name of the cman instance (e.g. ais-prod, gen-prod, etc.)

-o oracle_home The ORACLE_HOME path that must be used for the operation (e.g. cman1930)

EOF

}

CENTRAL_CONFIG_DIR=/ORA/dbs01/oracle/network/admin

while getopts ":${LOCAL_PARSE_OPTIONS}" opt ; do

case $opt in

L_Action=$OPTARG

;;

L_Config=$OPTARG

;;

L_OH=$OPTARG

;;

\?)

eerror "Invalid option: -$OPTARG"

exit 1

;;

eerror "Option -$OPTARG requires an argument."

exit 1

;;

esac

done

if [ ! $L_Config ] ; then

Usage

eerror "Please specify a configuration name with -c. Possible values are: "

ls -1 $CENTRAL_CONFIG_DIR | sed -e "s/\.ora//" | grep -v cman

exit 1

## if the install step was OK, we should have a valid OH installed with this name:

export ORACLE_HOME=$L_OH

if [ ! -f $ORACLE_HOME/bin/cmctl ] ; then

Usage

echo "Please set a valid ORACLE_HOME name with -o."

exit 1

export TNS_ADMIN=$CENTRAL_CONFIG_DIR

case $L_Action in

start)

$OH/bin/cmctl startup -c $L_Config

;;

stop)

$OH/bin/cmctl shutdown -c $L_Config

;;

reload)

$OH/bin/cmctl reload -c $L_Config

;;

restart)

$OH/bin/cmctl shutdown -c $L_Config

sleep 1

$OH/bin/cmctl startup -c $L_Config

;;

status)

$OH/bin/cmctl show status -c $L_Config

# do it again for the exit code

$OH/bin/cmctl show status -c $L_Config | grep "The command completed successfully." >/dev/null

;;

echo "Invalid action"

exit 1

;;

esac

This is at the same time ORACLE_HOME agnostic and configuration agnostic.

Make it executable:

chmod +x /u01/app/oracle/scripts/cman_service.sh

1	chmod +x /u01/app/oracle/scripts/cman_service.sh

and try to start CMAN:

$ /u01/app/oracle/scripts/cman_service.sh -o /u01/app/oracle/product/cman1930 -c cman-test -a start
VERSION         = 19.3.0.0.0
ORACLE_HOME     = /u01/app/oracle/product/cman1930
VERSION         = 19.3.0.0.0
ORACLE_HOME     = /u01/app/oracle/product/cman1930

CMCTL for Linux: Version 19.0.0.0.0 - Production on 12-JUL-2019 09:23:50

Copyright (c) 1996, 2019, Oracle.  All rights reserved.

Current instance cman-test is not yet started
Connecting to (DESCRIPTION=(address=(protocol=tcp)(host=ocf-cman-1)(port=1521)))
Starting Oracle Connection Manager instance cman-test. Please wait...
CMAN for Linux: Version 19.0.0.0.0 - Production
Status of the Instance
----------------------
Instance name             cman-test
Version                   CMAN for Linux: Version 19.0.0.0.0 - Production
Start date                12-JUL-2019 09:23:50
Uptime                    0 days 0 hr. 0 min. 9 sec
Num of gateways started   2
Average Load level        0
Log Level                 ADMIN
Trace Level               OFF
Instance Config file      /u01/app/oracle/product/cman1930/network/admin/cman.ora
Instance Log directory    /u01/app/oracle/diag/netcman/ocf-cman-1/cman-test/alert
Instance Trace directory  /u01/app/oracle/diag/netcman/ocf-cman-1/cman-test/trace
The command completed successfully.

$ /u01/app/oracle/scripts/cman_service.sh -o /u01/app/oracle/product/cman1930 -c cman-test -a start

VERSION = 19.3.0.0.0

ORACLE_HOME = /u01/app/oracle/product/cman1930

VERSION = 19.3.0.0.0

ORACLE_HOME = /u01/app/oracle/product/cman1930

CMCTL for Linux: Version 19.0.0.0.0 - Production on 12-JUL-2019 09:23:50

Current instance cman-test is not yet started

Connecting to (DESCRIPTION=(address=(protocol=tcp)(host=ocf-cman-1)(port=1521)))

Starting Oracle Connection Manager instance cman-test. Please wait...

CMAN for Linux: Version 19.0.0.0.0 - Production

Status of the Instance

----------------------

Instance name cman-test

Version CMAN for Linux: Version 19.0.0.0.0 - Production

Start date 12-JUL-2019 09:23:50

Uptime 0 days 0 hr. 0 min. 9 sec

Num of gateways started 2

Average Load level 0

Log Level ADMIN

Trace Level OFF

Instance Config file /u01/app/oracle/product/cman1930/network/admin/cman.ora

Instance Log directory /u01/app/oracle/diag/netcman/ocf-cman-1/cman-test/alert

Instance Trace directory /u01/app/oracle/diag/netcman/ocf-cman-1/cman-test/trace

The command completed successfully.

Stop should work as well:

$ /u01/app/oracle/scripts/cman_service.sh -o /u01/app/oracle/product/cman1930 -c cman-test -a stop
VERSION         = 19.3.0.0.0
ORACLE_HOME     = /u01/app/oracle/product/cman1930
VERSION         = 19.3.0.0.0
ORACLE_HOME     = /u01/app/oracle/product/cman1930

CMCTL for Linux: Version 19.0.0.0.0 - Production on 12-JUL-2019 09:28:34

Copyright (c) 1996, 2019, Oracle.  All rights reserved.

Current instance cman-test is already started
Connecting to (DESCRIPTION=(address=(protocol=tcp)(host=ocf-cman-1)(port=1521)))
The command completed successfully.

$ /u01/app/oracle/scripts/cman_service.sh -o /u01/app/oracle/product/cman1930 -c cman-test -a stop

VERSION = 19.3.0.0.0

ORACLE_HOME = /u01/app/oracle/product/cman1930

VERSION = 19.3.0.0.0

ORACLE_HOME = /u01/app/oracle/product/cman1930

CMCTL for Linux: Version 19.0.0.0.0 - Production on 12-JUL-2019 09:28:34

Current instance cman-test is already started

Connecting to (DESCRIPTION=(address=(protocol=tcp)(host=ocf-cman-1)(port=1521)))

The command completed successfully.

Add the service in systemctl

# as root:

cat <<EOF > /etc/systemd/system/cman-test.service
[Unit]
Description=CMAN Service for cman-test
Documentation=http://www.ludovicocaldara.net/dba/cman-oci-install
After=network-online.target

[Service]
User=oracle
Group=oinstall
LimitNOFILE=10240
MemoryLimit=8G
RestartSec=30s
StartLimitInterval=1800s
StartLimitBurst=20
ExecStart=/u01/app/oracle/scripts/cman_service.sh -c cman-test -a start -o /u01/app/oracle/product/cman1930
ExecReload=/u01/app/oracle/scripts/cman_service.sh -c cman-test -a reload -o /u01/app/oracle/product/cman1930
ExecStop=/u01/app/oracle/scripts/cman_service.sh -c cman-test -a stop -o /u01/app/oracle/product/cman1930
KillMode=control-group
Restart=on-failure
Type=forking

[Install]
WantedBy=multi-user.target
Alias=service-cman-test.service
EOF

/usr/bin/systemctl enable cman-test.service

# start
/usr/bin/systemctl start cman-test
# stop
/usr/bin/systemctl stop cman-test

# as root:

cat <<EOF > /etc/systemd/system/cman-test.service

[Unit]

Description=CMAN Service for cman-test

Documentation=http://www.ludovicocaldara.net/dba/cman-oci-install

After=network-online.target

[Service]

User=oracle

Group=oinstall

LimitNOFILE=10240

MemoryLimit=8G

RestartSec=30s

StartLimitInterval=1800s

StartLimitBurst=20

ExecStart=/u01/app/oracle/scripts/cman_service.sh -c cman-test -a start -o /u01/app/oracle/product/cman1930

ExecReload=/u01/app/oracle/scripts/cman_service.sh -c cman-test -a reload -o /u01/app/oracle/product/cman1930

ExecStop=/u01/app/oracle/scripts/cman_service.sh -c cman-test -a stop -o /u01/app/oracle/product/cman1930

KillMode=control-group

Restart=on-failure

Type=forking

[Install]

WantedBy=multi-user.target

Alias=service-cman-test.service

EOF

/usr/bin/systemctl enable cman-test.service

# start

/usr/bin/systemctl start cman-test

# stop

/usr/bin/systemctl stop cman-test

Open firewall ports

By default, new OL7 images use firewalld. Just open the port 1521 from the public zone:

# as root:
firewall-cmd --permanent --add-port=1521/tcp
firewall-cmd --reload

# as root:

firewall-cmd --permanent --add-port=1521/tcp

firewall-cmd --reload

Bonus: have a smart environment!

# as root:
yum install -y git rlwrap

# Connect as oracle
sudo su - oracle

# Clone this repository
git clone https://github.com/ludovicocaldara/COE.git

# Enable the profile scripts
echo ". ~/COE/profile.sh" >> $HOME/.bash_profile

# set the cman1930 home by default:
echo "setoh cman1930" >> $HOME/.bash_profile
echo "export TNS_ADMIN=/u01/app/oracle/network/admin" >> $HOME/.bash_profile

# Load the new profile
. ~/.bash_profile

# as root:

yum install -y git rlwrap

# Connect as oracle

sudo su - oracle

# Clone this repository

git clone https://github.com/ludovicocaldara/COE.git

# Enable the profile scripts

echo ". ~/COE/profile.sh" >> $HOME/.bash_profile

# set the cman1930 home by default:

echo "setoh cman1930" >> $HOME/.bash_profile

echo "export TNS_ADMIN=/u01/app/oracle/network/admin" >> $HOME/.bash_profile

# Load the new profile

. ~/.bash_profile

[root@ocf-cman-1 tmp]# su - oracle
Last login: Fri Jul 12 09:49:09 GMT 2019 on pts/0
VERSION         = 19.3.0.0.0
ORACLE_HOME     = /u01/app/oracle/product/cman1930

# [ oracle@ocf-cman-1:/home/oracle [09:49:54] [19.3.0.0.0 [CLIENT] SID="not set"] 0 ] #
# # ahhh, that;s satisfying

[root@ocf-cman-1 tmp]# su - oracle

Last login: Fri Jul 12 09:49:09 GMT 2019 on pts/0

VERSION = 19.3.0.0.0

ORACLE_HOME = /u01/app/oracle/product/cman1930

# [ oracle@ocf-cman-1:/home/oracle [09:49:54] [19.3.0.0.0 [CLIENT] SID="not set"] 0 ] #

# # ahhh, that;s satisfying

—

Ludo

Bio
Latest Posts

Ludovico

Principal Product Manager at Oracle

Ludovico is a member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle. He focuses on Oracle Data Guard, Flashback technologies, and Cloud MAA.

7 thoughts on “Install and configure CMAN 19c in the Oracle Cloud, step by step”

Anders Wong on March 30, 2021 at 5:06 am said:

Hi Ludovico,

If I have two CMAN installed on two nodes as HA solution, do you know what should I set for remote_listener parameter on the database instance please?

Regards,
AW

Reply ↓
- Ludovico on April 27, 2021 at 1:09 pm said:
  
  Hi Anders,
  
  ‘cman1:1521′,’cman2:1521’
  
  If you have RAC, don’t forget to add your scan address.
  —
  Ludovico
  
  Reply ↓
Carl on January 31, 2020 at 5:03 pm said:

Hi Ludovico —

Great job on this. Very helpful. We also had to fix the $OH missing in the script as follows:

export OH = $L_OH

Regards,
Carl

Reply ↓
Jacco H. Landlust on October 15, 2019 at 11:10 pm said:

Hi Ludo,

Thanks for posting this. Your cman_service.sh script is a bit rough around the edges, mostly because of references to functions / variables that you set in your profile that you deliver via git only after creating the cman_service.sh script: eerror and $OH are not present yet. Nevertheless this was very helpful for me.

Thanks!

Jacco.

Reply ↓
- Ludovico on October 25, 2019 at 12:49 am said:
  
  indeed, sometimes I rely so much on my env scripts that I forget about portability. Thanks Jacco!
  
  Reply ↓
Kalid Hameedullah on August 27, 2019 at 8:49 pm said:

Good article and nice to see a write up on CMAN. We have been using it for past one year (18c) and this technology perfectly fits for our architecture. Providing access to Cloud Native containers based read services accessing the on-prem based monolith Oracle DB’s.

Reply ↓
Grzegorz Goryszewski on July 13, 2019 at 1:32 pm said:

Thanks Ludo, honestly I can’t wait the 19c upgrade series .
Regards.
GG

Reply ↓

DBA survival BLOG

DBA stuff and Oracle Data Guard

Install and configure CMAN 19c in the Oracle Cloud, step by step

Ludovico

Latest posts by Ludovico (see all)

7 thoughts on “Install and configure CMAN 19c in the Oracle Cloud, step by step”

Leave a Reply Cancel reply