New to SAP - Basic DB architecture

[Former Member]

Hi all,

Being new to SAP, whould somebody be kind enough to spec the basic requirements for the SAP Oracle DB?

We bought at least the following modules HR, Payroll, Acounting.

Do we need multiple Oracle instances ? Oracle schemas ?

On the application side, it looks like we need different guests for every modules ..

Thanks in advance,

D - Oracle dba >

[lbreddemann]

> Being new to SAP, whould somebody be kind enough to spec the basic requirements for the SAP Oracle DB?

> We bought at least the following modules HR, Payroll, Acounting.

> Do we need multiple Oracle instances ? Oracle schemas ?

> On the application side, it looks like we need different guests for every modules ..

Hi Damien,

usually SAP products are bought together with the appropriate Oracle license.

If this is the case you get the full package:

- the oracle software with the required release/patchset/patches

- the dba toolset (brtools) that guarantees that all DBA actions are done along the requirements/recommendations for SAP products

- the installation programs that create the database instance as well as the users/schemas in it.

For the modules you listed there will just be one instance and one big schema (big as in >30000 tables + indexes).

All in all, there is not too much "inside db"-stuff you've to take care off.

However, planning and implementing the operation procedures (backup, consistency check, alarm processing, etc.) will take some effort.

As usually non-SAP-DBAs have their own procedures already in place, you may want to make yourself familiar with the SAP recommendations:

[SAP Database Guide: Oracle (BC-DB-ORA-DBA)|http://help.sap.com/saphelp_nw70/helpdata/en/0c/cd271365debc42bef96ac7fd907787/frameset.htm]

Since I know that the BRTOOLS are not too easy to start with you may want to check this blog:[We all hate the BR*TOOLS, donu2019t we?|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/6769] [original link is broken] [original link is broken] [original link is broken];

For the parameter recommendation make sure to use the check script of sap note #1171650.

Regards,

Lars