trouble getting client connections to connect to the “open” database in a DG environment.

From: Bob <orcl_at_comcast.net>
Date: Sat, 29 Jul 2006 10:10:59 -0400
Message-ID: <44CB6C73.4070201@comcast.net>

All, I'm having trouble getting client connections to connect to the “open” database in a DG environment.
Here is what I have:

Red Hat 4.3, Oracle 10GR2
Node 1 RH1PROD
Node2 RH2DEV
P DEV, service name DEV
S DEV, db_unique_name dev_s, service_name dev_s

I’ve got it so I can switch over using DGMGRL easily back and forth, the logs go where that are supposed to, which tells me my net config on the servers are good. My problem is if I connect from a client the connection is made to whatever instance is running on the first host whether it’s open or mounted. I’ve searched metalink and there was on document 316740.1 that I tried to implement but didn’t work, if you read the doc, its basically worthless, shows service name and hostname to be the same...

I’ve googled, searched the archives here and opened a SR with oracle, they are telling me there *is not * any documentation on this! Anyway, I’m hoping someone can share their config with me, or point me to a good doc. Ill paste in my config files below. I’ve also found it mandatory to have the indtance_DGMGRL line in the listener.ora, without it DGMGRL wont switchover without having to manually restart the instances.

Documentation I found
http://www.lc.leidenuniv.nl/awcourse/oracle/network.920/a96580/advcfg.htm#476387 http://www.freelists.org/archives/oracle-l/04-2006/msg00301.html

Any help would be hugely appreciated
Thanks
Bob
######## primary listener #############

TRACE_FILE_LISTENER = LISTENER.trc
LOG_DIRECTORY_LISTENER = /tech/oracle/network/log TRACE_DIRECTORY_LISTENER = /tech/oracle/network/log LOG_FILE_LISTENER = listener.log
TRACE_LEVEL_LISTENER = USER SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = DEV_DGMGRL)
(ORACLE_HOME = /tech/oracle/product/10.2.0/db_2)
(SID_NAME = DEV)

    )
    (SID_DESC =
(GLOBAL_DBNAME = PROD)
(ORACLE_HOME = /tech/oracle/product/10.2.0/db_2)
(SID_NAME = PROD)

    )
    (SID_DESC =
(GLOBAL_DBNAME = DEV)
(ORACLE_HOME = /tech/oracle/product/10.2.0/db_2)
(SID_NAME = DEV)

    )
    (SID_DESC =
(GLOBAL_DBNAME = RECOP)
(ORACLE_HOME = /tech/oracle/product/10.2.0/db_2)
(SID_NAME = RECOP)

    )
    (SID_DESC =
(GLOBAL_DBNAME = MARTP)
(ORACLE_HOME = /tech/oracle/product/10.2.0/db_2)
(SID_NAME = MARTP)

    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = RH1PROD)(PORT = 1521))   )

######### secondary listener #################

TRACE_FILE_LISTENER = LISTENER.trc
LOG_DIRECTORY_LISTENER = /tech/oracle/network/log TRACE_DIRECTORY_LISTENER = /tech/oracle/network/log LOG_FILE_LISTENER = LISTENER.log
TRACE_LEVEL_LISTENER = USER SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = dev_s_DGMGRL)
(ORACLE_HOME = /tech/oracle/product/10.2.0/db_1)
(SID_NAME = DEV)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = RH2DEV)(PORT = 1521))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = RH2DEV)(PORT = 1512))
    )
  )
####### client tnsnames ##########
dg =
  (DESCRIPTION=
    (ADDRESS_LIST=
(load_balance=off)(failover=on)

        (ADDRESS=
          (PROTOCOL=TCP)(Host=RH1PROD)(Port=1521)
        )
        (ADDRESS=
          (PROTOCOL=TCP)(Host=RH2DEV)(Port=1521)
        )
      )


      (CONNECT_DATA=

        (service_name=DEV)(instance_name=dev)
          (FAILOVER_MODE=
            (TYPE=session)(METHOD=BASIC)(RETRIES=180)(DELAY=5)
          )
        )
      )

-- 
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jul 29 2006 - 09:10:59 CDT