Tuesday 24 November 2015

ORA-32001: write to SPFILE requested but no SPFILE specified at startup


Sol:
SQL> show parameter spfile

NAME TYPE                VALUE
------------------------------------ ----------- ------------------------------
spfile                             string

SQL> show parameter pfile

NAME TYPE                VALUE
------------------------------------ ----------- ------------------------------
spfile                            string
SQL> show parameter dump
NAME TYPE                     VALUE
------------------------------------ ----------- ------------------------------
background_core_dump  string partial
background_dump_dest string /slot/oracle/11.2.0/log/diag/rdbms/oracledb1/oracledb1/trace
core_dump_dest string /slot/oracle/11.2.0/log/diag/rdbms/oracledb1/oracledb1/cdump
max_dump_file_size string 10M
shadow_core_dump string PARTIAL
user_dump_dest string /slot/oracle/11.2.0/log/diag/rdbms/oracledb1/oracledb1/trace
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 2154590208 bytes
Fixed Size 2230112 bytes
Variable Size 1325402272 bytes
Database Buffers 805306368 bytes
Redo Buffers 21651456 bytes
Database mounted.
Database opened.

SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /slot/oracle/11.2.0/dbs/spfileoracledb1.ora
SQL> ALTER SYSTEM SET processes = 5000 SCOPE=SPFILE;

System altered.

No comments:

Post a Comment