Cannot connect as Internal....?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Hari Om
    #1

    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=GATE S
    $./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.
    SQLconn 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!
    Tags: None
    • Maximus Bushwhacker
      #2
      Re: Cannot connect as Internal....?

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

      "Hari Om" <hari_om@hotmai l.comwrote in message
      news:d1d5ebe4.0 309081135.2f4d4 106@posting.goo gle.com...
      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=GATE S
      $./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.
      SQLconn 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!

        Comment

        • Dave Hau
          #3
          Re: Cannot connect as Internal....?

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

          Invalid URL
          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=GATE S
          $./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.
          SQLconn 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!

            Comment

            Previous template Next
            Working...