Please help: stuck with ORA-12514

I recently installed Oracle10g Enterprise on my Windows 2000 machine to get some coding experience with it. I used the custom installation, left most options alone and created a default database called "odb1", with a full name of "db1.local".

Now, I'm stuck because I can't login to the DB, neither with SQL*Plus nor with the "Administration Assistant for Windows". All I get is an ORA-12514 error when I use "odb1" as the connect descriptor. When I try anything else, like "db1", "db1.local" or "odb1.local", I get an ORA-12154 error and a message which translates to "cannot resolve connect descriptor".

Here's an example from the listener.log file:

---
15-JUN-2004 12:40:57 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=odb1)(CID=(PROGRAM=D:\Devel\Database\Oracle10g\bin\sqlplusw.exe)(HOST=HARDY)(USER=RMA)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.3)(PORT=1453)) * establish *
odb1 * 12514
TNS-12514: TNS: Listener kann in Connect-Deskriptor angegebenen Dienst
aktuell nicht auflösen
---

(Which translates to something like "Listener cannot resolve the
service specified by the connect descriptor".)



The original listener.ora file was:
---
# listener.ora Network Configuration File:
D:\Devel\Database\Oracle10g\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =


      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = D:\Devel\Database\Oracle10g)

      (PROGRAM = extproc)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = hardy)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

---

After some web research, I suspected there was something missing and
changed it to:
---
# listener.ora Network Configuration File:
D:\Devel\Database\Oracle10g\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =


      (GLOBAL_DBNAME=db1.local)

      (SID_NAME=odb1)

      (ORACLE_HOME = D:\Devel\Database\Oracle10g)

      (PROGRAM = extproc)

    )
    (SID_DESC =


      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = D:\Devel\Database\Oracle10g)

      (PROGRAM = extproc)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = hardy)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

---
 

This didn't help. My tnsnames.ora file looks like this:

---
# tnsnames.ora Network Configuration File:
D:\Devel\Database\Oracle10g\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ODB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hardy)(PORT = 1521))
    (CONNECT_DATA =


      (SERVER = DEDICATED)

      (SERVICE_NAME = odb1)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =


      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

    )
    (CONNECT_DATA =


      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )
  )
---


As an Oracle newbie, I'm pretty out of ideas. Does anybody see what
I'm doing wrong?


Oh, by the way, I don't know if this is related: In the Win2000
service list, the services "OracleCSService" and "OracleDBConsoleodb1"
are permanently in the "is being started"/"starting" state, not
"started"/"running". Is this normal or does it indicate an error?

Thanks