This is small summary for Federation Server connect to Oracle server via OCM.
1) install CMAN manually
select customer type install and then choose install Oracle Net Services --> Oracle Connection Manager
2) config CMAN
config file $ORACLE_HOME/network/admin/cman.orayou can get template from $ORACLE_HOME/network/admin/samples/cman.ora
and find log: $ORACLE_HOME/network/log/cman_nisco_li_alert.log
Example:
cman_abc.cn.ibm.com=
(configuration=
(address=(protocol=tcp)(host=abc.cn.ibm.com)(port=1630))
(rule_list=
(rule=
(src=*)(dst=*)(srv=*)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
)
(rule=
(src=abc)(dst=127.0.0.1)(srv=cmon)(act=accept)
)
)
)
Note:
1. address: please set oracle server's hostname and port number for CMAN, default is 1630.
2. rule_list and parameter_list: these are some connection rules and parameters, you can get detail info from samples
$ORACLE_HOME/network/admin/samples/cman.ora.
3) Run CMAN using cmctl
[oracle@abc bin]$ cmctl
CMCTL for Linux: Version 11.1.0.6.0 - Production on 04-FEB-2013 13:38:38
Copyright (c) 1996, 2007, Oracle. All rights reserved.
Welcome to CMCTL, type "help" for information.
CMCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:
administer close* exit quit
reload resume* save_passwd set*
show* shutdown sleep startup
suspend*
You can use administer to start CMAN.
4) Connect to oracle using CMAN
Config oracle client $ORACLE_HOME/network/admin/tnsnames.ora
Example:
PAWCMAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = abc.cn.ibm.com)(PORT = 1630))
(ADDRESS = (PROTOCOL = TCP)(HOST = abc.cn.ibm.com)(PORT = 1521))
(SOURCE_ROUTE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orapawpa)
)
)
Note:
(SOURCE_ROUTE = yes) is requried.
5) IFS connect to Oracle server using CMANTake AIX script for example:
1. create oracle wrapper
CREATE WRAPPER "WRAPPER1" LIBRARY 'libdb2net8.a' OPTIONS(DB2_FENCED 'Y')
CREATE WRAPPER "WRAPPER1" LIBRARY 'libdb2net8.a' OPTIONS(DB2_FENCED 'Y')
2. create server for PAWCMAN
create server "SERVER1" type oracle version 11.0 wrapper "WRAPPER1" authorization "J15USER12" password "J15USER12" options (node 'PAWCMAN', password 'Y', pushdown 'Y')
create server "SERVER1" type oracle version 11.0 wrapper "WRAPPER1" authorization "J15USER12" password "J15USER12" options (node 'PAWCMAN', password 'Y', pushdown 'Y')
3. create user mapping
create user mapping for user server "SERVER1" options ( REMOTE_AUTHID 'J15USER12', REMOTE_PASSWORD 'J15USER12' )
4. Then you can create other federated objects like nickname
create user mapping for user server "SERVER1" options ( REMOTE_AUTHID 'J15USER12', REMOTE_PASSWORD 'J15USER12' )