TNS-01150: The address of the specified listener name is incorrect [message #595954] |
Mon, 16 September 2013 10:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bbb9c08c140a808f4721ad782623af53?s=64&d=mm&r=g) |
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 #596017 is a reply to message #596015] |
Tue, 17 September 2013 07:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 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
|
|
|