Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

netca: "a listener with the name already exists" after bombing out

614312Apr 21 2009 — edited Apr 23 2009
Installing a listener via netca on a CentOS 5 x64 11g RAC setup.

I had a typo in the $ORACLE_HOME shell variable in .bash_profile for the oracle user. This caused netca to bomb out with a series of 'file not found' and 'directory not found' errors. netca did not complete.

netca did, however, create listener LISTENER on port 1521 on both my nodes. There is no listener.ora file anywhere, due to the bad $ORACLE_HOME directory.

I'd like to delete this and start over so that netca completes normally.

I cannot use netca to delete listener LISTENER. The delete option is greyed out. I did reboot, and tried killing the tsnlsnr process.

crs_stat -p shows the following:

NAME=ora.rac1.LISTENER_RAC1.lsnr
TYPE=application
ACTION_SCRIPT=/u01/app/oracle/product/11.1.0/db_1/bin/racgwrap
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=600
DESCRIPTION=CRS application for listener on node
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=rac1
OPTIONAL_RESOURCES=
PLACEMENT=restricted
REQUIRED_RESOURCES=ora.rac1.vip
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=600
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=
USR_ORA_OPEN_MODE=
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=

My question...how do I delete this listener (and the one on rac2) so that I can re-install them correctly using netca?

Edited by: user611309 on Apr 21, 2009 12:12 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2009
Added on Apr 21 2009
2 comments
6,098 views