RE: Connect as sysdba on 9i
Title: Connect as sysdba on 9i Ave ! Try: $ Sqlplus /nolog SQLPLUS> connect / as sysdba Br.Jorma -Original Message-From: ext Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: 22 January, 2002 14:05To: Multiple recipients of list ORACLE-LSubject: Connect as sysdba on 9i Hi! I have a question concerning "connect sys as sydba" on 9i. When I open sqlplus and connect as sysdba (I'm logged in as the Unix oracle user): sqlplus "sys as sysdba" Oracle asks for a password. Even if I type in the wrong password, I am connected to Oracle. So does Oracle just use the OS authentication (like connect internal did on 8i)? But why is Oracle asking for a password in the first place then? Any ideas? This is 9.0.1 on Sun Solaris. Thanks, Helmut
RE: Connect as sysdba on 9i
Title: Connect as sysdba on 9i Try: sqlplus "/ as sysdba" I suspect the / indicates current OS user and if you belong to the SYSDBA or SYSOPER groups then you will be connected. SYS is probably not a member of these groups. I haven't tested this. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, HelmutSent: Tuesday, January 22, 2002 7:05 AMTo: Multiple recipients of list ORACLE-LSubject: Connect as sysdba on 9i Hi! I have a question concerning "connect sys as sydba" on 9i. When I open sqlplus and connect as sysdba (I'm logged in as the Unix oracle user): sqlplus "sys as sysdba" Oracle asks for a password. Even if I type in the wrong password, I am connected to Oracle. So does Oracle just use the OS authentication (like connect internal did on 8i)? But why is Oracle asking for a password in the first place then? Any ideas? This is 9.0.1 on Sun Solaris. Thanks, Helmut
RE: Connect as sysdba on 9i
Hi Do'it the follow steps : sqlplus /nolog SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jan 22 15:23:12 2002 (c) Copyright 2001 Oracle Corporation. All rights reserved. SQL> connect sys as sysdba Enter password: Connected to an idle instance. Regards Rudi Original Message Von: [EMAIL PROTECTED] An: [EMAIL PROTECTED], Betreff: RE: Connect as sysdba on 9i Datum: Tue, 22 Jan 2002 04:05:22 -0800 >Hi! > >I have a question concerning "connect sys as sydba" on 9i. > >When I open sqlplus and connect as sysdba (I'm logged in as the Unix >oracle >user): > >sqlplus "sys as sysdba" > >Oracle asks for a password. Even if I type in the wrong password, I >am >connected to Oracle. So does Oracle just use the OS authentication >(like >connect internal did on 8i)? >But why is Oracle asking for a password in the first place then? Any >ideas? > >This is 9.0.1 on Sun Solaris. > >Thanks, >Helmut > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rudolf Konrad 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).
RE: Connect as sysdba on 9i
Title: Connect as sysdba on 9i That exactly connects you as SYS which u can check with SHOW USER Just my $.02. Regards, Sergey Babich -Original Message-From: eric harrington [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 22, 2002 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Connect as sysdba on 9i Try: sqlplus "/ as sysdba" I suspect the / indicates current OS user and if you belong to the SYSDBA or SYSOPER groups then you will be connected. SYS is probably not a member of these groups. I haven't tested this. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, HelmutSent: Tuesday, January 22, 2002 7:05 AMTo: Multiple recipients of list ORACLE-LSubject: Connect as sysdba on 9i Hi! I have a question concerning "connect sys as sydba" on 9i. When I open sqlplus and connect as sysdba (I'm logged in as the Unix oracle user): sqlplus "sys as sysdba" Oracle asks for a password. Even if I type in the wrong password, I am connected to Oracle. So does Oracle just use the OS authentication (like connect internal did on 8i)? But why is Oracle asking for a password in the first place then? Any ideas? This is 9.0.1 on Sun Solaris. Thanks, Helmut