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 -----
From: Rama Malladi <rmalladi_at_inteliant.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, September 07, 2000 6:25 PM Subject: RE: Sqlplus and connect internal

> 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).
Received on Fri Sep 08 2000 - 12:32:11 CDT