windows下多CPUOracle10.2.0.4无法启动

文章版权所有Jusin Hao（luckyfriends），支持原创，转载请注明。

1.1. 在windows下多CPUOracle10.2.0.4无法启动(20111021)

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

COMP_NAME VERSION STATUS

------------------------------ ----------------------

Oracle Database Catalog Views 10.2.0.4.0 VALID

Oracle Database Packages and Types 10.2.0.4.0 VALID

Oracle Workspace Manager 10.2.0.4.3 VALID

JServer JAVA Virtual Machine 10.2.0.4.0 VALID

Oracle XDK 10.2.0.4.0 VALID

Oracle Database Java Packages 10.2.0.4.0 VALID

Oracle Expression Filter 10.2.0.4.0 VALID

Oracle Data Mining 10.2.0.4.0 VALID

Oracle Text 10.2.0.4.0 VALID

Oracle XML Database 10.2.0.4.0 VALID

Oracle Rule Manager 10.2.0.4.0 VALID

Oracle interMedia 10.2.0.4.0 VALID

OLAP Analytic Workspace 10.2.0.4.0 VALID

Oracle OLAP API 10.2.0.4.0 VALID

OLAP Catalog 10.2.0.4.0 VALID

Spatial 10.2.0.4.0 VALID

Oracle Enterprise Manager 10.2.0.4.0 VALID

通过BIOS 修改CPU个数为ALL(6*8)

重启服务器后，发现数据库没有启动，如下

日志报错：

Current log# 1 seq# 1 mem# 0: F:\NCDATA\UFNC\REDO01.LOG

Successful open of redo thread 1

Fri Oct 21 23:29:50 2011

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Fri Oct 21 23:29:50 2011

SMON: enabling cache recovery

Fri Oct 21 23:29:51 2011

Successfully onlined Undo Tablespace 1.

Fri Oct 21 23:29:51 2011

SMON: enabling tx recovery

Fri Oct 21 23:29:51 2011

Database Characterset is ZHS16GBK

Opening with internal Resource Manager plan

where NUMA PG = 5, CPUs = 4

replication_dependency_tracking turned off (no async multimaster replication found)

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.

Completed: alter database open

Fri Oct 21 23:29:55 2011

db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

启动报错：

shutdown abort后再startup，alert日志中没有任何信息输出；

利用服务启动报错，alert日志中没有任何信息输出；

udump目录下的trace文件中有报错

racle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

Process Id: 0x00000a40 Thread Id : 0x00000488 Time : Sat Oct 22 00:42:52

Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

------------------- Registers ----------------------------

ip=00000000008D9BA0 sp=000000000C1197F0 rp=000000000C11A338

r1=0000000000000030 r2=0000000078EE079A r3=0000000000000000

r4=000000000001F9EC r5=000000000C1197F0 r6=000000000C11A338 r7=000000000C11A338

r8=0000000000000000 r9=0000000000000000 r10=0000000000000000 r11=0000000000000000

r12=0000000000000246 r13=0000000000000001 r14=000007FFCD15A1B8 r15=0000000000000000

------------------- End of Registers ---------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Windows NT Version V5.2 Service Pack 2

CPU : 48 - type 8664, 4 Physical Cores

Process Affinity : 0x0000000000000000

Memory (Avail/Total): Ph:30765M/32754M, Ph+PgF:32678M/33845M

Instance name: ufnc

Redo thread mounted by this instance: 0

Oracle process number: 0

Windows thread id: 1160, image: ORACLE.EXE (SHAD)

*** 2011-10-22 00:42:52.484

ksedmp: internal or fatal error

Abrupt exit from ksedmp in Exception Handler

*** 2011-10-22 00:42:52.515

ksedmp: internal or fatal error

ksedmp: error stack dump failed earlier. not retrying

Current SQL information unavailable - no session.

check trace file d:\oracle\product\10.2.0\db_1\rdbms\trace\ufnc_ora_0.trc for preloading .sym file messages

----- Call Stack Trace -----

calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------

slsupdatestat+820 0000000000000000 000000000 000000000 000000000

000000000

slsgetstat+76 CALL??? slsupdatestat+820 000000001 003C8B118 0000000AA

00001F9EC

ksunfy+2990 CALL??? slsgetstat+76 003C8A9C4 000000000 00C119FB0

008173A98

解决方法：

安装oracle 10.2.0.5补丁，然后开启服务器所有cpu，启动数据库没问题；

oracle补丁下载合集：

http://www.oracledatabase12g.com/archives/oracle%E5%AE%89%E8%A3%85%E4%BB%8B%E8%B4%A8%E5%8F%8A%E8%A1%A5%E4%B8%81%E9%9B%86%E4%B8%8B%E8%BD%BD%E5%9C%B0%E5%9D%80%E8%A1%A5%E5%85%A8%E7%89%88.html

windows 2003 64 oracle 10.2.0.5补丁

https://updates.oracle.com/Orion/PatchDetails/handle_plat_lang_change?plat_lang=46P&patch_file=&file_id=&password_required=&password_required_readme=&merged_trans=&aru=12794232&patch_num=8202632&patch_num_id=1253975&default_release=80102050&default_plat_lang=233P&default_compatible_with=&patch_password=&orderby=&direction=&no_header=0&sortcolpressed=&tab_number=

windows 2003 64 oracle 10.2.0.4补丁

https://updates.oracle.com/Orion/SimpleSearch/process_form?search_type=patch&patch_number=6810189&plat_lang=233P&display_type=&search_style=8&orderby=3&direction=d&old_type_list=&gobuttonpressed=&sortcolpressed=&tab_number=&c_release_parent=product&c_product_child=release

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14710393/viewspace-1097174/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14710393/viewspace-1097174/