Interconnect Oracle-Home location
==============================
Find out setting of $ORACLE_HOME on your system
Adapters Location
================
$ORACLE_HOME/integration/interconnect/adapters
Interconnect repository log file location
=================================
cd $ORACLE_HOME/integration/interconnect/repository/
reposlog.txt is the logfile name
you should see message "*** Initialization is complete and repository is ready ***" in the log file
Other log files >>>
$ORACLE_HOME/opmn/logs
$ORACLE_HOME/webcache/logs
Adapters logfile location
=====================
Adapters logfile can be find under $ORACLE_HOME/integration/interconnect/adapters/<adapter_name>/logs/ directory
For example for the SPEE_JDBC adapter:
[aixprod:appprod:/Prodinterconnect/IC10g/integration/interconnect/adapters/SPEE_JDBC/logs/1317361458107:] ls -ltr
total 64
-rw-r--r-- 1 appprod dba 3738 Sep 30 02:00 log.xml
Command to check the status of all available adapters
==============================================
opmnctl status -fmt %cmp18%prt30%pid7R%sta8%uid10R%mem8R%utm9R%por
Command to check the status of Interconnect Repository
=================================================
cd $ORACLE_HOME/integration/interconnect/bin
./ICManager -component repository -name InterConnectRepository -action ping
[aixprod:appprod:/Prodinterconnect/IC10g/integration/interconnect/bin:] ./ICManager -component repository -name InterConnectRepository -action ping
Repository :
Name = Repository
Status = Running
Alive Time = 29 hours 27 minutes 50 seconds
Command to check the ichub password used in interconnect setup/operation
==================================================================
"ichub" is the database user which is used for interconnect setup/operation
cd $ORACLE_HOME/integration/interconnect/bin
[aixserver:appdev:/Dev/IC10g/integration/interconnect/bin:] ./OracleWallet -viewsecret hub_password
Enter the admin password: <password>
sed4ddd
NOTE: Check by doing SQLPLUS that the password is right.
¦ List all passwords in the store
./OracleWallet -listsecrets
then after use below command to check the password of the required userid.
./OracleWallet -viewsecret
To update the ichub password used in interconnect setup/operation
==========================================================
cd $ORACLE_HOME/integration/interconnect/bin
./OracleWallet -updatesecret hub_password
To stop an adapter
=================
opmnctl stopproc process-type=<adapter_name>
for example :
opmnctl stopproc process-type=CORP_IND2EBS_MATTXN_JDBC
To start an adapter
================
opmnctl startproc process-type=<adapter_name>
for example:
opmnctl startproc process-type=CORP_EBS2IND_ORDER_AQ
For bouncing COMPLETE Interconnect services
=========================================
opmnctl stopall
opmnctl startall