Re: connect as versus internal

From: Joachim Rupik <JRupik_at_awrsp.gov.pl>
Date: Thu, 07 Feb 2002 10:16:17 +0100
Message-ID: <3C6245E1.D4FA1C2F@awrsp.gov.pl>

Hello Svend,

Thank you for your response.

Svend Jensen wrote:

> You must be connected somehow or use OS-auth to use connect / as sysdba.
> try this, sqlplus /nolog
> connect sys/password
> connect / as sysdba

It is not true!
I do not need neither "OS-auth in use" nor "connect first as someone else". Below is an output showing that I can "connect / as sysdba" when I execute sqlplus as an OS user from DBA group (simply Oracle owner). I do this that way every time I must manage my db,
I mean shutdown or startup. But when normal shutdown hangs because of still executing sessions
in strange way a "connect internal" is more "powerful". I do not use any net connection it is local connection and db is Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production

$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 7 09:50:48 2002

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

SQL> connect / as sysdba
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 157720468 bytes

Fixed Size                    73620 bytes
Variable Size             123920384 bytes
Database Buffers           33554432 bytes
Redo Buffers                 172032 bytes

Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option
JServer Release 8.1.7.2.0 - Production
$

Greetings,
Joachim Rupik Received on Thu Feb 07 2002 - 03:16:17 CST