Cannot connect as Internal....?

[Hari Om]

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!

[Maximus Bushwhacker]

INTERNAL is a desupported account, use CONNECT SYS/PASSWORD AS SYSDBA or
CONNECT / AS SYSDBA instead.

"Hari Om" <ha*****@hotmail.com> wrote in message
news:d1**************************@posting.google.c om...

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!

[Dave Hau]

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

http://download-west.oracle.com/docs...500.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!