SAP Basis Tech Supports

Symptom

Installation of an SAP NetWeaver 7.0 with Enhancement Package 1 (EHP1) SR1 based system, including the Business Suite 7 SR1, on Windows with Oracle
Other terms

SAPinst, NetWeaver 7.0 EHP1 SR1, Business Suite 7 SR1, ERP 6.0 EHP4 SR1, SCM 7.0 SR1, SRM 7.0 SR1, CRM 7.0 SR1
Reason and Prerequisites

Installation problems for an SAP system based on SAP NetWeaver 7.0 EHP1 SR1 on Windows with Oracle discovered after the publication of the installation guide.
It also includes information for the Business Suite 7 SR1, which is based on SAP NetWeaver 7.0 EHP1 SR1.
The Business Suite 7 SR1 includes:
ERP 6.0 EHP4 SR1
SCM 7.0 SR1
SRM 7.0 SR1
CRM 7.0 SR1
For a list of the software units you can install with your SAP system, see SAP Note 1326698.

Solution

Contents
1 General
2 Pre-Installation
3 Installation
4 Post-Installation
5 High-Availability (HA)
Each entry is marked with a prefix, to make clear for which SAP systems, software units, and technical stack (ABAP, Java, ABAP+Java), the information applies to. If there is no prefix, the information applies to all types.

Date Section Description
———————————————————————
16/DEC/08 3 Oracle 10.2.0: MISSING_STATISTICS errors
10/APR/08 2 ABAP, ABAP+Java: Installation/system copy: apply most recent R3load
26/JAN/06 3 Maximum of 2-3 parallel R3load processes per CPU
02/NOV/06 4 Insufficient permission for SAPService user on folder %ORACLE_HOME%\database (DB13)
———————————————————————

1 General

2 Pre-Installation

——————–< 10/APR/08, D023322 >————————–
ABAP, ABAP+Java: Installation/system copy: apply most recent R3load
Symptom:
As of SAP Basis 7.00, LCHR fields are no longer mapped to LONG but to CLOB. It depends on the number of characters whether CLOB or VARCHAR are used.
In case of Unicode, all fields with more than 666 characters are mapped to CLOB.
Cause:
It turned out that CLOB is not suitable for performance. As 2000 is not the hard limit (this would be 4000), we decided to define 4000 for the limit as of SAP Basis 7.00.
Solution:
Download the most recent R3load from the Software Distribution Center at http://service.sap.com/swdc -> Downloads -> Support Packages and Patches -> Entry by Application Group -> SAP NetWeaver -> SAP NETWEAVER -> SAP NETWEAVER 7.0 -> Entry by Component -> Application Server ABAP -> SAP Kernel 7.00 <32 or 64 Bit> -> – Oracle – R3LOAD

3 Installation

—————-16/DEC/08, D000674>————————–
Oracle 10.2.0: BRCONNECT “check” function returns many alert errors MISSING_STATISTICS
You have the following options to solve the problem:
If you use Oracle 10.2.0.4: Before loading SAP data into the database, you must install the optimizer merge fix contained in Windows patch collection 15 and higher according to SAP note 1284406. Otherwise, after you have installed the SAP system, log on as user adm and create the missing statistics with the command:
brconnect -u / -c -f stats -t missingIf you use Oracle 10.2.0.2: After you have installed the SAP system, log on as user adm and create the missing statistics with the command:
brconnect -u / -c -f stats -t missing

————–<26/JAN/07, D023322>———————————
Maximum of 2-3 parallel R3load processes per CPU
We recommend that you configure only a maximum of 2-3 parallel R3load processes per CPU. The default for the installation is 3 parallel R3load processes. Do not enter a value greater than ‘3′ in the field “Number of Parallel Jobs” on the screen “SAP System Database Import”.
Otherwise SAPinst may abort and you may find an error message like the following in SAPAPPL1.log:
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX “BBP_PDHCF~0″ ON “BBP_PDHCF” ( “CLIENT”, “GUID” )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P038
ORA-00018: maximum number of sessions exceeded

4 Post-Installation

02/NOV/06
The SAPService user does not have the correct permission for transaction DB13 in the Oracle_Home\database folder.
Solution:
Set the permission for the database folder with the following commands in a DOS command box as user adm:
cacls %ORACLE_HOME%\database /E /G ORA_OPER:F
cacls %ORACLE_HOME%\database /E /G ORA_%ORACLE_SID%_OPER:F
cacls %ORACLE_HOME%\database /E /G ORA_DBA:F
cacls %ORACLE_HOME%\database /E /G ORA_%ORACLE_SID%_DBA:F
You can also change the permission with the Windows explorer.
5 High-Availability (HA)