Listener cannot read SERVICE_NAME in TNS-Descriptor

[Axel Dachtler]

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=(A DDRESS_LIST=(AD DRESS=(PROTOCOL =TCP)(HOST=axel-0560nntbn1)
(PORT=1521)))(C ONNECT_DATA=(SE RVER=DEDICATED) (SERVICE_NAME=t estdb)))

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

Thanks

Axel

[Ana C. Dent]

Re: Listener cannot read SERVICE_NAME in TNS-Descriptor

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=(A DDRESS_LIST=(AD DRESS=(PROTOCOL =TCP)(HOST=axel-0560nntbn1)
(PORT=1521)))(C ONNECT_DATA=(SE RVER=DEDICATED) (SERVICE_NAME=t estdb)))
>
It is a local database so I tried testdb.localhos t, 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.

[Axel Dachtler]

Re: Listener cannot read SERVICE_NAME in TNS-Descriptor

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)(POR T =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)


Thanks
Axel

[Ana C. Dent]

Re: Listener cannot read SERVICE_NAME in TNS-Descriptor

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)(POR T =
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

[Axel Dachtler]

Re: Listener cannot read SERVICE_NAME in TNS-Descriptor

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)(POR T =
1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECT ION_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)(POR T =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle.localhos t)
)
)

MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(POR T =
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_LI ST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(POR T =
1521))
)
)
)

SID_LIST_LISTEN ER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92 )
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle.localhos t)
(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.localho st" ...

Dienst "oracleXDB.loca lhost" ...

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

obviously there is no service running for MYDB !?


Thanks Axel

[Ana C. Dent]

Re: Listener cannot read SERVICE_NAME in TNS-Descriptor

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)(POR T =
1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
>
EXTPROC_CONNECT ION_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)(POR T =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle.localhos t)
)
)
>
MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(POR T =
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_LI ST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = axel-0560nntbn1)(POR T =
1521))
)
)
)
>
SID_LIST_LISTEN ER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92 )
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle.localhos t)
(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.localho st" ...
>
Dienst "oracleXDB.loca lhost" ...
>
--------------------------
>
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.