Database Networking (MOSC)

MOSC Banner

Unable to connect when localhost is mentioned in listener.ora, but working fine when the ip address

edited Sep 12, 2012 7:21PM in Database Networking (MOSC) 6 commentsAnswered
Hi,

I have installed a 11g database on a windows server. In the listener.ora when the entry for host is given as localhost, the connection from the server itself is failing.

i.e. when trying to connect as sqlplus username/passwd@servicename

But when the ip address of the server is mentioned in listener.ora, it's working normal.

Is it must to mention the ip address in the listener.ora? Can't we run it by mentioning localhost.

If we want to run it by mentioning localhost, what should be the entry in listener.ora look like?

Regards,

Prasanna.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center