Home » RDBMS Server » Networking and Gateways » Problem with No TNS Listener error (11g)
Problem with No TNS Listener error [message #615357] Mon, 02 June 2014 16:33 Go to next message
JoeBell
Messages: 1
Registered: June 2014
Junior Member
I am an Oracle rookie that uses Oracle in support of a software analysis product and I have the following problem:

From SQLPLUS when I connect using the following string I connect successfully: sys/user/localhost:1523/oraclese as sysdba

When I change localhost to the server name as follows: sys/user/@server_name:1523/oraclese as sysdba I get the message ORA-12541 TNS no listener.

The only difference is the server name vs localhost.

What am I missing?

I really appreciate any help!

Report message to a moderator

Re: Problem with No TNS Listener error [message #615358 is a reply to message #615357] Mon, 02 June 2014 16:39 Go to previous messageGo to next message
John Watson
Messages: 8966
Registered: January 2010
Location: Global Village
Senior Member
Your database listener is not listening on whatever address server_name resolves to. Incidentally, an underscore "_" character is not actually legal in a host name (though it may sometimes work).

Report message to a moderator

Re: Problem with No TNS Listener error [message #615367 is a reply to message #615358] Mon, 02 June 2014 17:51 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

>From SQLPLUS when I connect using the following string I connect successfully: sys/user/localhost:1523/oraclese as sysdba

The difference in behavior is because the line above does not contain any at sign ("@") while the line below does.

>When I change localhost to the server name as follows: sys/user/@server_name:1523/oraclese as sysdba I get the message ORA-12541 TNS no listener.

You do not need to use SQL*Net to access any local database.

Report message to a moderator

Previous Topic: Data Retrieval from SQL server to oracle client through ODBC
Next Topic: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Mar 09 22:12:22 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.