Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When running

lsnrctl status

I can see that it is using the old host name, but I don't know where it is pulling that value from.

My Oracle installation is 11.2.0 on Windows7 x64, if that makes any difference.

share|improve this question

migrated from Jun 6 '12 at 18:24

This question came from our site for system and network administrators.

up vote 4 down vote accepted

When you run lsnrctl status, one of the things that it tells you is the location of the Listener Parameter File (the listener.ora file)

LSNRCTL for 64-bit Windows: Version - Production on 06-JUN-2012 13:12:22

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version - Production
Start Date                06-JUN-2012 09:33:58
Uptime                    0 days 3 hr. 38 min. 24 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         c:\oracle\diag\tnslsnr\jcave8560w\listener\alert\log.xml
Listening Endpoints Summary...
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "jcave11gR2XDB" has 1 instance(s).
  Instance "jcave11gr2", status READY, has 1 handler(s) for this service...
Service "jcave11gr2" has 1 instance(s).
  Instance "jcave11gr2", status READY, has 1 handler(s) for this service...
The command completed successfully

If you open that file, there will probably be an entry like this

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

where the host is specified. Change the host there and restart the listener.

share|improve this answer
Thanks worked like a charm... I also had to change a file named tsanames.ora but it was in the same dir so it was easy to find. – Cristiano Fontes Jun 11 '13 at 7:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.