1 Reply Latest reply: May 18, 2009 8:06 PM by dbanoob4ever RSS

    ORA-24324: service handle not initialized ORA-01041: internal error. hostde

    dbanoob4ever
      here's the information

      OS centos 5.3
      product 10g2
      I did not start the listener initially.
      database is in archive mode
      controfile autobackup is on
      situation

      before the error happen this is what rman backup I did if I did not remember wrongly
      rman>backup validate as copy database plus archivelog;
      I was performing a restore operation on datafile 8. Next I perform a recovery.

      Here's what I did if I did not remember wrongly
      rman> restore datafile 8 until scn 6344;
      rman>recover datafile 8;
      However after I
      alter database datafile 8 online
      I realize I did not do a backup
      backup database;
      so I try to close the database

      alter database close;
      next I realize that there's other sessions open, so I attempt to close the other sessions. so I exit out of another sqlplus session as another user.
      select s.sid, s.osuser, s.serial#, p.addr, s.username
      from v$session s join v$process p
      on s.paddr  = p.addr;
      
      select 'alter system kill session ''' || s.sid || ',' || s.serial# || ''';'
      from v$session s join v$process p
      on s.paddr  = p.addr;
      but I can't kill them as they are idle session.

      so next I
      SQL> shutdown immediate                                                         
      ORA-24324: service handle not initialized
      ORA-01041: internal error. hostdef extension doesn't exist
      even
      SQL> shutdown abort                                                             
      ORA-24324: service handle not initialized
      ORA-01041: internal error. hostdef extension doesn't exist
      here's my log
      Errors in file /u01/app/oracle/admin/tomkyte/udump/tomkyte_ora_4028.trc:
      Tue May 19 07:18:24 2009
      Errors in file /u01/app/oracle/admin/tomkyte/udump/tomkyte_ora_4028.trc:
      Tue May 19 07:18:24 2009
      Errors in file /u01/app/oracle/admin/tomkyte/udump/tomkyte_ora_4028.trc:
      Control autobackup written to DISK device
              handle '/u01/app/oracle/flash_recovery_area/TOMKYTE/autobackup/2009_05_19/o1_mf_s_687251904_513v609d_.bkp'
      Completed: alter database datafile 8 online
      Tue May 19 07:19:19 2009
      alter database close
      Tue May 19 07:19:19 2009
      Stopping background process CJQ0
      Tue May 19 07:19:19 2009
      Stopping background process QMNC
      Tue May 19 07:19:19 2009
      but don't think above is the correct portion of log I should be looking after all it already stated
      Completed: alter database datafile 8 online
      it is the portion of the log that is after I did the complete recovery of datafile 8
      perhaps the below log could be more useful
      Tue May 19 07:19:19 2009
      alter database close
      Tue May 19 07:19:19 2009
      Stopping background process CJQ0
      Tue May 19 07:19:19 2009
      Stopping background process QMNC
      Tue May 19 07:19:19 2009
      SMON: disabling tx recovery
      Tue May 19 07:19:20 2009
      Stopping Job queue slave processes
      Tue May 19 07:19:28 2009
      Waiting for Job queue slaves to complete
      Tue May 19 07:19:58 2009
      Job queue slave processes stopped
      Active process 4260 user 'oracle' program 'oracle@localhost.localdomain (TNS V1-V3)'
      Active process 3901 user 'oracle' program 'oracle@localhost.localdomain (TNS V1-V3)'
      Active process 3899 user 'oracle' program 'oracle@localhost.localdomain (TNS V1-V3)'
      Active process 4257 user 'oracle' program 'oracle@localhost.localdomain (TNS V1-V3)'
      Active process 4261 user 'oracle' program 'oracle@localhost.localdomain (TNS V1-V3)'
      CLOSE: Active sessions prevent database close operation
      CLOSE: Error 1093 during database close
      Tue May 19 07:19:58 2009
      SMON: enabling tx recovery
      Tue May 19 07:19:58 2009
      Starting background process CJQ0
      Tue May 19 07:19:58 2009
      ORA-1093 signalled during: alter database close...
      Tue May 19 07:19:58 2009
      ksvcreate: Process(m000) creation failed
      Tue May 19 07:19:58 2009
      ksvcreate: Process(m000) creation failed
      Tue May 19 07:19:58 2009
      ksvcreate: Process(m000) creation failed
      CJQ0 started with pid=10, OS id=4280
      Tue May 19 07:20:15 2009
      alter database close
      Tue May 19 07:20:15 2009
      Stopping background process CJQ0
      Tue May 19 07:20:15 2009
      SMON: disabling tx recovery
      Tue May 19 07:20:48 2009
      alter database close
      Tue May 19 07:20:48 2009
      ORA-1154 signalled during: alter database close...
      Tue May 19 07:33:54 2009
      alter database close
      Tue May 19 07:39:48 2009
      MMNL absent for 1257 secs; Foregrounds taking over
      Tue May 19 07:43:54 2009
      Starting ORACLE instance (normal)
      Tue May 19 07:44:05 2009
      Starting background process EMN0
      Tue May 19 07:44:05 2009
      Shutting down instance: further logons disabled
      EMN0 started with pid=18, OS id=4945
      Tue May 19 07:44:05 2009
      Stopping background process MMNL
      Tue May 19 07:44:06 2009
      Stopping background process MMON
      Tue May 19 07:44:07 2009
      Shutting down instance (immediate)
      License high water mark = 10
      here's my bash_profile as oracle user
      # .bash_profile
      umask 022
      # Get the aliases and functions
      if [ -f ~/.bashrc ]; then
              . ~/.bashrc
      fi
      
      # User specific environment and startup programs
      ORACLE_BASE=/u01/app/oracle/;
      ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
      ORACLE_SID=tomkyte;
      LD_LIBRARY_PATH=$ORACLE_HOME/lib;
      PATH=$PATH:$ORACLE_HOME/bin;
      
      
      export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
      thanks a lot for the experts' help

      Edited by: oraclewannabe2 on May 19, 2009 8:32 AM

      Edited by: oraclewannabe2 on May 19, 2009 8:48 AM