Print Page - CMOD Oracle

Title: CMOD Oracle
Post by: yousuf_gani on February 05, 2015, 12:39:20 PM

Hi,

In CMOD We have requirement to change the StandAlone Oracle with the Managed Service DBaaS (Oracle Service).
Just want to Know the How the tnsnames.ora is refered by the ars.ini

In Ars.ini
SRVR_INSTANCE=<INST_NAME> will refer the "<INST_NAME>.world" from tnsnames.ora?

In tnsname.ora
<INST_NAME>.world=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(PORT=000)(HOST=<Host>)))(CONNECT_DATA=(SID=<INST_NAME>)))

If that is the can we have <INST_NAME> different?
ie like "@SRV@_<INST_NAME>" can be different from "SRVR_INSTANCE=<INST_NAME_XX>"

Please suggest...

Thanks
Mohd Yousuf gani

Title: Re: CMOD Oracle
Post by: kbsiva on February 18, 2015, 04:13:46 AM

Hi,

To your statement :-

@SRV@_<INST_NAME>" can be different from "SRVR_INSTANCE=<INST_NAME_XX>"

Yes they can be different.

@SRV_@<INST_NAME> is the name of the CMOD instance. Here INST_NAME can be anything like archive or archive_prod etc.

Now here,

SRVR_INSTANCE=<INST_NAME_XX>

INST_NAME_XX will be the ORACLE_SID .

Hope this helps,

Siva

Title: Re: CMOD Oracle
Post by: yousuf_gani on February 19, 2015, 11:36:28 AM

Hi SIva,

Thanks a lot for the Info,
1 more Query

Now here,
SRVR_INSTANCE=<INST_NAME_XX> INST_NAME_XX will be the ORACLE_SID .

The 'FileSpace' Name(<instnceName/idxtable/> from TSM and CACHE folder Structure also depends on the 'SRVR_INSTANCE' value?
Thanks a lot for all your support...

Thanks
Mohd Yousuf gani

Title: Re: CMOD Oracle
Post by: kbsiva on March 06, 2015, 11:14:27 PM

Hi,
Yes cache depends on the ORACLE_SID value.

Thanks
Siva

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: yousuf_gani on February 05, 2015, 12:39:20 PM