From oracle-l-bounce@freelists.org Mon Jul 12 09:32:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6CEW9s01994 for ; Mon, 12 Jul 2004 09:32:19 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6CEVx601958 for ; Mon, 12 Jul 2004 09:32:09 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DF54972CB20; Mon, 12 Jul 2004 09:12:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05846-39; Mon, 12 Jul 2004 09:12:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 69C2D72CA6F; Mon, 12 Jul 2004 09:12:33 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Jul 2004 09:11:09 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 84BEE72C0A8 for ; Mon, 12 Jul 2004 09:11:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03563-54 for ; Mon, 12 Jul 2004 09:11:08 -0500 (EST) Received: from mx1.state.vt.us (ns1.state.vt.us [159.105.23.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 081B272C02B for ; Mon, 12 Jul 2004 09:11:08 -0500 (EST) Received: from TAX132 ([159.105.89.132]) by mx1.state.vt.us (Post.Office MTA v3.5.4 release 224 ID# 0-0U10L2S100V35) with SMTP id us for ; Mon, 12 Jul 2004 10:35:42 -0400 From: "Ruth Gramolini" To: Subject: RE: sysdba Date: Mon, 12 Jul 2004 10:35:42 -0400 Message-ID: <006c01c4681d$829ca220$8459699f@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4865 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I would only add that you have to give the number of entries as well as the filename and password. The number of entries probably should be more than one if you have sys logged on anywhere. HTH, Ruth -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mercadante, Thomas F Sent: Monday, July 12, 2004 10:22 AM To: 'oracle-l@freelists.org' Subject: RE: sysdba Brian, The only connection as SYSDBA allowed from a remote device is via the Oracle password file. On the database server, type the following: Orapwd file=orapw(ora_sid) password=(password). This will create the file named orapw(ora_sid) within the $ORACLE_HOME/dbs directory. You can type orapwd for help. Make sure that the remote_login_password param = exclusive. You will then be able to connect remotely as sys/pw@remotesid as sysdba; Read up on Orapwd and remote_Login_password in the Oracle docs. Good Luck. Tom Mercadante Oracle Certified Professional -----Original Message----- From: Spears, Brian [mailto:BSpears@Limitedbrands.com] Sent: Monday, July 12, 2004 10:16 AM To: oracle-l@freelists.org Subject: RE: sysdba I know sqlplus "/ as sysdba" works on the host... No problem.. But remote connection is what I am looking for.. Niall, what area has to be worked on with trusting the remote connection? Brian -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Niall Litchfield Sent: Monday, July 12, 2004 9:56 AM To: oracle-l@freelists.org Subject: Re: sysdba On Mon, 12 Jul 2004 09:46:31 -0400, Spears, Brian wrote: > > Someone was telling me connecting as sysdba from sqlplus is not > allowed in 9i. I tried and found it did seem to not be available. Do you mean *only* connecting to SYS as sysdba? If so then yes it is entirely a security mechanism. If you are talking about remote connection then there is some work to be done to trust the remote connection, but set oracle_sid= (make sure the env var applies ) sqlplus "/ as sysdba" will work fine. Even on windows, which is nice. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------