8 Replies Latest reply: May 22, 2013 11:03 PM by Law RSS

    Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5

    Law
      I have already installed Oracle RAC 11.2.0.3.5 2 nodes RHEL 64 bit. I need to create db links from Oracle to PostgreSQL so I was wondering if I must install in a new home oracle database gateways for odbc 11.2.0.3 Or Can I use existing RDBMS_HOME (hs/admin)?
        • 1. Re: Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5
          Srini Chavali-Oracle
          Not necessarily -

          How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX Itanium) to Connect to Non-Oracle Databases Post Install [ID 561033.1]

          HTH
          Srini
          • 2. Re: Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5
            Law
            Thanks Srini for the right direction.
            According to MOS, these are the general steps

            0) ODBC driver
            1) listener (in the ORACLE_HOME where the gateway software is installed)
            2) tnsnames (in the ORACLE_HOME where the Oracle database software is installed)
            3) init<SID>.ora of the hs subsystem (in the ORACLE_HOME where the gateway software is installed)
            4) Oracle database

            So, If I doesn't install gateway software, just using GI_HOME and RDBMS_HOME, Can I do this

            0) ODBC driver
            1) listener (in the GI_HOME)
            2) tnsnames (in the RDBMS_HOME where the Oracle database software is installed)
            3) init<SID>.ora of the hs subsystem (in the RDBMS_HOME, because GI_HOME doesn't have hs/admin directory)
            4) Oracle database (dblinks)

            Thanks in advance for your time.
            • 3. Re: Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5
              Kgronau-Oracle
              There have always been a couple of issues when you use the GI_Home listener. I commonly prefer to install the gateway into its own home as I can then patch the database and the gateway software independently. Sometimes you for example can't apply a database patch when a certain gateway patch is applied as both change the same file. There are also some parameters (inbound connect timeout) that have an impact on the gateway session.
              - Klaus
              • 4. Re: Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5
                Law
                thanks kgronau

                If I go to install DG4ODBC new Home, it means that, Do I need to config and start a Listener Gateway and init<sid>.ora from this new home?

                and second one, can I use same user of rdbms_home or create new one?

                thank for your time.
                • 5. Re: Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5
                  Kgronau-Oracle
                  Keep everything related to the gateway (gateway listener and gateway init file) in the gateway Oracle_home - so create a new listener that just spawns the gateway process in the gateway home. You shouldn't mix Gateway and Database homes (like for example using the database listener to spawn the gateway residing in its own home) - it will work in general, but it will be difficult to maintain this environment.
                  • 6. Re: Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5
                    Law
                    thanks kgronau

                    This gateway listener wont be on a cluster stack even has nothing todo with the scan, vip and high avaliability, right?

                    btw, Do I need to create a new oracle user in order to install and config dg4odbc?

                    On more thing

                    My RDBMS_HOME has hs/admin directory and files, are those 64 bit complain?. My platform is RHEL 6.2 64bit with Oracle Clusterware and Rac 64 bit too.


                    Best regards
                    • 7. Re: Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5
                      Kgronau-Oracle
                      It's not needed to put the gateway listener into the cluster - there's no advantage of doing so:
                      You connect to a foreign database, so there is for example no select failover capability hence no need to put the gateway into the cluster. If you want to have a high availability solution just set up on each cluster node in its own, dedicated directory the gateway software and specify in the tnsnames.ora within the address section the keyword (failover=yes) similar to:
                      (ADDRESS = (PROTOCOL = TCP) (HOST = racnode1-vip)(PORT=1521))
                      (ADDRESS = (PROTOCOL = TCP) (HOST = racnode2-vip)(PORT=1521))
                      (FAILOVER = yes)
                      SQL*Net will then check if the node is available and use the other one just in case it is down.

                      2. Do I need to create a new oracle user in order to install and config dg4odbc? => no need to do so, but you can... you only need to make sure that you always source the env correctly. You can do that using "oraenv" or writing your own shell script or define a dedicated user for the gateway software.

                      On 64bit platforms you have to install the 64bit Gateway software - when you installed the 64bit Oracle database then you automatically got the 64boit gateway DG4ODBC software installed.
                      SIDE NOTE:
                      When installing the 64bit Gateway software, please make sure you also have a 64bit ODBC driver and ODBC Driver Manager software installed.


                      - Klaus
                      • 8. Re: Do I need to install DG4ODBC new Home on an existing RAC install 11.2.0.3.5
                        Law
                        Thank you so much Mr. Kgronau
                        You help me a lot with your answers