Chinaunix首页 | 论坛 | 博客
  • 博客访问: 77819
  • 博文数量: 5
  • 博客积分: 1556
  • 博客等级: 上尉
  • 技术积分: 130
  • 用 户 组: 普通用户
  • 注册时间: 2005-11-25 18:01
文章分类

全部博文(5)

文章存档

2011年(1)

2009年(1)

2008年(3)

分类: Oracle

2008-12-28 19:39:42

硬件环境:
v880x2,HP4100 存储,使用裸设备
软件环境:
Solaris 10 u5
SunCluster3.1u4
EIS3.1.12 patch
Oracle 10 g 10.2.0.2 RAC
前面安装CRS和DB都很正常,但是到建库的时候点finish,确认完summry后将要Creating and starting Oracle instance时报错
 
[attach]309333[/attach]

-------------------
原来的环境是solaris10 u6,SunCluster3.2u1,报错结果和这个一样.
也怀疑过是裸设备的问题,看测试的结果好像确实和裸设备有关系,我用裸设备建单机的库也是报这个错,而我使用文件系统建单机库时是可以建库的,我测试过将某些裸设备做成文件系统,读写都没有问题.
折磨了很久了,crs和db重装过多遍.即将崩溃ing......
附部分dbca建库时的trace log
[Worker 1] [4:49:43:839] [RuntimeExec.runCommand:74]  Calling Runtime.exec() with the command
[Worker 2] [4:49:43:839] [RuntimeExec.runCommand:76]  /usr/bin/mkdir
[Worker 1] [4:49:43:839] [RuntimeExec.runCommand:76]  /usr/bin/rsh
[Worker 2] [4:49:43:839] [RuntimeExec.runCommand:76]  -p
[Worker 1] [4:49:43:839] [RuntimeExec.runCommand:76]  hdhis2
[Worker 2] [4:49:43:839] [RuntimeExec.runCommand:76]  /oracle/admin/w2000/udump
[Worker 1] [4:49:43:839] [RuntimeExec.runCommand:76]  -n
[Worker 1] [4:49:43:840] [RuntimeExec.runCommand:76]  /usr/bin/mkdir
[Worker 1] [4:49:43:840] [RuntimeExec.runCommand:76]  -p
[Worker 1] [4:49:43:840] [RuntimeExec.runCommand:76]  /oracle/admin/w2000/udump
[Worker 1] [4:49:43:916] [RuntimeExec.runCommand:131]  runCommand: Waiting for the process
[Thread-282] [4:49:43:916] [StreamReader.run:61]  In StreamReader.run
[Thread-283] [4:49:43:917] [StreamReader.run:61]  In StreamReader.run
[Worker 2] [4:49:43:917] [RuntimeExec.runCommand:131]  runCommand: Waiting for the process
[Thread-285] [4:49:43:917] [StreamReader.run:61]  In StreamReader.run
[Thread-284] [4:49:43:918] [StreamReader.run:61]  In StreamReader.run
[Worker 2] [4:49:43:937] [RuntimeExec.runCommand:133]  runCommand: process returns 0
[Worker 2] [4:49:43:937] [RuntimeExec.runCommand:147]  RunTimeExec: output>
[Worker 2] [4:49:43:937] [RuntimeExec.runCommand:155]  RunTimeExec: error>
[Worker 2] [4:49:43:937] [RuntimeExec.runCommand:175]  Returning from RunTimeExec.runCommand
[Worker 2] [4:49:43:938] [NativeSystem.rununixcmd:782]  NativeSystem.rununixcmd: RetString 1| :successful
[Worker 2] [4:49:43:939] [NativeResult.:88]  NativeResult: The String obtained is1| :successful
[Worker 2] [4:49:43:939] [NativeResult.:96]  The status string is: 1
[Worker 2] [4:49:43:939] [NativeResult.:109]  The result string is:  :successful 1
[Worker 2] [4:49:43:940] [ClusterConfig$ExecuteCommand.returnCommandToClient:2532]  returnCommandToClient; fillCount=0 is full=false
[Worker 2] [4:49:43:940] [Semaphore.acquire:109]  SyncBufferEmpty:Acquire called by thread Worker 2 m_count=100
[Worker 2] [4:49:43:941] [Semaphore.release:85]  SyncBufferFull:Release called by thread Worker 2 m_count=1
[Worker 2] [4:49:43:941] [ClientResource.getListener:157]  Calling getListener
[Worker 2] [4:49:43:941] [ClusterConfig$ExecuteCommand.run:2614]  Owner Thread name of the blocking Semaphore TaskScheduler timer
[Worker 2] [4:49:43:941] [ClusterConfig$ExecuteCommand.run:2622]  Obtained Semaphore
[Worker 2] [4:49:43:941] [Semaphore.release:85]  ClientResource Constructor:Blocking Semaphore owned by TaskScheduler timer:Release called by thread Worker 2 m_count=1
[Worker 2] [4:49:43:941] [ClusterConfig$ExecuteCommand.run:2637]  Released Semaphore by worker=Worker 2
[Worker 2] [4:49:43:942] [Semaphore.acquire:109]  SyncBufferFull:Acquire called by thread Worker 2 m_count=0
[TaskScheduler timer] [4:49:43:942] [ClusterConfig.block:547]  block acquired semnum=0
[TaskScheduler timer] [4:49:43:942] [Semaphore.acquire:109]  ClientResource Constructor:Blocking Semaphore owned by TaskScheduler timer:Acquire called by thread TaskScheduler timer m_count=0
[Worker 1] [4:49:43:975] [RuntimeExec.runCommand:133]  runCommand: process returns 0
[Worker 1] [4:49:43:975] [RuntimeExec.runCommand:147]  RunTimeExec: output>
[Worker 1] [4:49:43:976] [RuntimeExec.runCommand:155]  RunTimeExec: error>
[Worker 1] [4:49:43:976] [RuntimeExec.runCommand:175]  Returning from RunTimeExec.runCommand
[Worker 1] [4:49:43:976] [NativeSystem.rununixcmd:782]  NativeSystem.rununixcmd: RetString 1| :successful
[Worker 1] [4:49:43:976] [NativeResult.:88]  NativeResult: The String obtained is1| :successful
[Worker 1] [4:49:43:977] [NativeResult.:96]  The status string is: 1
[Worker 1] [4:49:43:977] [NativeResult.:109]  The result string is:  :successful 1
[Worker 1] [4:49:43:977] [ClusterConfig$ExecuteCommand.returnCommandToClient:2532]  returnCommandToClient; fillCount=1 is full=false
[Worker 1] [4:49:43:977] [Semaphore.acquire:109]  SyncBufferEmpty:Acquire called by thread Worker 1 m_count=99
[Worker 1] [4:49:43:977] [Semaphore.release:85]  SyncBufferFull:Release called by thread Worker 1 m_count=2
[Worker 1] [4:49:43:978] [ClientResource.getListener:157]  Calling getListener
[Worker 1] [4:49:43:978] [ClusterConfig$ExecuteCommand.run:2614]  Owner Thread name of the blocking Semaphore TaskScheduler timer
[Worker 1] [4:49:43:978] [ClusterConfig$ExecuteCommand.run:2622]  Obtained Semaphore
[Worker 1] [4:49:43:978] [Semaphore.release:85]  ClientResource Constructor:Blocking Semaphore owned by TaskScheduler timer:Release called by thread Worker 1 m_count=1
[Worker 1] [4:49:43:978] [ClusterConfig$ExecuteCommand.run:2637]  Released Semaphore by worker=Worker 1
[TaskScheduler timer] [4:49:43:978] [ClusterConfig.block:547]  block acquired semnum=1
[Worker 1] [4:49:43:978] [Semaphore.acquire:109]  SyncBufferFull:Acquire called by thread Worker 1 m_count=0
[TaskScheduler timer] [4:49:43:979] [ClusterConfig.destroy:391]  destroying resources for client thread Thread[TaskScheduler timer,5,main]
[TaskScheduler timer] [4:49:43:979] [Host.executeSteps:4184]  setupForOperation returned: true
[TaskScheduler timer] [4:49:43:980] [Host.createStepSQLInterface:5946]  sid =w20001
[TaskScheduler timer] [4:49:43:981] [SQLEngine.getEnvParams:424]  NLS_LANG: AMERICAN_AMERICA.ZHS16CGB231280
[TaskScheduler timer] [4:49:43:984] [SQLEngine.initialize:241]  Execing SQLPLUS/SVRMGR process...
[TaskScheduler timer] [4:49:44:29] [SQLEngine.initialize:269]  m_bReaderStarted: false
[TaskScheduler timer] [4:49:44:30] [SQLEngine.initialize:273]  Starting Reader Thread...
[Thread-288] [4:49:44:146] [StepContext$ModeRunner.run:2458]  ---- Progress Needed:=true
[Thread-288] [4:49:44:975] [BasicStep.execute:202]  Executing Step : DB_ENTRY
[Thread-288] [4:49:44:975] [StepErrorHandler.setFatalErrors:322]  setting Fatal Error: ORA-01501
[Thread-288] [4:49:44:975] [StepErrorHandler.setFatalErrors:322]  setting Fatal Error: ORA-01092
[Thread-288] [4:49:44:975] [StepErrorHandler.setFatalErrors:322]  setting Fatal Error: ORA-01034
[Thread-288] [4:49:44:976] [StepErrorHandler.setFatalErrors:322]  setting Fatal Error: ORA-03114
[Thread-288] [4:49:44:976] [StepErrorHandler.setFatalErrors:322]  setting Fatal Error: ORA-12560
[Thread-288] [4:49:44:976] [BasicStep.configureSettings:304]  messageHandler being
[Thread-288] [4:49:44:978] [BasicStep.execute:202]  Executing Step : INSTANCE_CREATION_OPS
[Thread-288] [4:49:44:979] [BasicStep.configureSettings:304]  messageHandler being
[Thread-288] [4:49:44:979] [InitParamAttributes.removeDuplicateOPSParams:845]  InitParamAttributes->removeDuplicateOPSParams: Start of function, number of parameters=262
[Thread-288] [4:49:44:980] [InstanceStepOPS.createInitFile:1485]  Updating cluster_database
[Thread-288] [4:49:44:980] [InitParamAttributes.replaceSidVars:4408]  1. replaceSidVars: instance=w20001
[Thread-288] [4:49:44:981] [InitParamAttributes.replaceSidVars:4414]  2. replaceSidVars: instance=w20001
[Thread-288] [4:49:44:981] [InitParamAttributes.replaceSidVars:4408]  1. replaceSidVars: instance=w20002
[Thread-288] [4:49:44:981] [InitParamAttributes.replaceSidVars:4414]  2. replaceSidVars: instance=w20002
[Thread-288] [4:49:44:982] [InitParamAttributes.replaceSidVars:4408]  1. replaceSidVars: instance=w20002
[Thread-288] [4:49:44:982] [InitParamAttributes.replaceSidVars:4414]  2. replaceSidVars: instance=w20002
[Thread-288] [4:49:44:982] [InitParamAttributes.replaceSidVars:4408]  1. replaceSidVars: instance=w20001
[Thread-288] [4:49:44:982] [InitParamAttributes.replaceSidVars:4414]  2. replaceSidVars: instance=w20001
[Thread-288] [4:49:44:983] [InitParamAttributes.replaceSidVars:4408]  1. replaceSidVars: instance=w20001
[Thread-288] [4:49:44:983] [InitParamAttributes.replaceSidVars:4414]  2. replaceSidVars: instance=w20001
[Thread-288] [4:49:44:983] [InitParamAttributes.replaceSidVars:4408]  1. replaceSidVars: instance=w20002
[Thread-288] [4:49:44:984] [InitParamAttributes.replaceSidVars:4414]  2. replaceSidVars: instance=w20002
[Thread-288] [4:49:44:984] [InitParamAttributes.replaceSidVars:4408]  1. replaceSidVars: instance=w20001
[Thread-288] [4:49:44:984] [InitParamAttributes.replaceSidVars:4414]  2. replaceSidVars: instance=w20001
[Thread-288] [4:49:44:984] [InitParamAttributes.replaceSidVars:4408]  1. replaceSidVars: instance=w20002
[Thread-288] [4:49:44:985] [InitParamAttributes.replaceSidVars:4414]  2. replaceSidVars: instance=w20002
[Thread-288] [4:49:44:985] [InitParamAttributes.sortParams:3525]  m_sortOn:4 sortOn:4
[Thread-288] [4:49:44:986] [InitParameterFile.addParameter:504]  InitParameterFile:addParameter, inst=w20001 param=instance_number value=1
[Thread-288] [4:49:44:986] [InitParameterFile.addParameter:504]  InitParameterFile:addParameter, inst=w20002 param=instance_number value=2
[Thread-288] [4:49:44:986] [InitParameterFile.addParameter:504]  InitParameterFile:addParameter, inst=w20002 param=thread value=2
[Thread-288] [4:49:44:986] [InitParameterFile.addParameter:504]  InitParameterFile:addParameter, inst=w20001 param=undo_tablespace value=UNDOTBS1
[Thread-288] [4:49:44:987] [InitParameterFile.addParameter:504]  InitParameterFile:addParameter, inst=w20002 param=undo_tablespace value=UNDOTBS2
[Thread-288] [4:49:44:990] [BasicStep.configureSettings:304]  messageHandler being
[Thread-288] [4:49:44:991] [BasicStep.configureSettings:304]  messageHandler being
[Thread-288] [4:49:44:991] [StepContext$ModeRunner.run:2484]  oracle.sysman.assistants.dbca.backend.InstanceStepOPS.executeImpl(InstanceStepOPS.java:1043)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)
oracle.sysman.assistants.dbca.backend.DBEntryStep.executeImpl(DBEntryStep.java:230)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2468)
java.lang.Thread.run(Thread.java:534)
[Thread-288] [4:49:46:432] [SQLEngine.done:1951]  Done called
 
 
-------------------------------------------------------------
问题已解决,多谢关注.
阅读(4337) | 评论(2) | 转发(0) |
给主人留下些什么吧!~~

chinaunix网友2009-11-14 10:21:23

我的错误提示: [Thread-91] [17:7:32:204] [BasicStep.execute:201] Executing Step : DB_ENTRY [Thread-91] [17:7:32:204] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01501 [Thread-91] [17:7:32:204] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092 [Thread-91] [17:7:32:205] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034 [Thread-91] [17:7:32:205] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114 [Thread-91] [17:7:32:20

chinaunix网友2009-11-14 10:20:27

能否将解决方法附上,谢谢!