ORA-01012: not logged on
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-01012: not logged on

Hybrid View

  1. #1
    Join Date
    Jun 2007
    Posts
    29

    ORA-01012: not logged on

    i was having an error ORA-00018: maximum number of sessions exceeded.
    so i took the step below but now i am having another error


    SQL> alter system set sessions = 225 scope = spfile;
    alter system set sessions = 225 scope = spfile
    *
    ERROR at line 1:
    ORA-01012: not logged on

    pls help
    Last edited by seyiisq; 06-15-2007 at 02:47 PM.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Please tell me you didn't just put the sys password of one of your production boxes online for the whole world to see.

    SOX anyone?
    I remember when this place was cool.

  3. #3
    Join Date
    Jun 2007
    Posts
    29
    i tried shutting down the database to start it up again but i got this other error.

    SQL> shutdown abort;
    ORACLE instance shut down.
    SQL> startup;
    ORA-12528: TNS:listener: all appropriate instances are blocking new connections
    SQL> startup force;
    ORA-01041: internal error. hostdef extension doesn't exist

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    This is all I found.

    http://dba.ipbhost.com/index.php?showtopic=6136

    Seems to be new to 10g.
    I remember when this place was cool.

  5. #5
    Join Date
    Jun 2007
    Posts
    29
    tahanks i have been able to rectify this problem using shutdown abort
    my instance is now up and running but the problem here now is when i log in as user system i keep having this page

    SQL*Plus: Release 10.1.0.2.0 - Production on Fri Jun 15 21:51:14 2007

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    ERROR:
    ORA-06553: PLS-213: package STANDARD not accessible


    ERROR:
    ORA-06553: PLS-213: package STANDARD not accessible


    Error accessing package DBMS_APPLICATION_INFO

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
    With the Partitioning, OLAP and Data Mining options

    SQL>

    pls is there any problem at all with this

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    sqplus sys/ @$ORACLE_HOME/rdbms/admin/standard.sql
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width