whenever you execute a command
SQL> startup nomount
ORA-27100: shared memory realm already exists
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Problem
====================
Some changes are made in sga_max_size or sga parameters.
After that database is abnormally shut down whenever you issue startup,
ORA-27100 is received as a result of changes made to parameters affecting the SGA size.
Solution
=====================
In most cases, ORA-27100 can be resolved by simply restarting Windows.
Otherwise
start the database with pfile .
SQL> startup pfile= loacation_of_pfile;
create spfile from pfile='location' ;
Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Sunday, September 20, 2009
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment