Help Needed! Oracle Server Requires Daily Re-boot

[TP]

We recently moved our EA Access database to Oracle 9i.  It works fine, except that each morning we have to re-boot the Windows 2000 server to allow connections to the database.  I cannot see any evidence of missing or stopped processes on the Windows server.  Has anyone seen this before?  I really need some help on this one!!  Please send me a message if you have a solution.  Thanks.

Regards

[Bruno.Cossi]

Hi,

what version/release of Oracle do you use exactly? Try the following first, that will help to pinpoint where exactly the problem is:

1. Connect to your database from SQL*Plus on the server
2. Connect to your database from EA installed on the server
3. Connect to your database from SQL*Plus on another machine

Can you tell me what error message do you get? Including the ORA number.
Also, do you use static or dynamic IP address?

Thanks,
Bruno

[TP]

Thanks for the reply Bruno.Cossi

The version of Oracle is 9.2.0.1.0

The error message that we receive is as follows:

"ORA 12505 TNS Listener could not resolve SID given in connect descriptor".

The user is also prompted for a password, although it is supplied in the connect string.

Regards

[Bruno.Cossi]

As per my e-mail, please have a look at the services on the server and make sure that the listener is running. If not, have a look at the Oracle log, you can send it to me and I will try to track down what is bringing it down.
If the listener is up, make sure that your client machine can connect to the server one.

Bruno