|
6.查察集群SCAN VIP信息（参考示例）
$ srvctl config scan
SCAN name: scan-ip,Network: 1/192.168.248.0/255.255.255.0/eth0
SCAN VIP name: scan1,IP: /scan-ip/192.168.248.110
$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
7.启、停集群数据库
整个集群的数据库启停
进入grid用户
$ srvctl stop database -d orcl
$ srvctl status database -d orcl
$ srvctl start database -d orcl
封锁全部节点
进入root用户
封锁全部节点
# /u01/app/11.2.0/grid/bin/crsctl stop crs
现实只封锁了当前结点
启动进程呈现的非常（因为内存不足后头低落了内存从头启动假造机）：
报错：ORA-00845: MEMORY_TARGET not supported on this system
$ srvctl start database -d orcl
PRCR-1079 : Failed to start resource ora.orcl.db
ORA-00845: MEMORY_TARGET not supported on this system
CRS-2674: Start of ‘ora.orcl.db‘ on ‘rac1‘ failed
CRS-2632: There are no more servers to try to place resource ‘ora.orcl.db‘ on that would satisfy its placement policy
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
ORA-00845: MEMORY_TARGET not supported on this system
CRS-2674: Start of ‘ora.orcl.db‘ on ‘rac2‘ failed
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
办理步伐：
加大/dev/shm，使他大于体系参数，因为停机后无法获取体系参数，在此可以配置一个总内存巨细：
#cat /etc/fstab | grep tmpfs
tmpfs /dev/shm tmpfs defaults,size=4G 0 0
#mount -o remount,size=4G /dev/shm
#df -h | grep shm
tmpfs 4.0G 0 4.0G 0% /dev/shm
接着从头启动即可，然后进入数据库修改内存
$ sqlplus / as sysdba
SQL> show parameter target; 个中/dev/shm必需大于MEMORY_TARGET，必要做修改下面2个值，改完必要从头启动数据库
sql> alter system set memory_max_target=12288M scope=spfile;
sql> alter system set memory_target=12288M scope=spfile;
（编辑：湖南网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
