Startup problem

Hello everyone,

I installed Oracle 10g Express on a Windows 2K3 Server box without any problem, (almost) everything runs ok.

The only problem I have is at startup, after rebooting the server if i try to connect to the server (even using SQL Prompt locally), I get this error:

ORA-12514: The TNS Listener does not currently know the service requested in connection descriptor (The error description might be slightly different, I translated from Italian).

If I stop and restart the database, then it works ok...

I'm posting here my *.ORA files:

• TNSNAMES --- XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = whitey)(PORT = 1521)) (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = XE)
  ) )

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

    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)

    )
  )

• LISTENER --- SID_LIST_LISTENER = (SID_LIST = (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
  (PROGRAM = extproc)
  ) (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
  (PROGRAM = extproc)
  ) )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = whitey)(PORT = 1521))
    )
  )

DEFAULT_SERVICE_LISTENER = (XE)

• SQLNET --- # This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS) I did not make any changes to the defaults.

Thanx in Advance
Paolo Received on Tue Nov 14 2006 - 02:33:50 CST