Solaris10 安装Oracle 10202 dbca建库时报invalid argument.请高手指点.万分感谢！

ahcnpl

硬件环境:
v880x2,HP4100 存储,使用裸设备

软件环境:
Solaris 10 u5
SunCluster3.1u4
EIS3.1.12 patch
Ｏracle 10 g 10.2.0.2 RAC

前面安装ＣＲＳ和ＤＢ都很正常，但是到建库的时候点finish，确认完summry后将要Creating and starting Oracle instance时报错

trace.zip (33.81 KB, 下载次数: 32)

2008-12-28 19:03 上传

点击文件名下载附件

．
－－－－－－－－－－－－－－－－－－－
原来的环境是solaris10 u6，ＳunCluster3.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.<init>:88]  NativeResult: The String obtained is1| :successful
[Worker 2] [4:49:43:939] [NativeResult.<init>:96]  The status string is: 1
[Worker 2] [4:49:43:939] [NativeResult.<init>: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.<init>:88]  NativeResult: The String obtained is1| :successful
[Worker 1] [4:49:43:977] [NativeResult.<init>:96]  The status string is: 1
[Worker 1] [4:49:43:977] [NativeResult.<init>: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 set=oracle.sysman.assistants.util.UIMessageHandler@1d85e85
[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 set=oracle.sysman.assistants.util.UIMessageHandler@1d85e85
[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 set=oracle.sysman.assistants.util.UIMessageHandler@1d85e85
[Thread-288] [4:49:44:991] [BasicStep.configureSettings:304]  messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@1d85e85
[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:246
java.lang.Thread.run(Thread.java:534)
[Thread-288] [4:49:46:432] [SQLEngine.done:1951]  Done called

[ 本帖最后由 ahcnpl 于 2008-12-28 19:40 编辑 ]

ziggler

原帖由 ahcnpl 于 2008-12-28 19:03 发表
硬件环境:
v880x2,HP4100 存储,使用裸设备

软件环境:
Solaris 10 u5
SunCluster3.1u4
EIS3.1.12 patch
Ｏracle 10 g 10.2.0.2 RAC

前面安装ＣＲＳ和ＤＢ都很正常，但是到建库的时候点finish，确认完 ...

http://www.itpub.net/thread-1086943-1-1.html

ahcnpl

我建库时有写SYSAUX表空间的.我建库时选的是不含数据文件的自定义模版,自己指定用裸设备的.SYSAUX的裸设备文件为/dev/did/rdsk/d9s6做的,空间大小为800M,不自动扩展.

ahcnpl

自己顶一下.

ahcnpl

晕，这是咋地啦？20分都没有吸引力？这可是CU里悬赏的上限了...

twinklezcf

可能是没人遇到过吧...怎么指定的RAW对照表啊?

ahcnpl

raw设备用的是/dev/did/rdsk/dxsx,应该没问题。

问题已经解决，对于新版本的solaris操作系统和SunCluster3.2，oracle 10.2.0.2版有bug，不能使用裸设备建库，用10.2.0.1（即不打补丁的DB）或者10.2.0.3或以上就ok了。

感谢大家的支持和关注。