Re: svrmgrl needs OracleService<SID> on NT, not an Oracle Instance

OH, ok, now I see...
You can , of course, connect internal and issue a shutdown immediate, then a startup nomount ....

I do not use either the Enterprise Manager or the Admin Asst, I manage my instances thru DBA Studio ( from the 8.1.6 Client install) and run it stand-alone, not thru Ent.Mgr - I have never been happy with Oracle Agents, Enterprise Manager, etc...and DBA Studio meets my needs...

dong_liu62_at_hotmail.com wrote:

> You are right that OracleService<SID> and Oracle instance are two
>separate things.
> That is exactly what I wanted to point out in my first message.
> The only problem is that the default setting on Oracle
>Administration Assistance binds them togather.
> In Oracle Administration Assistance, find the database instance
>icon (the name is your <SID>). On my computer, it is Oracle Managed
>Objects > Computers > (Machine Name) > Databases > (SID). Right click
>on the single cylinder icon for your database instance, you will see a
>small window. Choose "Startup/Shutdown Options." In the tab for "Oracle
>Instance," there are two checkboxes for "start up instance when service
>is started," and "shut down instance when service is stopped."
> As default, both checkboxes are checked. That means if you starts
>OracleService<SID>, the Oracle instance is automatically started by
>OracleService<SID>. Only at this time you can start svrmgrl/sqlplus
>and "connect internal." But you can not do "startup nomount," since the
>Oracle instance is already started.
> To start svrmgrl, you need OracleService<SID> started. To "startup
>nomount," you need the Oracle Instance NOT started. You have to un-
>select the checkbox "start up instance when service is started."
> If this checkbox is already un-selected on your machine, you just
>achieve the same goal.
> Look forward to your experience.
>
> Dong Liu
>
>In article <39ad2676.164486388_at_news>,
> See Message body for real address wrote:
>> Have your service start automatically (or start it first ) - the
 service needs
>> to be running before you try to start or mount the database-
>>
>> I'm not sure what you mean by de-couple the service....The NT service
 and the
>> Oracle instance are 2 separate entities....
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Aug 30 2000 - 15:56:28 CDT