ORA-27100 Error resolution of Oracle in Windows system

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/