Oracle-L: Re: Difference between connect internal and connect / as sysdba in sqlplus

From: Mikhail Ivanov <mivanov_at_tdera.ru>
Date: Mon, 07 Oct 2002 01:13:23 -0800
Message-ID: <F001.004E1E82.20021007011323@fatcity.com>

I use Oracle 8.1.7. I tried install patchset 8.1.7.3 and there is written:

" ...
Invoke SQL*Plus (sqlplus), connect as internal and run the following SQL scripts with event 10520 set. NOTE: This event is not intended for regular database operation and MUST be turned off as indicated below:

ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';

?/rdbms/admin/catalog.sql
?/rdbms/admin/catproc.sql
?/rdbms/admin/catrep.sql

(This only needs to be run if you are using symmetric/advanced replication. This is not necessary for sites using dblinks and read-only snapshots if symmetric/advanced replication is not installed)

CONNECT / AS SYSDBA;
update obj$ set status=5 where type#=29 and owner#!=0; commit;
..."

Excuse me for long quotation.
Why first "connect internal" and second "connect / as sysdba"? For a multiplicity only ?
If it's not, what's difference between thease?

> 'connect internal' is no longer supported in 9i+
>
> 'connect / as sysdba' is the replacement.
>
> --- Mikhail Ivanov <mivanov_at_tdera.ru> wrote:
> > What is difference between "connect internal" and "connect / as
> > sysdba" in
> > sqlplus ?
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com

-- 
Best regards
Mikhail Ivanov
ÿóåy«±ç…ê~'"jS‘
ü¸¬´k«»ÿÚØ§¶¦zËàN
âÉnuæ¥Šwœ¢{ZŠx§ƒõ
I_at_ND

Received on Mon Oct 07 2002 - 04:13:23 CDT