CMOD Oracle

[yousuf_gani]

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

[kbsiva]

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

[yousuf_gani]

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

[kbsiva]

Hi,
Yes cache depends on the ORACLE_SID value.

Thanks
Siva