The listener supports no services
Introduction:
This document is intended for DBA’s who need to know the listener supports no services.
Why we need to do:
Listener is not support to the databases.
Steps to solve the issue:
a. First check the listener status,
lsnrctl status LISTENER
b. Check the local listener parameter
show parameter local_listener
c. Show parameter spfile.
d. alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))’;
show parameter local_listener
e. Register the listener.:
ALTER SYSTEM REGISTER;
f. Shut down the database:
Shut immediate;
g. Start the database:
startup;
h. Check the listener status:
lsnrctl status LISTENER
Conclusion:
Using the above steps DBA can easily solve the issue.
Recent Posts