ORA-03113/03114 Processing

Source: Internet
Author: User

ORA-03113/03114 handle if the database does not set the correct OS core variable during installation, it may be okay when installing the database file, when creating a database, the error 03113 is often returned. Another reason for this is that the processes parameter in the init. ora parameter file specifies an unreasonable value, causing an error when the database is started (of course, this is also the core parameter problem in the final analysis ). This error message is generally as follows: ORA-03113: end-of-file on communication channelORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist solution has two: 1. Modify core parameters, increase the value of the corresponding core parameter (recommended); 2. Reduce init. the Processes value of the ora parameter. Note that SEMMSL must be set to at least 10 + 'maximum Number of processs', and SEMMNS also depends on the process parameter values of each database. Note: This error type only appears on Unix platforms. On Windows, if the processes value is too large, an error similar to the following occurs: ORA-00068: invalid value 24200001 for parameter max_rollback_segments, must be between 2 and 65535/* The specified parameter value exceeds 65535 */or a large parameter value with ORA-27102: out of memory/* Less Than 65535 */software environment: windows 2000 Version 5.0 Service Pack 3, CPU type 586 oracle rdbms Version: 8.1.7.0.0

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.