ORA-01041: on Windows with Auxiliary Instance

From: A. Coskan Gundogar <gundogar_at_gmail.com>
Date: Thu, 16 Aug 2007 11:01:05 +0300
Message-ID: <d1f742de0708160101w391c86a6t44dd0d2743b4edd7@mail.gmail.com>

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

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_at_DABAKAUX

Recovery Manager: Release 10.2.0.3.0 - Production on Per Au 16 10:19:14 2007

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 16 2007 - 03:01:05 CDT