Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Startup problem
"QDL" <qdl_at_qdl.qdl> schreef in bericht
news:4559d149$0$3207$4fafbaef_at_reader2.news.tin.it...
>> Does the database actually open?
> I'm a *real* beginner with Oracle... How can I check this? :)
>
>> Did you examine the alert log?
> No... You mean the Windows log or Oracle's
>
>> 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.
> I used the standard installer and I keyed in the password for SYS and
> SYSTEM there, so I guess this is not the problem. Also if I stop and
> restart the DB it works.
>
>> 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?
> How can I retrieve the SID... I told you I'm a real beginner...
>
> I think this problem is about some other service starting very slow
> (Network?) and Oracle not being able to start propertly. As I told before,
> after booting if I stop and restart Oracle DB, it start working ok...
>
> I forgot to mention I have also Oracle Application Server installed on the
> same machine...
>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>>
>
> Thanx again
> Paolo
>
Tried the same configuration, XE and IAS on same machine, and I get THE SAME ERROR when I start SQLPLUS from the ias/bin directory, which seems to be default if no path is specified. Can you try to start sqlplus from the XE-bin directory (start a dos-box, cd until you're there and start sqlplus)? Received on Tue Nov 14 2006 - 10:54:26 CST