oracle 11g 修改内存示例

增加Oracle内存示例：

环境：集群环境Oracle 11.2.0.0.4

脚本示例如下

操作系统修改shm 为3072M ，sqlplus中备份spfile生成pfile，修改pfile中mem参数，使用pfile启动，创建spfile，完毕。

[root@rac2 ~]# df -h | grep shm
tmpfs                    1.9G  459M  1.5G  25% /dev/shm
[root@rac2 ~]# grep /etc/fstab
^C
[root@rac2 ~]# grep shm /etc/fstab
[root@rac2 ~]# vi /etc/fstab 
[root@rac2 ~]# grep shm /etc/fstab
tmpfs /dev/shm                    tmpfs    defaults,size=3072m        0 0
[root@rac2 ~]# mount -o remount tmpfs
[root@rac2 ~]# df -h | grep shm
tmpfs                    3.0G  459M  2.6G  15% /dev/shm
[root@rac2 ~]# 

　　fstab文件如下

[root@rac2 ~]# cat /etc/fstab 
 
#
# /etc/fstab
# Created by anaconda on Tue Sep 14 23:19:16 2021
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/centos-root /                       xfs     defaults        0 0
UUID=e123d649-cfa2-45f6-b49c-eb994a56c914 /boot                   xfs     defaults        0 0
/dev/mapper/centos-swap swap                    swap    defaults        0 0
tmpfs /dev/shm                    tmpfs    defaults,size=3072m        0 0
[root@rac2 ~]# 

sqlplus 中操作如下：

[oracle@rac2 ~]$ sqlplus / as sysdba 
 
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 17 00:23:13 2021
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
 
SQL> show parameter sga
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
lock_sga                 boolean     FALSE
pre_page_sga                 boolean     FALSE
sga_max_size                 big integer 1520M
sga_target               big integer 0
SQL> create pfile="001.ora" from spfile;
create pfile="001.ora" from spfile
             *
ERROR at line 1:
ORA-02236: invalid file name
 
 
SQL> create pfile='001.ora' from spfile;
 
File created.
 
SQL> ho vi /u01/app/oracle/product/11.2.0/db_1/dbs/001.ora
 
SQL> startup force pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/001.ora';
ORACLE instance started.
 
Total System Global Area 2137886720 bytes
Fixed Size          2254952 bytes
Variable Size        1275070360 bytes
Database Buffers      855638016 bytes
Redo Buffers            4923392 bytes
Database mounted.
Database opened.
 
SQL> show parameter sga
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
lock_sga                 boolean     FALSE
pre_page_sga                 boolean     FALSE
sga_max_size                 big integer 2G
sga_target               big integer 0
SQL> create spfile from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/001.ora';
 
File created.
 
SQL> startup force 
ORACLE instance started.
 
Total System Global Area 2137886720 bytes
Fixed Size          2254952 bytes
Variable Size        1275070360 bytes
Database Buffers      855638016 bytes
Redo Buffers            4923392 bytes
Database mounted.
Database opened.
SQL> 

　　修改完毕。

　　001.ora 文件参考

[root@rac2 ~]# cat /u01/app/oracle/product/11.2.0/db_1/dbs/001.ora
rac1.__db_cache_size=587202560
rac2.__db_cache_size=587202560
rac1.__java_pool_size=16777216
rac2.__java_pool_size=16777216
rac1.__large_pool_size=33554432
rac2.__large_pool_size=33554432
rac1.__pga_aggregate_target=637534208
rac2.__pga_aggregate_target=637534208
rac1.__sga_target=956301312
rac2.__sga_target=956301312
rac1.__shared_io_pool_size=0
rac2.__shared_io_pool_size=0
rac1.__shared_pool_size=301989888
rac2.__shared_pool_size=301989888
rac1.__streams_pool_size=0
rac2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/rac/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.4.0'
*.control_files='+DATA/rac/controlfile/current.260.1083455781'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='rac'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racXDB)'
rac2.instance_number=2
rac1.instance_number=1
#*.memory_target=1588592640
*.memory_target=2048m
*.open_cursors=300
*.processes=150
*.remote_listener='rac-scan:1521'
*.remote_login_passwordfile='exclusive'
rac2.thread=2
rac1.thread=1
rac1.undo_tablespace='UNDOTBS1'
rac2.undo_tablespace='UNDOTBS2'
[root@rac2 ~]# 