SAP - Systems Applications and Products in Data Processing

Command:  find -mtime +5 -exec rm {} \;

The above command deletes all the files which are ending with extension ".log" and is older than 5 days.

Example: You want to delete all the files ending with .log extension, are in /tmp and older than 10 days then below would be the command:

find /tmp/*.log -mtime +10 -exec rm {} \;

In the above command, replace with following

DBSID = Livecache Database SID

DBHOST= Live Cache Database hostname

PASSWORD = With appropriate password

SAPSID = User with SQL access to database.

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