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)(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 Received on Sun Dec 28 2003 - 14:25:31 CET