From oracle-l-bounce@freelists.org Mon Jul 12 09:05:17 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6CE4k027838 for ; Mon, 12 Jul 2004 09:04:56 -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 i6CE4a627796 for ; Mon, 12 Jul 2004 09:04:46 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B67772CBB7; Mon, 12 Jul 2004 08:45:15 -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 29385-46; Mon, 12 Jul 2004 08:45:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C672672CA82; Mon, 12 Jul 2004 08:45:14 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Jul 2004 08:43:45 -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 CCBCA72CB0B for ; Mon, 12 Jul 2004 08:43:44 -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 28067-100 for ; Mon, 12 Jul 2004 08:43:44 -0500 (EST) Received: from ross.alise.lv (ross.alise.lv [194.19.227.242]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2137F72CA92 for ; Mon, 12 Jul 2004 08:43:44 -0500 (EST) In-Reply-To: To: oracle-l@freelists.org Subject: RE: sysdba MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.2 June 01, 2004 Message-ID: From: J.Velikanovs@alise.lv Date: Mon, 12 Jul 2004 16:45:24 +0300 X-MIMETrack: Serialize by Router on ROSS/IT ALISE/LV(Release 5.0.11 |July 24, 2002) at 2004.07.12 17:00:39, Serialize complete at 2004.07.12 17:00:39 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4862 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: J.Velikanovs@alise.lv Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org idle> conn sys/s@jozh as sysdba Connected. SYS:jozh> @par Parameters vai dala no ta :password NAME VALUE ---------------------------------------- -------------------------------- remote_login_passwordfile EXCLUSIVE SYS:jozh> @ver BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production CORE 9.2.0.3.0 Production TNS for 32-bit Windows: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production 5 rows selected. SYS:jozh> I would suggest to look on password file (seach key word orapwd) and remote_login_passwordfile parameter. Jurijs 9268222 ============================================ http://otn.oracle.com/ocm/jvelikanovs.html "David Sharples" Sent by: oracle-l-bounce@freelists.org 12.07.2004 16:52 Please respond to oracle-l To: cc: Subject: RE: sysdba Course it is allowed (how else are you going to connect?) Sqlplus "/ as sysdba" works just fine -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Spears, Brian Sent: 12 July 2004 14:47 To: oracle-l@freelists.org Subject: sysdba 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. Is this a security consideration... And/or does anyone have a workaround? Thanks Brian ---------------------------------------------------------------- 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 -----------------------------------------------------------------