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 -> connect as versus internal

connect as versus internal

From: Joachim Rupik <JRupik_at_awrsp.gov.pl>
Date: Wed, 06 Feb 2002 14:46:13 +0100
Message-ID: <3C6133A5.C9724C52@awrsp.gov.pl>


Hello,

I have one question:

I can connect to oracle using new syntax (method) " connect / as sysdba" and it should be equivalent to "connect internal" (de-supported beginning from 9i). But below is output that shows that it does not work the same way. Why?

Thank you in advance,
Joachim Rupik
jrupik_at_awrsp.gov.pl

$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 8 08:40:20 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-01089: immediate shutdown in progress - no operations are permitted

SQL> shutdown abort
ORA-01031: insufficient privileges
SQL>
SQL> connect internal
Connected to an idle instance.
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected Received on Wed Feb 06 2002 - 07:46:13 CST

Original text of this message

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