Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Start a database as sysoper from DBA-Studio

Re: Start a database as sysoper from DBA-Studio

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 10 Jul 2001 21:42:27 +0200
Message-ID: <tkmmh28rifs461@beta-news.demon.nl>

"Jan" <strik.j_at_planet.nl> wrote in message news:9ifilf$pg43$1_at_reader01.wxs.nl...
> Can someone help with the following ?
>
> We want to start a database on Windows NT and/or UNIX from DBA-Studio on
> (another) Windows NT.
> We log in to the database with user sys as sysoper, right-mouse-click and
> choose startup. We see a window with the message that the database is
> started alright.
> When we do a select from v$instance, we see that the database is in the
> mounted-status, so it is not open.
> The last entry in the alert.log : Completed: ALTER DATABASE MOUNT
>
> When we try the same thing as user sys as sysdba, the database starts and
> opens alright.
>
> When we login on the UNIX-box, do sqlplus "sys/... as sysoper" and start
 the
> database, the database starts and opens.
> The same thing happens if we use sqlplus as sysoper from a DOS-box on the
> Windows NT-machine where the DBA-Studio is. If we start the database on
 the
> remote Windows NT-machine, the database starts and opens.
>
> We want to use sysoper to start the database from DBA-Studio.
> How can we do that ?
>
>
>
>
>

This might well be a version specific bug. As you don't provide any information as to which version of the database and which version of DBA studio you are using, it is very unlikely you will get any adequate response.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Jul 10 2001 - 14:42:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US