This post describes, that a listener can be removed by accident if you remove an obsolete Oracle home.
After
upgrading a single database from 11.2.0.3 (dbhome_1) to 11.2.0.4 (dbhome_2),
the old 11.2.0.3 home becomes obsolete. The listener has already been moved to the new
home as well.
oracle@demohost01:/home/oracle> which lsnrctl
/opt/oracle/product/11.2.0/dbhome_2/bin/lsnrctl
oracle@demohost01:/home/oracle> ps -ef | grep
LISTENER
oracle
10305 1 0 Jan29 ? 00:00:13
/opt/oracle/product/11.2.0/dbhome_2/bin/tnslsnr LISTENER -inherit
oracle
12642 9408 0 08:30 pts/0 00:00:00 grep LISTENER
From your
home directory, deinstall (on Linux) as follows:
oracle@demohost01:/opt/oracle/product/11.2.0/dbhome_1/deinstall/deinstall
Now some
checks are performed.
oracle@demohost01:/home/oracle>
/opt/oracle/product/11.2.0/dbhome_1/deinstall/deinstall
Checking for required files and bootstrapping
...
Please wait ...
Location of logs /opt/oracle/oraInventory/logs/
############ ORACLE DEINSTALL & DECONFIG
TOOL START ############
######################### CHECK OPERATION START
#########################
## [START] Install check configuration ##
Checking for existence of the Oracle home
location /opt/oracle/product/11.2.0/dbhome_1
Oracle Home type selected for deinstall is:
Oracle Single Instance Database
Oracle Base selected for deinstall is:
/opt/oracle
Checking for existence of central inventory
location /opt/oracle/oraInventory
Checking for sufficient temp space availability
on node(s) : 'demohost01'
## [END] Install check configuration ##
Network Configuration check config START
Network de-configuration trace file location:
/opt/oracle/oraInventory/logs/netdc_check2015-01-30_08-28-54-AM.log
Specify all Single Instance listeners that are
to be de-configured [LISTENER]:
WAIT !! This
is strange…. The listener is running on the new home. So why is it trying to
deinstall it? Press
ctrl-C to abort this deinstallation!!
Check if there
is still a copy of the old listener.ora in the network/admin folder:
oracle@demohost01:/home/oracle> ls -l
/opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
-rw-------. 1 oracle oinstall 568 Sep 20 2013
/opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
If we move
or rename this to listener.ora_old, the de-installation runs fine.
oracle@demohost01:/opt/oracle/product/11.2.0/dbhome_1/network/admin>
mv listener.ora listener.ora_old
So try
again:
oracle@demohost01:/home/oracle>
/opt/oracle/product/11.2.0/dbhome_1/deinstall/deinstall
Checking for required files and bootstrapping
...
Please wait ...
Location of logs /opt/oracle/oraInventory/logs/
############ ORACLE DEINSTALL & DECONFIG
TOOL START ############
######################### CHECK OPERATION START
#########################
## [START] Install check configuration ##
Checking for existence of the Oracle home
location /opt/oracle/product/11.2.0/dbhome_1
Oracle Home type selected for deinstall is:
Oracle Single Instance Database
Oracle Base selected for deinstall is:
/opt/oracle
Checking for existence of central inventory
location /opt/oracle/oraInventory
Checking for sufficient temp space availability
on node(s) : 'demohost01'
## [END] Install check configuration ##
Network Configuration check config START
Network de-configuration trace file location:
/opt/oracle/oraInventory/logs/netdc_check2015-01-30_08-40-09-AM.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location:
/opt/oracle/oraInventory/logs/databasedc_check2015-01-30_08-40-09-AM.log
Use comma as separator when specifying list of
values as input
Specify the list of database names that are
configured in this Oracle home []:
Hit Enter here, there are no databases found active on this
Oracle Home.
Database Check Configuration END
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location:
/opt/oracle/oraInventory/logs/emcadc_check2015-01-30_08-40-28-AM.log
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /opt/oracle/oraInventory/logs//ocm_check3812.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END
#########################
####################### CHECK OPERATION SUMMARY
#######################
Oracle Home selected for deinstall is:
/opt/oracle/product/11.2.0/dbhome_1
Inventory Location where the Oracle home
registered is: /opt/oracle/oraInventory
No Enterprise Manager configuration to be
updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to
migrate
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR
is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]:
y
The
y-response is entered manually, and then the process starts running.
A log of this session will be written to:
'/opt/oracle/oraInventory/logs/deinstall_deconfig2015-01-30_08-40-06-AM.out'
Any error messages from this session will be
written to: '/opt/oracle/oraInventory/logs/deinstall_deconfig2015-01-30_08-40-06-AM.err'
######################## CLEAN OPERATION START
########################
[ *** output removed, no errors ***]
######################### CLEAN OPERATION END
#########################
####################### CLEAN OPERATION SUMMARY
#######################
Cleaning the config for CCR
As CCR is not configured, so skipping the
cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home
'/opt/oracle/product/11.2.0/dbhome_1' from the central inventory on the local
node.
Successfully deleted directory
'/opt/oracle/product/11.2.0/dbhome_1' on the local node.
Oracle Universal Installer cleanup was
successful.
Oracle deinstall tool successfully cleaned up
temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG
TOOL END #############
