Start database from DBA-Studio as sysoper

From: Jan <strik.j_at_planet.nl>
Date: Mon, 9 Jul 2001 21:48:50 +0200
Message-ID: <9id24p$nh2o$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 Mon Jul 09 2001 - 14:48:50 CDT