Re: Startup problem

On Nov 14, 9:33 am, "QDL" <q..._at_qdl.qdl> wrote:
> 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

The database needs to register itself with the listener. Apparently this didn't yet happen when you connected. Please note that when Windows becomes available after a reboot, this doesn't necessarily mean that all services have started.
You need to exercise a little bit more patience.

-- 
Sybrand Bakker
Senior Oracle DBA