DG修改SGA 遇ORA-00845

oracle 11G: 生成PFILE文件: create pfile=/home/oracle/initorcl.ora from spfile; 修改PFILE中的*.memory_target=536870912 值。 然后重啟數據庫從新的PFILE文件啟動到NOMOUNT狀態。 SQL startup nomount pfile=/home/Oracle/initorcl.ora; ORA-00845: ME

Oracle 11G: 生成PFILE文件: create pfile=’/home/oracle/initorcl.ora’ from spfile;
修改PFILE中的*.memory_target=536870912 值。
然后重啟數據庫從新的PFILE文件啟動到NOMOUNT狀態。
SQL> startup nomount pfile=’/home/Oracle/initorcl.ora’;

ORA-00845: MEMORY_TARGET not supported on this system
原因是這個值大過了/dev/shm的值。
df -k /dev/shm
Filesystem?????????? 1K-blocks????? Used Available Use% Mounted on
tmpfs?????????????????? 517600???????? 0??? 517600?? 0% /dev/shm
解決方法:
修改FSTAB
vi /etc/fstab
/dev/VolGroup00/LogVol00 /?????????????????????? ext3??? defaults??????? 1 1
LABEL=/boot???????????? /boot?????????????????? ext3??? defaults??????? 1 2
tmpfs?????????????????? /dev/shm??????????????? tmpfs?? defaults,size=1024m??????? 0 0
devpts????????????????? /dev/pts??????????????? devpts? gid=5,mode=620? 0 0
sysfs?????????????????? /sys??????????????????? sysfs?? defaults??????? 0 0
proc??????????????????? /proc?????????????????? proc??? defaults??????? 0 0
/dev/VolGroup00/LogVol01 swap??????????????????? swap??? defaults??????? 0 0
重新掛載:
[root@localhost ~]# umount /dev/shm
[root@localhost ~]# mount /dev/shm
[root@localhost ~]# df -h /dev/shm
Filesystem??????????? Size? Used Avail Use% Mounted on
tmpfs???????????????? 1.0G???? 0? 1.0G?? 0% /dev/shm

再次啟動數據庫
SQL> startup pfile=’/home/Oracle/initorcl.ora’;
Oracle instance started.

Total System Global Area? 535662592 bytes
Fixed Size????????????????? 1337720 bytes
Variable Size???????????? 327157384 bytes
Database Buffers????????? 201326592 bytes
Redo Buffers??????????????? 5840896 bytes
Database mounted.
Database opened.
SQL> show sga

Total System Global Area? 535662592 bytes
Fixed Size????????????????? 1337720 bytes
Variable Size???????????? 327157384 bytes
Database Buffers????????? 201326592 bytes
Redo Buffers??????????????? 5840896 bytes
SQL> select 535662592/1024/1024 from dual;

535662592/1024/1024
——————-
???????? 510.847656

可 以看到已經修改過來了。

最后驗證同步功能。

? 版權聲明
THE END
喜歡就支持一下吧
點贊14 分享