Re: Cannot connect as Internal....?

All you need to do is look up the error message ORA-09275 in the Oracle documentation.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96525/e7500.htm#294368

ORA-09275 CONNECT INTERNAL is not a valid DBA connection

     Cause: CONNECT INTERNAL is no longer supported for DBA connections.

     Action: Please try to connect AS SYSDBA or AS SYSOPER.

HTH,
Dave

Hari Om wrote:
> Cannot connect as Internal
>
> Hello,
>
> I am using IBM AIX 5.1L box for Oracle 9.2.0.1.
>
> I cannot connect as internal to my DB INstance - wonder why? Here is
> what is do:
> -------------------------------------------------------------------
> $export ORACLE_SID=GATES
> $./sqlplus /nolog
> SQL*Plus: Release 9.2.0.1.0 - Production on Mon Sep 8 13:28:42 2003
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> SQL> conn internal/oracle
> ERROR:
> ORA-09275: CONNECT INTERNAL is not a valid DBA connection
> SQL>
> -------------------------------------------------------------------
>
> Can anyone tell what is wrong here....? Also, BTW why do we need to
> connect as Internal and what is the use of Internal which cannot be
> done by other accounts like SYS or SYSTEM or SCOTT etc....?
>
> Any related information on this is appreciated.
>
> THANKS!
Received on Mon Sep 08 2003 - 21:55:30 CEST