OraFAQ Forum: Data Guard » SAP and Data Guard

Home » Server Options » Data Guard » SAP and Data Guard

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SAP and Data Guard [message #119313]

Wed, 11 May 2005 14:53

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

Report message to a moderator

Re: SAP and Data Guard [message #119360 is a reply to message #119313]

Thu, 12 May 2005 03:41

Frank Naude
Messages: 4595
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

Report message to a moderator

Re: SAP and Data Guard [message #119507 is a reply to message #119313]

Thu, 12 May 2005 21:44

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

If it is an option, use 10gR1 instead of 9iR2.

Report message to a moderator

Re: SAP and Data Guard [message #119627 is a reply to message #119313]

Fri, 13 May 2005 10:05

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

Report message to a moderator

Re: SAP and Data Guard [message #120093 is a reply to message #119360]

Tue, 17 May 2005 14:38

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?

Report message to a moderator

Re: SAP and Data Guard [message #120237 is a reply to message #119313]

Wed, 18 May 2005 10:09

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 ")".

Report message to a moderator

Previous Topic:	SAP/DG looking for a few good examples
Next Topic:	Oracle 8i Dataguard Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 12:53:23 CDT 2025