Home » RDBMS Server » Server Administration » TNS-01150 The address of the specified listener name is incorrect (2 Merged) (Oracle10g 10.2.0.1.0)
TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493096] Fri, 04 February 2011 16:51 Go to next message
binuUK
Messages: 5
Registered: January 2011
Location: UK
Junior Member
Hi,

I am having issue with configuring listner name on Oracle Server.My default listener is working,But I have stopped the default listener and tried to create another listener is differnt port,but no success,It always says The address of the specifed listener name is incorrect.Below is the listener.ora file
My db name and sid name are etl
LIST1=(DESCRIPTION=(ADDRESS=
                            (HOST=127.0.0.1)
                            (PROTOCOL=TCP)
                            (PORT=1530)
                    )
       )
SID_LIST_LIST1=(SID_LIST=(SID_DESC=    
                              (GLOBAL_DBNAME=etl)
                              (SID_NAME=etl)
                   (ORACLE_HOME=/home/oracle10g/oracle/product/10.2.0/db_1)
                          )
               )

and the list1.log file says
The address of the specified listener is incorrect.

[Updated on: Sat, 05 February 2011 00:31] by Moderator

Report message to a moderator

TNS-01150 The address of the specified listener name is incorrect [message #493097 is a reply to message #493096] Fri, 04 February 2011 16:52 Go to previous messageGo to next message
binuUK
Messages: 5
Registered: January 2011
Location: UK
Junior Member
Hi,

I am having issue with configuring listner name on Oracle Server.My default listener is working,But I have stopped the default listener and tried to create another listener is differnt port,but no success,It always says The address of the specifed listener name is incorrect.Below is the listener.ora file
My db name and sid name are etl
LIST1=(DESCRIPTION=(ADDRESS=
(HOST=127.0.0.1)
(PROTOCOL=TCP)
(PORT=1530)
)
)
SID_LIST_LIST1=(SID_LIST=(SID_DESC=
(GLOBAL_DBNAME=etl)
(SID_NAME=etl) (ORACLE_HOME=/home/oracle10g/oracle/product/10.2.0/db_1)
)
)

and the list1.log file says
The address of the specified listener is incorrect.

Could anybody help please
Re: TNS-01150 The address of the specified listener name is incorrect [message #493098 is a reply to message #493097] Fri, 04 February 2011 17:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>Could anybody help please
What is gained by running a different listener?

>(HOST=127.0.0.1)
No remote client can ever connect to this listener.
Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493109 is a reply to message #493096] Sat, 05 February 2011 00:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TNS-01150: The address of the specified listener name is incorrect
 *Cause:  The address on which the listener attempted to listen contains a
 syntax error.
 *Action: For the listener name or service name specified to LSNRCTL, check
 that the address or connect descriptor is well-formed. You can find the
 listener name in LISTENER.ORA, or you can access the listener through
 the service name is TNSNAMES.ORA.

Regards
Michel
Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493113 is a reply to message #493096] Sat, 05 February 2011 01:17 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
Almost certainly, you have some non-printing characters in there that sqlnet doesn't like. It is usually better to use the tools (the netca or the netmgr) or to copy and edit an existing listener definition, to avoid the problem. Try pasting in this entry:
LIST1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1530)))

Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493118 is a reply to message #493113] Sat, 05 February 2011 03:12 Go to previous messageGo to next message
binuUK
Messages: 5
Registered: January 2011
Location: UK
Junior Member
Hi all,

Thank you very much to all.I have recently cleared my OCP certification and I am practising in my PC at the moment.I will use netca or netmgr tools to create listener or tnsname file.

Now I have another doubt how to change my PC IP address from 127.0.0.1 to another one please.I have edited /etc/hosts and in network files ,but I can't ping that new IP address.

Thank you very much.
Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493121 is a reply to message #493118] Sat, 05 February 2011 03:17 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
Your PC will be listening on all class A addresses beginning with 127, just ping a few and you'll see:
c:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN>ping 127.0.0.100

Pinging 127.0.0.100 with 32 bytes of data:
Reply from 127.0.0.100: bytes=32 time<1ms TTL=128
Reply from 127.0.0.100: bytes=32 time<1ms TTL=128

Ping statistics for 127.0.0.100:
    Packets: Sent = 2, Received = 2, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms
Control-C
^C
c:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN>ping 127.0.1.100

Pinging 127.0.1.100 with 32 bytes of data:
Reply from 127.0.1.100: bytes=32 time<1ms TTL=128
Reply from 127.0.1.100: bytes=32 time<1ms TTL=128

Put one of them, and another hostname, in your hosts file. That will be nuch easier than changing the external address.

[Updated on: Sat, 05 February 2011 03:18]

Report message to a moderator

Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493122 is a reply to message #493118] Sat, 05 February 2011 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to access to your database ONLY from your PC you can keep 127.0.0.1 or you can giev your PC name (note that in this case you don't need any listener).

Regards
Michel
Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493151 is a reply to message #493122] Sat, 05 February 2011 09:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have edited /etc/hosts and in network files ,but I can't ping that new IP address.
answer depends upon exactly which other "network files" were changed & resultant content.
Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493195 is a reply to message #493151] Sun, 06 February 2011 11:17 Go to previous messageGo to next message
binuUK
Messages: 5
Registered: January 2011
Location: UK
Junior Member
Hi

I have edited /etc/hosts and /etc/sysconfig/network files.
In /etc/hosts file contains IP address

127.0.0.1 localhost.localdomain localhost

and I have added as

10.100.12.128 redhat.localdomain redhat

and In /etc/sysconfig/network contains

HOSTNAME=localhost.localdomain

and I have added one more line

HOSTNAME=redhat.localdomain

These are the changes I have done.
Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493196 is a reply to message #493195] Sun, 06 February 2011 11:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post complete content of listener.ora

post results from following OS commands using COPY & PASTE

ifconfig
cat /etc/hosts
uname -a
lsnrctl status
lsnrctl service
Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493219 is a reply to message #493196] Sun, 06 February 2011 17:31 Go to previous messageGo to next message
binuUK
Messages: 5
Registered: January 2011
Location: UK
Junior Member
Hi
Results of the above commands are

# TRACE_DIRECTORY_<lsnr>
# Sets the directory for the listener's trace file.
# Default: <oracle_home>/network/trace
#
# TRACE_DIRECTORY_LISTENER=/private/app/oracle/product/8.0.3/network/trace
# CONNECT_TIMEOUT_<lsnr>
# Sets the number of seconds that the listener waits to get a
# valid database query after it has been started.
# Default: 10
#
# CONNECT_TIMEOUT_LISTENER=10
LIST1=
(DESCRIPTION=
(ADDRESS=(HOST=localhost.localdomain)(PROTOCOL=TCP)(PORT=1530)
)
)
SID_LIST_LIST1=
( SID_LIST=
( SID_DESC =
( GLOBAL_DBNAME = etl )
( SID_NAME = etl )
( ORACLE_HOME = /home/oracle10g/oracle/product/10.2.0/db_1 )
)
)

[oracle10g@localhost ~]$ /sbin/ifconfig
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:334204 errors:0 dropped:0 overruns:0 frame:0
TX packets:334204 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:45396710 (43.2 MiB) TX bytes:45396710 (43.2 MiB)

[oracle10g@localhost ~]$


[oracle10g@localhost ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
#10.100.12.128 redhat.localdomain redhat
[oracle10g@localhost ~]$


[oracle10g@localhost ~]$ uname -a
Linux localhost.localdomain 2.6.9-5.EL #1 Wed Jan 5 19:22:18 EST 2005 i686 i686 i386 GNU/Linux
[oracle10g@localhost ~]$

[oracle10g@localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-JAN-2011 14:54:46

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 09-JAN-2011 14:27:21
Uptime 0 days 0 hr. 27 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle10g/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle10g/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "etl" has 1 instance(s).
Instance "etl", status READY, has 1 handler(s) for this service...
Service "etlXDB" has 1 instance(s).
Instance "etl", status READY, has 1 handler(s) for this service...
Service "etl_XPT" has 1 instance(s).
Instance "etl", status READY, has 1 handler(s) for this service...
Service "oem" has 1 instance(s).
Instance "oem", status READY, has 1 handler(s) for this service...
Service "oemXDB" has 1 instance(s).
Instance "oem", status READY, has 1 handler(s) for this service...
Service "oem_XPT" has 1 instance(s).
Instance "oem", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle10g@localhost ~]$

[oracle10g@localhost ~]$ lsnrctl service

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-JAN-2011 14:56:01

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "etl" has 1 instance(s).
Instance "etl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "etlXDB" has 1 instance(s).
Instance "etl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:972 state:ready
DISPATCHER <machine: localhost.localdomain, pid: 3018>
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=32774))
Service "etl_XPT" has 1 instance(s).
Instance "etl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "oem" has 1 instance(s).
Instance "oem", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:13 refused:0 state:ready
LOCAL SERVER
Service "oemXDB" has 1 instance(s).
Instance "oem", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:972 state:ready
DISPATCHER <machine: localhost.localdomain, pid: 3111>
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=32781))
Service "oem_XPT" has 1 instance(s).
Instance "oem", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:13 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle10g@localhost ~]$


Thanks
Re: TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493221 is a reply to message #493219] Sun, 06 February 2011 19:37 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
#TRACE_LEVEL_LISTENER = 16
TRACE_LEVEL_LISTENER = OFF
TRACE_FILE_LISTENER = $ORACLE_HOME/network/trace/listener.trc

SID_LIST_LISTENER =
  (SID_LIST =
	(SID_DESC =
         (SID_NAME = mysql)			
         (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
         (PROGRAM = /u01/app/oracle/product/11.2.0/dbhome_1/bin/dg4odbc)
         (ENVS="FOOBAR=/tmp")
        )
	(SID_DESC =
         (SID_NAME = v112)			
         (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
        )
  )

SID_LIST_LISTENER_11G =
  (SID_LIST =
     (SID_DESC =
      (SID_NAME = v112)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    )
  )

LISTENER_11G =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    )
  )

lsnrctl start LISTENER_11G

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-FEB-2011 17:35:12

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

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/bcm-laptop/listener_11g/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_11G
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                06-FEB-2011 17:35:12
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/bcm-laptop/listener_11g/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
Services Summary...
Service "v112" has 1 instance(s).
  Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Previous Topic: Oracle process ORACLE.EXE (P00,P001... P024
Next Topic: Location of a DB Block
Goto Forum:
  


Current Time: Wed May 08 18:29:17 CDT 2024