Follow the steps to restore the pfile
peri@dbsvrum2kADOT2 sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 13 18:21:12 2015
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup pfile=/opt/oracle/dbs/spfileum2k.ora
LRM-00109: could not open parameter file '/opt/oracle/dbs/spfileum2k.ora'
ORA-01078: failure in processing system parameters
SQL> startup pfile=/u01/oracle/dbs/spfileum2k.ora
LRM-00123: invalid character 0 found in the input file
ORA-01078: failure in processing system parameters
SQL> startup pfile=/u01/oracle/dbs/pfileUM2k.ora
ORACLE instance started.
Total System Global Area 2684354560 bytes
Fixed Size 2032544 bytes
Variable Size 1426070624 bytes
Database Buffers 1241513984 bytes
Redo Buffers 14737408 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2684354560 bytes
Fixed Size 2032544 bytes
Variable Size 1073749088 bytes
Database Buffers 1593835520 bytes
Redo Buffers 14737408 bytes
Database mounted.
Database opened.
SQL>
login as: peri
Using keyboard-interactive authentication.
Password:
Last login: Tue Oct 13 17:40:04 2015 from mpsadoaap1-c
If you are not authorized to use this system, disconnect now.
The system may be monitored or recorded without notice or permission.
You have new mail.
peri@dbsvrum2kADOA1 sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 13 18:18:52 2015
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> show parameters pfile
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
spfile string
/u01/oracle/dbs/spfileum2k.ora
SQL>
in some situations when the startup does not start and still persist with the same errors
a) check the alert_um2k.log in /u01/oracle/rdbms/log folder
Wed Jan 20 16:08:47 2016
ERROR: Current internal value of shared_pool_size is 352321536 bytes
Hence, shared_pool_reserved_size can not be more than 176160768 bytes
In general, it is not advisable to set shared_pool_reserved_size
without setting shared_pool_size explicitly
b) edit the pfile with the setting shown in bold and underlined for the variable *.shared_pool_reserved_size=176160768 and save the file and restart them using startup and all should be fine
