setting up oracle Data Guard

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Tue, 17 May 2005 19:36:56 GMT
Message-ID: <7thk811483mlqii7mm0dlak8f9pul2tns4@4ax.com>

I can't seem to get the tnsnames.ora and listener.ora to be 'correct' when I go to add the failover server.

Here is the working listener.ora when SND is the only system listed:

LISTENER =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=IPC)(KEY= SND.WORLD))
(ADDRESS=(PROTOCOL=IPC)(KEY= SND))
(ADDRESS =(COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)
(HOST = dbcisnd)(PORT = 1527))

)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC = (SDU = 32768)(SID_NAME = SND)
(ORACLE_HOME = /oracle/SND/920_64))

)

And the tnsnames.ora:

SND.WORLD=
(DESCRIPTION = (SDU = 32768)
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)
(HOST = dbcisnd)(PORT = 1527))

)
(CONNECT_DATA = (SID = SND)(GLOBAL_NAME = SND.WORLD))
)

I change them to:
listener.ora
LISTENER =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=IPC)(KEY= SND.WORLD))
(ADDRESS=(PROTOCOL=IPC)(KEY= SND))
(ADDRESS =(COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)
(HOST = dbcisnd)(PORT = 1527))
(ADDRESS = (PROTOCOL=TCP)(HOST=sapude)(PORT-1527)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC = (SDU = 32768)(SID_NAME = SND)
(ORACLE_HOME = /oracle/SND/920_64)

)
)

And the tnsnames.ora:
SND.WORLD=
(DESCRIPTION = (SDU = 32768)
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)
(HOST = dbcisnd)(PORT = 1527))

)
(CONNECT_DATA = (SID = SND)(GLOBAL_NAME = SND.WORLD))
)
SSND.WORLD=
(DESCRIPTION = (SDU = 32768)
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)
(HOST = sapude)(PORT = 1527))

)
(CONNECT_DATA = (SID = SND)(GLOBAL_NAME = SND.WORLD))
)

The listener on the primary (sapsnd/SND) and the failover server
(sapude/SND) don't respond to tnsping anymore....

Does anyone have a working example of the files that they can share?

---

Come race with us!
http://www.mgpmrc.org Received on Tue May 17 2005 - 14:36:56 CDT