Re: ORACLE INSTANCE IS DOWN

Unfortunately, It's been a while since I handled the Sun Solaris OS.

When you echo $ORACLE_SID what do you get?

Are there any oracle related entries in the Shell Login scripts.

The last time I had similar problem, it was because the Default SID keep chaning on me. I don't remember the other details though. Sorry!

HTH Prasad Chavali

BHAVESH PATEL wrote in message <6m8a3n$gg5_at_bgtnsc03.worldnet.att.net>...
>Do you two INIT.ORA files for your instances INITDEVEL.ORA and
INITTEST.ORA?
>- YES
>
>What is your Server OS?
>- SUN Solaris 4.2
>
>If it is NT are the services setup to start both instances automatically?
>------ Its Unix and during Unix Startup it starts the instance
>automatically
>
>What is the Default Oracle sid on the machine?
>--- do not remember for sure.
>
>Did you change the ORACLE_SID parameter before making changes to INIT files
>and before starting the databases?
>----But I did not change anything with SID in parameter files.
>what I changed was job_queue_process and jiob_queue_interval parameters in
>INIT.ORA.
>
>
>
>
>Prasad Chavali wrote in message <6m6m19$4j4_at_nntp02.primenet.com>...
>>To analyze your problem, there may some more information needed.
>>
>>Do you two INIT.ORA files for your instances INITDEVEL.ORA and
>INITTEST.ORA?
>>What is your Server OS?
>>
>>If it is NT are the services setup to start both instances automatically?
>>\What is the Default Oracle sid on the machine?
>>Did you change the ORACLE_SID parameter before making changes to INIT
files
>>and before starting the databases?
>>
>>Thanks
>>Prasad Chavali
>>pchavali_at_assettech.com
>>
>>BHAVESH PATEL wrote in message <6m5ll7$pk0_at_bgtnsc03.worldnet.att.net>...
>>>Hi
>>>I tried to change the INIT.ORA file settings and then after saving the
>.ORA
>>>file. I tried to reboot my system. So during thre boot up the Instance
can
>>>start on its own. I dont know what the problem was, H/w or S/W. The .ORA
>>>file got junk lines from somewhere, I fixed the .ORA file from the
backup
>>>copy. I tried to start the instance, actually, I was under the impression
>>>that, I am running the Development , where as the Instance that was
>started
>>>was that of TEST. Since test and Devlopment both resides on the same m/c.
>>>Now I tried to change the settings and fix the INIT.ORA and my devlp.
>>>instance is started, Still my TEST instance is failing and not letting me
>>to
>>>mount the database. What I need to do? Can anyone please be of any use to
>>>me. Thanks and have a nice day.
>>>-BHAVESH
>>>(bhavesh-patel_at_worldnet.att.net )
>>>
>>>
>>>
>>
>>
>
>
Received on Wed Jun 17 1998 - 18:47:02 CDT