Startup problem

[Database Administrator]

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

[Database Administrator]

On Nov 14, 9:33 am, "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

[Database Administrator]

On Nov 14, 9:33 am, "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

[Database Administrator]

> 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.

Thanx for answering, I thought about something needed to get "really"
started, I will wait more before attempting a connection. This is just a
test server so reboots are much more frequent than they'd be on a production
server, hence the problem.

> Sybrand Bakker
> Senior Oracle DBA

Bye
Paolo

[Database Administrator]

> 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.

Thanx for answering, I thought about something needed to get "really"
started, I will wait more before attempting a connection. This is just a
test server so reboots are much more frequent than they'd be on a production
server, hence the problem.

> Sybrand Bakker
> Senior Oracle DBA

Bye
Paolo

[Database Administrator]

[CUT]

Last update: after booting the server and waiting about 15 minutes, the
problem still persists... I think that it must be something different... Any
ideas?

Thanx in Advance
Paolo

[Database Administrator]

[CUT]

Last update: after booting the server and waiting about 15 minutes, the
problem still persists... I think that it must be something different... Any
ideas?

Thanx in Advance
Paolo

[Database Administrator]

"QDL" schreef in bericht
news:4559973f$0$19233$4fafbaef@reader4.news.tin.it ...
> [CUT]
>
> Last update: after booting the server and waiting about 15 minutes, the
> problem still persists... I think that it must be something different...
> Any ideas?
>
> Thanx in Advance
> Paolo
>

Does your server have a fixed IP address? (I hope so...)

[Database Administrator]

"QDL" schreef in bericht
news:4559973f$0$19233$4fafbaef@reader4.news.tin.it ...
> [CUT]
>
> Last update: after booting the server and waiting about 15 minutes, the
> problem still persists... I think that it must be something different...
> Any ideas?
>
> Thanx in Advance
> Paolo
>

Does your server have a fixed IP address? (I hope so...)

[Database Administrator]

>
> Does your server have a fixed IP address? (I hope so...)

Thanx for answering, yes I have a fixed IP address... And I'm still
clueless...

Thanx
Paolo