I have a new requirement to setup CMOD 9.5 on RHEL with remote ORACLE.
1) I see the parameter ARS_ORACLE_HOIME what would be the value while having remote Oracle? Do I need to install any ORACLE component (Oracle server binary or Oracle client) on the CMOD Library server?
3) Is it necessary to keep the CMOD instance owner id and the Oracle database owner id the same?
2) Can some one share all the CMOD configuration parameters that need to be taken care, and what values are assigned to them.
3) Is tablespace creation user exit required with Oracle on remote server?
With IBM documentation it seems we may not need it if we use default oracle tables space.
3) Is table space creation is a onetime requirement that I can have ORACLE DBA to create when configuring the oracle database?
4) If a tablespace user exit is required can some one share working sample.