Re: Q: How to shutdown an instances on Windows NT

Open up a console (DOS box). Before you start svrmgr type:

     set oracle_sid=dev

Then, start svrmgr, and type:

     connect internal

The default password is Oracle.

Then type:

    shutdown immediate

If you still get errors it's likely that the database never came up properly, so use the NT Server Manager to shut them down, but start them with svrmgr so you can see any errors on startup. You'll probably have to have Administrator privileges on the box to do this.

Regards,

Nigel

In article <36773719.9542EBF3_at_one.net>,   "Srinivasa R. Medam" <msr_at_one.net> wrote:
> Hi guys,
> I need help in the following situation.
> Scenario:
> On Windows NT Server 3 instances are running.
> One: 'dev' running oracle7
> Two: 'test' running oracle7
> Three: 'test8' running oracle8.
>
> What I need to do is shutdown instances 'test' and 'test8' and
> leaving 'dev' instance running.
>
> When I open instance manager, I see the above three instances.
> I could delete the instances from the Instance Manager, but that
> I will loose all the datafiles, etc. All I want to do shut-down the
> 'test' and 'test8' instances.
> I see them in the NT administation menu, in Services list.
>
> I tried connecting thru svrmgr23.exe in Orant/bin as internal/sys
> for the test and test8 instances, I was not successful. I could not set
> instance in svrmgr to test or test8 instances. The errors I was getting
> was:
> ORA-01034: Oracle Not Available.
> ORA-09243: smsget: Error attaching to SGA
> OSD-04104: Invalid SGA: SGA not initialized.
>
> But when I see 'Instance Manager' window. I see the above three
> instances.
> For instance 'dev' it is automatic mode. In the details it both
> instances
> and services check-boxed are ON (i.e. checked). And they are in
> grayed-out.
> When I see 'test' or 'test8' instances details, both services are
> checked, but
> not the instances check box. There is no way I could make these boxes
> enabled.
>
> Could someone help what is happening.
>
> My questions are how do I know which instances are running. How do I
> set the instances in the server managerline mode. I appreciate your
> help and time.
>
> Thanks so much in advance
>
> Srinivasa Medam
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 16 1998 - 23:07:28 CST