2 Replies Latest reply on Jan 31, 2008 5:35 AM by Vihang Astik

    ORA-24327: need explicit attach before authenticating a user

    Vihang Astik
      dear friends,

      i m getting this error when i try to shutdown the database using oradim utility..

      ORA-24327: need explicit attach before authenticating a user

      getting this kind of error in alert_log file again and again
      Process m000 died, see its trace file

      thanks
        • 1. Re: ORA-24327: need explicit attach before authenticating a user
          584650
          Did you check the trace file?
          • 2. Re: ORA-24327: need explicit attach before authenticating a user
            Vihang Astik
            trace file for mmon process

            *** SERVICE NAME:(SYS$BACKGROUND) 2008-01-31 10:30:21.171
            *** SESSION ID:(161.1) 2008-01-31 10:30:21.171
            *** 2008-01-31 10:30:21.171
            Process m000 is dead (pid=7088, state=3):
            Unable to schedule a MMON slave at: Auto Flush Main 1
            Attempt to create slave process failed.
            Can happen for several reasons:
            - No process state objects
            - Reached OS set limits
            - A shutdown was going on
            Check alert log for more details.
            *** 2008-01-31 10:31:22.687
            Process m000 is dead (pid=7304, state=3):
            Unable to schedule a MMON slave at: Auto Flush Main 1
            Attempt to create slave process failed.
            Can happen for several reasons:
            - No process state objects
            - Reached OS set limits
            - A shutdown was going on
            Check alert log for more details.
            *** 2008-01-31 10:32:20.718
            Process m000 is dead (pid=7412, state=3):
            Unable to schedule a MMON slave at: Auto Flush Main 1
            Attempt to create slave process failed.
            Can happen for several reasons:
            - No process state objects
            - Reached OS set limits
            - A shutdown was going on
            Check alert log for more details.
            *** 2008-01-31 10:33:24.718
            Process m000 is dead (pid=7584, state=3):
            Unable to schedule a MMON slave at: Auto Flush Main 1
            Attempt to create slave process failed.
            Can happen for several reasons:
            - No process state objects
            - Reached OS set limits
            - A shutdown was going on
            Check alert log for more details.
            *** 2008-01-31 10:34:25.890
            Process m000 is dead (pid=7944, state=3):
            Unable to schedule a MMON slave at: Auto Flush Main 1
            Attempt to create slave process failed.
            Can happen for several reasons:
            - No process state objects
            - Reached OS set limits
            - A shutdown was going on
            Check alert log for more details.