SCM 13.0 upgrade error ORA-27101: shared memory realm does not exist

Document ID : KB000121550
Last Modified Date : 27/11/2018
Show Technical Document Details
Introduction:
Upgrade to CA Harvest Software Change Manager 13.0 is failing with HP-AI
/usr/lib/hpux64/dld.so: Unable to find library '1:/devel/cascm/hpia/v13TPL/DDWorking/DD/lib/libodbcinst.so'. 

Manual Upgrade of the Database (Oracle) is failing with error: 

1034 [CAI/PT][ODBC Oracle Dynamic driver][Oracle]ORA-01034: ORACLE not available 
ORA-27101: shared memory realm does not exist 
HP-UX Error: 2: No such file or directory 
0 [CAI/PT][ODBC Oracle Dynamic driver]Unknown initial connection attribute in connection string: SERVERNAME. 
 
Background:
All the components that were successfully installed are: 
eTPKI 
PEC 
ODBC 

Its failed only with the database upgrade.
 
Environment:
Product: SOFTWARE CHANGE MANAGER, 
Release: 13.0, 
Service Pack: , 
Operating System: HP-IA 64 
Instructions:
Please contact CA Support.

Harvest is 64 bit but the Oracle Client was 32 bit , this was resulting in error. 
In webex, pointed to 64 bit oracle and installed odbc, pec and SCM server again. 
Upgrade was successful and was able to connect broker successfully. 

Customer requested for required variables to be exported for SCM. Customer want to have it placed in.

We have provided following variables to them: 

ORACLE_SID=tcenh003_dharv.telkom.co.za 
ORACLE_HOME=/app/oracle/product/11.2.0/db_1 
LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH} 
PATH=${ORACLE_HOME}/bin:${PATH} 
TNS_ADMIN=/app/oracle/product/11.2.0/db_1/network/admin 
export ORACLE_SID ORACLE_HOME LD_LIBRARY_PATH PATH TNS_ADMIN 


RTHOME=/app/harvest/tmp/pec 
export RTHOME 

ODBC_HOME=/app/harvest/tmp/odbc/odbc 
export ODBC_HOME 

LD_LIBRARY_PATH=/app/harvest/tmp/odbc/odbc/lib:$LD_LIBRARY_PATH 
export LD_LIBRARY_PATH 

CA_SCM_DIR="/app/harvest/tmp/scm" 
HARVESTDIR=${CA_SCM_DIR} 
PATH="${CA_SCM_DIR}"/bin:"${PATH}" 
CA_SCM_HOME="${CA_SCM_DIR}" 
HARVESTHOME="${CA_SCM_DIR}" 
LD_LIBRARY_PATH=./:"${CA_SCM_DIR}"/lib:"${LD_LIBRARY_PATH}" 

export LD_LIBRARY_PATH HARVESTDIR CA_SCM_DIR CA_SCM_HOME HARVESTHOME PATH