ORA-27100 Error resolution of Oracle in Windows system

Source: Internet
Author: User
Tags windows x86 sqlplus

Ora-27100:shared Memory realm already exists error resolution

Database ora-27100:shared memory realm already exists error resolution

Environment:

Operating system platform Windows Service 2003 R2 x86

Database version Oracle Enterprise 9.2.0.1 for Windows x86

Today, a customer database is not open, reported ora-27100:shared memory realm already exists error. To view related documents, an error is generally due to the memory parameter setting does not

When caused. The idea of solving the problem is to create the pfile first, then modify the pfile parameters, save the modified parameters as pfile files and then create back to SPFile, restart the Oracle phase again

Off the service can be.

Problem Description: Database open error: ora-27100:shared memory realm already exists.

Problem diagnosis: There is a problem with the parameter file configuration.

Process and steps to solve the problem

Workaround One,

1, Backup. All parameter files including Spfile,pfile are backed up to the desktop.

2. Execute create Pfile from SPFile inside Sqlplus

3. Only pfile files created by the second step are retained, all others are deleted.

4, with Ultredit tools to modify the Pfile, note: The size of the SGA can not exceed the other parts of the 1.7G,SGA can not add up to super

The size of the sga_max_size configuration, and note that the maximum unit size used in 9i can only be m. My configuration is as follows:

sga_max_size=700m

db_cache_size=400m

java_pool_size=30m

large_pool_size=80m

shared_pool_size=150m

5, after the completion of the modification, save exit, and check the file suffix name is. ora

6, execute the Create SPFile from pfile command creation SPFile, remember, do not enter Sqlplus to execute Starup Qicu.

7, in the cmd command to execute the services.msc command to start the Service Manager, all the Oracle services are stopped, is all, and manually instead.

8, restart the server

9, manual Oracle's listening and instance service.

10, through the sqlplus into the database, the implementation of select Instance_name,status from V$instance this time the state of the database should be open.

11, the failure to handle the finished.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

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.