11 Replies Latest reply: Aug 23, 2010 12:27 PM by Chinar RSS

    ORA-01012: not logged on

    kkrm333
      Hi,

      I am getting this error after login as sysdba.
      and also not able to connect using any other user.
      my database is up and running.

      What is the reason?

      Please check this

      sqlplus system/manager

      SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 2 02:21:23 2010

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

      $ sqlplus '/as sysdba'

      SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 2 02:21:51 2010

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

      Connected.
      SQL> desc v$instance;
      ERROR:
      ORA-01012: not logged on


      Thanks,
      Kavitha
        • 1. Re: ORA-01012: not logged on
          671721
          pls provide alert_$sid.log info for analyze

          tks
          • 2. Re: ORA-01012: not logged on
            Girish Sharma
            Possible solutions:

            1.set proper oracle_sid and oracle_home <its case sensetive, because you are using linux>.

            2.There's no much you can do, except drop some session so that you can connect as sysdba and increase processes. Need re-bounce; due to limit of parameter processes hit. Sessions and processes may reach the max value.
            Source:ORA-01012: not logged on

            3.Copy and paste; how and what exactly you are doing to log on the db, so that we may find where else is the issue.

            Regards
            Girish Sharma
            • 3. Re: ORA-01012: not logged on
              kkrm333
              Hi,

              While startup, I got the following error

              ORA-24324: service handle not initialized
              ORA-24323: value not allowed
              ORA-03113: end-of-file on communication channel


              After installation of latest version of 11g,
              I have created initsid.ora with following paramets. Do I need to add any more parameters?
              Please check.


              db_name='oraqa'
              memory_target=1G
              processes = 150
              audit_file_dest='/oraweb/admin/oraweb/adump'

              audit_trail ='db'
              db_block_size=8192
              db_domain=''
              db_recovery_file_dest='/oraweb/recovery_area/flash_recovery_area'
              db_recovery_file_dest_size=2G
              diagnostic_dest='/oraweb'
              dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
              open_cursors=300
              remote_login_passwordfile='EXCLUSIVE'
              undo_tablespace='UNDOTBS1'
              # You may want to ensure that control files are created on separate physical
              # devices
              control_files = (ora_control1, ora_control2)
              compatible ='11.2.0'


              Thanks,
              Kavitha
              • 4. Re: ORA-01012: not logged on
                kkrm333
                And the alert log showing

                ORA-07445: exception encountered: core dump [PC:0x1BC35E] [SIGSEGV] [ADDR:0x68747541] [PC:0x1BC35E] [Address not mapped to object] []


                And the trace file showing

                Error Descriptor: ORA-7445 [PC:0x1BC35E] [SIGSEGV] [ADDR:0x68747541] [PC:0x1BC35E] [Address not mapped to object] [] [] [] [] [] [] []

                Thanks,
                Kavitha
                • 5. Re: ORA-01012: not logged on
                  cnester
                  kavi,

                  Did you ever get a solution to the issues in your last two posts? I am having the same problem. I have just installed Oracle 11gR2 (11.2.0) onto a Red Hat Enterprise 4 (32-bit) server. When trying to do a startup command I get the errors:

                  ORA-24324: service handle not initialized
                  ORA-24323: value not allowed
                  ORA-03113: end-of-file on communication channel

                  The in the alert.log I see this messages along with numerous trace files and core dumps:

                  ORA-07445: exception encountered: core dump [PC:0x41035E] [SIGSEGV] [ADDR:0x68747541] [PC:0x41035E] [Address not mapped to object] []

                  Any assistance would be greatly appreciated, I'm stumped!
                  • 6. Re: ORA-01012: not logged on
                    sb92075
                    is any type of Operating System Virtualization installed on this system?
                    • 7. Re: ORA-01012: not logged on
                      cnester
                      No, this is on physical hardware. There is no virtualization.
                      • 8. Re: ORA-01012: not logged on
                        gjilevski1
                        Hi,

                        database not starting up with errors ORA-01092 ORA-24324 ORA-01041 [ID 779356.1]

                        Regards,
                        • 9. Re: ORA-01012: not logged on
                          cnester
                          Thanks for the suggestion, but note: 779356.1 is not applicable to my situation. I do not have any datafiles in recovery. I installed 11gR2 in order to perform a test upgrade from 10.2.0. I can still open the database in 10.2.0, just fine and I've checked for datafiles in recovery already.

                          I also created an init.ora for brand new database and attempted a "startup nomount" and got the exact same errors. So the issue does not lie in the database itself, since I got the same error before even creating the physical database in that particular situation.

                          Edited by: user6190648 on Aug 12, 2010 4:12 PM
                          • 10. Re: ORA-01012: not logged on
                            cnester
                            After putting in an SR with Oracle Support I was able to get a resolution to my issue. The problem stems from the fact that we have 32-bit Linux running on 64-bit AMD processors and there are bugs related to this.

                            Applying the following patch resolved the issue entirely and the error message went away:
                            8670579 , “NETCA/DBCA FAILED WITH HOTSPOT VIRTUAL MACHINE”.

                            Edited by: cnester on Aug 23, 2010 9:59 AM
                            • 11. Re: ORA-01012: not logged on
                              Chinar
                              kavi wrote:
                              Hi,

                              While startup, I got the following error

                              ORA-24324: service handle not initialized
                              ORA-24323: value not allowed
                              ORA-03113: end-of-file on communication channel
                              Check system time.
                              1. Set the system time correctly.
                              2. Reboot the server.
                              3. And connect as sysdba then startup database.
                              *ORA-1041 When Trying to Connect as Sysdba to Startup Database [ID 552218.1]*