TNS-01150 The address of the specified listener name is incorrect (2 Merged) [message #493096] |
Fri, 04 February 2011 16:51 |
|
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
|
|
|
|
|
|
|
|
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 |
John Watson
Messages: 8964 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 #493219 is a reply to message #493196] |
Sun, 06 February 2011 17:31 |
|
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 |
|
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
|
|
|