クライアントHOME=/u01/app/oracle/product/19.0.0/client_1
CMANポート=1525
-- 1. Connection Managerインストール
cd /tmp
unzip LINUX.X64_193000_client.zip
LANG=C ./client/runInstaller
Custom
Oracle Connection Manager
Oracle Net Listener
-- 2. cman.oraファイルの構成
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/client_1
cd $ORACLE_HOME/network/admin
cp samples/cman.ora .
vi cman.ora
cman_mmm111.example.com =
(configuration=
(address=(protocol=tcp)(host=mmm111.example.com)(port=1525))
(parameter_list =
(registration_invited_nodes=mmm111.example.com)
(idle_timeout=0)
(inbound_connect_timeout=0)
(session_timeout=0)
(outbound_connect_timeout=0)
)
(rule_list=
(rule=
(src=*)(dst=*)(srv=*)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
)
)
)
vi listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mmm111.example.com)(PORT = 1525))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
-- 3. Oracle Connection Managerの起動
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/client_1
$ORACLE_HOME/bin/lsnrctl status
$ORACLE_HOME/bin/cmctl STARTUP
$ORACLE_HOME/bin/cmctl show all
$ORACLE_HOME/bin/cmctl show services
$ORACLE_HOME/bin/cmctl SHUTDOWN
-- 4. Oracle Databaseサーバーの構成
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
$ORACLE_HOME/bin/lsnrctl status
$ORACLE_HOME/bin/lsnrctl start
$ORACLE_HOME/bin/sqlplus / as sysdba
show parameter listener
alter system set REMOTE_LISTENER= '(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST= mmm111.example.com)(PORT=1525))))' scope=both sid='*';
show parameter listener
alter system register;
-- 5. クライアントの構成
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/client_1
vi $ORACLE_HOME/network/admin/tnsnames.ora
orcl_cm=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=mmm111.example.com)(PORT=1525))
(CONNECT_DATA=
(SERVICE_NAME=orcl.example.com)))
$ORACLE_HOME/bin/sqlplus sys/oracle@orcl_cm as sysdba
