ORA-01041: on Windows with Auxiliary Instance
566761Aug 16 2007 — edited Aug 16 2007Hi
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
Message was edited by:
coskan