Endpoints_listener.ora not updated when altering listener.ora by hand

As a part of standards every (RAC) database has its own listener in my projects. This week i was asked to alter the local listener to a different port to keep it similar to a specific port that I used on other database(s) in that project.
Technically this was Of course a little effort  2 be made to keep everybody happy.

I altered my listener.ora (yup still an old-fashioned kind of guy) manually and I stopped and started the listener:

srvctl start listener -l listener_mydb1
srvctl status listener -l listener_mydb1

And in the database i had altered the local_listener too  to show new ports well. And of course  I altered the tnsnames entry too.  So I had it all covered i thought. That was only until the moment that I checked the listener for that database for its status. And much to my surprise I saw this.

Continue reading

The Good , the bad and the Gui Listener


Sometimes it is almost funny how old habits indeed seldom die.  At the Customers site where I am working there still seems to be a culture in which it is not that common to use Gui solutions offered by Oracle to do day-to-day jobs. In Dutch there is an  expression telling unknown things  makes things disliked. Well this week i came across nice behavior of the NETCA tool in an environment where Grid Infrastructure is running and I must say I really liked it.

My environment is a four Node Cluster on Redhat Linux 5.5, my Grid Infra structure is

Continue reading