Custom Installations Backup

Introduction

This document explains the process of moving an SmartHCM installation from one machine to another. An example scenario is the migration of SmartHCM in production under Microsoft Windows to a Linux server for Database.

Files

Take the SmartHCM directory and create a compressed and portable file with it (eg. zip or tar.gz). Once we have the SmartHCM.zip, move it to the target machine. Unzip this file to the desired target directory.

Database

Export the Old Oracle Database

To create a dump file of the database:

expdp system/password directory=oracle_dump schemas=smarthcmdb dumpfile=smarthcmdb.dmp logfile=smarthcmdb.log

In this case the user "system" password is "password", database schema name is "smarthcmdb" and oracle directory to export the database is "oracle_dump".

Import the Oracle Database

To import the previously exported file:

impdb system/password directory=oracle_dump dumpfile=smarthcmdb.dmp remap_schema=smarthcmdb:smarthcmdbnew transform=oid:n

In this case the user "system" password is "password", database new schema name is "smarthcmdbnew" and oracle directory to export the database is "oracle_dump".

After import, change the password for newly created user for "smarthcmdbnew" by SQLPlus:

ALTER USER smarthcmdbnew IDENTIFIED BY password;