|
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;
（编辑：晋中站长网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
