How to flush an instance in the listener.ora file
645962Dec 8 2008 — edited Dec 9 2008Hi,
We have Oracle DB server 10.2.0.3.0 running in RHEL4 2.6.9-42. It is a RAC Configured, previously 8 instances. Now we only have seven because we remove the other one; removedserver.company.com
Unfortunately, it was not removed following the correct method because the server was destroyed. We are able to remove it from the list of RAC though using deletenode.sh (in fact it is no longer appearing in +./olsnodes+).
Our problem now is that the instance name is still appearing in our listener.ora file. And I am getting error in alert.log
ORA-00130: invalid listener address '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=+removedserver.company.com+) (PORT=xxxx)))'
If I will edit the listener.ora manually and removed the instance from there, my problem will be
1. it might be added again in the listener.ora when we do adautoconfig
2. I am not sure of the impact if I will do it manually.
Hope somebody would help.
Thanks in advance.