SAP - Systems Applications and Products in Data Processing

During installation of Oracle 11.2.0.2, encountered the below error.

INS-07009 Unable to load bean store

This is caused due to Environmental variable PS1. The value of PS1 should be ora < DBSID >. But in this case the value of this parameter was showing up in next line when I gave the command env.

Solution: 

If ORACLE_SID=XYZ then

setenv PS1 oraxyz>

or 

PS1=oraxyz>;export PS1

When you run sapinst and a database is created, it will create the initial initSID.ora profile with the parameter remote_os_authent = true.  At some point in the installation, sapinst restarts Oracle, which then returns an error like

Error message: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

When you see this, leave the sapinst message up, but edit initSID.ora and remove the line remove_os_authent = true.  Restart Oracle with "shutdown immediate" and "startup nomount" and click "retry" in sapinst.  This will cause its own problems later on, so you will need to add it back and restart Oracle once the database has been created.

Be sure that there are no other "deprecated parameter" messages after you do this.  Any such message will cause sapinst to stop dead in its tracks.  Other deprecated parameters include "user_dump_dest" and "background_dump_dest".

SAPINST error while DB installation on Oracle 11g

New Password Case Sensitivity Feature

With 11g installations, you will encounter problems if you entered a lowercase database password in your sapinst parameter screens.  The problem is that passwords now have case-sensitivity enforced in 11g.  You may encounter a message like:

ORA-01017: invalid username/password; logon denied

While you are editing initSID.ora to solve , set the following parameter and restart Oracle:

SEC_CASE_SENSITIVE_LOGON=FALSE

Error: During Heterogeneous system copy using SAPINST – Import phase got below error.

(TPL) ERROR: unknown template variable "compress"

Solution: Get the latest R3load executable to resolve the issue

Error in SAP system:

Database error text........: "ORA-12899: value too large for column

 ""."KAPOL"."VARDATA" (actual: 72, maximum: 36)"

Internal call code.........: "[RSQL/INSR/A016 ]"

Please check the entries in the system log (Transaction SM21).

Solution is in SAP Note 686357.

Executed report RATPONTC as per note 686357.

Sticky bit permissions for saposcol on Unix platforms

chown root:sapsys saposcol

chmod 4750 saposcol