| regarding configuring listener.ora and tnsnames .ora [message #428303] |
Tue, 27 October 2009 16:44  |
gouthamk10
Messages: 2
Registered: August 2008
|
Junior Member |
|
|
hi
can anybody help with the issue related to configuring listener.ora and tnsnames.ora.
i had configured listener.ora
list_goutham=
(description_list=
(description=
(address_list=
(address=(protocol=tcp)(host=192.168.1.65)(port=1521))
))
sid_list_list_goutham=
(sid_list=
(sid_desc=
(sid_name=goutham)
(ORACLE_HOME= /oraeng/app/product/10.2.0)))
iam getting an error=tns-01150: the address of the specified listener name is incorrect.
and at the client side i configured tnsnames.ora
to_goutham=
(description=
(address_list=
(address= (protocol=tcp)(host=192.168.1.65)(port=1521)))
(connect_data=
(sid=goutham)
)).
can anybody pls help me .
thank u
|
|
|
|
| Re: regarding configuring listener.ora and tnsnames .ora [message #428305 is a reply to message #428303] |
Tue, 27 October 2009 17:00  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
1150, 00000, "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.
With V10+ Oracle, no listner.ora file is required.
the listener will start & run OK without listener.ora existing.
Try i. You'll like it!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
