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: connecting automatically as sys

Re: connecting automatically as sys

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: 16 Jul 2004 05:43:38 -0700
Message-ID: <d4d6f278.0407160443.43aa2bc3@posting.google.com>


If the script you are running is on the database machine/server then (depending on who is logged on) you can do this ...

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.5.0 - Production on Fri Jul 16 08:39:05 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba;
Connected.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Producti
on

But take the caveats of the earlier posters. DBMS JOB can be used to automate things along with other things such as OEM, scripts kicked off by the system when it is changing run levels, etc.

Plus the questions "what is it I need to do and why" along with "what is minimum authority level needed to accomplish this?". Received on Fri Jul 16 2004 - 07:43:38 CDT

Original text of this message

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