ORA-01041: on Windows with Auxiliary Instance
- From: "A. Coskan Gundogar" <gundogar@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Aug 2007 11:01:05 +0300
Hi
I'm trying to test TSPITR on 10.2.0.3 database on Windows XP with an
auxilary instance
I followed the document from page 8.20 but I got
ORA-01041: internal error. hostdef extension doesn't exist error when
starting up the auxilary instance
the details are below
*target instance=* DABAK
*auxiliary instance =*DABAKAUX
*sqlnet parameters =* SQLNET.AUTHENTICATION_SERVICES = (NTS)
*auxiliary instance parameters*
*.control_files='D:\ORACLE\ORADATA\DABAKAUX\CONTROL01.CTL','D:\ORACLE\ORADATA\DABAKAUX\CONTROL02.CTL','D:\ORACLE\ORADATA\DABAKAUX\CONTROL03.CTL'
*.core_dump_dest='D:\ORACLE\PRODUCT\10.2.0\ADMIN\DABAKAUX\CDUMP'
*.db_name='dabak'
*.db_unique_name='dabakaux'
*.remote_login_passwordfile='EXCLUSIVE'
*.db_block_size=8192
*.compatible='10.2.0.1.0'
*.log_file_name_convert='d:\oracle\oradata\DABAK','d:\oracle\oradata\DABAKAUX'
*.local_listener='LISTENER_DABAKAUX'
*.log_archive_format='ARC%S_%R.%T'
*.nls_language='TURKISH'
*.nls_length_semantics='BYTE'
*.nls_territory='TURKEY'
*.open_cursors=300
*.pga_aggregate_target=100663296
*.processes=150
*.recyclebin='ON'
*.resource_manager_plan=''
*.session_max_open_files=20
*.sga_target=268435456
*.undo_management='AUTO'
*.undo_retention=900
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\ORACLE\PRODUCT\10.2.0\ADMIN\DABAKAUX\UDUMP'
*.audit_file_dest='D:\ORACLE\PRODUCT\10.2.0\ADMIN\DABAKAUX\ADUMP'
*.background_dump_dest='D:\ORACLE\PRODUCT\10.2.0\ADMIN\DABAKAUX\BDUMP'
*when I try to login and startup the error log below occurs*
*D:\oracle\product\10.2.0\asm\database>set ORACLE_SID=DABAKAUX
D:\oracle\product\10.2.0\asm\database>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Per Au 16 10:14:55 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount
pfile='D:\oracle\product\10.2.0\asm\database\initDABAKAUX.ora';
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01041: internal error. hostdef extension doesn't exist*
*I tried to delete and recreate the service but nothing has changed what I
tried are below*
*
C:\Documents and Settings\cgundogar>oradim -DELETE -SID DABAKAUX
Instance deleted.
C:\Documents and Settings\cgundogar>oradim -NEW -SID DABAKAUX -SRVC
OracleServiceDABAKAUX -STARTMODE manual -PFILE D:\oracle\product\10.2.0\
asm\database\initDABAKAUX.ora -INTPWD manager
Instance created.*
*when I look at the alert log sometimes database seems started despite the
ORA-01041: error. but I cant connect through RMAN with the command below it
still gives ORA-01041*
*
C:\Documents and Settings\cgundogar>rman target / auxiliary
sysuser/manager@DABAKAUX
Recovery Manager: Release 10.2.0.3.0 - Production on Per Au 16 10:19:14
2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01041: internal error. hostdef extension doesn't exist*
*when I look at udump folder I saw the eror stack below*
*Windows thread id: 1708, image: ORACLE.EXE (SHAD)
opiino: Attach failed! error=-1 ifvp=00000000*
I tried the steps of metalink 252697.1 so it is not the case too.
How can I get rid of this error
Pages: 1
--
A. Coskan GUNDOGAR
Oracle DBA
http://coskan.wordpress.com
Other related posts:
