Windows Server 2008 R2 X64安装Oracle 10g R2后不能创建数据库问题解决办法
一、背景交代客户刚刚到的一台新服务器，型号为：IBM X3850，自带的操作系统为：Windows Server 2008 R2 X64；需要安装版本为10.2.0.4版本的Oracle数据库。
二、遇到问题
找到Oracle提供的安装光盘后安装数据库一路next，到了最后创建数据库的时候遇到了问题，进度停止不前，如下图：
http://www.wsria.com/wp-content/uploads/2011/06/oracle-create-db.png
查看trace.log内容如下：
CommandLineArguments->process: number of arguments = 32
CommandLineArguments->process: Create Database argument is specified
CommandLineArguments->process: template Name argument is specified
CommandLineArguments->process: db name argument is specified
CommandLineArguments->process: in Operation Type is Creation/GenerateScripts Mode condition
CommandLineArguments->process: Successfully process command line arguments
Inside checkOPS
Trying to check cluster existence
Created instance of Library.
Loading orauts.dll...
oracleHome D:\oracle\product\10.2.0\db_1
osName=Windows Vista osArch=amd64 rc=false
Loadinglibrary D:\oracle\product\10.2.0\db_1\bin\orauts.dll
Loaded library D:\oracle\product\10.2.0\db_1\bin\orauts.dll from path=
D:\oracle\product\10.2.0\db_1\bin
Loading MSVCRT.dll...
oracleHome D:\oracle\product\10.2.0\db_1
osName=Windows Vista osArch=amd64 rc=false
Loadinglibrary D:\oracle\product\10.2.0\db_1\bin\MSVCRT.dll
Loaded library D:\oracle\product\10.2.0\db_1\bin\MSVCRT.dll from path=
D:\oracle\product\10.2.0\db_1\bin
Loading orawsec10.dll...
oracleHome D:\oracle\product\10.2.0\db_1
osName=Windows Vista osArch=amd64 rc=false
Loadinglibrary D:\oracle\product\10.2.0\db_1\bin\orawsec10.dll
Loaded library D:\oracle\product\10.2.0\db_1\bin\orawsec10.dll from path=
D:\oracle\product\10.2.0\db_1\bin
Loading orasrvm10.dll...
oracleHome D:\oracle\product\10.2.0\db_1
osName=Windows Vista osArch=amd64 rc=false
Loadinglibrary D:\oracle\product\10.2.0\db_1\bin\orasrvm10.dll
Loaded library D:\oracle\product\10.2.0\db_1\bin\orasrvm10.dll from path=
D:\oracle\product\10.2.0\db_1\bin
isPre10i.java: Returning FALSE
WindowsSystem.regKeyExists: mainkey= HKEY_LOCAL_MACHINE subkey = Software\Oracle\Ocr
configType=null
cluster existence:false
Cluster installed=false
CustomSGA flag: false
Database Type: MULTIPURPOSE
Mem Percentage: 40
distributing Memory: 13737443328
Setting SGA to MAX_SGA 1610612736
IN threadID:1 group#=1
IN threadID:1 group#=2
Current threadID=1
Current threadID=1 ==> redoGroups=1
vRedoGroups:
setAttribute: bExists=false
IN threadID:1 group#=3
Current threadID=1
Current threadID=1 ==> redoGroups=1
Current threadID=1 ==> redoGroups=2
vRedoGroups:
setAttribute: bExists=false
See for any transportable datafiles in TemplateManager.....
Selected Template by user:=General Purpose
The Message Id to be searched:=GENERAL_PURPOSE
create new clone data file for tp file.......
setupOIDCommandlineParameters:
m_regWithdirService: false
m_unregWithdirService: false
m_updateDirService: false
StorageType == 0
setOradataDest:dfDest=D:\oracle\product\10.2.0\oradata
updateDatafiles:datafileDir=D:\oracle\product\10.2.0\oradata
From template, RedoLogGrName=1
new file name redo01.log
From template, RedoLogGrName=2
new file name redo02.log
From template, RedoLogGrName=3
new file name redo03.log
processRawConfigFile=false
StorageType == 0
validateTemplate=true
bRacOn = false
StorageType == 0
canonicalPath=D:\oracle\product\10.2.0\
canonicalPath=D:\oracle\product\10.2.0\
canonicalPath=D:\oracle\product\10.2.0\
canonicalPath=D:\oracle\product\10.2.0\
canonicalPath=D:\oracle\product\10.2.0\
canonicalPath=D:\oracle\product\10.2.0\
canonicalPath=D:\oracle\product\10.2.0\
canonicalPath=D:\oracle\product\10.2.0\
No. of Control files:=3
Executing steps....
setUpForOperation: Mode = 128
setupForOperation returned: true
sid =orcl
Execing SQLPLUS/SVRMGR process...
m_bReaderStarted: false
Starting Reader Thread...
---- Progress Needed:=true
Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
setting Fatal Error: ORA-01092
setting Fatal Error: ORA-01034
setting Fatal Error: ORA-03114
setting Fatal Error: ORA-12560
setting Ignorable Error: ORA-01109
messageHandler being set=null
Executing Step : INSTANCE_CREATION
messageHandler being set=null
m_sortOn:-1 sortOn:4
bRacOn = false
Check made for oratab arg passed............
AddEntry=
getEditEntry cmd=
oracleHomeKey: SOFTWARE\ORACLE\KEY_OraDb10g_home1
messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@6f27f79d
Instance Creation went fine..........
db_recovery_file_dest=D:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size=2147483648
old Spool= null
Setting Spool= D:\oracle\product\10.2.0\db_1\cfgtoollogs\dbca\orcl\CloneRmanRestore.log
Is spool appendable? --> true
starting with pfile=D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora
开始怀疑是操作系统的问题，然后我在vmware虚拟机上安装Windows Server 2008 R2 X64然后安装数据库顺利通过，之后让管理员安装企业版的系统，再安装orace问题还是存在。
三、解决办法
因为是正版的就打电话给oracle咨询，几经周折后得知需要安装补丁，编号：8202632，这个补丁需要的安装办法：
[*]安装数据库的时候不要选择“创建数据库”选项
[*]安装完成后安装补丁8202632，注意这个步骤在安装的时候选择安装数据库的时候home路径（例如C:\oracle\product\10.2.0\db_1）
[*]补丁安装完成之后再运行“Database Configuration Assistant”创建数据库。
补丁8202632下载地址：ftp://updates.oracle.com/8202632/p8202632_10205_MSWIN-x86-64.zip
补充下载地址:http://antoshenka-o.zakadum.ru/10.2.0.5.0%20PATCH%20SET%20FOR%20ORACLE%20DATABASE%20SERVER/x64/p8202632_10205_MSWIN-x86-64.zip
页:
[1]