Telesupply Knowledge Center

This guide is to reinstall the Oracle database when it's corrupted or unable to connect to database. By reinstalling Oracle, all of the data (Call data, audit trail, user account) will be lost. Kindly get the confirmation from user before proceed.

Call data will be able to restore by restoring xml file.

• Backup media files (/var/dcloge/media/000) & dclog.xml  (In Case anything happen)
• Stop DCLog services.
  • systemctl stop dclogvoip
  • systemctl stop dclogcorej
  • systemctl stop tomcat
• Login with root, open terminal and run following command.

cd /home

systemctl stop oracle-xe;

rpm -e oracle-xe-11.2.0-1.0.x86_64 ;

rm -rf /var/lib/selinux/targeted/active/modules/100/oracleasm;

rm -rf /var/spool/mail/oracle;

rm -rf /usr/share/sql-bench/limits/oracle.cfg;

rm -rf /usr/share/selinux/targeted/default/active/modules/100/oracleasm;

rm -rf /etc/default/oracle-xe;

rm -rf /run/lock/subsys/oracle-xe;

rm -rf /run/systemd/generator.late/oracle-xe.service;

rm -rf /u01/app/oracle/;

rm -rf /var/dcloge/data/*;

rm -rf /var/tmp/.oracle;

rm -rf /tmp/.oracle;

userdel -r oracle;

rpm -ivh /home/Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm

        /etc/init.d/oracle-xe configure

. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

/u01/app/oracle/product/11.2.0/xe/bin/sqlplus system/duplicall@xe  @/home/oracle35.sql

• Start all dclog services. Configure and test call.

Step 6

Configure and test recording.

Download from NAS: Technical\Software\DCLog Patches\Oracle Reinstallation.zip