SUM Tool errors with RSUPGJOB Failed

When performing upgrade using SUM Tool, it stops with RSUPGJOB Failed - If this is because of SLT Triggers(CHECK_SLT_TRIGGER) then follow the below procedure

Before proceeding, please make sure that the replication is complete in SLT system. 

Find the list of tables against which triggers are set.

Then in remote system, enter into below SAP transaction,
IUUC_REMOTE --> Expert Functions --> Delete Triggers --> Enter Table names ...


Retry in SUM tool.

NOTE: Make sure you have list of the tables for which triggers are being deleted so that you can recreate them post upgrade and retrigger the replication.

Deleting files older than n days

There is always a need to delete or housekeep filesystem at OS level and normally this is done by deleting files older than certain number of days.

Especially in applications where there are lot of logs or backups being generated, there is a need to automate this process of housekeeping.

Below command helps in deleting files which are older than specified number of days.

GENERAL PRECAUTION: Please avoid running these commands using root account

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 {} \;

LiveCache Short Dump post System copy – LCA03 (DBIF_DSQL2_SQL_ERROR)


After System copy of LiveCache Database to test system, you get DBIF_DSQL2_SQL_ERROR shortdump when you run consistency check of LCA03.

Shortdump include the following:

POS(1) Work rolled back: tExpect nnnnn in SIM_SIMSESSION


Execute following dbmcli command to remove production entries from the table.


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.

Oracle 11g OUI error - INS-07009 Unable to load bean store

During installation of Oracle, 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.


The problem solved executing export PS1="oraSID >;". This means, correcting either environmental variable file or manually adding it in the session where Oracle OUI is being run.

setenv PS1 oraxyz>


PS1=oraxyz>;export PS1

Problems Installing or System Copy Import to Oracle 11g

Issue - Deprecated Parameters
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".

ORA-01017: invalid username/password; logon denied

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:


ERROR- unknown template variable compress in sapinst

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