데이터베이스 질문과 답변
startup 할 때 "ORA-03113: 통신 채널에 EOF 가 있습니다" 에러가 납니다.
0
3
11,597
by 손님 [Oracle 에러코드] ORA-03113 [2011.11.04 18:30:32]
안녕하세요? 오라클 초보 입니다.
윈도우 서버 2003에 오라클 10.2 사용 중 입니다.
서버를 리부팅 하고 나서 오라클 실행이 안 됩니다. ㅜ.ㅜ
도와주세요. 로그는 아래쪽에 있습니다.
-- sqlplus 실행 시 --
SQL*Plus: Release 10.2.0.1.0 - Production on 금 11월 4 18:15:02 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
휴지 인스턴스에 접속되었습니다.
SQL> startup
ORACLE 인스턴스가 시작되었습니다.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 88083332 bytes
Database Buffers 515899392 bytes
Redo Buffers 7135232 bytes
데이터베이스가 마운트되었습니다.
ORA-03113: 통신 채널에 EOF 가 있습니다
SQL> startup
ORA-24324: 서비스 처리가 초기화되지 않았습니다
ORA-01041: 내부오류. hostdef 확장이 존재하지 않습니다
SQL> shutdown immediate
ORA-24324: 서비스 처리가 초기화되지 않았습니다
ORA-01041: 내부오류. hostdef 확장이 존재하지 않습니다
-- alert_orcl.log 내용 --
Fri Nov 04 18:15:19 2011
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_1304.trc:
ORA-00470: LGWR process terminated with error
-- orcl_psp0_1304.trc 파일 내용 --
Dump file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_1304.trc
Fri Nov 04 18:15:19 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1501M/2045M, Ph+PgF:3038M/3944M, VA:1339M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 3
Windows thread id: 1304, image: ORACLE.EXE (PSP0)
*** SERVICE NAME:() 2011-11-04 18:15:19.843
*** SESSION ID:(169.1) 2011-11-04 18:15:19.843
error 470 detected in background process
ORA-00470: LGWR process terminated with error
by ,
[2011.11.07 14:32:45]
메타링크에 이런 내용이 있네요... 참고하세요.
ID 1168554.1
****
Database shutdown or startup fails with the following errors.
SQL> shutdown abort;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup mount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
****
1. Exit current SQL*Plus session and verify the following environment variables are set.
echo $ORACLE_HOME
echo $ORACLE_SID (echo %ORACLE_SID% on Windows)
2. Execute the following.
sqlplus / as sysdba
shutdown abort
exit
sqlplus / as sysdba
startup
References
ID 1168554.1
****
Database shutdown or startup fails with the following errors.
SQL> shutdown abort;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup mount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
****
1. Exit current SQL*Plus session and verify the following environment variables are set.
echo $ORACLE_HOME
echo $ORACLE_SID (echo %ORACLE_SID% on Windows)
2. Execute the following.
sqlplus / as sysdba
shutdown abort
exit
sqlplus / as sysdba
startup
References
by 타락천사
[2011.11.07 14:49:43]
요런 케이스도 있네요
혹 oracle 기동 유저가 domain 유저면 아래 참고 하세요
Symptoms
After some system changes, e.g. replacing the motherboard, in the server, trying to connect or startup the database fails.
The service is running, but you are unable to connect as sysdba using a domain account:
SQL> connect / as sysdba
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01041: internal error. hostdef extension doesn't exist
A domain administrator account is used to connect. If the local system account is used, the connection as sysdba works fine.
Cause
The system time was set incorrectly.
The local system time did not match the time on the domain server causing the authentication to fail.
Solution
-- To implement the solution, please execute the following steps:
1. Set the local system time correctly.
2. Reboot the server.
3. Verify that the database starts and that sysdba connections can be made.
혹 oracle 기동 유저가 domain 유저면 아래 참고 하세요
Symptoms
After some system changes, e.g. replacing the motherboard, in the server, trying to connect or startup the database fails.
The service is running, but you are unable to connect as sysdba using a domain account:
SQL> connect / as sysdba
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01041: internal error. hostdef extension doesn't exist
A domain administrator account is used to connect. If the local system account is used, the connection as sysdba works fine.
Cause
The system time was set incorrectly.
The local system time did not match the time on the domain server causing the authentication to fail.
Solution
-- To implement the solution, please execute the following steps:
1. Set the local system time correctly.
2. Reboot the server.
3. Verify that the database starts and that sysdba connections can be made.
by 손님
[2011.11.08 09:52:53]
sid, home 환경변수 문제가 있었습니다.
근데 또 다른 에러가 생기네요. ㅜ.ㅜ
아무튼 답변 감사합니다.
근데 또 다른 에러가 생기네요. ㅜ.ㅜ
아무튼 답변 감사합니다.
) 버튼을 클릭하여 작성 하시면 됩니다.