Home » RDBMS Server » Server Administration » ORA-01041: internal error. hostdef extension doesn't exist
icon8.gif  ORA-01041: internal error. hostdef extension doesn't exist [message #179386] Tue, 27 June 2006 04:47 Go to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
Whenever I connect with sys/pwd as sysdba or conn / as sysdba, I recieve a msg ORA-01041: internal error. hostdef extension doesn't exist. May anyone help me regarding the said problem. Pleeeeeeeeez
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179387 is a reply to message #179386] Tue, 27 June 2006 04:55 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Your database are in shutdowm progress. Stop them first, and start. If you in Oracle 8i, then connect by internal and execute shutdown abort. If you are in 9i and upper,
>sqlplus /nolog
SQL>connect as sysdba
.....
SQL>shutdown abort
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179392 is a reply to message #179387] Tue, 27 June 2006 05:13 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
But I m having problem even when connect. Then how can I shutdown the database.


waiting for response
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179394 is a reply to message #179392] Tue, 27 June 2006 05:15 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Are you tried to make what I am write here? Did you set correc SID before connect by sqlplus?
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179398 is a reply to message #179394] Tue, 27 June 2006 05:24 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
Yes I got ur previous reply and I m using the correct sid i-e mydb and even create new sid mydb1 and change the previous mydb sid into new sid mydb1 thru regedit.


thnx
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179402 is a reply to message #179398] Tue, 27 June 2006 05:33 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
No, it can be incorrect. Make the next from command line:
Z:\>set ORACLE_SID=MYDB
-- to verify that your SID is set correct
Z:\>echo %ORACLE_SID%
MYDB

Z:>sqlplus /nolog
SQL> connect as sysdba
............
SQL> shutdown abort

If you also give the error, restart the instance service from Service Manager(As i understand, you have Win installed).
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179406 is a reply to message #179402] Tue, 27 June 2006 05:41 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
I have set and checked sid as u wrote but still the same problem the I restarted the service mydb but still same problem.


waiting 4 reply.
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179408 is a reply to message #179406] Tue, 27 June 2006 05:44 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Paste here last !200 rows from init.ora . As I see, will be necessary to restart your host.
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179410 is a reply to message #179408] Tue, 27 June 2006 05:47 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
I m using Windows XP and made database in learning environment so that there is small init.ora file. However the init.ora code is copies as follow:
##############################################################################
# Copyright (c) 1991, 2001 by Oracle Corporation
##############################################################################

###########################################
# Archive
###########################################
#log_archive_min_succeed_dest=5
log_archive_dest_1="location=D:\mydb\archive"
log_archive_dest_2="service=mydb.hyd.customs.gov.pk"
log_archive_format=%t_%s.dbf
log_archive_start=true

###########################################
# Cache and I/O
###########################################
db_block_size=4096
db_cache_size=33554432

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=D:\mydb\bdump
core_dump_dest=D:\mydb\cdump
timed_statistics=TRUE
user_dump_dest=D:\mydb\udump

###########################################
# Distributed, Replication and Snapshot
###########################################
db_domain=""
remote_login_passwordfile=shared

###########################################
# File Configuration
###########################################
control_files=("D:\mydb\CONTROL01.CTL", "D:\mydb\CONTROL02.CTL", "D:\mydb\CONTROL03.CTL")

###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"

###########################################
# Miscellaneous
###########################################
compatible=9.0.0
db_name=mydb

###########################################
# Network Registration
###########################################
instance_name=mydb

###########################################
# Pools
###########################################
java_pool_size=33554432
large_pool_size=1048576
shared_pool_size=33554432

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
sort_area_size=524288

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS

#REMOTE_OS_AUTHENT=TRUE
#checkpoints_to_alert=true
#sql_trace=true
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179414 is a reply to message #179410] Tue, 27 June 2006 05:52 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Sorry, I want to see alert.log Smile I am mitaked when are queried init.ora Smile
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179418 is a reply to message #179414] Tue, 27 June 2006 05:57 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
Its okay. I have attached herewith alert.log
  • Attachment: mydbALRT.LOG
    (Size: 64.78KB, Downloaded 1364 times)
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179423 is a reply to message #179418] Tue, 27 June 2006 06:18 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
From you alert.log, I can see that when you stops your server, database are not shutting down. This is not good. Also You have problem with host mydb.hyd.customs.gov.pk - possible he doesn't response to your database calls. Because of this problem, ARCH process cannot stop corectly and database cannot stop. Under WinXP exist utility which are called some like Oracle NT Instance configuration. From this utility You can stop explicitly your database(you must to see at the end of alert.log ARC0: 'Archival stopped'). Aftre stopping, resolve problem with

ARC0: Error 12154 connecting to standby host 'mydb.hyd.customs.gov.pk'

or comment corresponding row in the alert.log.
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179426 is a reply to message #179423] Tue, 27 June 2006 06:21 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
Actually the power was got off so that db shutdown abnormally. Now please help me and tell stepwise method that how can the problem be fixed.


Waiting
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179428 is a reply to message #179426] Tue, 27 June 2006 06:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Can you connect as a non-SYSDBA user without getting the error?

If so, you may want to recreate your password file with the ORAPWD utility.
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179429 is a reply to message #179426] Tue, 27 June 2006 06:33 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
1)for excluding appearence of error, resolve situation with conexion between your host and mydb.hyd.customs.gov.pk, or comment the row log_archive_dest_2="service=mydb.hyd.customs.gov.pk" from your init.ora.
2)Is necessary to restart your database. It is possible to try to connect to database as I already write(I think that you are already tried, but will be good to try yet once an to paste log of execution here), or to go to service manager, and stop service, that responds for work of your instance mydb(also possible to try to use Oracle NT Instance configuration).

P.S. stopping of host without shutdown of database are from 5 june.
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179430 is a reply to message #179428] Tue, 27 June 2006 06:34 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
During of shutdown of startup of database is possibe to connect ONLY with SYSDBA option.
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179431 is a reply to message #179430] Tue, 27 June 2006 06:37 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
aciolac wrote on Tue, 27 June 2006 06:34

During of shutdown of startup of database is possibe to connect ONLY with SYSDBA option.

Not really sure what that has to do with the price of rice. I was simply asking whether he could make a NON-SYSDBA connection. NO mention of startup or shutdown anywhere in my response !!
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179567 is a reply to message #179428] Wed, 28 June 2006 01:24 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
No I can't connect even with non-sysdba user becuase db is not opened
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179589 is a reply to message #179431] Wed, 28 June 2006 02:37 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
Still same problem
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179655 is a reply to message #179589] Wed, 28 June 2006 05:46 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This is windoze after all. Have you tried rebooting your system? Prior to rebooting your system, modify the Windows database service to start manually. From the command prompt:

oradim -edit -sid mydb -startmode m

Once the system is rebooted, go to a command prompt and ensure the Oracle Home and Oracle SID are set correctly and start the Windows service associated with the database:

oradim -startup -sid mydb -starttype srvc

Then try to make a connection to the database.

sqlplus /nolog

SQL> conn / as sysdba


IF this works, you can try to start the database.

If you still can't connect after rebooting your system, you may want to try and delete the Oracle service (using ORADIM) associated with this database, reboot your system and recreate the Windows Oracle service with ORADIM.

If you still encounter the problem, since this is a test system, you may want to uninstall oracle and reinstall.

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179818 is a reply to message #179386] Wed, 28 June 2006 22:27 Go to previous messageGo to next message
raja_rajendran
Messages: 3
Registered: June 2006
Location: Malaysia
Junior Member

Hi,
I also had the same problem with my Windows 2000 server when installed Oracle 9i server.

During the o/s installation process, I mentioned the system as the 'domain' wrongly.
So, I encountered the problem.

I reinstalled the o/s and during the o/s installation, it asked whether the system is 'domain' or 'workgroup', I select 'workgroup' from the option.


Then, I went for Oracle installation, right frm the begining and it is fine now.

Try this,

all the best.
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179878 is a reply to message #179818] Thu, 29 June 2006 02:59 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
thnx for reply
When I connect my netwrok with workgroup my database works properly but when connet to domain still same problem
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179952 is a reply to message #179878] Thu, 29 June 2006 06:43 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you logging into the box as a domain user or local user? Is the oracle process configured to run as a local user or domain user? Seems to be a cross between one of the above.
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179958 is a reply to message #179952] Thu, 29 June 2006 07:19 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
I m logging into windows xp as administrator
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #180029 is a reply to message #179386] Thu, 29 June 2006 20:36 Go to previous messageGo to next message
raja_rajendran
Messages: 3
Registered: June 2006
Location: Malaysia
Junior Member

Hi,

Frm Control panel choose the system.
Ans look into it's properties.

In the 'Network identification' tab,

you'll have

full computer name : XXXXXX
Workgroup : Workgroup.

During the O/s installation, if you have selected it as DOMAIN
here you'll see as

workgroup : Domain

In this case, if it is domain, then you'll have the 'hostdef extension doesn't exist' problem.

Because, in your 'tnasnames.ora', you will have the server or hostname, same as the full computer name.

ie, the computer name "xxxxx" will be found in the tnsnames.ora file as hostname.

Now, if your computer was installed as workgroup, then it will recognise your system and it won't give any problem.

But, if it was installed as Domain, then you'll have the 'hostdef' problem.

So, if you can, install the o/s again and during the o/s installation choose 'workgroup' and please don't choose 'domain'.

When I encounterd the same problem 'hostdef extension dosen't exist' in my windows server, I reinstalled the o/s and Oracle as mentioned above and the Oracle db is fine now.

If possible, do resinstall the o/s and oracle.

all the best.

Raja
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #180077 is a reply to message #180029] Fri, 30 June 2006 02:05 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
Hi Raja
Thnx for spare time 4 me. My computer name is Zaheer and doamin name is hyd.customs.gov.pk. I have attached herewwith the tnsname.ora file for ur consideartion.
  • Attachment: TNSNAMES.ORA
    (Size: 2.95KB, Downloaded 930 times)
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #180128 is a reply to message #179386] Fri, 30 June 2006 04:15 Go to previous messageGo to next message
raja_rajendran
Messages: 3
Registered: June 2006
Location: Malaysia
Junior Member

(ADDRESS
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=tcp)
(HOST=zaheer.customs.gov.pk)
(PORT=<portnumber (1521 is a standard port used)>)

Hi,
As we discussed,
if your computer name and the hostname are same, then there won't be problem.

here your computer name is zaheer.
but in your tnsnames.ora, it is with the domain name(zaheer.customs.gov.pk).
so, changes are there for conflict and error msg will appear.

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #181612 is a reply to message #180077] Mon, 10 July 2006 16:54 Go to previous messageGo to next message
indbluechip
Messages: 2
Registered: July 2006
Location: texas
Junior Member
hi zaheer,
Try to check tnsnames.ora and listener.ora. see if u'r listner has started.If its in windows see in services.if unix or linux see in dbs directory.and check lsnrctl start in linux.see if windows try to see the service with u'r sid has been started or not.these are the main things to check
Re: ORA-01041: internal error. hostdef extension doesn't exist [message #300156 is a reply to message #181612] Thu, 14 February 2008 07:56 Go to previous messageGo to next message
funky
Messages: 4
Registered: December 2007
Location: Zagreb
Junior Member
You have classic problem with firewall.

Note 208433.1 seems to indicate that Intel-Linux does not support OOB.

The "disable_oob" is set in the sqlnet.ora on the client. It does not need a database instance restart. The client specifies to the server when it connects whether it will be using "in-band" or "out-of-band".


Re: ORA-01041: internal error. hostdef extension doesn't exist [message #300158 is a reply to message #300156] Thu, 14 February 2008 08:02 Go to previous message
joy_division
Messages: 4489
Registered: February 2005
Location: East Coast USA
Senior Member
Notice that the last response was in 2006. Locked.
Previous Topic: ora-00279
Next Topic: Undo Tablespace
Goto Forum:
  


Current Time: Tue Jul 29 03:49:57 CDT 2014

Total time taken to generate the page: 0.13866 seconds