Two Oracle 10g listeners running at the same time

15 pts.
Tags:
Oracle
Oracle 10g
PL/SQL
Hi all, can you help regarding oracle 10g listener? Sometimes for no reason i cannot log on int database, and then found there is two listeners running at the same time, do you know why?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can find what listeners are running in Unix by typing the following command.

ps -ef | grep tns
oracle 18873 1 0 Dec12 ? 00:00:00 /u02/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
oracle 18876 18873 0 Dec12 ? 00:00:00 /u02/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
root 21779 8976 0 08:06 pts/1 00:00:00 grep tnslsnr

Check all listeners returned for the correct listener and stop the undesired listeners. You will need to set your ORACLE_HOME to match the ORACLE_HOME of the listener you want to stop. Then set your ORACLE_HOME for the listener you want use, check current stats (lsnrctl stat), make any necessary changes and type lsnrctl reload to bounce the listener. Any changes you made will take effect at this point.

However, if your login is related to a listener problem you should be receiving some type of TNS error code. If so, on the Unix Command prompt, type oerr TNS <Error Number> to determine what it actually causing you your problems.

Good Luck!
______________

If you have two listeners running that means that you have two instances of Oracle running.

What error message are you getting?

two listeners running doesn’t mean two instance of Oracle.

Please specify what error you are getting

If u know which listener you are using then stop another listener using LSNRCTL command

The fact that you have one or two listeners running on a system doesn’t necessarily affect your login problem and certainly doesn’t imply the number of database instances running. Typically a login problem is due to your environment and/or permissions settings. If you are the DBA, you should know if and why more than 1 listener is running. If you are the DBA, then check the listener.ora file and see how the listeners are defined. I have multiple listeners on a system when I have multiple versions of Oracle installed and there are communications compatibility issues…. such as a 7.3.4 listener on a system which also has a 9.2.0 listener. I realize the age, etc issues… but sometimes it is necessary. But the first question must be, what error are you receiving, or is it simply locking and not responding? If you are coming from a client system to the database server, there could be different issues than if you are on the database server trying to connect. But you need to start with the error to determine the problem.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 2617
    Yes i understand what you mean, but i dont get any error, the database simply gets stuck! Thanks anyway for your help!
    15 pointsBadges:
    report
  • Paladine Solamnia
    Hi, U said the database simply gets stuck. First of all, are u able to even connect to it locally using probably this in any command prompt: sqlplus "/ as sysdba"
    170 pointsBadges:
    report
  • sasivardhan
    FRM-10142: HTTP Listener is not running on <IP Address> at port <Port Number>. 
    20 pointsBadges:
    report
  • sasivardhan
     The HTTP listener is not started, or is listening on a different address or port number than specified in the Runtime preferences in Oracle Forms. 
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following