| unable to startup oracle instance [message #277406] |
Mon, 29 October 2007 23:56  |
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 #277420 is a reply to message #277415] |
Tue, 30 October 2007 00:58  |
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 |
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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
