> My goal is to have Oracle user JOHNQPUBLIC bounce a database from the > local host or remotely. Any UNIX account for that user would NOT be part > of the DBA group. > > I performed the following steps: > > orapwd file=$ORACLE_HOME/dbs/orapwXXX password=YYY > $ ls -l > -rwSr----- 1 oracle dba 1536 Apr 25 09:10 orapwXXX > > $ grep exclusive initXXX.ora > remote_login_passwordfile=exclusive > > In sqlplus: > grant SYSOPER to JOHNQPUBLIC; > shutdown immediate > startup > > From the local AIX UNIX host: > $ ps -ef | grep pmon > oracle 33628 1 0 09:16:37 - 0:00 ora_pmon_XXX > $ sqlplus /nolog > SQL> connect JOHNQPUBLIC/hispassword as SYSOPER > SP2-0614: Server version too low for this feature > Connected to an idle instance. > > From client PC (same result): > <click SQL*Plus> > system > ********** > XXX > > SQL*Plus: Release 8.1.6.0.0 - Production on Wed Apr 25 09:10:24 2001 > > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > > Connected to: > Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production > With the Partitioning option > JServer Release 8.1.6.0.0 - Production > > SQL> connect JOHNQPUBLIC/hispassword as SYSOPER > SP2-0614: Server version too low for this feature > Connected to an idle instance. > > The instance is up. Why "idle"? What am I missing? > Thanks, Alan Martin Oracle DBA - GMAC Insurance Winston-Salem, NC [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin, Alan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
