ORA-03113_endof_file_in_communication

Microsoft Windows 2000 [Version 5.00.2195]

(C) Copyright 1985-2000 Microsoft Corp.

C:\Documents and Settings\SADMIN>set ORACLE_SID=siebeldb

C:\Documents and Settings\SADMIN>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 15 06:46:44 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to an idle instance.

SQL> startup

ORA-03113: end-of-file on communication channel

SQL> startup pfile='D:\ora10\dbs\initSIEBELDB.ora'

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

SQL> exit

Disconnected

IT happened because of background process not being started because in initSIEBELDB.ora file the path fore udump,adump,cdump mismatched .

So changed in that file and started database with this file.

C:\Documents and Settings\SADMIN>echo %ORACLE_HOME%

D:\ora10

C:\Documents and Settings\SADMIN>echo %PATH%

d:\ora10\BIN;D:\ora10\NETWORK\tools;D:\ora10\jre\1.4.2\bin\client;D:\ora10\jre\1

.4.2\bin;D:\ora10\NETWORK\ADMIN;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbe

m;C:\Program Files\Executive Software\DiskeeperLite\

C:\Documents and Settings\SADMIN>set ORACLE_SID=siebeldb

C:\Documents and Settings\SADMIN>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 15 06:49:05 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to an idle instance.

SQL> startup pfile='D:\ora10\database\initSIEBELDB.ora'

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size                  1253096 bytes

Variable Size             264241432 bytes

Database Buffers          805306368 bytes

Redo Buffers                2940928 bytes

Database mounted.

Database opened.

SQL> create spfile='D:\ora10\database\SPFILESIEBELDB.ora' from pfile='D:\ora10\database\in

itSIEBELDB.ora'

  2  ;

File created.

SQL> startup

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size                  1253096 bytes

Variable Size             264241432 bytes

Database Buffers          805306368 bytes

Redo Buffers                2940928 bytes

Database mounted.

Database opened.

SQL>