WARNING: This web is not used anymore. Please use PDBService.Removal instead!

Oracle RAC removal steps

Note1: This page shows the necessary steps to completely delete and start re-install Oracle RAC software.

1. Stop and remove all ASM and RAC instances with SRVCTL command

srvctl disable instance -d <DB_NAME> -i <INSTANCE_NAME>
srvctl disable asm -n <HOST_NAME>

srvctl stop instance -d <DB_NAME> -i <INSTANCE_NAME>
srvctl remove instance -d <DB_NAME> -i <INSTANCE_NAME>

srvctl stop asm -n <HOST_NAME>
srvctl remove asm -n <HOST_NAME>

2. Remove the following files/folders from /etc: oracle, orainst, oratab, ORCLcluster

sudo rm -rf /etc/oracle /etc/orainst /etc/oratab /etc/ORCLcluster 
3. Remove all init.crsd, init.crs, init.cssd, init.evmd files from /etc/init.d

sudo rm -rf /etc/init.d/init.crsd /etc/init.d/init.crs /etc/init.d/init.cssd /etc/init.d/init.evmd 

4. Remove soft links to /etc/init.d/init.crs from the /etc/rc2.d, /etc/rc3.d, /etc/rc5.d folders

sudo rm -rf /etc/rc2.d/K96init.crs /etc/rc2.d/S96init.crs /etc/rc3.d/K96init.crs /etc/rc3.d/S96init.crs /etc/rc5.d/K96init.crs /etc/rc5.d/S96init.crs 

5. From the /etc/inittab file remove last three lines starting with h1, h2, h3

6. Restart init

telinit q 

7. Remove the contents of /tmp folder

sudo rm -rf /tmp/*

8. From the /usr/local/bin remove dbhome, oraenv, coraenv files

sudo rm -rf /usr/local/bin/dbhome /usr/local/bin/oraenv /usr/local/bin/coraenv

9. Remove /var/tmp/.oracle folder

sudo rm -rf /var/tmp/.oracle

10. From the /ORA/dbs01/oracle folder remove all subfolders except home

sudo rm -rf /ORA/dbs01/oracle/admin /ORA/dbs01/oracle/product /ORA/dbs01/oracle/oraInventory

Prepare re-installation

11. unset variables

unset TNS_ADMIN;

12. shutdown virtual interface

/sbin/ifconfig eth0:1 down;

13. clean contents of ASM disks

for letter in b4 c d e f g h j4 k l m n o p q; do dd if=/dev/zero of=/dev/sd$letter bs=1024 count=1000; done;

14. clean contents of ASM disks

for letter in 1 2 3; do dd if=/dev/zero of=/dev/raw/raw$letter bs=1024 count=1000; done;

15. reload QLA driver

/sbin/rmmod qla2300; /sbin/modprobe qla2300;

16. change permissions

chown oracle:ci /dev/raw/raw1 /dev/raw/raw2 /dev/raw/raw3;

17. ASM reconfiguation (primary node only)

/etc/init.d/oracleasm configure (answers: oracle; ci; y; y)

18. Recreate ASM disks (primary node only)

/etc/init.d/oracleasm createdisk STOR15_1 /dev/sdb4;
/etc/init.d/oracleasm createdisk STOR15_2 /dev/sdc;
/etc/init.d/oracleasm createdisk STOR15_3 /dev/sdd;
/etc/init.d/oracleasm createdisk STOR15_4 /dev/sde;
/etc/init.d/oracleasm createdisk STOR15_5 /dev/sdf;
/etc/init.d/oracleasm createdisk STOR15_6 /dev/sdg;
/etc/init.d/oracleasm createdisk STOR15_7 /dev/sdh;

/etc/init.d/oracleasm createdisk STOR16_1 /dev/sdj4;
/etc/init.d/oracleasm createdisk STOR16_2 /dev/sdk;
/etc/init.d/oracleasm createdisk STOR16_3 /dev/sdl;
/etc/init.d/oracleasm createdisk STOR16_4 /dev/sdm;
/etc/init.d/oracleasm createdisk STOR16_5 /dev/sdn;
/etc/init.d/oracleasm createdisk STOR16_6 /dev/sdo;
/etc/init.d/oracleasm createdisk STOR16_7 /dev/sdp;
/etc/init.d/oracleasm createdisk STOR16_8 /dev/sdq;

19. Synchronize ASM (other nodes)

/etc/init.d/oracleasm enable;
/etc/init.d/oracleasm scandisks;
Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r4 - 2007-02-07 - MiguelAnjo
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback