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
Documentation I found http://www.lc.leidenuniv.nl/awcourse/oracle/network.920/a96580/advcfg.htm#476387 //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."
-- //www.freelists.org/webpage/oracle-l