OraFAQ Forum: Server Administration » ORA-01041: internal error. hostdef extension doesn't exist

Home » RDBMS Server » Server Administration » ORA-01041: internal error. hostdef extension doesn't exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01041: internal error. hostdef extension doesn't exist [message #179386]

Tue, 27 June 2006 04:47

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179387 is a reply to message #179386]

Tue, 27 June 2006 04:55

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179392 is a reply to message #179387]

Tue, 27 June 2006 05:13

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179394 is a reply to message #179392]

Tue, 27 June 2006 05:15

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?

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179398 is a reply to message #179394]

Tue, 27 June 2006 05:24

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179402 is a reply to message #179398]

Tue, 27 June 2006 05:33

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).

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179406 is a reply to message #179402]

Tue, 27 June 2006 05:41

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179408 is a reply to message #179406]

Tue, 27 June 2006 05:44

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179410 is a reply to message #179408]

Tue, 27 June 2006 05:47

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179414 is a reply to message #179410]

Tue, 27 June 2006 05:52

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179418 is a reply to message #179414]

Tue, 27 June 2006 05:57

prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan

Member

Its okay. I have attached herewith alert.log

Attachment: mydbALRT.LOG
(Size: 64.78KB, Downloaded 2797 times)

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179423 is a reply to message #179418]

Tue, 27 June 2006 06:18

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179426 is a reply to message #179423]

Tue, 27 June 2006 06:21

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179428 is a reply to message #179426]

Tue, 27 June 2006 06:32

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179429 is a reply to message #179426]

Tue, 27 June 2006 06:33

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179430 is a reply to message #179428]

Tue, 27 June 2006 06:34

aciolac
Messages: 242
Registered: February 2006

Senior Member

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179431 is a reply to message #179430]

Tue, 27 June 2006 06:37

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 !!

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179567 is a reply to message #179428]

Wed, 28 June 2006 01:24

prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan

Member

No I can't connect even with non-sysdba user becuase db is not opened

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179589 is a reply to message #179431]

Wed, 28 June 2006 02:37

prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan

Member

Still same problem

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179655 is a reply to message #179589]

Wed, 28 June 2006 05:46

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179818 is a reply to message #179386]

Wed, 28 June 2006 22:27

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179878 is a reply to message #179818]

Thu, 29 June 2006 02:59

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179952 is a reply to message #179878]

Thu, 29 June 2006 06:43

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #179958 is a reply to message #179952]

Thu, 29 June 2006 07:19

prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan

Member

I m logging into windows xp as administrator

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #180029 is a reply to message #179386]

Thu, 29 June 2006 20:36

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #180077 is a reply to message #180029]

Fri, 30 June 2006 02:05

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 2372 times)

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #180128 is a reply to message #179386]

Fri, 30 June 2006 04:15

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.

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #181612 is a reply to message #180077]

Mon, 10 July 2006 16:54

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

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #300156 is a reply to message #181612]

Thu, 14 February 2008 07:56

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".

Report message to a moderator

Re: ORA-01041: internal error. hostdef extension doesn't exist [message #300158 is a reply to message #300156]

Thu, 14 February 2008 08:02

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Notice that the last response was in 2006. Locked.

Report message to a moderator

Previous Topic:	ora-00279
Next Topic:	Undo Tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 07:25:25 CST 2024