Re: Startup problem

From: sybrandb <sybrandb_at_gmail.com>
Date: 14 Nov 2006 05:45:30 -0800
Message-ID: <1163511929.939013.254680@i42g2000cwa.googlegroups.com>

On Nov 14, 1:55 pm, "QDL" <q..._at_qdl.qdl> wrote:
> > 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

Does the database actually open? Did you examine the alert log? There have been many cases in the past the service does start, but the database didn't open, usually because there was a mismatch between the SYS password and the password of the password file. The database registers itself when it opens. Alternatively, if you change service_name= in sid=<your sid> in tnsnames.ora, which error do you get?

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Tue Nov 14 2006 - 07:45:30 CST