RE: Sqlplus and connect internal

From: Rama Malladi <rmalladi_at_inteliant.com>
Date: Fri, 8 Sep 2000 13:30:02 -0700
Message-Id: <10613.116548@fatcity.com>

Tom,
 Thanks for your feedback. Checked the Support Site and found the following message.

Rama

---

Desupport of "CONNECT INTERNAL" syntax

---

Versions Affected

---

  It is expected that Oracle 8.1 will be the last release which supports the   'CONNECT INTERNAL' syntax to connect to Oracle as an administrative user.

Platforms Affected

---

  GENERIC - All platforms will be affected by this change.

Description

---

  "CONNECT INTERNAL" will no longer be supported AFTER Oracle 8.1 .   As part of planning for future releases users are advised to convert   administrative scripts to use the SYSDBA or SYSOPER privileges instead.   These privileges have been available and fully documented since Oracle 7.1 .

Updating Scripts

---

  From Oracle 7.1 onwards there are a number of ways to connect as   an administrative user. These are summarised below.   For most scripts it should be sufficient to replace:

        CONNECT INTERNAL
  with

        CONNECT / AS SYSDBA   but it would be sensible to review the alternatives before making such a   change.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Tom Pall Sent: Friday, September 08, 2000 11:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: Sqlplus and connect internal

Internal is not deactivated in 8.1.6.

There is an opened bug about running catalog with sql*plus as sysdba. One DBA ran catalog using sql*plus in 8.1.6, knowing that svrmgrl was going away.
She discovered that there were linefeeds in some of the scripts run by catalog.sql in object
definitions. Svrmgrl tolerates these linefeeds, sql*plus does not, so she would up with errors
that certain objects had not been created. Views upon the objects were of course invalid.
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, September 07, 2000 6:25 PM

> Steve,
> Read somewhere that "internal" is de-activated from 8.1.6 onwards ...
> Suggested user is Sys as Sysdba
>
> Rama
>
> -----Original Message-----
> O'Donnell
> Sent: Thursday, September 07, 2000 2:50 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> I've been having a problem connecting internal with sqlplus on the server
> running Oracle.
>
> It's NT 4.0 and Oracle 8.1.6.0.
>
> Server manager connects OK with connect internal, but sqlplus insists on
> having a password and then fails to connect with the ORA-01031
insufficient
> privileges message.
>
> But if I supply sqlplus with a connect internal/password all on the same
> line it connects fine.
>
> Are there two bugs with sqlplus here ?
>
> 1. You cannot connect internal if prompted for a password in sqlplus.
> 2. sqlplus requires a password for internal but svrmgrl does not.
>
> I suspect this is only a feature on NT.
>
> Has anyone else run into this ?
>
> Steve O'Donnell
>
> --
> Author: Steve O'Donnell
> INET: ocpsteve_at_oracle-dba.org.uk
>
> 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: ListGuru_at_fatcity.com (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).
>
> --
> Author: Rama Malladi
> INET: rmalladi_at_inteliant.com
>
> 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: ListGuru_at_fatcity.com (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).

--
Author: Tom Pall
  INET: tom_at_cdproc.com

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: ListGuru_at_fatcity.com (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

Received on Fri Sep 08 2000 - 15:30:02 CDT