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
