1 2 Previous Next 21 Replies Latest reply on Mar 30, 2012 11:08 AM by Nicolas.Gasparotto

    ORA-01012: not logged on

    user597936
      [b]At times I am not able to execute any Select statements after logging in. Does this has to do with SGA size? How to troubleshoot this issue

      $ sqlplus "/ as sysdba"

      SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 1 10:30:32 2007

      Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

      Connected.
      SQL> select instance_name from v$instance;
      select instance_name from v$instance
      *
      ERROR at line 1:
      ORA-01012: not logged on

      =======================================

      This is the o/p taken from already connected session

      Name Bytes % Used Var. Size
      -------------------------- ------------ ------- ------------
      free memory 25,165,824 40.00 62,914,560
      free memory 8,189,984 13.02 62,914,560
      library cache 5,911,848 9.40 62,914,560
      miscellaneous 5,895,664 9.37 62,914,560
      dictionary cache 3,221,760 5.12 62,914,560
      event statistics per sess 2,287,800 3.64 62,914,560
      kgl simulator 2,145,024 3.41 62,914,560
      1M buffer 2,098,176 3.33 62,914,560
      sql area 1,324,880 2.11 62,914,560
      KSXR receive buffers 1,034,000 1.64 62,914,560
      message pool freequeue 940,944 1.50 62,914,560
      KSXR pending messages que 853,952 1.36 62,914,560
      sessions 608,400 .97 62,914,560
      transaction 399,696 .64 62,914,560
      FileOpenBlock 393,232 .63 62,914,560
      enqueue 378,016 .60 62,914,560
      character set object 274,528 .44 62,914,560
      processes 257,600 .41 62,914,560
      krvxrr 253,056 .40 62,914,560
      KQR L PO 250,240 .40 62,914,560
      db_handles 232,000 .37 62,914,560
      KGLS heap 231,680 .37 62,914,560
      KSXR large reply queue 166,824 .27 62,914,560
      KQR M PO 150,624 .24 62,914,560
      PX subheap 20,872 .03 62,914,560
      KQR S SO 6,672 .01 62,914,560
      joxs heap init 4,240 .01 62,914,560
      KGK heap 2,200 .00 62,914,560
      PLS non-lib hp 2,088 .00 62,914,560
      table definiti 992 .00 62,914,560
      fixed allocation callback 544 .00 62,914,560

      ============================================================

      Message was edited by:
      user597936
        1 2 Previous Next