tag:blogger.com,1999:blog-4096575.post7580496864125239244..comments2024-03-19T03:20:26.726-04:00Comments on The Arup Nanda Blog: Setting Up Oracle Connection ManagerArup Nandahttp://www.blogger.com/profile/03392706779349258765noreply@blogger.comBlogger29125tag:blogger.com,1999:blog-4096575.post-90196346049514201132013-04-07T05:29:10.067-04:002013-04-07T05:29:10.067-04:00Thanks for the amazing article here. I was searchi...Thanks for the amazing article here. I was searching for something like that for quite a long time and at last I have found it here. Your blog is better than others because of useful and meaningful posts. Keep posting them in the future too, I will be waiting for that!<br /><a href="http://www.vitalsofttech.com/" rel="nofollow">Oracle Goldengate</a>Anonymoushttps://www.blogger.com/profile/03605696969730584916noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-1739975691192078212013-03-25T09:55:25.501-04:002013-03-25T09:55:25.501-04:00Arup - Nice post and thx for sharing. Oracle Conne...Arup - Nice post and thx for sharing. Oracle Connection Manager works if client got Oracle at there end. Let's say client's connection is ODBC/JDBC...in that case Connection Manager Concept works ? If yes, than what set up would be requird ? If not, then do we have any work around for such solutions using Proxy in between Client and Oracle DB ?<br />Thanks<br />Jitesh R. (jrughani@gmail.com) <br />Jiteshhttps://www.blogger.com/profile/18177859887976350971noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-58785099022504511032013-03-11T12:56:50.864-04:002013-03-11T12:56:50.864-04:00your post diagram is technically wrong please corr...your post diagram is technically wrong please correct it. <a href="http://freeantivirusdownloadx.com" rel="nofollow">free antivirus download</a>Free Antivirus Downloadhttp://freeantivirusdownloadx.comnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-58655221674296349632012-06-06T03:42:16.188-04:002012-06-06T03:42:16.188-04:00Awesome Post Write it up. This is so useful and in...Awesome Post Write it up. This is so useful and informative for me.. I am really appreciate about your thought. Vote of thanks to shared this information.data recovery expertshttp://www.diskdoctors.com/data-recovery.aspnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-28214584178496674302012-01-31T13:44:32.593-05:002012-01-31T13:44:32.593-05:00DanyC,
I have created a follow up post to this on...DanyC, <br />I have created a follow up post to this one. <br />It's exactly about <a href="http://berxblog.blogspot.com/2012/01/setting-up-oracle-connection-manager.html" rel="nofollow">Setting Up Oracle Connection Manager (without SOURCE_ROUTE)</a>. Hopefully it answers your questions.<br />MartinMartin Bergerhttps://www.blogger.com/profile/16504572924713610305noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-66706145589521282942012-01-29T08:13:43.942-05:002012-01-29T08:13:43.942-05:00Hi Arup,
Very nice post, thx for sharing.
Have yo...Hi Arup,<br /><br />Very nice post, thx for sharing.<br />Have you had the chance to follow up with Martin B about REMOTE_LISTENER config? <br /><br />If yes, would be possible to write/ update the current topic as i'm very interested to see the other approach?<br /><br />Many thanks,<br />DaniDanyCnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-14818946212212680032012-01-12T09:02:18.580-05:002012-01-12T09:02:18.580-05:00Hi Arup,
very interesting post. I am configuring ...Hi Arup,<br /><br />very interesting post. I am configuring CMAN in a 10R2 test environment, but following the docs I did not be able to make the client connection working.<br /><br />The parameter SOURCE_ROUTE is not indicated in the doc, and I lost lot of time looking for solution.<br /><br />So your post has been very appreciated!<br />Thank you very much<br /><br />M.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-4967756054979940092012-01-11T09:44:18.127-05:002012-01-11T09:44:18.127-05:00@Davide - by SCANIP, you mean the DNS hostname of ...@Davide - by SCANIP, you mean the DNS hostname of the SCAN, correct? Well, I haven't tried it; but I did successfully use the three actual IPs associated with the SCANIP DNS hostname. You could do that way.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-68497462693129065452012-01-11T08:08:43.418-05:002012-01-11T08:08:43.418-05:00Hi Arup,
this note is very usefull for me.
A quest...Hi Arup,<br />this note is very usefull for me.<br />A question, if in tns_cm i use only cmhost and in the cman.ora I specify:<br /><br />(RULE_LIST= <br /> (RULE=(SRC=*)(DST=SCAN-IP)(SRV=*)(ACT=accept)) <br /> (rule=(src=CMHost)(dst=127.0.0.1)(srv=cmon)(act=accept)))) <br /><br />with RAC SCAN-IP, it works?Davidehttps://www.blogger.com/profile/15643026226261263709noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-5715316210780082692011-12-15T01:55:12.202-05:002011-12-15T01:55:12.202-05:00Great post. What are your thoughts on using Oracle...Great post. What are your thoughts on using Oracle Database Firewall to control the sqlnet traffic?<br />Thanks<br />ValValnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-56899927009619578352011-11-30T06:21:59.101-05:002011-11-30T06:21:59.101-05:00Thanks for sharing your info. I really appreciate ...Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.SEO toolshttp://seotoolster.com/seotoolsternoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-870622603017614612011-09-22T16:17:32.380-04:002011-09-22T16:17:32.380-04:00Excellent ... You make it so easy to understand. T...Excellent ... You make it so easy to understand. ThanksKarunahttps://www.blogger.com/profile/00157274080956232708noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-58862906713932835392011-09-22T16:16:01.547-04:002011-09-22T16:16:01.547-04:00This comment has been removed by the author.Karunahttps://www.blogger.com/profile/00157274080956232708noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-13658490916500622322011-09-07T15:23:42.308-04:002011-09-07T15:23:42.308-04:00Alexandre,
easy connect only provides one host - ...Alexandre, <br /><i>easy connect</i> only provides <b>one</b> <i>host</i> - so you can not use <i>(SOURCE_ROUTE = YES)</i>. If you make the Instances register them to the cman, it will work.Martin Bergerhttps://www.blogger.com/profile/16504572924713610305noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-68695114256991514452011-09-07T14:26:54.826-04:002011-09-07T14:26:54.826-04:00Hi Arup. Can I use cm with easy connect naming met...Hi Arup. Can I use cm with easy connect naming method?<br /><br />Thank´s<br /><br />Alexandre Marti.Alexandre Martihttps://www.blogger.com/profile/02893874964520119060noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-4822037128274131942011-09-04T01:42:43.914-04:002011-09-04T01:42:43.914-04:00Hello Arup,
Oracle open world is around this mont...Hello Arup,<br /><br />Oracle open world is around this month-end,would be great to know if any upcoming presentation related to 11gR2 RAC from your side are in line for the same.<br /><br />Thanks,<br />JatinJatin Gulatihttps://www.blogger.com/profile/14068179537053788489noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-85685757506728919902011-09-02T20:49:57.893-04:002011-09-02T20:49:57.893-04:00@jcnars your last comment somehow does not show up...@jcnars your last comment somehow does not show up here in the blog; but I got the comments via email. Can you repost the comment? Hopefully that will make the comment show up.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-61534493619122238882011-09-02T20:28:04.934-04:002011-09-02T20:28:04.934-04:00@jcnars The CM is installed in a "different&q...@jcnars The CM is installed in a "different" server. Please refer to the figure. Installing CM on the same server as the database itself won't make any sense.<br /><br />Oracle software comes in three broad categories:<br /><br />(1) Grid Infrastructure<br />(2) Database<br />(3) Client<br /><br />#2 includes #3 as well. On the different server (CM), you need to install the Client software; not the database software or GI software. Even if you have DB installed there, and even though DB software has client; you still need to install the client in a separate home.<br /><br />Hope this helps.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-66560696985841692502011-09-02T16:31:09.168-04:002011-09-02T16:31:09.168-04:00Here's a dumb question from someone new to OCM...Here's a dumb question from someone new to OCM:<br /><br />"If not, install CM by running the installer from Oracle Client (not Database or Grid Infra) software".<br /><br />I take it to mean "If not, install CM by running the installer from Oracle Client (not Database or Grid Infra) software INTO A NEW ORACLE HOME IN THE EXADATA (or the database)SERVER" <br /><br />Will i right in assuming that?jcnarsnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-52353250026183694652011-09-02T13:53:59.404-04:002011-09-02T13:53:59.404-04:00@Martin could you please email me at arup@proligen...@Martin could you please email me at arup@proligence.com? I would like to follow up on this.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-30716035653121990492011-09-02T01:10:09.316-04:002011-09-02T01:10:09.316-04:00Arup,
I fear I was not clear in my question, as y...Arup, <br />I fear I was not clear in my question, as you know the setup for sure:<br />You are using the SOURCE_ROUTING config - so every clients tnsnames.ora need to be configured with this parameter. <br />I prefer a small tnsnames.ora on the clients side, with only <i> (PROTOCOL = TCP)(HOST = cmhost1)(PORT = 1950)</i>, but without the <i>SOURCE_ROUTING</i> and without the <i>(PROTOCOL = TCP)(HOST = dbhost1)(PORT = 1521)</i>. For this configuration I have to change the <i>REMOTE_LISTENER</i> in the related DBs spfile from <i>dbhost1:1521</i> to a pre-created tnsnames.ora entry on all DB-hosts, eg. (in tnsnames.ora): SCAN_CMAN= .... ADDRESS_LIST=(ADDRESS ... (HOST=SCAN1) ... HOST=(SCAN2) ... (HOST=SCAN3) ...(HOST=host1-vip) ... <b>(HOST= cmhost1)</b> )<br />With the spfile having <i>remote_listener=SCAN_CMAN</i>, pmon registers it's services not only to it's local listeners, but also to CMAN. <br />By that method I can also see all the available services in <i>CMCTL> show services</i>Martin Bergerhttps://www.blogger.com/profile/16504572924713610305noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-40308710741962778622011-09-02T00:53:47.536-04:002011-09-02T00:53:47.536-04:00Hi Arup,
I was thinking of restricting applicatio...Hi Arup,<br /><br />I was thinking of restricting applications like toad,sqldev access to the database. I guess OCM and DB Vault can be complimentary. :) <br /><br />Regards,<br />Royroyskihttps://www.blogger.com/profile/01294659620663764982noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-10307237825044489012011-09-02T00:46:28.051-04:002011-09-02T00:46:28.051-04:00@Martin - the target database is a 11.2 RAC one, w...@Martin - the target database is a 11.2 RAC one, where a SCAN listener is used for client connections. That's the one I have used. However, it can be any listener - not necessarily the SCAN one.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-54934728471174405762011-09-02T00:43:36.001-04:002011-09-02T00:43:36.001-04:00Arup,
Is there a reason why you prefered SOURCE_R...<i>Arup</i>, <br />Is there a reason why you prefered <b>SOURCE_ROUTE</b> against <b>REMOTE_LISTENER</b> config? I like the REMOTE_LISTENER method more, as a change in the setup does not require a rollout of tnsnames.ora to the clients.Martin Bergerhttps://www.blogger.com/profile/16504572924713610305noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-89868402684842345902011-09-02T00:41:26.602-04:002011-09-02T00:41:26.602-04:00@royski Not at all. DB Vault separates the accesse...@royski Not at all. DB Vault separates the accesses of SYSDBA and schema. CM merely acts as a gatekeeper of the connection requestsArup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.com