It is well known that a new file is introduced in the management of initialization parameters in Oracle9i: SPFILE. This parameter is a binary file, and it will be erroneously written by hand. It can be modified by ALTER SYSTEM SET ....
Not a wonderful, sometimes, the wrong modification of the parameters found that the system can not start, and the careless user or primary DBA may not have a backup of the file (or the contents of the parameter file).
How to solve this time?
Below is a scenario in an error:
SQL> Connect / as SYSDBA is connected. SQL> Show Parameter SPFILE
Name Type Value ------------------------------- --------------- Spfile string% Oracle_Home% / Database / SPFILE% Oracle_sid%. Oracle
# Use SPFile
SQL> Show Parameter DB_Cache_SIZE;
Name Type Value ---------------------------------------------- -------------- DB_Cache_Size Big Integer 67108864
SQL> ALTER SESTEM SET DB_CACHE_SIZE = 671088640000000 Scope = SPFILE;
The system has changed.
#WeWe we will "wrong adjustment" in the previous step
SQL> Shutdown Immediate; Database has been turned off. The database has been uninstalled. Oracle routines have been closed.
SQL> StartUpora-27102: Out of memoryosd-00029: Message 29 Not Found; Product = RDBMS; Facility = SOSD
O / S-Error: (OS 8)? 洢 ?? ? ? ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?????? ? ? SQL>
# 错 错 出, can not start the database.
Some friends may have seen "9i new features: SPFILE use" (see the reference below) This article, which has such a sentence: You can link to the spfile file in Pfile, and define other parameters in the PFile, If the parameter is repeated, the parameters read later will replace the previous settings.
Slightly pay attention to this sentence, it is found to solve our current problem:
Manually created a PFILE type file, the content is as follows: spfile = 'd: /oracle/ora92/database/spfiledemo.ora' *. Db_cache_size = 67108864 There is already a DB_CACHE_SIZE parameter in the spfileDemo.ora file, the parameters read after reading Replace the previous settings. OK. Use this parameter to start the database:
SQL> Startup Pfile = 'd: /oracle/ora92/database/initdemotest.ora'oracle routine has been started.
Total System Global Area 160505408 Bytesfixed Size 454208 Bytesvariable size 92274688 bytesdatabase buffers 67108864 BYTESREDO BUFFERS 667648 BYTES Database Database Database Loading. The database has been opened. The thing you have to do immediately is to back up the content of spfile:
SQL> CREATE PFILE = 'D: /oracle/ora92/Database/initdemo.ora' from spfile;
The dead sheep is completed, remember to make a backup before modifying the initialization parameters.
Reference:
"9i new features: SPFILE use" (Eygle masterpiece, ITPUB e-magazine fourth phase) download address: http://www.itpub.net/magazine/itpub200304.rar
"Oracle9i Database Administrator's Guide Release 2 (9.2)" Download Address: http://tahiti.oracle.com
http://www.google.com
This article is from:
