데이터베이스 질문과 답변
안녕하세요 오라클 설치시 오류문의드려요 ㅠ
서버는 window2012 64bit 램은 8GB구요
오라클은 11g r2 64bit 설치하였습니다.
database configuration assistant 중에 2% 진행에서 시스템 메모리만 올라가고
마지막엔 out if memory 에러를 띄웁니다.
관련 로그는 아래랑 같아요 ㅠ 조언 부탁드려요!
[main] [ 2015-12-14 16:45:31.556 KST ] [InventoryUtil.getOracleBase:147] Getting ORACLE_BASE from inventory. [main] [ 2015-12-14 16:45:31.572 KST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS [main] [ 2015-12-14 16:45:31.572 KST ] [InventoryUtil.getOracleBase:162] Inventory Home Size = 1 [main] [ 2015-12-14 16:45:31.572 KST ] [InventoryUtil.getOracleBase:187] ORACLE_BASE returned from inventory:= C:\app\Administrator [main] [ 2015-12-14 16:45:31.572 KST ] [Host.displayOracleBaseWarning:1206] oracleBaseFromEnv null [main] [ 2015-12-14 16:45:31.572 KST ] [Host.displayOracleBaseWarning:1212] oracle_base from OUI C:\app\Administrator oracle_base from envC:\app\Administrator [main] [ 2015-12-14 16:45:31.572 KST ] [Host.checkOPS:2522] Inside checkOPS [main] [ 2015-12-14 16:45:31.572 KST ] [Host.checkOPS:2534] Trying to check cluster existence [main] [ 2015-12-14 16:45:31.572 KST ] [Version.isPre:304] version to be checked 11.2.0.1.0 major version to check against10 [main] [ 2015-12-14 16:45:31.572 KST ] [Version.isPre:315] isPre.java: Returning FALSE [main] [ 2015-12-14 16:45:31.572 KST ] [OCR.loadLibrary:308] Inside constructor of OCR [main] [ 2015-12-14 16:45:31.572 KST ] [OCR.isCluster:939] Calling OCRNative for isCluster() [main] [ 2015-12-14 16:45:31.572 KST ] [OCR.isCluster:943] OCR Result status = true [main] [ 2015-12-14 16:45:31.572 KST ] [OCR.isCluster:955] Bolean result = false [main] [ 2015-12-14 16:45:31.572 KST ] [Host.checkOPS:2540] cluster existence:false [main] [ 2015-12-14 16:45:31.572 KST ] [Host.checkOPS:2581] Cluster installed=false [main] [ 2015-12-14 16:45:31.588 KST ] [InitParamHandler.endElement:524] CustomSGA flag: false [main] [ 2015-12-14 16:45:31.588 KST ] [InitParamHandler.endElement:525] Database Type: MULTIPURPOSE [main] [ 2015-12-14 16:45:31.588 KST ] [InitParamHandler.endElement:526] Mem Percentage: 40 [main] [ 2015-12-14 16:45:31.588 KST ] [OsUtilsBase.getTotalPhysicalMemory:375] Total Physical Memory in MB: 8063 [main] [ 2015-12-14 16:45:31.588 KST ] [OsUtilsBase.is64Bit:359] architecture is 64 bit: true [main] [ 2015-12-14 16:45:31.588 KST ] [InitParamHandler.endElement:559] Total memory MB: 3226 [main] [ 2015-12-14 16:45:31.588 KST ] [OsUtilsBase.is64Bit:359] architecture is 64 bit: true [main] [ 2015-12-14 16:45:31.588 KST ] [MemoryCalculator.<clinit>:95] setting memory minimums for 64 bit [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:240] IN threadID:1 group#=1 [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:240] IN threadID:1 group#=2 [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:249] Current threadID=1 [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:256] Current threadID=1 ==> redoGroups[0]=1 [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:266] vRedoGroups:[1] [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:296] setAttribute: bExists=false [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:240] IN threadID:1 group#=3 [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:249] Current threadID=1 [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:256] Current threadID=1 ==> redoGroups[0]=1 [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:256] Current threadID=1 ==> redoGroups[1]=2 [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:266] vRedoGroups:[1, 2] [main] [ 2015-12-14 16:45:31.588 KST ] [StorageAttributes.setAttribute:296] setAttribute: bExists=false [main] [ 2015-12-14 16:45:31.588 KST ] [Verifier.getDatabaseSize:3143] Clone Datafile: SYSTEM01.DBF size: 680 [main] [ 2015-12-14 16:45:31.588 KST ] [Verifier.getDatabaseSize:3143] Clone Datafile: SYSAUX01.DBF size: 440 [main] [ 2015-12-14 16:45:31.588 KST ] [Verifier.getDatabaseSize:3143] Clone Datafile: UNDOTBS01.DBF size: 25 [main] [ 2015-12-14 16:45:31.588 KST ] [Verifier.getDatabaseSize:3143] Clone Datafile: USERS01.DBF size: 5 [main] [ 2015-12-14 16:45:31.588 KST ] [Verifier.getControlfFileSizes:3510] No. of Control files:=2 [main] [ 2015-12-14 16:45:31.588 KST ] [Verifier.getDatabaseSize:3204] dbSize: 1177600 redoLogSize: 153600 ctrlFileSize: 4096 [main] [ 2015-12-14 16:45:31.588 KST ] [TemplateManager.getParsedAttributes:1828] Setting DB_RECOVERY_FILE_SIZE to default size: 3912 [main] [ 2015-12-14 16:45:31.588 KST ] [TemplateManager.parseCloneTemplate:1518] See for any transportable datafiles in TemplateManager..... [main] [ 2015-12-14 16:45:31.588 KST ] [TemplateManager.isInstallTemplate:2300] Selected Template by user:=General Purpose [main] [ 2015-12-14 16:45:31.588 KST ] [TemplateManager.isInstallTemplate:2307] The Message Id to be searched:=GENERAL_PURPOSE [main] [ 2015-12-14 16:45:31.588 KST ] [TemplateManager.parseCloneTemplate:1530] create new clone data file for tp file....... [main] [ 2015-12-14 16:45:31.588 KST ] [Host.setupOIDCommandlineParameters:8452] setupOIDCommandlineParameters: [main] [ 2015-12-14 16:45:31.603 KST ] [Host.setupOIDCommandlineParameters:8453] m_regWithdirService: false [main] [ 2015-12-14 16:45:31.603 KST ] [Host.setupOIDCommandlineParameters:8454] m_unregWithdirService: false [main] [ 2015-12-14 16:45:31.603 KST ] [Host.setupOIDCommandlineParameters:8455] m_updateDirService: false [main] [ 2015-12-14 16:45:31.603 KST ] [HAUtils.getHASHome:631] Oracle home from system properties: C:\app\Administrator\product\11.2.0\dbhome_1 [main] [ 2015-12-14 16:45:31.603 KST ] [HAUtils.getCRSHome:588] Getting configured CRS/HAS home for Oracle home ( C:\app\Administrator\product\11.2.0\dbhome_1 ) ... [main] [ 2015-12-14 16:45:31.603 KST ] [GETCRSHOMEUtil.<init>:88] Toolname: getcrshome.exe --- Tool location: C:\app\Administrator\product\11.2.0\dbhome_1\binTool dependencies: [Ljava.lang.String;@39385660 [main] [ 2015-12-14 16:45:31.603 KST ] [CmdToolUtil.doexecute:360] starting remote exec server on local node src=C:\app\Administrator\product\11.2.0\dbhome_1\bin dest=C:\Users\ADMINI~1\AppData\Local\Temp\1\ [main] [ 2015-12-14 16:45:31.603 KST ] [Utils.getLocalHost:356] Hostname retrieved: WINDOWS-QCBCFSG, returned: WINDOWS-QCBCFSG [main] [ 2015-12-14 16:45:31.603 KST ] [WindowsSystem.startRemoteExecServer:1728] _WS_: Checking if service is started [main] [ 2015-12-14 16:45:31.603 KST ] [Utils.getLocalHost:356] Hostname retrieved: WINDOWS-QCBCFSG, returned: WINDOWS-QCBCFSG [main] [ 2015-12-14 16:45:31.603 KST ] [WindowsSystem.dorunRemoteExecCmd:2061] _WS_: Calling windowsNative with cmd: C:\app\Administrator\product\11.2.0\dbhome_1\bin\getcrshome.exe [main] [ 2015-12-14 16:45:32.619 KST ] [WindowsSystem.dorunRemoteExecCmd:2064] _WS_: WinNative returned: true [main] [ 2015-12-14 16:45:32.619 KST ] [WindowsSystem.dorunRemoteExecCmd:2078] _WS_: remote command executed, but didn't return zero. [main] [ 2015-12-14 16:45:32.619 KST ] [GETCRSHOMEUtil.getCRS_HOME:147] cmdTool.execute() failed. [main] [ 2015-12-14 16:45:32.619 KST ] [HAUtils.isHASConfigured:364] Ignoring exception in isHASConfigured: PRCT-1400 : getcrshome 실행을 실패했습니다. 자세한 오류: localnode PRCT-1400 : getcrshome 실행을 실패했습니다. 자세한 오류: localnode at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:425) at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:592) at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:652) at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:360) at oracle.sysman.assistants.dbca.backend.Host.startOperation(Host.java:3413) at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:119) at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:184) Caused by: PRCT-1400 : getcrshome 실행을 실패했습니다. 자세한 오류: localnode at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:161) at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:112) at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:422) ... 6 more [main] [ 2015-12-14 16:45:32.619 KST ] [Verifier.processRawConfigFile:4031] StorageType == 0 [main] [ 2015-12-14 16:45:32.619 KST ] [Verifier.setOradataDest:4897] setOradataDest:dfDest=D:\Oracle\oradata [main] [ 2015-12-14 16:45:32.619 KST ] [TemplateManager.updateDatafileDestination:2081] updateDatafiles:datafileDir=D:\Oracle\oradata [main] [ 2015-12-14 16:45:32.619 KST ] [TemplateManager.updateDatafileDestination:2225] From template, RedoLogGrName=1 [main] [ 2015-12-14 16:45:32.634 KST ] [TemplateManager.updateDatafileDestination:2240] new file name redo01.log [main] [ 2015-12-14 16:45:32.634 KST ] [TemplateManager.updateDatafileDestination:2225] From template, RedoLogGrName=2 [main] [ 2015-12-14 16:45:32.634 KST ] [TemplateManager.updateDatafileDestination:2240] new file name redo02.log [main] [ 2015-12-14 16:45:32.634 KST ] [TemplateManager.updateDatafileDestination:2225] From template, RedoLogGrName=3 [main] [ 2015-12-14 16:45:32.634 KST ] [TemplateManager.updateDatafileDestination:2240] new file name redo03.log [main] [ 2015-12-14 16:45:32.634 KST ] [ProgressOnlyHost.performOperation:259] processRawConfigFile=false [main] [ 2015-12-14 16:45:32.634 KST ] [Verifier.validateTemplate:2019] StorageType == 0 [main] [ 2015-12-14 16:45:32.634 KST ] [ProgressOnlyHost.performOperation:275] validateTemplate=true [main] [ 2015-12-14 16:45:32.650 KST ] [NetworkUtils.checkListenerStatus:429] Checking listener status: LISTENER [main] [ 2015-12-14 16:45:32.744 KST ] [NetworkUtils.checkListenerStatus:435] lsnrct status output LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-12월-2015 16:45:32 Copyright (c) 1991, 2010, Oracle. All rights reserved. (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))에 연결되었습니다 리스너의 상태 ------------------------ 별칭 LISTENER 버전 TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production 시작 날짜 14-12월-2015 16:45:28 업타임 0 일 0 시간. 0 분. 8 초 트레이스 수준 off 보안 ON: Local OS Authentication SNMP OFF리스너 매개변수 파일 C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora 리스너 로그 파일 c:\app\administrator\diag\tnslsnr\WINDOWS-QCBCFSG\listener\alert\log.xml 끝점 요약 청취 중... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) 리스너는 서비스를 지원하지 않습니다 명령이 성공적으로 수행되었습니다 [main] [ 2015-12-14 16:45:32.744 KST ] [NetworkUtils.checkListenerStatus:453] returning listenernull [main] [ 2015-12-14 16:45:32.744 KST ] [Verifier.validateTemplate:2019] StorageType == 0 [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=D:\ [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=D:\ [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=D:\ [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=D:\ [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=D:\ [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.calculateRedoLogGroupFileSizes:3591] canonicalPath=D:\ [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.calculateRedoLogGroupFileSizes:3591] canonicalPath=D:\ [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.calculateRedoLogGroupFileSizes:3591] canonicalPath=D:\ [main] [ 2015-12-14 16:45:32.806 KST ] [Verifier.getControlfFileSizes:3510] No. of Control files:=2 [main] [ 2015-12-14 16:45:32.869 KST ] [Host.executeSteps:5039] Executing steps.... [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3625] setUpForOperation: Mode = 128 [main] [ 2015-12-14 16:45:32.869 KST ] [OsUtilsBase.copyFile:1499] OsUtilsBase.copyFile: [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3841] Creating directory: C:\app\Administrator\admin\orcl\adump [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3860] Setting admin permissions on: C:\app\Administrator\admin\orcl\adump [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3841] Creating directory: C:\app\Administrator\admin\orcl\dpdump [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3860] Setting admin permissions on: C:\app\Administrator\admin\orcl\dpdump [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3841] Creating directory: C:\app\Administrator\admin\orcl\pfile [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3860] Setting admin permissions on: C:\app\Administrator\admin\orcl\pfile [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3841] Creating directory: C:\app\Administrator\flash_recovery_area [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3860] Setting admin permissions on: C:\app\Administrator\flash_recovery_area [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3841] Creating directory: C:\app\Administrator\flash_recovery_area\orcl [main] [ 2015-12-14 16:45:32.869 KST ] [Host.setUpForOperation:3860] Setting admin permissions on: C:\app\Administrator\flash_recovery_area\orcl [main] [ 2015-12-14 16:45:32.884 KST ] [Host.setUpForOperation:3841] Creating directory: D:\Oracle\oradata\orcl [main] [ 2015-12-14 16:45:32.884 KST ] [Host.setUpForOperation:3860] Setting admin permissions on: D:\Oracle\oradata\orcl [main] [ 2015-12-14 16:45:32.884 KST ] [Host.executeSteps:5220] setupForOperation returned: true [main] [ 2015-12-14 16:45:32.884 KST ] [Host.createStepSQLInterface:7124] sid =orcl [main] [ 2015-12-14 16:45:32.884 KST ] [Host.createStepSQLInterface:7125] sidOrConnectString orcl [main] [ 2015-12-14 16:45:32.884 KST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: null [main] [ 2015-12-14 16:45:32.884 KST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS [main] [ 2015-12-14 16:45:32.884 KST ] [OracleHome.getVersion:899] Homeinfo C:\app\Administrator\product\11.2.0\dbhome_1,1 [main] [ 2015-12-14 16:45:33.213 KST ] [OracleHome.getVersion:925] OracleHome.server.getVersion Version: 11.2.0.1.0 [main] [ 2015-12-14 16:45:33.213 KST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0 [main] [ 2015-12-14 16:45:33.213 KST ] [OracleHome.getVersion:951] using sqlplus: C:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe [main] [ 2015-12-14 16:45:33.213 KST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0 [main] [ 2015-12-14 16:45:33.213 KST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0 [main] [ 2015-12-14 16:45:33.213 KST ] [OracleHome.getVersion:951] using sqlplus: C:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe [main] [ 2015-12-14 16:45:33.228 KST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0 [main] [ 2015-12-14 16:45:33.228 KST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0 [main] [ 2015-12-14 16:45:33.228 KST ] [OracleHome.getVersion:951] using sqlplus: C:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe [main] [ 2015-12-14 16:45:33.228 KST ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.1.0 [main] [ 2015-12-14 16:45:33.228 KST ] [SQLPlusEngine.getCmmdParams:223] version > 112 true [main] [ 2015-12-14 16:45:33.228 KST ] [SQLEngine.getEnvParams:552] Default NLS_LANG: KOREAN_KOREA.AL32UTF8 [main] [ 2015-12-14 16:45:33.228 KST ] [SQLEngine.getEnvParams:562] NLS_LANG: KOREAN_KOREA.AL32UTF8 [main] [ 2015-12-14 16:45:33.228 KST ] [SQLEngine.initialize:322] Execing SQLPLUS/SVRMGR process... [main] [ 2015-12-14 16:45:33.228 KST ] [SQLEngine.initialize:359] m_bReaderStarted: false [main] [ 2015-12-14 16:45:33.228 KST ] [SQLEngine.initialize:363] Starting Reader Thread... [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home1 [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [StepManager.getSteps:257] logging folder set: C:\app\Administrator\cfgtoollogs\dbca\orcl [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [StepManager.getSteps:265] ckFileName C:\app\Administrator\cfgtoollogs\dbca\orcl\OraDb11g_home1_orcl_creation_checkpoint.xml ckContext oracle.sysman.assistants.util.CheckpointContext@9931579 [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [CheckpointContext.isCleanupNeeded:140] failedChkFiles null [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [CheckpointContext.isCleanupNeeded:149] Failed check files iterator null [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [StepManager.getSteps:295] checkpoint from file oracle.sysman.oic.oics.OicsCheckPoint@2dc0435 [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [StepManager.getSteps:301] adding checkpoint to session [Thread-7] [ 2015-12-14 16:45:33.353 KST ] [StepManager.getSteps:303] saved new checkpoint session for DB creation [Thread-7] [ 2015-12-14 16:45:33.369 KST ] [StepManager.getSteps:426] StepManager isHARegitrationRequired : false [Thread-7] [ 2015-12-14 16:45:33.431 KST ] [StepContext$ModeRunner.run:2657] ---- Progress Needed:=true [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092 [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034 [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114 [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560 [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109 [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [BasicStep.configureSettings:304] messageHandler being set=null [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [BasicStep.execute:202] Executing Step : INSTANCE_CREATION [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [BasicStep.configureSettings:304] messageHandler being set=null [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [InstanceStep.createInitFile:479] Checking registerWithHAListener [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [Host.registerWithHAListener:8719] m_cmdArgs.m_listenersnull [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [Host.registerWithHAListener:8720] isHARegistrationRequired false [Thread-7] [ 2015-12-14 16:45:33.478 KST ] [InitParamAttributes.sortParams:3777] m_sortOn:-1 sortOn:4 [Thread-7] [ 2015-12-14 16:45:34.259 KST ] [InitParamAttributes.createInitFile:1811] Processing init param dispatchers [Thread-7] [ 2015-12-14 16:45:34.291 KST ] [InitParamAttributes.createInitFile:1816] The value is "(PROTOCOL=TCP) (SERVICE=orclXDB)" [Thread-7] [ 2015-12-14 16:45:34.291 KST ] [InitParamAttributes.createInitFile:1811] Processing init param compatible [Thread-7] [ 2015-12-14 16:45:34.291 KST ] [InitParamAttributes.createInitFile:1816] The value is 11.2.0.0.0 [Thread-7] [ 2015-12-14 16:45:34.291 KST ] [InitParamAttributes.createInitFile:1811] Processing init param diagnostic_dest [Thread-7] [ 2015-12-14 16:45:34.306 KST ] [InitParamAttributes.createInitFile:1816] The value is C:\app\Administrator [Thread-7] [ 2015-12-14 16:45:34.306 KST ] [InitParamAttributes.createInitFile:1811] Processing init param memory_target [Thread-7] [ 2015-12-14 16:45:34.384 KST ] [InitParamAttributes.createInitFile:1816] The value is 3382706176 [Thread-7] [ 2015-12-14 16:45:34.447 KST ] [InitParamAttributes.createInitFile:1811] Processing init param local_listener [Thread-7] [ 2015-12-14 16:45:34.509 KST ] [InitParamAttributes.createInitFile:1816] The value is LISTENER_ORCL [Thread-7] [ 2015-12-14 16:45:34.509 KST ] [InitParamAttributes.createInitFile:1811] Processing init param db_domain [Thread-7] [ 2015-12-14 16:45:34.509 KST ] [InitParamAttributes.createInitFile:1816] The value is "" [Thread-7] [ 2015-12-14 16:45:34.509 KST ] [InitParamAttributes.createInitFile:1811] Processing init param db_name [Thread-7] [ 2015-12-14 16:45:34.509 KST ] [InitParamAttributes.createInitFile:1816] The value is orcl [Thread-7] [ 2015-12-14 16:45:34.525 KST ] [InitParamAttributes.createInitFile:1811] Processing init param audit_file_dest [Thread-7] [ 2015-12-14 16:45:34.588 KST ] [InitParamAttributes.createInitFile:1816] The value is C:\app\Administrator\admin\orcl\adump [Thread-7] [ 2015-12-14 16:45:34.603 KST ] [InitParamAttributes.createInitFile:1811] Processing init param audit_trail [Thread-7] [ 2015-12-14 16:45:34.603 KST ] [InitParamAttributes.createInitFile:1816] The value is db [Thread-7] [ 2015-12-14 16:45:34.603 KST ] [InitParamAttributes.createInitFile:1811] Processing init param remote_login_passwordfile [Thread-7] [ 2015-12-14 16:45:34.603 KST ] [InitParamAttributes.createInitFile:1816] The value is EXCLUSIVE [Thread-7] [ 2015-12-14 16:45:34.603 KST ] [InitParamAttributes.createInitFile:1811] Processing init param undo_tablespace [Thread-7] [ 2015-12-14 16:45:34.603 KST ] [InitParamAttributes.createInitFile:1816] The value is UNDOTBS1 [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1811] Processing init param db_block_size [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1816] The value is 8192 [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1811] Processing init param open_cursors [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1816] The value is 300 [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1811] Processing init param control_files [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1816] The value is ("D:\Oracle\oradata\orcl\control01.ctl", "C:\app\Administrator\flash_recovery_area\orcl\control02.ctl") [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1811] Processing init param db_recovery_file_dest [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1816] The value is C:\app\Administrator\flash_recovery_area [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1811] Processing init param db_recovery_file_dest_size [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1816] The value is 4102029312 [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1811] Processing init param processes [Thread-7] [ 2015-12-14 16:45:34.681 KST ] [InitParamAttributes.createInitFile:1816] The value is 150 [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [InstanceStep.executeImpl:246] Checking Register with HA Listener [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [Host.registerWithHAListener:8719] m_cmdArgs.m_listenersnull [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [Host.registerWithHAListener:8720] isHARegistrationRequired false [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [NetworkUtils.getOneLocalListenerProtocolAddress:2984] lsnr LISTENER [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [HAUtils.isCRSInstalled:409] enter isCRSInstalled() m_ouiLoc C:\Program Files\Oracle\Inventory\ContentsXML [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [InstallGroupImpl.<init>:109] OUI_LOC_PROPERTY = oracle.installer.oui_loc [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [ClusterwareInfo.isCRSInstalled:369] PRCI-1123 : CRS 홈이 로컬 노드에 존재하지 않습니다. [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [HAUtils.getHASHome:631] Oracle home from system properties: C:\app\Administrator\product\11.2.0\dbhome_1 [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [HAUtils.getCRSHome:588] Getting configured CRS/HAS home for Oracle home ( C:\app\Administrator\product\11.2.0\dbhome_1 ) ... [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [GETCRSHOMEUtil.<init>:88] Toolname: getcrshome.exe --- Tool location: C:\app\Administrator\product\11.2.0\dbhome_1\binTool dependencies: [Ljava.lang.String;@39385660 [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [CmdToolUtil.doexecute:360] starting remote exec server on local node src=C:\app\Administrator\product\11.2.0\dbhome_1\bin dest=C:\Users\ADMINI~1\AppData\Local\Temp\1\ [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [Utils.getLocalHost:356] Hostname retrieved: WINDOWS-QCBCFSG, returned: WINDOWS-QCBCFSG [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [WindowsSystem.startRemoteExecServer:1728] _WS_: Checking if service is started [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [Utils.getLocalHost:356] Hostname retrieved: WINDOWS-QCBCFSG, returned: WINDOWS-QCBCFSG [Thread-7] [ 2015-12-14 16:45:34.697 KST ] [WindowsSystem.dorunRemoteExecCmd:2061] _WS_: Calling windowsNative with cmd: C:\app\Administrator\product\11.2.0\dbhome_1\bin\getcrshome.exe [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [WindowsSystem.dorunRemoteExecCmd:2064] _WS_: WinNative returned: true [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [WindowsSystem.dorunRemoteExecCmd:2078] _WS_: remote command executed, but didn't return zero. [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [GETCRSHOMEUtil.getCRS_HOME:147] cmdTool.execute() failed. [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [HAUtils.isHASConfigured:364] Ignoring exception in isHASConfigured: PRCT-1400 : getcrshome 실행을 실패했습니다. 자세한 오류: localnode PRCT-1400 : getcrshome 실행을 실패했습니다. 자세한 오류: localnode at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:425) at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:592) at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:652) at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:360) at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2990) at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2965) at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddressForPort(NetworkUtils.java:1214) at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddress(NetworkUtils.java:1197) at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddresses(NetworkUtils.java:1251) at oracle.sysman.assistants.util.NetworkUtils.addLocalListenerEntry(NetworkUtils.java:1305) at oracle.sysman.assistants.dbca.backend.InstanceStep.executeImpl(InstanceStep.java:260) at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210) at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251) at oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.executeImpl(CloneRmanRestoreStep.java:220) at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210) at oracle.sysman.assistants.util.step.Step.execute(Step.java:140) at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667) at java.lang.Thread.run(Thread.java:595) Caused by: PRCT-1400 : getcrshome 실행을 실패했습니다. 자세한 오류: localnode at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:161) at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:112) at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:422) ... 17 more [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.getOneLocalListenerProtocolAddress:3138] bestSoFar=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)) [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.getOneLocalListenerProtocolAddress:3151] host=null hostParam=localhost [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.getOneLocalListenerProtocolAddress:3213] returning bestAddrSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.getOneLocalListenerProtocolAddress:3273] Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.getOneLocalListenerProtocolAddress:3273] Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.isDefaultHostName:2666] lsnrHost: localhost ==> ip address:127.0.0.1 host: WINDOWS-QCBCFSG ==> ip address:192.168.0.20 [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.getLocalListenerAddresses:1253] listener[0]=LISTENER address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.addLocalListenerEntry:1323] addLocalListenerEntry addresses[0]=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.createAddressListAlias:2058] createAddressListAlias TNS_ADMIN=null [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.createAddressListAlias:2064] createAddressListAlias ORACLE_HOME=null [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.createAddressListAlias:2066] createAddressListAlias name=LISTENER_ORCL addresses=1 [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.createAddressListAlias:2088] createAddressListAlias address = (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.createAddressListAlias:2098] createAddressListAlias endpoints.addElement address = (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.createAddressListAlias:2128] createAddressListAlias Adding LISTENER_ORCL to Endpoints [Thread-7] [ 2015-12-14 16:45:35.728 KST ] [NetworkUtils.createAddressListAlias:2130] createAddressListAlias Saving net config [Thread-7] [ 2015-12-14 16:45:35.744 KST ] [NetworkUtils.createAddressListAlias:2132] createAddressListAlias Saved config [Thread-7] [ 2015-12-14 16:45:35.744 KST ] [Host.noEntryinOratab:6172] Check made for oratab arg passed............ [Thread-7] [ 2015-12-14 16:45:35.744 KST ] [Oradim.getAddEntryCommand:359] AddEntry=[C:\app\Administrator\product\11.2.0\dbhome_1\bin\oradim.exe, -new, -sid, ORCL, -startmode, manual, -spfile] [Thread-7] [ 2015-12-14 16:45:37.119 KST ] [Oradim.getEditEntryCommand:440] getEditEntry cmd=[C:\app\Administrator\product\11.2.0\dbhome_1\bin\oradim.exe, -edit, -sid, ORCL, -startmode, auto, -srvcstart, system] [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home1 [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [OsUtilsBase.getOracleHomeKeyImpl:979] getting home key for home name: OraDb11g_home1 [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [Oradim.addSidToRegistry:913] oracleHomeKey: SOFTWARE\ORACLE\KEY_OraDb11g_home1 [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [OsUtilsBase.getRegistryEntry:1021] hklmKey while getting registry entryHKEY_LOCAL_MACHINE [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [OsUtilsBase.getRegistryEntry:1022] keyToSet while getting registry entrySOFTWARE\ORACLE\KEY_OraDb11g_home1 [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: null [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS [Thread-7] [ 2015-12-14 16:45:37.306 KST ] [OracleHome.getVersion:899] Homeinfo C:\app\Administrator\product\11.2.0\dbhome_1,1 [Thread-7] [ 2015-12-14 16:45:37.447 KST ] [OracleHome.getVersion:925] OracleHome.server.getVersion Version: 11.2.0.1.0 [Thread-7] [ 2015-12-14 16:45:37.447 KST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0 [Thread-7] [ 2015-12-14 16:45:37.447 KST ] [OracleHome.getVersion:951] using sqlplus: C:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe [Thread-7] [ 2015-12-14 16:45:37.447 KST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0 [Thread-7] [ 2015-12-14 16:45:37.447 KST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0 [Thread-7] [ 2015-12-14 16:45:37.447 KST ] [OracleHome.getVersion:951] using sqlplus: C:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe [Thread-7] [ 2015-12-14 16:45:37.447 KST ] [CommonUtils.createPasswordFile:604] calling new orapwd for 11.1 or higher [Thread-7] [ 2015-12-14 16:45:37.447 KST ] [OsUtilsBase.execProg:2117] beginning execProg with input array. [Thread-7] [ 2015-12-14 16:45:37.525 KST ] [OsUtilsBase.execProg:2154] finished execProg with input array. Status:0 [Thread-7] [ 2015-12-14 16:45:37.525 KST ] [InstanceStep.setASMAdminGID:329] isWindows: true Storage Type: 0 [Thread-7] [ 2015-12-14 16:45:37.525 KST ] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@d71194d [Thread-7] [ 2015-12-14 16:45:37.525 KST ] [CloneRmanRestoreStep.executeImpl:221] Instance Creation went fine.......... [Thread-7] [ 2015-12-14 16:45:37.525 KST ] [CloneRmanRestoreStep.executeImpl:228] db_recovery_file_dest=C:\app\Administrator\flash_recovery_area [Thread-7] [ 2015-12-14 16:45:37.525 KST ] [CloneRmanRestoreStep.executeImpl:231] db_recovery_file_dest_size=4102029312 [Thread-7] [ 2015-12-14 16:45:38.041 KST ] [SQLEngine.setSpool:1945] old Spool = null [Thread-7] [ 2015-12-14 16:45:38.041 KST ] [SQLEngine.setSpool:1946] Setting Spool = C:\app\Administrator\cfgtoollogs\dbca\orcl\CloneRmanRestore.log [Thread-7] [ 2015-12-14 16:45:38.041 KST ] [SQLEngine.setSpool:1947] Is spool appendable? --> true [Thread-7] [ 2015-12-14 16:45:38.041 KST ] [CloneRmanRestoreStep.executeImpl:324] starting with pfile=C:\app\Administrator\admin\orcl\pfile\init.ora
by 부부부부
[2015.12.15 21:13:55]
PRCT-1400 관련 에러 같은데 해결책을 잘 모르겠네요 ㅠ
) 버튼을 클릭하여 작성 하시면 됩니다.