修改ORACLE 系统参数导致的 ORA-00064 ,ora-32001

 

本来想修改系统的PROCESSES , SESSIONS 等参数, 却遇到

ORA-00064: object is too large to allocate on this O/S (1,440000012)

ora-32001 :write to spfile requested but

经过查资料及自己的摸索,终于解决了

以下是操作LOG :

SQL> create spfile from pfile;

File created.

if we don't create spfile from the pfile , we will get the :ora-32001 :write to spfile requested but......

SQL> alter system set processes=99999999 scope=spfile;

System altered.

SQL> alter system set sessions=99999999 scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00064: object is too large to allocate on this O/S (1,440000012)
SQL> startup
ORA-00064: object is too large to allocate on this O/S (1,440000012)
SQL> alter system set sessions=9999 scope=spfile;
alter system set sessions=9999 scope=spfile
*
ERROR at line 1:
ORA-01034: ORACLE not available
--if we haven't started the oracle , cann't modify the amount of sessions or processes.

--use another session window open and modify $ORACLE_HOME/dbs/initPROD.ora
--modify session =100 , processes=100.

--then :
SQL> startup pfile=$ORACLE_HOME/dba/initPROD.ora
LRM-00109: could not open parameter file '/oraebs/d01/oracle/proddb/9.2.0/dba/initPROD.ora'
ORA-01078: failure in processing system parameters
SQL> startup pfile=$ORACLE_HOME/dbs/initPROD.ora
ORACLE instance started.

Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
Database mounted.

though it had some errors , but this method is effective. the Oracle started!

SQL> create spfile from pfile;

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
Database mounted.
Database opened.
SQL> show parameters processes;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
job_queue_processes integer 2
log_archive_max_processes integer 2
processes integer 100
SQL> show parameters sessions;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
mts_sessions integer 0
sessions integer 115 --- why 115? not 100?shared_server_sessions integer 0

--modify the parameters once more :
SQL> alter system set processes=999 scope=spfile;

System altered.

SQL> alter system set sessions=999 scope=spfile;

System altered.

SQL> startup
ORACLE instance started.

Total System Global Area 598283904 bytes
Fixed Size 452224 bytes
Variable Size 419430400 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
Database mounted.
Database opened.

successfuly change the amount of processes /sessions 200/400 to 999!

 

From:http://blog.itpub.net/post/15182/485340