Home » Infrastructure » Windows » unable to startup oracle instance
unable to startup oracle instance [message #277406] Mon, 29 October 2007 23:56 Go to next message
keithtai
Messages: 5
Registered: October 2007
Location: Kuala Lumpur
Junior Member
Hi, I'm unble to startup the instance. Got the following error.

SQL> startup;
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250452 bytes
Variable Size 142609260 bytes
Database Buffers 465567744 bytes
Redo Buffers 2940928 bytes
Database mounted.
ORA-03113: end-of-file on communication channel


When I try startup using pfile, I got this error.

SQL> startup pfile=E:\oracle\product\10.2.0\db_1\database\initicms.ora
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist


How do I start the instance? The following are the content of initicms.ora, listener.ora, sqlnet.ora, and tnsnames.ora.

initicsm.ora
SPFILE='E:\oracle\product\10.2.0\db_1/dbs/spfileicms.ora'

listener.ora
# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = ICMS)
)
(SID_DESC =
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = CATDB)
)
(SID_DESC =
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = CATDB)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = AAN-DBASE)(PORT = 1521))
)
)

TRACE_LEVEL_LISTENER = SUPPORT

sqlnet.ora
# sqlnet.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

tnsnames.ora
# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = AAN-DBASE)(PORT = 1521))
(CONNECT_DATA =
(SID = Oracle)
)
)

ICMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = AAN-DBASE)(PORT = 1521))
)
(CONNECT_DATA =
(SID = icms)
)
)

CATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = AAN-DBASE)(PORT = 1521))
)
(CONNECT_DATA =
(SID = catdb)
)
)

DPTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = AAN-DBASE)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DPTEST)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Re: unable to startup oracle instance [message #277415 is a reply to message #277406] Tue, 30 October 2007 00:18 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check alert.log.
How did you connect to the database? locally or remotely?

Also check trace file.

Regards
Michel

[Updated on: Tue, 30 October 2007 00:19]

Report message to a moderator

Re: unable to startup oracle instance [message #277420 is a reply to message #277415] Tue, 30 October 2007 00:58 Go to previous messageGo to next message
keithtai
Messages: 5
Registered: October 2007
Location: Kuala Lumpur
Junior Member
Hi Michel,

Thank you for your reply. I connect locally using remote desktop connection to server.

I'm still new in troubleshooting Oracle. Where can I find the alert.log and trace files? Thank you very much.

Regards,
Keith
Re: unable to startup oracle instance [message #277422 is a reply to message #277420] Tue, 30 October 2007 01:05 Go to previous messageGo to next message
keithtai
Messages: 5
Registered: October 2007
Location: Kuala Lumpur
Junior Member
I found a alert.log but the name is alert_icms.log. It's located in E:\oracle\product\10.2.0\admin\icms\bdump

The content contain error.
Tue Oct 30 12:42:32 2007
Errors in file e:\oracle\product\10.2.0\admin\icms\bdump\icms_lgwr_5124.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ICMS\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

LGWR: terminating instance due to error 313
Tue Oct 30 12:42:32 2007
Errors in file e:\oracle\product\10.2.0\admin\icms\bdump\icms_dbw0_4908.trc:
ORA-00313: open failed for members of log group of thread

Tue Oct 30 12:42:32 2007
Errors in file e:\oracle\product\10.2.0\admin\icms\bdump\icms_pmon_580.trc:
ORA-00313: open failed for members of log group of thread

Tue Oct 30 12:42:33 2007
Errors in file e:\oracle\product\10.2.0\admin\icms\bdump\icms_reco_3280.trc:
ORA-00313: open failed for members of log group of thread

Tue Oct 30 12:42:33 2007
Errors in file e:\oracle\product\10.2.0\admin\icms\bdump\icms_mman_2812.trc:
ORA-00313: open failed for members of log group of thread

Tue Oct 30 12:42:33 2007
Errors in file e:\oracle\product\10.2.0\admin\icms\bdump\icms_smon_5052.trc:
ORA-00313: open failed for members of log group of thread

Tue Oct 30 12:42:33 2007
Errors in file e:\oracle\product\10.2.0\admin\icms\bdump\icms_ckpt_5228.trc:
ORA-00313: open failed for members of log group of thread

Tue Oct 30 12:42:33 2007
Errors in file e:\oracle\product\10.2.0\admin\icms\bdump\icms_psp0_1020.trc:
ORA-00313: open failed for members of log group of thread

Instance terminated by LGWR, pid = 5124


Re: unable to startup oracle instance [message #277432 is a reply to message #277422] Tue, 30 October 2007 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems (at least) one redolog file is missing.
You have to make a recover.

Regards
Michel
Re: unable to startup oracle instance [message #277442 is a reply to message #277432] Tue, 30 October 2007 02:48 Go to previous messageGo to next message
keithtai
Messages: 5
Registered: October 2007
Location: Kuala Lumpur
Junior Member
Hello Michel,

Yup, Oracle support manage to provide me the technical doc to reset the logs. document ID:117481.1

SQL>startup mount;
SQL>recover database until cancel;
(cancel immediately)
SQL>alter database open resetlogs;

That seems to do the trick.

Thank you Michel Razz
Re: unable to startup oracle instance [message #277447 is a reply to message #277442] Tue, 30 October 2007 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For the future, I recommend the reading the excellent chapter 9 of Oracle9i User-Managed Backup and Recovery Guide: User-Managed Media Recovery Scenarios

Regards
Michel
Re: unable to startup oracle instance [message #277465 is a reply to message #277447] Tue, 30 October 2007 04:24 Go to previous message
keithtai
Messages: 5
Registered: October 2007
Location: Kuala Lumpur
Junior Member
Thanks Michel, it will come in handy Smile
Previous Topic: Oracle installation dba user and pwd
Next Topic: Error coming while installing
Goto Forum:
  


Current Time: Sat Aug 30 14:11:42 CDT 2014

Total time taken to generate the page: 0.08246 seconds