장마가 지나가지 불볕더위가 계속되네요
모두 건강조심하시구요
제목 그대로 Windows 2008 R2(64비트)에 10g 설치하는 과정에서 데이터베이스 생성 작업에서 더이상 진행이 되지 않습니다.
OS : Windows 2008 Server R2 64비트
설치파일 : 10204_vista_w2k8_x64_production_db(오라클에서 다운로드)
<작업 진행 순서>
1. 시스템 날짜 변경(2009년으로)
2. 설치전 설정파일에 OS 버전 6.1 추가
3. 설치시 고급설치 옵션으로 진행
<결과>
1. 고급설치시 데이터베이스 생성 옵션으로 진행하면 데이터베이스 생성하는 과정에서 진행상태가 2%이상 진행되지 않음
2. 소프트웨어만 설치 하고 dbca 실행하여 데이터베이스 생성시 진행상태가 2%이상 진행되지 않음
결국은 데이터베이스가 생성되지 않습니다.
어떻게 해야 할까요
PS 아래는 trace.log 파일에서 생성된 에러가 발생한 부분의 로그입니다.
[TaskScheduler timer] [17:41:41:330] [Host.executeSteps:4044] Executing steps....
[TaskScheduler timer] [17:41:41:345] [Host.setUpForOperation:2920] setUpForOperation: Mode = 128
[TaskScheduler timer] [17:41:41:501] [Host.executeSteps:4186] setupForOperation returned: true
[TaskScheduler timer] [17:41:41:501] [Host.createStepSQLInterface:5948] sid =NAS
[TaskScheduler timer] [17:41:41:501] [SQLEngine.initialize:242] Execing SQLPLUS/SVRMGR process...
[TaskScheduler timer] [17:41:41:501] [SQLEngine.initialize:270] m_bReaderStarted: false
[TaskScheduler timer] [17:41:41:501] [SQLEngine.initialize:274] Starting Reader Thread...
[TaskScheduler timer] [17:41:41:501] [SQLEngine.initialize:323] Waiting for m_bReaderStarted to be true
[Thread-24] [17:41:41:595] [StepContext$ModeRunner.run:2478] ---- Progress Needed:=true
[Thread-24] [17:41:41:626] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
[Thread-24] [17:41:41:626] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
[Thread-24] [17:41:41:626] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
[Thread-24] [17:41:41:626] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
[Thread-24] [17:41:41:626] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
[Thread-24] [17:41:41:626] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
[Thread-24] [17:41:41:626] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-24] [17:41:41:626] [BasicStep.execute:202] Executing Step : INSTANCE_CREATION
[Thread-24] [17:41:41:626] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-24] [17:41:41:626] [InitParamAttributes.sortParams:3532] m_sortOn:-1 sortOn:4
[Thread-24] [17:41:41:844] [OracleHome.isRacEnabled:149] bRacOn = false
[Thread-24] [17:41:41:844] [Host.noEntryinOratab:5115] Check made for oratab arg passed............
[Thread-24] [17:41:41:844] [Oradim.getAddEntryCommand:353] AddEntry=[D:\oracle\product\10.2.0\db_1\bin\oradim.exe, -new, -sid, NAS, -startmode, manual, -spfile]
[Thread-24] [17:41:42:531] [Oradim.getEditEntryCommand:422] getEditEntry cmd=[D:\oracle\product\10.2.0\db_1\bin\oradim.exe, -edit, -sid, NAS, -startmode, auto, -srvcstart, system]
[Thread-24] [17:41:42:593] [Oradim.addSidToRegistry:871] oracleHomeKey: SOFTWARE\ORACLE\KEY_OraDb10g_home1
[Thread-24] [17:41:42:656] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@7cb3b6a6
[Thread-24] [17:41:42:656] [CloneRmanRestoreStep.executeImpl:217] Instance Creation went fine..........
[Thread-24] [17:41:42:656] [CloneRmanRestoreStep.executeImpl:224] db_recovery_file_dest=null
[Thread-24] [17:41:42:656] [CloneRmanRestoreStep.executeImpl:227] db_recovery_file_dest_size=null
[Thread-24] [17:41:43:529] [SQLEngine.setSpool:1750] old Spool = null
[Thread-24] [17:41:43:529] [SQLEngine.setSpool:1751] Setting Spool = D:\oracle\product\10.2.0\db_1\cfgtoollogs\dbca\NAS\CloneRmanRestore.log
[Thread-24] [17:41:43:529] [SQLEngine.setSpool:1752] Is spool appendable? --> true
[Thread-24] [17:41:43:529] [CloneRmanRestoreStep.executeImpl:320] starting with pfile=D:\oracle\product\10.2.0\admin\NAS\pfile\init.ora |