Listener supports no services
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))
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))
0