Home » RDBMS Server » Networking and Gateways » regarding configuring listener.ora and tnsnames .ora (oracle10g on linux)
regarding configuring listener.ora and tnsnames .ora [message #428303] Tue, 27 October 2009 16:44 Go to next message
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 Go to previous message
BlackSwan
Messages: 25045
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!
Previous Topic: ORA- 12154: TNS:Could not Resolve the service name
Next Topic: oracle local net service name have default username password
Goto Forum:
  


Current Time: Wed Dec 07 18:24:34 CST 2016

Total time taken to generate the page: 0.25590 seconds