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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Steve O'Donnell
Sent: Thursday, September 07, 2000 2:50 PM To: Multiple recipients of list ORACLE-L Subject: Sqlplus and connect internal

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).