468,133 Members | 1,120 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,133 developers. It's quick & easy.

Cannot connect as Internal....?

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!
Jul 19 '05 #1
2 20855
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!

Jul 19 '05 #2
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!


Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jack Smith | last post: by
2 posts views Thread by Krista | last post: by
4 posts views Thread by bettina | last post: by
2 posts views Thread by Hari Om | last post: by
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.