Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SAP and Oracle DG: Looking for ideas and best practices

Re: SAP and Oracle DG: Looking for ideas and best practices

From: Andy France <andyATzespriDOTcom>
Date: Wed, 06 Jul 2005 11:06:24 +1200
Message-ID: <11cm4jmmi6f845d@news.supernews.com>


Andy France wrote:
> Vince Laurent wrote:
>

>> We have 2 servers with the following configuration:
>>
>> role    server               SID
>> ------- -------------------  ---
>> primary sapsnd.ic.ssmhc.com  SND
>> standby sapude.ic.ssmhc.com  SND
>>
>> I managed to get oracle data guard working to where I
>> can fail sapsnd over to sapude.  NOW we are trying to
>> figure out how to bring SAP up on sapude.  Ideas we are pondering 
>> include changing DNS or changing the IP
>> of sapude to make it sapsnd.
>>
>> Someone must have done this before.  What have you found to be best 
>> practice?
>> Thanks
>> Vince
>> -----------------------------------------------------
>> Come race with us!
>> http://www.mgpmrc.org

>
>
> Your main problem will probably be that the SAP profiles are bound to
> the host name. The IP itself doesn't really matter as SAP binds itself
> to all interfaces (in my experience with 4.0B anyway).
>
> If you copy all of the application directories for SAP (using a
> scheduled rsync or such), and the sidadm user home directory, you may be
> able to get away with an alias.
>
> i.e. on sapude use the alias option of ifconfig to add a hostname of
> sapsnd. You would obviously have to change the IP to avoid conflicts,
> or shutdown sapsnd while testing (probably not a good proposition)
>
> We took a slightly different tack when faced with the same situation. I
> first installed a shell/default instance of SAP on our "sapude" server
> using the SID "SND". This allowed me to tune the SAP instance
> specifically for the "sapude" server. I then deployed dataguard to
> replace the "SND" database on "sapude".
>
> When we tested the dataguard switchover, I had to import the "sapude"
> instance profile to get it in synch, but other than that there weren't
> too many issues getting SAP running. Switching back didn't cause any
> issues either, other than not being able to maintain the "sapude"
> instance profile when adjusting parameters.
>
> You will also need to get another license for the "SND" instance on
> "sapude", but that's not too much of an issue on sapnet.
>
> I seem to remember seeing some high availability recommendation docs on
> sapnet, but will need to confirm the details later.
>
> HTH,
> Andy.

Just to follow up on my last point, a "quick search" in SAPnet on the search term "high availability" turns up too many documents to list here!

If you don't have access to SAPnet, talk to one of your SAP BASIS/Support folk who does. Received on Tue Jul 05 2005 - 18:06:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US