startup ORA-00064: object is&nb..."/>
您好,登錄后才能下訂單哦!
在processes設(shè)置過大后,可能導(dǎo)致數(shù)據(jù)庫打不開,開啟數(shù)據(jù)庫后會(huì)報(bào)錯(cuò):
SQL> startup ORA-00064: object is too large to allocate on this O/S (1,7746920) SQL>
首先找到pfile位置,然后從pfile啟動(dòng)數(shù)據(jù)庫;
startup pfile=$ORACLE_BASE/admin/SID/pfile/init.ora.49201715235'
pfile一般在$ORACLE_BASE/admin/$ORACLE_SID/pfile目錄下。
找到spfile位置。然后用spfile生成pfile;
create pfile='/tmp/pfile.ora' from spfile='+DATADG/SID/spfileSID.ora'
spfile文件位置會(huì)在文件$ORACLE_HOME/dbs/init${ORACLE_SID}.ora文件中標(biāo)明。
修改新生成的pfile,把process值改小后,用pfile生成spfile;
create spfile='+DATADG/SID/spfileSID.ora' from pfile='/tmp/pfile.ora';
重啟數(shù)據(jù)庫后執(zhí)行 show parameter spfile,查看當(dāng)前spfile位置,如果位置和 $ORACLE_HOME/dbs/init${ORACLE_SID}.ora文件中標(biāo)明的位置不一致,請把當(dāng)前的spfile別名后,重新啟動(dòng)數(shù)據(jù)庫。
查看spfile的位置
[oracle@kdb01 ~]$ more /opt/oracle/product/10.2.0/db_1/dbs/initkhadb1.ora SPFILE='+MYDATA/khadb/spfilekhadb.ora'
用spfile生成pfile
SQL> SQL> startup ORA-00064: object is too large to allocate on this O/S (1,7746920) SQL> startup pfile='/opt/oracle/admin/khadb/pfile/init.ora.492017152117'; ORACLE instance started. Total System Global Area 343932928 bytes Fixed Size 2096152 bytes Variable Size 113247208 bytes Database Buffers 222298112 bytes Redo Buffers 6291456 bytes Database mounted. Database opened. SQL> SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> SQL> create pfile='/tmp/pfile.ora' from SPFILE='+MYDATA/khadb/spfilekhadb.ora'; File created.
修改新生成的pfile,把process值改小后,用pfile生成spfile
SQL> create SPFILE='+MYDATA/khadb/spfilekhadb.ora' from pfile='/tmp/pfile.ora'; File created.
重啟數(shù)據(jù)庫,查看processes設(shè)置
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 343932928 bytes Fixed Size 2096152 bytes Variable Size 142607336 bytes Database Buffers 192937984 bytes Redo Buffers 6291456 bytes Database mounted. Database opened. SQL> show parameter processes; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ aq_tm_processes integer 0 db_writer_processes integer 1 gcs_server_processes integer 1 job_queue_processes integer 10 log_archive_max_processes integer 2 processes integer 1000 SQL> SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string +MYDATA/khadb/spfilekhadb.ora SQL>
當(dāng) PROCESSES > 1500時(shí),候需要確保ksmg_granule_size=16M or 32M;而ksmg_granule_size大小是根據(jù)sga_max_size來決定,當(dāng)sga_max_size<=1024時(shí),ksmg_granule_size=4M;sga_max_size是根據(jù)sga_target來決定的,修改sga_target>=1025M即可;
此處通過下面的方法,先恢復(fù)數(shù)據(jù)庫,后續(xù)可根據(jù)自己規(guī)劃先修改sga_target后,再修改process值
alter system set sga_target=1200m scope=spfile
修改sga_target=1200M,重啟數(shù)據(jù)庫時(shí),sga_max_size=1200m;
select x.ksppinm name,y.ksppstvl value,x.ksppdesc descbtion from x$ksppi x,x$ksppcv y where x.inst_id=userenv('Instance') and y.inst_id=userenv('Instance') and x.indx=y.indx and x.ksppinm like '%_ksmg_granule%';
查看ksmg_granule_size大小。當(dāng)SGA足夠大時(shí),我們可以手動(dòng)設(shè)置 _ksmg_granule_size=32MB;
alter system set "_ksmg_granule_size"=33554432 scope=spfile;
再根據(jù)自己的需求修process大小
alter system set sessions=10000 scope=spfile;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。