When the number of logical CPUs on windows hosts is more than 32, Database startup hangs and databasehangs

Source: Internet
Author: User

When the number of logical CPUs on windows hosts is more than 32, Database startup hangs and databasehangs

Bug 9772171-Database startup hangs on Windows when machine has more than 64 cores [9772171.8]

If you use a specific version of oracle db in windows (especially a single machine, non-rac), if the number of windows logical CPUs exceeds 32, the oracle db may not start up, or the db may be abnormal: memory overflow.
In this case, a bug is basically hit,

This bug is: Bug 9772171-Database startup hangs on Windows when machine has more than 64 cores [9772171.8]

The impact scope of this bug is:

Product (Component) Oracle Server (Rdbms)
Range of versionsBelievedTo be affected Versions belowner 12.1
VersionsConfirmedAs being affected
  • 11.2.0.1
  • 11.1.0.7
  • 10.2.0.4
Platforms affected
  • Windows 64bit (AMD64/EM64T)
  • Windows/NT/XP


The bug is fixed in the following versions:

This issue is fixed in
  • 12.1.0.1 (Base Release)
  • 11.2.0.2 (Server Patch Set)
  • 11.2.0.1 Patch 5 on Windows Platforms
  • 11.1.0.7 Patch 33 on Windows Platforms
  • 10.2.0.5 Patch 16 on Windows Platforms
  • 10.2.0.4 Patch 39 on Windows Platforms

 


We upgraded 11.2.0.1 (x64) to 11.2.0.4 (x64) in windows in one environment. This machine has 64 logical CPUs, only oracle db of version 11.2.0.1 cannot use so many CPUs,
Therefore, from the bios of the host, only 32 logical CPUs are configured. After 11.2.0.4 is upgraded, restart the OS and set it to 64 logical CPUs in the bios. Then, the oracle 11.2.0.4 database starts smoothly.
Therefore, the problem was solved smoothly.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.