SAP Basis Tech Supports

Symptom

***********************************************************************
*
* Installation on Unix : Oracle
* SAP NetWeaver 7.0 including Enhancement Package 1 (EHP1)
* Support Release (SR) 1
* (SAP NetWeaver 7.0 EHP1 SR1,
* SAP ERP 6.0 EHP4 SR1,
* SAP CRM 7.0 SR1,
* SAP SRM 7.0 SR1,
* SAP SCM 7.0 SR1)
*
*
***********************************************************************

Other terms

SAPinst, SAP NetWeaver 7.0 EHP1 SR1 , SAP ERP 6.0 EHP4 SR1, SAP CRM 7.0 SR1, SAP SRM 7.0 SR1, SAP SCM 7.0 SR1, Unix, AIX, HP-UX, Linux, Solaris, Oracle

Reason and Prerequisites

Problems discovered after the publication of the installation guide

Solution

DO NOT CHANGE OR ADD INFORMATION TO THIS NOTE !
If you want to contribute something, please send a mail to:
Klaus Billig klaus.billig@sap.com

UNIX Oracle-specific Problems discovered after the publication of the installation guides for SAP NetWeaver 7.0 EHP 1 SR1 and Business Suite 7 SR1.Installation information related to the installation of the Oracle database instanceSolution

DO NOT CHANGE OR ADD INFORMATION TO THIS NOTE !
If you want to contribute something, please send a mail to:
Klaus Billig klaus.billig@sap.com
Always use the latest documentation version (see SAP Service Marketplace at:
http://service.sap.com/installNW70
http://service.sap.com/erp-inst
http://service.sap.com/crm-inst
http://service.sap.com/srm-inst
http://service.sap.com/instguides -> SAP Business Suite Applications -> SAP SCM -> SAP SCM Server

Sections of this note are:

1. General2. Pre-Installation3. Installation4. Post-Installation5. Corrections in the installation guides

Contents

Date Section Description
———————————————————————
OCT/22/09 3 Make sure that umask is set to 022
16/DEC/08 3 Oracle 10.2.0: BRCONNECT “check” function returns many alert errors MISSING_STATISTICS
15/SEP/08 3 Java, Java Add-In: Error in step “createOracleStatisticsJava”
10/APR/08 2 ABAP, ABAP+Java: Installation/system copy: apply most recent R3load
31/MAR/08 3 Java Add-In, SCS on database instance host: Error role ORA_SID is not created yet
29/NOV/07 3 Linux: inst. using reiserfs, apply SAP Note 914177
26/JAN/06 3 Maximum of 2-3 parallel R3load processes per CPU
18/SEP/06 2 NFS-V4 file system: create ora on NFS server
08/SEP/06 3 Problems while Oracle Universal Installer is running
08/SEP/06 3 Updating SAP-Specific Files in the Oracle stage area
11/AUG/06 4 Error while trying to connect to liveCache via LC10
02/AUG/06 2 sapinst create sapdata folders under root folder.
10/MAY/06 2 Oracle 10.2 and SP6 required
for installation of SR2 components
25/APR/06 2 ABAP+Java,Java: Hot News: Oracle 10g JDBC drivers
21/MAR/06 3 NFSv4-Mount SOLARIS 10 : ERROR FCO-00011
15/MAR/06 4 Error message in sapcpe.log
=> dbclient.lst does not exist
15/FEB/06 3 Wrong path to RUNINSTALLER in SAPinst message box
“SAPinst now stops the installation
…you must install the Oracle database…”

=======================================================================
1 General

=======================================================================

NOTE:
Entries that are only valid for the installation of an ABAP+Java system are marked with “ABAP+Java only” in the first line of the corresponding entry.Entries that are only valid for the installation of an ABAP system are marked with “ABAP only” in the first line of the corresponding entry.Entries that are only valid for the installation of a Java system are marked with “Java only” in the first line of the corresponding entry.Entries without such a mark are valid for both ABAP+Java systems and Java systems and ABAP systems.

NOTE:

For information on downloading files from sapserv, see SAP Note 19466.

File requirements of Oracle sapdata file systems

File requirements of Oracle sapdata file systems. Pure space requirements can also be found in file DBSIZE.XML on the Export DVD.
Note:
The recommended values that are listed in the following table are a little bit larger than the values contained in DBSIZE.XML).
These values are only guiding values.
Each file in these filesystems can grow up to 10,0 GB maximum.

SAP NetWeaver 7.0 EHP1 SR1 ABAP:
File System NameSpace Requirement/oracle//sapdata12 GB/oracle//sapdata29 GB/oracle//sapdata39 GB/oracle//sapdata41 GBSUM18 GB

SAP NetWeaver 7.0 EHP1 SR1 Java:
File System NameSpace Requirement/oracle//sapdata11 GB/oracle//sapdata23 GB/oracle//sapdata3- GB/oracle//sapdata46 GBSUM10 GB

SAP ERP 6.0 EHP4 SR1: ERP Central Component (ECC):
File System NameSpace Requirement/oracle//sapdata122 GB/oracle//sapdata222 GB/oracle//sapdata320 GB/oracle//sapdata420 GBSUM84 GB

SAP CRM 7.0 SR1: CRM Application Set (CRM APP):
File System NameSpace Requirement/oracle//sapdata19 GB/oracle//sapdata29 GB/oracle//sapdata37 GB/oracle//sapdata49 GBSUM36 GB

SAP SRM 7.0 SR1: SRM Application Set (SRM APP):
File System NameSpace Requirement/oracle//sapdata12 GB/oracle//sapdata211 GB/oracle//sapdata38 GB/oracle//sapdata41 GBSUM22 GB

SAP SCM 7.0 SR1: SCM Application Set (SCM APP):
File System NameSpace Requirement/oracle//sapdata12 GB/oracle//sapdata220 GB/oracle//sapdata39 GB/oracle//sapdata41 GBSUM32 GB

SAP Solution Manager 7.0 EHP1:
File System NameSpace Requirement/oracle//sapdata12 GB/oracle//sapdata220 GB/oracle//sapdata38 GB/oracle//sapdata41 GBSUM31 GB

=======================================================================
2 Pre-Installation

=======================================================================
———————–————————–
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

———————–————————–
NFS-V4 file system: create ora on NFS server
If you use NFS-V4 file system, then you have to create the
ora user on the NFS server. You can
do this either manually or by running
“Operating System Users and Groups”.
This user must have the same user ID as the ora user
on the database server.
Otherwise, you get the error message
“FSL-02098 Could not change owner of …”
during the installation of the database instance.

———————–—————————
Sapinst create sapdata[5|6|7|...] directories under /(root) directory.
Solution:
Stop the installation after selecting your installation option
update control.xml as follows:
old:
OraCom.prototype._importRow_tORA_SapdataNodes = function() {
…
…
for ( var i=1; i < 5; i++ ) {
new:
OraCom.prototype._importRow_tORA_SapdataNodes = function() {
...
...
for ( var i=1; i < 20; i++ ) {
Restart the installation.

-----------------------—————————
ABAP+Java, Java: Hot News: Oracle 10g JDBC drivers

The Oracle 10g JDBC drivers delivered with SAP NetWeaver 2004s and Business Suite 2005 contain a bug which, under certain circumstances, can cause data loss when writing on the database.
This bug is fixed with Oracle 10.2.0.2.
Before you start the installation, you must update the software component from which the JDBC driver is taken to version 10.2.0.2. Depending on your configuration, this is the database software itself, the Oracle Instant Client, or the driver delivered by SAP according to Note 915079.
You do not need to update the database software if you do not use the JDBC driver included in it.
For more information, see Note 939424.

=======================================================================
3 Installation

=======================================================================

———————————————–
Make sure that umask is set to 022
Make sure that umask is set to 022 for user ora. As user ora enter the following command:umask 022
—————-16/DEC/08, D022850>————————–
Oracle 10.2.0: BRCONNECT “check” function returns many alert errors MISSING_STATISTICS
Solution:
To solve the problem create the missing statistics with the following command:
brconnect -u / -c -f stats -t missing
See also SAP Note 1284406.
——————–—————————
Java, Java Add-In: Error in step “createOracleStatisticsJava”
Symptom:
You changed the default value for the Oracle database Java schema (default value “SAPSR3DB” with a value of your choice.
During installation step “createOracleStatisticsJava”, you find the following error in brconnect.log:
BR0824E Owner ‘SAPSR3DB’ not found in database or not SAP owner
Solution:
Proceed as follows:
1. Edit keydb.xml.2. Search for dbSchemaJava.3. Replace default value “SAPSR3DB” with your correct java schema value:

DB]]>

——————–————————-
Java Add-In, SCS on database instance host: Error role ORA_SID is not created yet
Symptom:
ERROR 2008-03-20 12:53:21.202 [sixxcstepexecute.cpp:951]
FCO-00011 The step setUserEnvironment with step key
NW_Addin_SCS ind ind ind ind 0 0 NW_Users_Create_Do ind ind ind ind 3 0
setUserEnvironment was executed with status ERROR ( Last error reported
by the step :Caught ESAPinstException in Modulecall: in
function (role) {
…
…
role ORA_SID is not created yet..)
Solution:
1. Search in control.xml for the following entry:
NWDBora.prototype.setDBUserEnvironment = function(nwusers, cdroot)…
…2. Replace the following line:
if ( installer.onUnix() && OraCom.isDbHost(nw)) {
with the following line:
if ( installer.onUnix() && OraCom.isDbHost(nw) && !nw.
isAddinInstallation() ) {3. Restart Sapinst with the option “Continue old installation”.

—————————————————
Linux: inst. using reiserfs, apply SAP Note 914177
If you install on Linux using reiserfs, mount the file system as described in SAP Note 914177.
Otherwise the installation may abort due to errors during the database creation.

————–—————————-
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

————————–————————-
Problems while Oracle Universal Installer is running
If you encounter problems while the Oracle Universal Installer is running, check SAP Notes 841728 and 978272.

————————–————————-
Updating SAP-Specific Files in the Oracle stage area
Use
SAPinst extracts the Oracle RDBMS software to the staging area, usually /oracle/stage/102_64/database.
The “SAP” folder located in /oracle/stage/102_64/database contains SAP-specific scripts as well as the response files.
Before starting the Oracle software installation, you need to update this SAP folder so that the newest versions of the scripts or response files are used.
Procedure
1. Rename the original “SAP” folder by performing one of the following:mv /oracle/stage/102_64/database/SAP
/oracle/stage/102_64/database/SAP_ORIGmv /oracle/stage/102_64/database/Disk1/SAP
/oracle/stage/102_64/database/Disk1/SAP_ORIG2. Download the file RDBMS_SAP_32.zip (for 32-bit platforms) or RDBMS_SAP_64.zip (for 64-bit platforms) attached to SAP Note 819830 and copy it to a temporary location such as /tmp3. Extract the zip file by performing one of the following:cd /oracle/stage/102_64/database
unzip /tmp/RDBMS_SAP.zipcd /oracle/stage/102_64/database/Disk1
unzip /tmp/RDBMS_SAP.zip
You should now see the directory “SAP” extracted with the updated
version of SAP-specific files.
————————–————————-
NFSv4-Mount SOLARIS 10 : ERROR FCO-00011
Using NFSv4-Mount on SOLARIS 10 you may get the following error message:
FCO-00011 The step setPermissions
Workaround:
Create the required user on the sharing server manually and repeat the installation step.
Note:
This problem should not occur if you use central user management (for example LDAP, YP).
————————–————————-
Wrong path to RUNINSTALLER on SAPinst dialog “SAPinst now stops the installation…you must install the Oracle database as follows…”
Symptom:
The path to RUNINSTALLER can be wrong on the SAPinst dialog for some UNIX operating systems.
Solution:
The correct path for the following operating systems is:
1. For the Oracle database installation:LINUX*, SOLARIS*, HP_IA64:
/oracle/stage/102_<32 or 64>/database/SAP/RUNINSTALLERAIX* and HP_PARISC:
/oracle/stage/102_64/database/Disk1/SAP/RUNINSTALLER1. For deleting the Oracle database software:LINUX*, SOLARIS*, HP_IA64:
/oracle/stage/102_<32 or 64>/database/runInstallerAIX* and HP_PARISC:
/oracle/stage/102_64/database/Disk1/runInstaller

=======================================================================
4 Post-Installation

=======================================================================
———————–————————
Error while trying to connect to liveCache via LC10
Symptom:
You have installed a NetWeaver 2004s system or a
Business Suite Application
(ERP 6.0 (2005), CRM 5.0, SRM 5.0, SCM 5.0) and one or more liveCache
instances on one host.
When trying to connect your system to the liveCache using
transaction LC10, you get an error like the following:
Runtime Errors DBIF_DSQL2_CONNECTERR
Except. CX_SY_NATIVE_SQL_ERROR
Date and Time 31.01.2006 23:05:32
Short text
SQL error 0 occurred when setting up connection
What happened?
When setting up the connection to the database system with the
identifier “LCA”, database error 0 occurred.
Missing RAISING Clause in Interface
Program SAPLSADB
Include LSADBF02
Row 12
Module type (FORM)
Module Name CONNECT_TO_LC
Solution:
Log on to the installation host as user adm.
1. Add the path ‘/sapdb/programs/lib/lib64′ to the environment2. variable LIBPATH.

————————————————-
Error message in sapcpe.log => dbclient.lst does not exist
Symptom:
There is an error after the installation in file:
/usr/sap/QE1/JC01/work/sapcpe.log
Solution:
If your start profile contains the lines
_CPARG2 = list:$(DIR_CT_RUN)/dbclient.lst
Execute_02 = immediate $(DIR_CT_RUN)/sapcpe$(FT_EXE) pf=$(_PF) $(_CPARG2
you can remove them.

======================================================================
5 Corrections in the installation guides

======================================================================