Start a database as sysoper from DBA-Studio

From: Jan <strik.j_at_planet.nl>
Date: Tue, 10 Jul 2001 20:47:30 +0200
Message-ID: <9ifilf$pg43$1@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 ? Received on Tue Jul 10 2001 - 13:47:30 CDT