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

    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 unselect  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 - 13:25:31 CDT