Database Networking (MOSC)

MOSC Banner

Listener supports no services

edited Jul 15, 2011 3:32AM in Database Networking (MOSC) 6 commentsAnswered
Hi .. I am using Ubuntu 11.04, Oracle 11g Enterprise on a local machine and everything works fine except when I try to log in using useris/passwd@Hostname. If I log in to sqllus with userid / passwd .. everything is fine.

The hostname is SpongeBob and I can ping the host name and the fully qualified name.

tnsnames.ora

SPONGEBOB
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SpongeBob)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = amr)
    )
  )
 
Listener.ora

SPONGEBOB =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SpongeBob.xxx.xxx.com)(PORT = 1521))
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = SpongeBob)(PORT = 1521))

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