Re: SAP and Oracle

Van Messner wrote:
>
> Any advice on what to do with Oracle as the db for an SAP installation? Are
> you using Advanced replication? Synchronous or Non-synchronous? Standby
> database? Any other? SAP says they strongly discourage parallel server.
>
> Thanks
>
> Van

We have over 2 TB in three production SAP/Oracle databases. One is standard SAP and two are industry solutions (IS in SAP terminology). You need to be careful in what you use if you want SAP support for problems. It's a little different as Oracle problems are sent to SAP first and they escalate to Oracle. The basic Oracle license is included in the SAP package and is all we use. The only Oracle option we have considered is parallel/partitioning and not parallel server. If you look at SAP architecture, you will see that it does data caching on it's application servers controlled by SAP which would get complicated if Oracle starting maintaining the database from two Oracle parallel servers. Since SAP is over-normalized you would really need to know the data model if you wanted to use replication and that can change with the application of a hot pack (read fixes) or a new release. I do highly recommend using a disk array for storage (we use EMC products) as it helps the availability issue.

Big Al Received on Mon Aug 28 2000 - 20:49:57 CDT