Home » RDBMS Server » Server Administration » ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist (10gr2, centos 5.3)
ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist [message #403805] Mon, 18 May 2009 19:54 Go to next message
kytemanaic
Messages: 55
Registered: February 2009
Member
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

[Updated on: Mon, 18 May 2009 20:04]

Report message to a moderator

Re: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't e [message #403806 is a reply to message #403805] Mon, 18 May 2009 20:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Ready, Fire, Aim!
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
Both are likely because this is not being done as user oracle or env is lacking
CUT & PASTE the following


env | sort

Report message to a moderator

Re: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't e [message #403807 is a reply to message #403805] Mon, 18 May 2009 20:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://forums.oracle.com/forums/thread.jspa?threadID=901635&tstart=0

Pick 1 forum or the other for assistance.

Report message to a moderator

Re: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't e [message #403808 is a reply to message #403805] Mon, 18 May 2009 20:07 Go to previous messageGo to next message
kytemanaic
Messages: 55
Registered: February 2009
Member
 
[oracle@localhost ~]$ env | sort
COLORTERM=gnome-terminal
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-ezTEG8bLz0,guid=28e9d30679d6d33c21eb4b004a11e379
DESKTOP_SESSION=default
DESKTOP_STARTUP_ID=
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=Default
GNOME_KEYRING_SOCKET=/tmp/keyring-vBbtDl/socket
GTK_IM_MODULE=scim-bridge
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=localhost.localdomain
INPUTRC=/etc/inputrc
JAVA_HOME=/usr/java/jdk1.6.0_13/jre/bin/
JAVA_PATH=/usr/java/jdk1.6.0_13/jre/bin/
KDEDIR=/usr
KDE_IS_PRELINKED=1
KDE_NO_IPV6=1
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/u01/app/oracle//product/10.2.0/db_1/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/u01/app/oracle/
ORACLE_HOME=/u01/app/oracle//product/10.2.0/db_1
ORACLE_SID=tomkyte
PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/java/jdk1.6.0_13/jre/bin/:/u01/app/oracle//product/10.2.0/db_1/bin:/usr/java/jdk1.6.0_13/jre/bin/
PWD=/home/oracle
QT_IM_MODULE=scim
SESSION_MANAGER=local/localhost.localdomain:/tmp/.ICE-unix/3505
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=3540
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-erjjGx3505/agent.3505
TERM=xterm
USERNAME=oracle
USER=oracle
_=/usr/bin/env
WINDOWID=50474299
XAUTHORITY=/tmp/.gdm0GAJUU
XMODIFIERS=@im=SCIM
[oracle@localhost ~]$

Report message to a moderator

Re: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't e [message #403809 is a reply to message #403805] Mon, 18 May 2009 20:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Cool that process looks OK.
From that process type CUT & paste from below & execute exactly

sqlplus
/ as sysdba
shutdown abort
startup
select * from v$version;
exit


Post results from above back here.

Report message to a moderator

Re: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't e [message #403810 is a reply to message #403805] Mon, 18 May 2009 20:50 Go to previous messageGo to next message
kytemanaic
Messages: 55
Registered: February 2009
Member
 
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 19 09:23:54 2009

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  922746880 bytes
Fixed Size                  1222624 bytes
Variable Size             322963488 bytes
Database Buffers          591396864 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


I restart the machine before I reply.

i think should be alright now....I dun know what exactly happen.....thanks

Report message to a moderator

Re: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't e [message #403811 is a reply to message #403810] Mon, 18 May 2009 20:53 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Check your SQLNET.ORA

Thanks

Report message to a moderator

Re: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't e [message #403814 is a reply to message #403805] Mon, 18 May 2009 22:34 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>next I realize that there's other sessions open, so I attempt to close the other sessions.

ALTER SYSTEM KILL SESSION -- will tag the sessions as "killed", but they remain inside Oracle until the corresponding Unix process gets terminated at OS level.

kill -9 <pid> # just be sure to hit the correct process.

Report message to a moderator

Previous Topic: Memory allocation between OS and Oracle
Next Topic: dbwr
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 22:00:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.