Home » Server Options » Data Guard » SAP and Data Guard
SAP and Data Guard [message #119313] Wed, 11 May 2005 14:53 Go to next message
eAddict
Messages: 12
Registered: May 2005
Location: St Louis, MO
Junior Member
I am about to undertake this - setting up DG for an SAP environment. We are running HP-UX and Oracle 9.2.0.4.

Any gotchas? Anything I need to be aware of SAP/ORacle wise before I start?

Thanks!
Vince
Re: SAP and Data Guard [message #119360 is a reply to message #119313] Thu, 12 May 2005 03:41 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Hi,

I cannot think of any. DataGuard is completly transparent to the application. So, SAP will be unaware of the fact that you are using DataGuard.

Best regards.

Frank
Re: SAP and Data Guard [message #119507 is a reply to message #119313] Thu, 12 May 2005 21:44 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
If it is an option, use 10gR1 instead of 9iR2.
Re: SAP and Data Guard [message #119627 is a reply to message #119313] Fri, 13 May 2005 10:05 Go to previous messageGo to next message
eAddict
Messages: 12
Registered: May 2005
Location: St Louis, MO
Junior Member
Thanks for the replies. We are running 9.2.0.6 right now and doesn't look like I will have the chance to upgrade it. Last time I checked SAP didn't say 10 was SAP ready.... that might have changed recently.

Thanks again - I will post how it goes.
Vince
Re: SAP and Data Guard [message #120093 is a reply to message #119360] Tue, 17 May 2005 14:38 Go to previous messageGo to next message
eAddict
Messages: 12
Registered: May 2005
Location: St Louis, MO
Junior Member
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....

Do you have a working example of the files?
Re: SAP and Data Guard [message #120237 is a reply to message #119313] Wed, 18 May 2005 10:09 Go to previous message
eAddict
Messages: 12
Registered: May 2005
Location: St Louis, MO
Junior Member
Got it to work. All it took was another set of eyes. I was missing a ")".
Previous Topic: SAP/DG looking for a few good examples
Next Topic: Oracle 8i Dataguard Problem
Goto Forum:
  


Current Time: Thu Dec 02 14:07:01 CST 2021