Home » RDBMS Server » Server Administration » TNS-01150: The address of the specified listener name is incorrect (Oracle Version 11.2.0.3.0, Windows Server 2012)
TNS-01150: The address of the specified listener name is incorrect [message #595954] Mon, 16 September 2013 10:06 Go to next message
ramamosn
Messages: 7
Registered: August 2013
Junior Member
I am building a new Oracle Server. I have the following in the listener.ora file.

LISTENERProd =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLEPRODDB)(PORT=1555))
)

SID_LIST_LISTENERProd=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc)
(ORACLE_HOME=c:\Oracle\product\11.2.0\dbhome_1)
(PROGRAM=dg4odbc)
)
)



C:\>lsnrctl start LISTENERProd

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 16-SEP-2013 09:56
:58

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

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
System parameter file is C:\Oracle\product\11.2.0\dbhome_1\network\admin\listene
r.ora
Log messages written to C:\Oracle\diag\tnslsnr\ORACLEPRODDB\listenerPROD\ale
rt\log.xml
TNS-01150: The address of the specified listener name is incorrect

Listener failed to start. See the error message(s) above...

Can someone please help?

Thanks.
Re: TNS-01150: The address of the specified listener name is incorrect [message #595957 is a reply to message #595954] Mon, 16 September 2013 10:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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.


Quote:
(PROGRAM=dg4odbc)


Are you sure?
And about the other parameters?

Regards
Michel
Re: TNS-01150: The address of the specified listener name is incorrect [message #595963 is a reply to message #595957] Mon, 16 September 2013 12:21 Go to previous messageGo to next message
ramamosn
Messages: 7
Registered: August 2013
Junior Member
Thank you Michel for the reply. Please ignore my previous posting. I have changed the listener and here is the modified file.


Listerner.ora

DEVITG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLEPRODDB.global.corp)(PORT = 3521))
)
)

ADR_BASE_DEVITG = C:\Oracle

LISTENER_DEVITG =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLEPRODDB.global.corp)(PORT = 3521))


C:\>lsnrctl start devitg

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 16-SEP-2013 13:08
:38

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

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
System parameter file is C:\Oracle\product\11.2.0\dbhome_1\network\admin\listene
r.ora
Log messages written to C:\Oracle\diag\tnslsnr\ORACLEPRODDB\devitg\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLEPRODDB.global.corp)(
PORT=3521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLEPRODDB.global.corp)(
PORT=3521)))
STATUS of the LISTENER
------------------------
Alias devitg
Version TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ
ction
Start Date 16-SEP-2013 13:08:43
Uptime 0 days 0 hr. 0 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\Oracle\product\11.2.0\dbhome_1\network\admin\listen
er.ora
Listener Log File C:\Oracle\diag\tnslsnr\ORACLEPRODDB\devitg\alert\log.x
ml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLEPRODDB.global.corp)(PORT=3521)))

The listener supports no services
The command completed successfully

C:\>lsnrctl services devitg

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 16-SEP-2013 13:11
:52

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLEPRODDB.global.corp)(
PORT=3521)))
The listener supports no services
The command completed successfully

I am getting the message "The listener supports no services". Can someone please help me to resolve this?


Thanks
ramamosn


I
Re: TNS-01150: The address of the specified listener name is incorrect [message #595965 is a reply to message #595963] Mon, 16 September 2013 12:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing to solve.
Why do you think there is a problem?

Regards
Michel
Re: TNS-01150: The address of the specified listener name is incorrect [message #595982 is a reply to message #595965] Mon, 16 September 2013 15:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Rarely is non-default listener required; like DEVITG
Rarely is non-default port required; like 3521.
Both are specially true for any newbie who does not know how to properly configure SQL*Net.
Re: TNS-01150: The address of the specified listener name is incorrect [message #596015 is a reply to message #595963] Tue, 17 September 2013 07:27 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
============================================================================
One single listener, using the default name of LISTENER and the default port of 1521 is quite capable of -- indeed, was designed to -- service multiple databases of multiple versions running from multiple homes. Anything else introduces unnecessary complexity and potential for thing to not work .. as you are discovering.

The listener is quite happy to start with no listener.ora file at all. I suggest you do the same. Then if business requirements dictate some non-default values, you can create a listener.ora to address those specific requirements. And after 17 years of working with Oracle, I've *never* seen a legitimate business requirement for creating a listener with a non-default name or non-default port. Such requirements exist only in the fevered imagination of those who don't understand how a listener works.
============================================================================
Re: TNS-01150: The address of the specified listener name is incorrect [message #596017 is a reply to message #596015] Tue, 17 September 2013 07:37 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I've *never* seen a legitimate business requirement for creating a listener with a non-default name or non-default port.


One may be security.
It is (a little bit) harder to hack a listener when you don't know the name or the port.

Another be may be organization.
There may be a port or name policy in the enterprise.
And maybe port 1521 is already used by someone else when you install Oracle.

Regards
Michel

[Updated on: Tue, 17 September 2013 07:38]

Report message to a moderator

Previous Topic: ORA-04030
Next Topic: Upgrade
Goto Forum:
  


Current Time: Thu Mar 28 03:16:48 CDT 2024