Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> password scripting question
This is somewhat related to the question earlier about how to encrypt a password in a script... however, what I want to do is also be able to start that database through a script.
(Oracle 9.2.0.)
Essentially I have a database that I want to shut down at 5pm every night, and start it back up at 8am in the morning. I currently have a script that logs into sqlplus "/ as sysdba"
I tried creating a use OPS$ORACLE and granted it dba, sysdba, and set the tablespaces. And I can log in fine doing a
$ sqlplus /
and when I do a 'select user from dual;' it comes back and says OPS$ORACLE... exactly what I want... however when I try to start or shutdown the database it says I must be logged in as SYSDBA or SYSOPR... or I try
$ sqlplus "/ as sysdba"
logs into oracle just fine, but when I do a 'select user from dual;' it comes back as SYS and not OPS$ORACLE... what am I doing wrong?
Thanks!
Nick
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nick Wagner INET: Nick.Wagner_at_quest.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Feb 25 2003 - 13:24:03 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).