Fix error during startup with SPFILE in Oracle

Fixed error with SPFILE parameter in Oracle

Error:
Generate error with alert command to change any parameter which caused error during startup.


SQL> alter system set processes=0 scope=spfile;
System altered.

SQL> shutdown immediate
ORACLE instance shut down.

SQL> startup
Database mounted.
ORA-00020: maximum number of processes () exceeded
Process ID: 23928
Session ID: 26 Serial number: 59446

Solution:
Fixed the SPFILE issue by creating PFILE. You can edit the PFILE for change valid value for the parameter or remove that parameter from the file, so that Oracle automatically pick default value. You can get old value from alert log file.

Create the PFILE from SPFILE.

SQLPLUS / as sysdba
create pfile='D:\initfixed.ora' from spfile;
File created.

Edit the PFILE in notepad .
If you know the exact value then replace it (get from alert log file) otherwise remove the parameter from PFILE and save it.

-- In example, Removed following entry from pfile and save it.
*.processes=0

Create SPFILE from PFILE.

SQL> create spfile from pfile='D:\initfixed.ora';
File created.

Start the database.

SQL> startup
ORACLE instance started.
Total System Global Area 1610609464 bytes
Fixed Size                  9028408 bytes
Variable Size            1258291200 bytes
Database Buffers          335544320 bytes
Redo Buffers                7745536 bytes
Database mounted.
Database opened.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.