Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

About listener and services

About listener and services

Hi All,
I have redundant system with Oracle database as Primary on one side and Standby on the other.

1) When the database on Active is up and Running as Primary and on Inactive it is started and mounted as Standby, I am able to connect from Active database to the Standby and viceversa.

2) Then I shutdown the database on both the sides. Then I tried to connect from Active to Standby database and viceversa. I was able to connect this time as well

3) The active and standby database were shutdown . Then I stopped the listener and restarted it. This time when I tried to connect from Active to Standby and I was unable to connect. It gave me the error [B]ORA-12514 The listener supports no services[/B]

4) I started the Active database. Then I tried to connect to Active from Standby side. This time I was able to connect.

So it appears that ever since I stopped and started the listener, I am able to connect to the other side only if the instance is up. If the instance is down then I get an error.

This was not the case before re-starting the listener.

Could you please let me know why I am facing this issue after restarting the listener?

Waiting for your kind reply.

Thanks and regards,
Kaustubh Kane.
Honored Contributor

Re: About listener and services


this is because the listener takes some time to discover the services and this is why the message "The listener supports no services" pops up. If you had waited for 1 or 2 minutes, it would have worked.

kind regards
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)