By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

Listener cannot read SERVICE_NAME in TNS-Descriptor

P: n/a
Hi,

I have a listener problem. The listener cannot read SERVICE_NAME in
TNS-Descriptor. The service-name I specified in Oracle Net Manager for
this database is testdb as well.

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=axel-0560nntbn1)
(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERV ICE_NAME=testdb)))

It is a local database so I tried testdb.localhost, but this didn't
work too!

Thanks

Axel
Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Axel Dachtler wrote:
Hi,

I have a listener problem. The listener cannot read SERVICE_NAME in
TNS-Descriptor. The service-name I specified in Oracle Net Manager for
this database is testdb as well.

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=axel-0560nntbn1)
(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERV ICE_NAME=testdb)))

It is a local database so I tried testdb.localhost, but this didn't
work too!

Thanks

Axel


You did not provide enough information to troubleshoot the problem.
A listener is NOT required to access a local database.

"didn't work"?
EXACTLY what did not work?
EXACTLY what was the error message?
I have NO idea what you actually tried to do
or the error message with which Oracle responded.
Jul 19 '05 #2

P: n/a
> EXACTLY what did not work?
EXACTLY what was the error message?

I added a new database MYBD to the tree. But I cannot access MYDB. I
get this message:

ORA-12514: TNS:Listener couldn't dissolve SERVICE_NAME in connection
descriptor

(translated from German into English!)

That is in my tnsnames.ora:

MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)
Thanks
Axel
Jul 19 '05 #3

P: n/a
Axel Dachtler wrote:
EXACTLY what did not work?
EXACTLY what was the error message?


I added a new database MYBD to the tree. But I cannot access MYDB. I
get this message:

ORA-12514: TNS:Listener couldn't dissolve SERVICE_NAME in connection
descriptor

(translated from German into English!)

That is in my tnsnames.ora:

MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)
Thanks
Axel


1) What Operating System (OS)?
2) What OS version?
3) What is contents of listener.ora file
4) EXACTLY what are you doing to generate the ORA-12514 error?
5) If you are logged onto the actual database server system DIRECTLY,
then SQL*Net and Listener is NOT required to connect to the database.
6) "ping axel-0560nntbn1"
produces what output?
(without double quote marks)
7) lsnrctl status
produces what output?
8) while logged onto the database server
what is produced when the following is entered at the command line?
sqlplus
/ as sysdba
exit

Jul 19 '05 #4

P: n/a
> 1) What Operating System (OS)?
2) What OS version?
3) What is contents of listener.ora file
4) EXACTLY what are you doing to generate the ORA-12514 error?
5) If you are logged onto the actual database server system DIRECTLY,
then SQL*Net and Listener is NOT required to connect to the database.
6) "ping axel-0560nntbn1"
produces what output?
(without double quote marks)
7) lsnrctl status
produces what output?
8) while logged onto the database server
what is produced when the following is entered at the command line?
sqlplus
/ as sysdba

1) Windows XP
2) OS version 2002

3a) contents of tnsnames.ora:

# TNSNAMES.ORA Network Configuration File:
C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle.localhost)
)
)

MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb.localhost)
)
)

3b) contents of listener.ora:

# LISTENER.ORA Network Configuration File:
C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle.localhost)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = oracle)
)
)
4) ORA-12514 error: I doubleklick on the database icon of MYDB I just
added to the tree to open it! There is a pre-configured database
called "oracle" in the tree. When I click on this one it changes into
"oracle - Axel as sysdba" and opens.

5) I run Oracle 9i on my laptop, so I am logged onto the database
server system DIRECTLY. You say a Listener is NOT required to connect
to a database directly. But why do I get bothered by this ORA-12514
error ?

6) ping statistic for 172.0.0.1:
response from 172.0.0.1: Bytes = 32 time <1ms TTL 128
(4 times)
package: sent = 4 got = 4 lost = 0

7)lsnrctl status produces these Services:

-----------------------

Dienst "PLSExtProc" ...

Dienst "oracle.localhost" ...

Dienst "oracleXDB.localhost" ...

--------------------------

obviously there is no service running for MYDB !?
Thanks Axel
Jul 19 '05 #5

P: n/a
Axel Dachtler wrote:
1) What Operating System (OS)?
2) What OS version?
3) What is contents of listener.ora file
4) EXACTLY what are you doing to generate the ORA-12514 error?
5) If you are logged onto the actual database server system DIRECTLY,
then SQL*Net and Listener is NOT required to connect to the database.
6) "ping axel-0560nntbn1"
produces what output?
(without double quote marks)
7) lsnrctl status
produces what output?
8) while logged onto the database server
what is produced when the following is entered at the command line?
sqlplus
/ as sysdba


1) Windows XP
2) OS version 2002

3a) contents of tnsnames.ora:

# TNSNAMES.ORA Network Configuration File:
C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle.localhost)
)
)

MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb.localhost)
)
)

3b) contents of listener.ora:

# LISTENER.ORA Network Configuration File:
C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(PORT =
1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle.localhost)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = oracle)
)
)
4) ORA-12514 error: I doubleklick on the database icon of MYDB I just
added to the tree to open it! There is a pre-configured database
called "oracle" in the tree. When I click on this one it changes into
"oracle - Axel as sysdba" and opens.

5) I run Oracle 9i on my laptop, so I am logged onto the database
server system DIRECTLY. You say a Listener is NOT required to connect
to a database directly. But why do I get bothered by this ORA-12514
error ?

6) ping statistic for 172.0.0.1:
response from 172.0.0.1: Bytes = 32 time <1ms TTL 128
(4 times)
package: sent = 4 got = 4 lost = 0

7)lsnrctl status produces these Services:

-----------------------

Dienst "PLSExtProc" ...

Dienst "oracle.localhost" ...

Dienst "oracleXDB.localhost" ...

--------------------------

obviously there is no service running for MYDB !?
Thanks Axel

Upon further review & reading between the lines
it might be the case that you think you added a
new database/instance onto this system.

Somehow I serious doubt that by simply manipulating
some silly GUI that you actually created a 2nd DB.

If you log into the "oracle" DB which seems to be OK,
please do the following:
SELECT FILE_NAME FROM DBA_DATA_FILES;

The result is a collection of files which comprise
the majority of this instance.

If, in fact, a 2nd DB exists on this system,
you should be able to locate files with similar
or identical name which reside in a different path
where typically the pathname includes the SID.

My gut says that you do not have two databases on this system.

Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.