-

How to remove old oracle home ?

    -  Get tar file of old oracle home.

             /<$BACKUP_LOCATION>/db_home.tar.gz $ORACLE_HOME

-        Go to $ORACLE_HOME/oui/bin location

 

-        Check oratab file before remove file.

 

-        Execute below in silent mode to detach home.

 

-bash-4.4$ ./runInstaller -silent -waitforcompletion -detachHome ORACLE_HOME='/u01/app/oracle/product/12.2.0/dbhome_1' -local

 

-        After executed above check the oratab file.

 

Output of above command:

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 38817 MB    Passed

The inventory pointer is located at /var/opt/oracle/oraInst.loc

'DetachHome' was successful.

-        Check inventory.xml in oraInventory.

-bash-4.4$ cat /var/opt/oracle/oraInst.loc

inventory_loc=/u01/app/oraInventory

inst_group=oinstall

 

-bash-4.4$ cd /u01/app/oraInventory/ContentsXML/

-bash-4.4$ ls -lrt

total 9

-rw-rw----   1 oracle   oinstall     174 Sep  2 22:16 oui-patch.xml

-rw-rw----   1 oracle   oinstall     917 Oct 19 22:17 inventory.xml

-rw-rw----   1 oracle   oinstall     329 Oct 19 22:17 comps.xml

-rw-rw----   1 oracle   oinstall     292 Oct 19 22:17 libs.xml

-bash-4.4$ cat inventory.xml

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2022, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.2.0.1.4</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraGI19Home1" LOC="/u01/app/19.0.0/grid" TYPE="O" IDX="4" CRS="true"/>

<HOME NAME="agent13c1" LOC="/EM13C/emagent/agent_13.2.0.0.0" TYPE="O" IDX="3"/>

<HOME NAME="OraDB19Home1" LOC="/u01/app/oracle/product/19.0.0.0/dbhome_1" TYPE="O" IDX="5"/>

<HOME NAME="agent13c2" LOC="/em_agent/emagent_13c/agent_13.4.0.0.0" TYPE="O" IDX="6"/>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.2.0/grid" TYPE="O" IDX="1" REMOVED="T"/>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.2.0/dbhome_1" TYPE="O" IDX="2" REMOVED="T"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

 

-        After removed entry should be as above.

-        Rename the old oracle home folder and keep few days and remove after checked by fuser command.

 

Fuser -u $ORACLE_HOME/*


Comments

Post a Comment

Popular posts from this blog

ASM DISK MIGRATION [OCR/DATA/RECO DISK GROUPS] in RAC

-
Image
  Current Disk group as below. You must prepare candidate disks with proper permissions by storage level. Here we are going to add below new disks for each disk group with rebalance power 6 and we can do afd label below disks and assign to ASM disk group using asmca or sqlplus commands. After added new disks to relevant disk groups you may drop the old disks in DATA and RECO disk groups with rebalance power using asmca or sqlplus. But note here,  we do not drop old disk of OCR disk group due to existing voting disks. Therefore, you must need to transfer voting disks in to another ASM disk group which has sufficient space. Before moving voting disk  check OCR devices and existing voting disk location. Note you need to have OCR mirroring device before move voting disk to another ASM disk group and get a manual backup of OCR. To check OCR device = > ocrcheck To check voting disks => crsctl query css votedisk To check OCR backup=> ocrconfig -showbackup <AUTO|MAN...
Read more

ORA-00609: could not attach to incoming connection in database alert log

-
 Environment Details ---------------------------- Oracle Real Application Cluster 02 Nodes Oracle Solaris 11.3 SPARC Oracle version 19.6.1.0.0 Problem Description --------------------------- Above error continuously reported in the database alert. In that case we have to check certain logs instead to database alert. Before that, we must find for any firewall rule changes or any IP filter changes in between application server IP and database IPs with the internal network team. So the error reported in the db alert as follows. 2021-11-23T15:20:09.766518+05:30 opiodr aborting process unknown ospid (9758) as a result of ORA-609 2021-11-23T15:20:09.770202+05:30 Errors in file /u01/app/oracle/diag/rdbms/db/db1/trace/db1_ora_9758.trc : ORA-00609: could not attach to incoming connection ORA-12547: TNS:lost contact Considering the alert log error we must check listener logs as well. This can be done finding and comparing the similar timestamp in the listener logs. 23-NOV-2021 15:...
Read more