达梦æ°æ®åºâ
åæºå®è£ é¨ç½²æ¹æ¡â
达梦æ°æ®åºâ
2022 å¹´09 æâ
ç®å½â
ââ第ä¸ç« å®è£ ååå¤ 3âââ
ââ1.1硬件åæä½ç³»ç»å¹³å° 3âââ
ââ1.2ç³è¯·å¹é ççæ¬ 4âââ
ââ第äºç« å®è£ åè§å 4âââ
ââ2.1è§åå®è£ è·¯å¾ 4âââ
ââ2.2 è§åæ°æ®åºåå§ååæ° 4âââ
ââ2.2.1 é¡µå¤§å° 4âââ
ââ2.2.2 æ¥å¿æä»¶å¤§å° 5âââ
ââ2.2.3 æ¶åºè®¾ç½® 5âââ
ââ2.2.4 å符串æ¯è¾å¤§å°ææ 5âââ
ââ2.2.5 å符é 5âââ
ââ2.2.6 VARCHARç±»å以å符为åä½ 5âââ
ââ2.2.7 æ¹è¿å符串HASHç®æ³ 5âââ
ââ第ä¸ç« å®è£ æ°æ®åº 6âââ
ââ3.1 å®è£ åçæ£æ¥ 6âââ
ââ3.1.1 å ³éé²ç«å¢,å¼æºç¦æ¢èªå¨å¯å¨é²ç«å¢ 6âââ
ââ3.1.2 ç¦æ¢selinux 6âââ
ââ3.1.2 æä½ç³»ç»å ååæ°æ£æ¥ 7âââ
ââ3.2 å建ç¨æ·åç¨æ·ç» 7âââ
ââ3.3 ç£çååæ åµ 11âââ
ââ3.4 æ£æ¥ç³»ç»åæ°éå¶ 11âââ
ââ3.4.1 ä¿®æ¹limits.confåæ° 11âââ
ââ3.4.2 ç£çè°åº¦ç®æ³æ£æ¥ 12âââ
ââ3.5 æ°æ®åºå®è£ 12âââ
ââ3.5.1 æè½½éå 12âââ
ââ3.5.2 æ°æ®åºå®è£ 13âââ
ââ3.5.3 ç¯å¢åéé ç½® 20âââ
ââ3.6é ç½®å®ä¾ 20âââ
ââ3.6.1 å½ä»¤è¡é ç½®å®ä¾ 21âââ
ââ3.6.2 æå¨å¾å½¢åé ç½®å®ä¾ 22âââ
ââ3.7注åæå¡ 27âââ
ââ3.7.1 å½ä»¤è¡æ³¨å 27âââ
ââ3.7.2å¾å½¢å注åæå¡ 28âââ
ââ3.8å¯å¨ï¼åæ¢æ°æ®åº 30âââ
ââ第åç« æ°æ®åºå½æ¡£,å¤ä»½,åæ°ä¼å 31âââ
ââ4.1 æ°æ®åºå½æ¡£(两ç§æ¹å¼) 31âââ
ââ4.1.1 å½ä»¤è¡æ¨¡å¼é ç½®å½æ¡£ 31âââ
ââ4.1.2 å¾å½¢åçé¢é ç½®å½æ¡£ 31âââ
ââ4.2æ°æ®åºå¤ä»½(å ¨å¤,å¢éå¤ä»½,å®æ¶å é¤30天åå¤ä»½) 34âââ
ââ4.2.1 æ°æ®åºå ¨åºå¤ä»½ 34âââ
ââ4.2.2 å¢éå¤ä»½ 37âââ
ââ4.2.3 å®æ¶å é¤å¤ä»½çç¥ 40âââ
ââ4.2 æ°æ®åºé ç½®åæ°çä¼å 42âââ
第ä¸ç« å®è£ ååå¤
1.1硬件平å°åæä½ç³»ç»
æ¬å®éªéç¨x86æ¶ææ¥æ¨¡æå®é ç产ç¯å¢å®è£ åé¨ç½²ãâ
éç¨centos 7.xçæ¬ 64ä½æä½ç³»ç»æ¥å®è£ é¨ç½²çãâ
å¨ç»ç«¯å½ä»¤è¡ä¸ï¼è·åæä½ç³»ç»å硬件信æ¯â
åæ°ä¿¡æ¯â | å½ä»¤â |
æ¥çCPUä¿¡æ¯â | cat /proc/cpuinfoâ |
æ¥çæä½ç³»ç»ä½æ°â | getconf âLONG_BITâ |
æ¥è¯¢linuxçæ¬(centos)â | Uname -aæè cat /etc/redhat-releaseâ |
æ¥è¯¢å åâ | Free -gâ |
æ¥è¯¢ç£çâ | df -hâ |
æ¥è¯¢ç½ç»â | Ifconfigâ |
1.2ç³è¯·å¹é ççæ¬
æ ¹æ®ä»¥ä¸ç硬件åæä½ç³»ç»ä¸è½½ç¸åºççæ¬â
第äºç« å®è£ åè§å
2.1è§åå®è£ è·¯å¾
- 使ç¨df -hæ¥çç£çæè½½æ åµâ
- æ ¹æ®æå¡å¨é ç½®è§åå®è£ è·¯å¾ï¼æ°æ®è·¯å¾ï¼å¤ä»½è·¯å¾â
- å®è£ è·¯å¾:建议æ¾æ¬å°ç£çâ
- æ°æ®è·¯å¾:建议æ¾åå¨æ§è½å¥½çå°æ¹ï¼å¦ç£çéµåçæè½½ç¹â
- å¤ä»½è·¯å¾:建议æ¾å¨æ°æ®çä¸åçç£çä¸â
- å½æ¡£è·¯å¾:建议æ¾å¨æ°æ®è·¯ä¸ï¼é¿å 误å â
è§åè·¯å¾â
- å®è£ è·¯å¾:/opt/dmdbmsâ
- æ°æ®è·¯å¾:/home/dameng/dataâ
- å½æ¡£è·¯å¾:/home/dameng/data/archâ
- å¤ä»½è·¯å¾:/home/dameng/bakâ
2.2 è§åæ°æ®åºåå§ååæ°
达梦æ°æ®åºåå§åå®ä¾ååå§ååæ°æ æ³ä¿®æ¹ï¼ä¸ºäºç§»æ¤ãå¼åãç»´æ¤çæ¹ä¾¿ï¼æ ¹æ®åºâ
ç¨ç¹å¾åçè§ååå§ååæ°å°¤ä¸ºéè¦ï¼ä¸é¢å¯¹ä¸äºéè¦çåå§ååæ°è¿è¡è¯¦ç»è¯´æ:â
2.2.1 页大å°
达梦æ°æ®åºé»è®¤é¡µå¤§å°æ¯8Kï¼ç产建议该åæ°è®¾ç½®32Kâ
2.2.2 æ¥å¿æ件大å°
æ¯ä¸ªDM æ°æ®åºå®ä¾å¿ é¡»è³å°æ2 个éåæ¥å¿æ件ï¼é»è®¤ä¸¤ä¸ªæ¥å¿æ件为DAMENG01.logãDAMENG02.logï¼è¿ä¸¤ä¸ªæ件循ç¯ä½¿ç¨ï¼æ¥å¿æ件å¨åå§åå®ä¾åå¯ä»¥å¢å åæ©å¤§ï¼å°åOA ç³»ç»å»ºè®®è®¾ç½®ä¸º2*2048Mï¼å¨çº¿å¤§å交æç³»ç»å»ºè®®è®¾ç½®ä¸º4*2048Mãâ
2.2.3 æ¶åºè®¾ç½®
éæ©æ¶åºåéè¦ç¡®è®¤æä½ç³»ç»æ¶åºåæ°æ®åºæ¶åºç¸å以é¿å æ¶é´å·®å¼ï¼å»ºè®®ä½¿ç¨å京â
æ¶é´+8:00ãâ
2.2.4 å符串æ¯è¾å¤§å°ææ
达梦为äºå ¼å®¹ä¸åçæ°æ®åºï¼å¨åå§åæ°æ®åºçæ¶åæä¸ä¸ªåæ°å符串æ¯è¾å¤§å°åæâ
æï¼ç¨äºç¡®å®æ°æ®åºå¯¹è±¡åæ°æ®æ¯å¦åºå大å°åï¼é»è®¤ä¸ºåºåï¼ä¸å¯æ´æ¹ã建议MYSQL â
åSQLSERVER è¿ç§»è¿æ¥çç³»ç»ï¼ä½¿ç¨å¤§å°åä¸ææï¼ORACLE è¿ç§»è¿æ¥çç³»ç»ï¼ä½¿ç¨å¤§â
å°åææï¼ä»¥ä¾¿ååæ¥ç³»ç»å¹é ãâ
2.2.5 å符é
建议éç¨é»è®¤å¼GB18030ï¼å¦æéè¦å½é å符å¯ä»¥éç¨Unicodeï¼GB18030 æ°ååæ¯å â
1 个åèï¼æ®éæ±åå 2 个åèï¼é¨åç¹ä½åå°æ°æ°ææåå 4 åèï¼Unicode å¨è¾¾æ¢¦ä¸éç¨UTF-8 ç¼ç æ ¼å¼ï¼æ¬§æ´²çåæ¯å符å 1 å°2 个åèï¼äºæ´²ç大é¨åå符å 3 个åèï¼éå å符为4 个åèãå¦æåªåå¨ä¸æååæ¯æ°åï¼ä¸è¬æ¥è¯´GB18030 æ´èç空é´ä¸äºãâ
2.2.6 VARCHARç±»å以å符为åä½
该åæ°çä½ç¨æ¯å»ºè¡¨æ¶VARCHAR çé¿åº¦æ¯æç §å符计ç®è¿æ¯åè计ç®ï¼é»è®¤ä»¥åè为â
åä½ï¼å³å段çé¿åº¦åä½æç §åè计ç®ï¼å¦æéç¨å符为åä½ï¼å段çé¿åº¦åä½æç §å符æ¥â
计ç®ï¼ä¸åçå符éä¼å¯¼è´å段é¿åº¦ä¸ä¸æ ·ï¼å®é æ大é¿åº¦åå°é¡µå¤§å°çéå¶ã建议éç¨é»â
认以åè为åä½ï¼å¦æä»MYSQL è¿ç§»çåæ¶åä¸æ¹ä¾¿æ©å¤§è¡¨ç»æçé¿åº¦ï¼éè¦è®¾ç½®ä¸ºä»¥â
å符为åä½ãâ
2.2.7 æ¹è¿å符串HASHç®æ³
å¨ä¹åç达梦çæ¬ä¸ç¨çæ§çHASH ç®æ³ï¼å¤§æ¦2016 å¹´10 æååï¼å ·ä½æ¶é´æªç¥ï¼ï¼â
ä¹åççæ¬é»è®¤ä½¿ç¨æ°HASH ç®æ³ï¼å¦ææ¯ä»ä¹åæ§çæ¬æ°æ®è¿åå°æ°çæ¬ä¸ä½¿ç¨ï¼ä¸è½â
使ç¨æ¹è¿å符串HASH ç®æ³ï¼å ¶ä»æ åµä½¿ç¨æ¹è¿å符串HASH ç®æ³ãâ
第ä¸ç« å®è£ æ°æ®åº
3.1 å®è£ åçæ£æ¥
3.1.1 å ³éé²ç«å¢,å¼æºç¦æ¢èªå¨å¯å¨é²ç«å¢
[root@DM8 ~]# systemctl status firewall ----æ¥è¯¢é²ç«å¢ç¶æâ
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5SMjN2MhhDNwYDZxkzLcBTMyIDMy8CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
[root@DM8 ~]# systemctl stop firewalldå ³éé²ç«å¢â
[root@DM8 ~]# systemctl disable firewalldç¦æ¢å¼æºå¯å¨é²ç«å¢â
ãâ
[root@DM8 ~]# firewall-cmd --permanent --znotallow=public --add-prot=5236/tcpå¼æ¾5236端å£â
[root@DM8 ~]# firewall-cmd --reloadéå¯é²ç«å¢â
3.1.2 ç¦æ¢selinux
[root@DM8 ~]# getenforceæ¥çselinuxç¶æâ
[root@DM8 ~]# vi /etc/selinux/configç¼è¾selinuxï¼æSELINUX=Enforcingæ¹ædisabledâ
[root@DM8 ~]# rebootéå¯æä½ç³»ç»â
3.1.2 æä½ç³»ç»å ååæ°æ£æ¥
Linuxæä½ç³»ç»è¦æ³¨ææ£æ¥/proc/sys/vm/overcommit_memoryæ¯å¦è®¾ç½®ä¸º1â
[root@DM8 ~]# cat /proc/sys/vm/overcommit_memoryâ
æ°¸ä¹ ä¿®æ¹:â
ç¼è¾/etc/sysctl.conf,ä¿®æ¹vm.overcommit_memory=1,ç¶åæ§è¡sysctl -p使é ç½®æ件çæ,æä½å¦ä¸:â
[root@DM8 ~]# vi /etc/sysctl.conf ---ç¼è¾/etc/sysctl.confæ·»å ä¸é¢é ç½®â
3.2 å建ç¨æ·åç¨æ·ç»
1.使ç¨rootç¨æ·å建ç»åç¨æ·:â
å建å®è£ ç¨æ·ç»dinstallâ
[root@DM8 ~]# groupadd -g 1010 dinstallâ
å建å®è£ ç¨æ·dmdbaâ
[root@DM8 ~]# useradd -u 1010 -g dinstall -m -d /home/dmdba -s /bin/bash dmdbaâ
åå§ådmdbaç¨æ·å¯ç â
[root@DM8 ~]# passwd dmdbaâ
Changing password for user dmdba.â
New password:â
Retype new password:â
passwd: all authentication tokens updated successfully.â
2.å建å®è£ è·¯å¾ï¼æ°æ®è·¯å¾ï¼å½æ¡£è·¯å¾ï¼å¤ä»½è·¯å¾å ç¸åºçæéâ
[root@DM8 ~]# mkdir /opt/dmdbmsâ
[root@DM8 ~]# mkdir -p /data/dmdataâ
[root@DM8 ~]# mkdir -p /data/dmarchâ
[root@DM8 ~]# mkdir -p /data/bakâ
[root@DM8 ~]# chown -R dmdba:dinstall /opt/dmdbms/â
[root@DM8 ~]# chown -R dmdba:dinstall /data/dmdata/â
[root@DM8 ~]# chown -R dmdba:dinstall /data/dmarchâ
[root@DM8 ~]# chown -R dmdba:dinstall /data/bakâ
[root@DM8 ~]# chmod -R 755 /dataâ
[root@DM8 ~]# chmod -R 755 /opt/dmdbms/â
注æ:å®é ç产ç¯å¢éè¦æç£çåç¬æè½½å°å®è£ è·¯å¾ï¼æ°æ®è·¯å¾ï¼å¤ä»½è·¯å¾,æ¿ä¸åç£çåä¾,æä½å¦ä¸:â
æ¯å¦:æ°æ·»å ä¸åç£çæè ç£çéµåååä¸åç£çå è½½å°æä½ç³»ç»ä¸[root@DM8 ~]# fdisk -læ¥çæ°å ç£ççè·¯å¾â
ç»/dev/sdbååº ä½¿ç¨å½ä»¤ fdisk /dev/sdb æç §æä½è¾å ¥ï¼å¦ä¸å¾æ示:â
æè½½ç£ç
[root@DM8 /]# mount /dev/sdb1 /data/bak --æç£çæè½½å°/data/bakç®å½
注æ:è¿åªæ¯ä¸´æ¶æè½½,éå¯æè½½ä¼æ¶å¤±
æ°¸ä¹ æè½½éè¦å¨/etc/fstabä¸å å ¥ä¸é¢é ç½®ï¼å¦ä¸å¾:â
[root@DM8 data]# vi /etc/fstab â
[root@DM8 data]# mount -a --æµè¯é ç½®æ¯å¦æ£ç¡®â
3.3 ç£çååæ åµ
è¿è¡å½ä»¤ï¼df ådf -h /tmpï¼æ¥çç£ç容éå使ç¨æ åµãå®è£ ç¨åºäº§çç临æ¶æ件ï¼é»â
认使ç¨/tmp ç®å½ï¼ä¸ºäºå®è£ ç¨åºè½å¤æ£å¸¸è¿è¡ï¼ç¨æ·åºè¯¥ä¿è¯/tmp æ大äº600M çå©ä½ç©ºé´ãå¦æ/tmp ç®å½çå©ä½ç©ºé´ä¸è¶³ï¼ç¨æ·å¯ä»¥æ©å /tmp ç®å½ç空é´ï¼ä¹å¯ä»¥éè¿è®¾ç½®ç¯å¢åéDM_INSTALL_TMPDIR æå®å®è£ ç¨åºç临æ¶ç®å½ãâ
3.4 æ£æ¥ç³»ç»åæ°éå¶
3.4.1 ä¿®æ¹limits.confåæ°
[root@DM8 ~]# vi /etc/security/limits.confç¼è¾å¨æä¸é¢å ä¸ä¸é¢6è¡â
dmdba - data unlimitedâ
dmdba - fsize unlimitedâ
dmdba - nofile 1048576 â
dmdba - memlock unlimitedâ
dmdba - nproc 10240â
dmdba - core unlimitedâ
åæ¢å°dmdbaç¨æ·ï¼æ¥çæ¯å¦çæï¼å½ä»¤å¦ä¸:â
[root@DM8 ~]# su - dmdbaâ
Last login: Thu Sep 15 10:09:11 CST 2022 on pts/0â
[dmdba@DM8 ~]$ ulimit -aâ
3.4.2 ç£çè°åº¦ç®æ³æ£æ¥
æ¥ç对åºçè°åº¦ç®æ³(以redhatæä½ç³»ç»ä¸ºä¾):â
[dmdba@DM8 ~]$ cat /sys/block/sda/queue/schedulerâ
å¦ææ¥è¯¢æ¯å¦ä¸ç»æï¼å°±ä¸è¦ä¿®æ¹â
3.5 æ°æ®åºå®è£
3.5.1 æè½½éå
å ä¸ä¼ æ°æ®åºéåå°/rootç®å½â
åæ¢å°rootç¨æ·â
[dmdba@DM8 ~]$ su - rootâ
Password:â
Last login: Thu Sep 15 09:59:16 CST 2022 from 192.168.174.1 on pts/0â
æ¥çä¸æ¬¡æ°æ®åºéåç®å½ï¼æè½½å°ç®å½ä¸â
[root@DM8 ~]# mount -o loop /root/dm8_20220701_x86_rh6_64_ent_8.1.2.128.iso /mntâ
mount: /dev/loop0 is write-protected, mounting read-onlyâ
3.5.2 æ°æ®åºå®è£
åæ¢å°dmdbaç¨æ·ä¸é¢â
[root@DM8 ~]# su - dmdbaâ
Last login: Thu Sep 15 10:23:10 CST 2022 on pts/0â
è¿å ¥æè½½ç®å½ï¼æ¥è¯¢ç®å½ä¸æ件â
[dmdba@DM8 ~]$ cd /mnt/â
[dmdba@DM8 mnt]$ llâ
total 946102â
-r-xr-xr-x 1 root root 2823968 Jul 1 13:44 DM8 Install.pdfâ
-r-xr-xr-x 1 root root 965983690 Jul 1 13:49 DMInstall.binâ
3.5.2.1 å½ä»¤è¡å®è£
-
åæ¢è³âsu - dmdbaâ
cd /mntâ
DMInstall.bin -iâ
- æéæ±éæ©å®è£ è¯è¨ï¼é»è®¤ä¸ºä¸æãæ¬å°å®è£ éæ©ãä¸è¾å ¥â
- éæ©ã1-å ¸åå®è£ ãï¼æå·²è§åçå®è£ ç®å½ /dm8 å®ææ°æ®åºè½¯ä»¶å®è£ ï¼ä¸å»ºè®®ä½¿ç¨é»è®¤å®è£ ç®å½â
-
达梦DM8数据库的单机部署 - æ°æ®åºå®è£ 大æ¦â
-
达梦DM8数据库的单机部署 - æ°æ®åºå®è£ å®æåï¼éè¦åæ¢è³ root ç¨æ·æ§è¡ä¸å¾ä¸çå½ä»¤ /opt/dmdbms/script/root/root_installer.sh å建 DmAPServiceï¼å¦åä¼å½±åæ°æ®åºå¤ä»½â
3.5.2.2å¾å½¢åå®è£
使ç¨dmdbaç¨æ·æ§è¡ä¸ä¸å½ä»¤ï¼â
[dmdba@DM8 mnt]$ export DISPLAY=192.168.0.102:0.0â
å¾å½¢åçé¢å¯å¨æååï¼å°å¼¹åºãéæ©è¯è¨ä¸æ¶åºã页é¢ï¼é»è®¤ä¸ºç®ä½ä¸æåä¸å½æ åæ¶é´ãâ
ç¹å»ãç¡®å®ãåï¼å¼¹åºâ
ç¹å»ãä¸ä¸æ¥ãåï¼ä¸ºè®¸å¯è¯å议页é¢ï¼éæ©ãæ¥åã
ç¹å»ãä¸ä¸æ¥ãåï¼å¼¹åº key æ件页é¢ï¼ç¹å»ãæµè§ãéæ©ãkey æ件ãï¼è¥æ²¡æ key æ件å¯ä»¥ç´æ¥ç¹å»ãä¸ä¸æ¥ãï¼è·³è¿è¯¥æ¥éª¤ãâ
ç¹å»ãä¸ä¸æ¥ãåï¼å¼¹åºéæ©ç»ä»¶é¡µé¢ï¼å»ºè®®éæ©å ¸åå®è£ ï¼ä¹å¯æ ¹æ®éè¦ï¼éæ©æå¡å¨å®è£ ã客æ·ç«¯å®è£ åèªå®ä¹å®è£ â
ç¹å»ãä¸ä¸æ¥ãåï¼å¼¹åºéæ©å®è£ ä½ç½®é¡µé¢ï¼å¯ç¹å»ãæµè§ãéæ©å®è£ ä½ç½®ï¼ä¹å¯å®è£ å¨é»è®¤è·¯å¾ä¸â
ç¹å»ãä¸ä¸æ¥ãåï¼å¼¹åºç¡®è®¤å®è£ ä¿¡æ¯é¡µé¢ï¼æ£æ¥å®è£ ä¿¡æ¯æ¯å¦åç¡®ï¼ç¡®è®¤æ 误åç¹å»ãå®è£ ãâ
ç¹å»ãå®è£ ãåï¼çå¾ â
éæ°æå¼ä¸ä¸ªç»ç«¯ï¼åæ¢å°â
èæ¬æ§è¡å®æåï¼ç¹å»æ§è¡é ç½®èæ¬é¡µé¢ä¸çãå®æãï¼å¼¹åºæ示æ¡ï¼æ示æ¯å¦å ³éçªå£ï¼éæ©æ¯ï¼æ示æ°æ®åºå®è£ å®æï¼åç¹å»ãå®æãæé®ï¼å®ææ°æ®åºå®è£ ãâ
3.5.3 ç¯å¢åéé ç½®
åæ¢å° root ç¨æ·è¿å ¥ dmdba ç¨æ·çæ ¹ç®å½ä¸ï¼é 置对åºçç¯å¢åéãDM_HOME åéåå¨æé¾æ¥åºæ件çå 载路å¾å¨ç¨åºå®è£ æååä¼èªå¨å¯¼å ¥ãå½ä»¤å¦ä¸ï¼â
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/toolâ
ç¼è¾â
[dmdba@DM8 ~]$ vi .bash_profileâ
~
åæ¢è³â
source .bash_profileâ
3.6é ç½®å®ä¾
DM æ°æ®åºå¨ Linux ç¯å¢æ¯æå½ä»¤è¡é ç½®å®ä¾ä»¥åå¾å½¢åé ç½®å®ä¾ï¼æ¬ç« èå°åå«è¿è¡ä»ç»â
3.6.1 å½ä»¤è¡é ç½®å®ä¾
ä½¿ç¨ dmdba ç¨æ·é ç½®å®ä¾ï¼è¿å ¥å° DM æ°æ®åºå®è£ ç®å½ä¸ç bin ç®å½ä¸ï¼ä½¿ç¨ dminit å½ä»¤åå§åå®ä¾ãdminit å½ä»¤å¯è®¾ç½®å¤ç§åæ°ï¼å¯æ§è¡å¦ä¸å½ä»¤æ¥çå¯é ç½®åæ°
[root@DM8 dmdbms]# su - dmdbaâ
Last login: Thu Sep 15 11:16:33 CST 2022 on pts/1â
[dmdba@DM8 ~]$ cd $DM_HOMEâ
[dmdba@DM8 dmdbms]$ cd binâ
[dmdba@DM8 bin]$ ./dminit helpâ
å¯ä»¥ä½¿ç¨é»è®¤åæ°åå§åå®ä¾ï¼éè¦éå å®ä¾åæ¾è·¯å¾ãæ¤å¤ä»¥åå§åå®ä¾å°data/dmdataç®å½ä¸ä¸ºä¾ï¼æ§è¡åå§åå½ä»¤åï¼éè¦ä½¿ç¨ root ç¨æ·æäº /data/dmdataç®å½ç¸åºæéï¼å¯ä»¥åèââä¿®æ¹ç®å½æéââï¼ï¼åå§åå½ä»¤å¦ä¸ï¼â
[dmdba@DM8 bin]$ ./dminit path=/data/dmdataâ
ä¹å¯ä»¥èªå®ä¹åå§åå®ä¾çåæ°ï¼åèå¦ä¸ç¤ºä¾â
以ä¸å½ä»¤è®¾ç½®é¡µå¤§å°ä¸º 32 KBï¼ç°å¤§å°ä¸º 32 KBï¼å¤§å°åææï¼å符é为 utf_8ï¼æ°æ®åºå为 DMDBï¼å®ä¾å为 DBSERVERï¼ç«¯å£ä¸º 5237ãâ
./dminit path=/data/dmdata PAGE_SIZE=32 EXTENT_SIZE=32 CASE_SENSITIVE=y CHARSET=1 DB_NAME=DMDB INSTANCE_NAME=DBSERVER PORT_NUM=5237â
注æâ
å¦ææ¤å¤èªå®ä¹äºåå§ååæ°ï¼å¨åé¢ç注åæå¡åå¯å¨æ°æ®åºçæ¥éª¤ä¸ï¼è¯·æå®é çèªå®ä¹åæ°è¿è¡æä½ãâ
3.6.2 æå¨å¾å½¢åé ç½®å®ä¾
è¥éè¦ä¸»å¨æå¼é ç½®å©æï¼å¯ä½¿ç¨ dmdba ç¨æ·é ç½®å®ä¾ï¼è¿å ¥å° DM æ°æ®åºå®è£ ç®å½ä¸ç tool ç®å½ä¸ï¼ä½¿ç¨å½ä»¤æå¼æ°æ®åºé ç½®å©æãâ
[dmdba@DM8 dmdata]$ cd $DM_HOMEâ
[dmdba@DM8 dmdbms]$ cd tool/â
[dmdba@DM8 tool]$ ./dbca.shâ
éæ©å建æ°æ®åºå®ä¾ï¼ç¹å»ãå¼å§ãï¼è¿å ¥å建æ°æ®åºé¡µé¢çå建æ°æ®åºæ¨¡ç页ç¾ï¼éæ©ãä¸è¬ç¨éãï¼å¦ä¸å¾æç¤ºï¼ â
ç¹å»ãä¸ä¸æ¥ãï¼éæ©æ°æ®åºå®ä¾å®è£ ç®å½ï¼å¦ä¸å¾æ示ï¼â
ç¡®å®å¥½æ°æ®åºå®è£ ç®å½åï¼ç¹å»ãä¸ä¸æ¥ãï¼ç¨æ·å¯æ ¹æ®éè¦è®¾ç½®å¯¹åºçæ°æ®åºåæ°ï¼å¦ä¸å¾æ示ï¼â
ç¹å»ãä¸ä¸æ¥ãï¼é ç½®æ°æ®åºæ件路å¾ï¼éæ©ãé»è®¤è·¯å¾ãå³å¯ï¼å¦ä¸å¾æ示ï¼â
ç¹å»ãä¸ä¸æ¥ãï¼é ç½®åå§ååæ°ï¼æ³¨æç°å¤§å°ã页大å°ãå符é以å大å°åææç¡®å®åä¸å¯ä¿®æ¹ï¼é»è®¤é ç½®å³å¯ï¼å¦ä¸å¾æ示ï¼â
ç¹å»ãä¸ä¸æ¥ãï¼é ç½®æ°æ®åºå£ä»¤ï¼é»è®¤é ç½®å³å¯ï¼å¦ä¸å¾æ示ï¼â
ç¹å»ãä¸ä¸æ¥ãï¼é 置示ä¾åºï¼å»ºè®®å¾éæ DMHRï¼ä½ä¸ºæ¼ç¤ºç¯å¢ï¼å¦ä¸å¾æç¤ºï¼ â
ç¹å»ãä¸ä¸æ¥ãï¼ç¨æ·å¯æ£æ¥å建åæ°ï¼è¥æéè¦ä¿®æ¹ä¹å¤å¯ç¹å»ãä¸ä¸æ¥ãåå°éè¦ä¿®æ¹çä½ç½®è¿è¡ä¿®æ¹ï¼å¦ä¸å¾æ示ï¼â
ç¹å»ãå®æãï¼å建å®ææ°æ®åºå®ä¾åï¼æä¸å¾ææ示æ§è¡èæ¬å³å¯å®æå®ä¾é ç½®ï¼â
3.7注åæå¡
3.7.1 å½ä»¤è¡æ³¨å
注åæå¡éä½¿ç¨ root ç¨æ·è¿è¡æ³¨åãä½¿ç¨ root ç¨æ·è¿å ¥æ°æ®åºå®è£ ç®å½ç /script/root ä¸ï¼å¦ä¸æ示ï¼â
cd /opt/dmdbms/script/rootâ
注åæå¡ï¼å¦ä¸æ示ï¼
./dm_service_installer.sh -t dmserver -dm_ini /data/dmdata/DAMENG/dm.ini -p DMSERVERâ
ç¨æ·å¯æ ¹æ®èªå·±çç¯å¢æ´æ¹ dm.ini æ件çè·¯å¾ä»¥åæå¡åï¼å¦ä¸æ示ï¼â
./dm_service_installer.sh -hâ
å¦éä¸ºå ¶ä»å®ä¾æ³¨åæå¡ï¼éæå¼ dbca å·¥å ·ï¼è¿è¡æ³¨åæå¡ï¼å¦ä¸æ示ï¼â
3.7.2å¾å½¢å注åæå¡
æå¼è¿è¡â
[dmdba@DM8 tool]$ export DISPLAY=192.168.0.102:0.0â
[dmdba@DM8 tool]$ ./dbca.shâ
åå»ãå¼å§ãï¼å¼¹åºæ³¨åæ°æ®åºæå¡é¡µé¢ï¼å¦ä¸å¾æ示ï¼â
ç¹å»ãå®æãåï¼å¼¹åºæ§è¡é ç½®èæ¬é¡µé¢ï¼æ页é¢è¦æ±æ§è¡èæ¬å³å¯ï¼å¦ä¸å¾æ示ï¼â
æ§è¡èæ¬æååï¼è¯¥å®ä¾å·²å¯å¨ï¼å¦ä¸å¾æ示:â
3.8å¯å¨ï¼åæ¢æ°æ®åº
Systemctl start DmServiceDMSERVER.serviceå¯å¨æ°æ®åºâ
Systemctl stop DmServiceDMSERVER.serviceå ³éæ°æ®åºâ
Systemctl status DmServiceDMSERVER.serviceæ¥çæ°æ®åºç¶æâ
建议使ç¨ä¸é¢èæ¬æ¹å¼å¯å¨ååæ¢æ°æ®åºâ
su - dmdbaâ
cd $DM_HOME/binâ
./DmServiceDMSERVER statusæ¥è¯¢æ°æ®åºç¶æâ
./DmServiceDMSERVER stop/start/restart --åæ¢/å¯å¨/éå¯æ°æ®åºâ
æ°æ®åºå½æ¡£,å¤ä»½,åæ°ä¼å
æ°æ®åºå½æ¡£(两ç§æ¹å¼)
4.1.1 å½ä»¤è¡æ¨¡å¼é ç½®å½æ¡£
- 使ç¨disql SYSDBA/SYSDBAç»å½æ°æ®åºå®ä¾â
-
达梦DM8数据库的单机部署 - ææ°æ®åºä¿®æ¹å°mountç¶æ,æä½å¦ä¸:âSQL> alter database mount;â
- æ·»å å½æ¡£è·¯å¾åå½æ¡£æ件大å°âalter database add archivelog 'type=local,dest=/data/dmarch,file_size=2028,space_limit=10240';â
-
达梦DM8数据库的单机部署 -
ææ°æ®åºä¿®æ¹æå½æ¡£æ¨¡å¼âSQL> alter database archivelog;â
æä½å·²æ§è¡â
å·²ç¨æ¶é´: 11.666(毫ç§). æ§è¡å·:0.â
- æå¼æ°æ®åºâ
SQL> alter database open;â
4.1.2 å¾å½¢åçé¢é ç½®å½æ¡£
- 使ç¨DM管çå·¥å ·ç»å½æ°æ®åº,å¦ä¸å¾:â
-
达梦DM8数据库的单机部署 - ç¹å»ç¡®å®ç»å½æ°æ®åºï¼å³é®,éæ©ç®¡çæå¡å¨ï¼å¦ä¸å¾â
-
达梦DM8数据库的单机部署 - éæ©ç³»ç»ç®¡çï¼ç¶æ转æ¢éæ©é ç½®ï¼ç¹å»è½¬æ¢ï¼æ°æ®åºå°mountç¶æï¼å¦ä¸å¾:â
-
达梦DM8数据库的单机部署 - ç¹å»å½æ¡£é ç½®ï¼éæ©å½æ¡£ï¼ç¹å»å å·ï¼æ·»å å½æ¡£è·¯å¾åå½æ¡£æ件大å°ï¼ç¹å»ç¡®å®,å¦ä¸å¾:â
-
达梦DM8数据库的单机部署 - ç¹å»ç³»ç»ç®¡çï¼éæ©æå¼ï¼ç¹å»è½¬æ¢,å¦ä¸å¾:â
4.2æ°æ®åºå¤ä»½(å ¨å¤,å¢éå¤ä»½,å®æ¶å é¤30天åå¤ä»½)
4.2.1 æ°æ®åºå ¨åºå¤ä»½
- 使ç¨å®¢æ·ç«¯DM管çå·¥å ·ç»å½å®¢æ·ç«¯,éæ©ä»£çï¼ä½ä¸ï¼å¦ä¸æ示:â
-
达梦DM8数据库的单机部署 - ç¹å¼æ°å»ºä½ä¸,è¾å ¥ä½ä¸å:BACK_FULLï¼ç¹å»ä½ä¸æ¥éª¤,å¦ä¸å¾æ示:â
-
达梦DM8数据库的单机部署 - è¾å ¥æ¥éª¤å称åä½ä¸å称ä¸æ ·ï¼æ¥éª¤ç±»åéæ©å¤ä»½æ°æ®åºï¼å¤ä»½è·¯å¾è¾å ¥åé¢è§å好çè·¯å¾/data/bak,ï¼éæ©å®å ¨å¤ä»½ï¼å¨éæ©é«çº§ï¼å¦ä¸å¾æ示:â
-
达梦DM8数据库的单机部署 - éæ©æåæ¯æ¥åæ§è¡æå并ç»æä½ä¸å失败æ¥åæ§è¡å¤±è´¥å¹¶ç»æä½ä¸ï¼ç¹å»ç¡®å®ï¼ç¶åç¹å»ä½ä¸è°åº¦ï¼å¦ä¸å¾æ示:â
-
达梦DM8数据库的单机部署 - ç¹å»ä½ä¸è°åº¦,è¾å ¥è°åº¦å称ï¼ç±»åé»è®¤éæ©å¨ï¼éæ©ææ天æä¸23:00åï¼å ·ä½æ¶é´æ ¹æ®ç¨æ·æ¥ä¿®æ¹ï¼ç¹å»ç¡®å®ï¼è¿æ ·å ¨å¤å°±åå®ï¼å¦ä¸å¾æ示:â
4.2.2 å¢éå¤ä»½
- æ°å»ºä½ä¸ï¼è¾å ¥ä½ä¸å:BACK_INC,å¨ç¹å»ä½ä¸æ¥éª¤ï¼å¦ä¸å¾æ示:â
-
达梦DM8数据库的单机部署 - æ¥éª¤å称è¾å ¥BACK_INCï¼å¾1æ示ï¼ç¹å»æ·»å ï¼æ¥éª¤ç±»åéæ©å¤ä»½æ°æ®åºï¼å¦å¾2æ示ï¼è¾å ¥ç¸å ³ä¿¡æ¯ï¼ç¹å»é«çº§ï¼éæ©æåç»æä½ä¸ ï¼å¤±è´¥éæ©æ§è¡ä¸ä¸æ¥ï¼ç¹å»ç¡®å®.â
-
达梦DM8数据库的单机部署 - å¾ä¸â
-
达梦DM8数据库的单机部署 -
å¾äºâ
â
- å¢éå¤ä»½çæ¶åï¼å»ºè®®å ä¸æ§è¡å¤±è´¥çæ¶åæ§è¡ä¸ä¸å ¨åºå¤ä»½ï¼ç¹å»ä½ä¸æ¥éª¤ï¼å次ç¹å»æ·»å ï¼è¾å ¥å ¨å¤çç¸å ³ä¿¡æ¯ï¼é«çº§éæ©ï¼æåå失败ç»æä½ä¸ï¼å¦ä¸å¾æ示:â
-
达梦DM8数据库的单机部署 - å¾ä¸â
-
达梦DM8数据库的单机部署 - å¾äºâ
- ç¹å»ä½ä¸è°åº¦ï¼è¾å ¥å称ï¼å¢éå¤ä»½é»è®¤å¾ä¸ææä¸å°ææå ï¼è°åº¦ç±»åéæ©åå¤æ§è¡ï¼æ¶é´éæ©23:00:00 ï¼å ·ä½æ ¹æ®èªå·±è¦æ±é ç½®ï¼ç¶åç¹å»ç¡®å®ï¼å¦ä¸å¾æ示:â
-
达梦DM8数据库的单机部署 - æä½å®ä»¥ä¸æ¥éª¤ä»¥åï¼å¢éå¤ä»½ä½ä¸å°±å·²ç»å®æãâ
4.2.3 å®æ¶å é¤å¤ä»½çç¥
1.æ°å»ºä½ä¸ï¼è¾å ¥ä½ä¸å称åæ¥éª¤å称é½æ¯JOB_DEL_BAK_TIMEYï¼æ¥éª¤ç±»åéæ©sqlèæ¬ï¼èæ¬è¯å¥å¦ä¸å¾æ示ï¼é«çº§ï¼æåå失败é½éæ©æ§è¡ç»æä½ä¸ã â
- è°åº¦ä½ä¸ï¼ç¹å»ç¡®å®ï¼å¦ä¸å¾æ示:â
-
达梦DM8数据库的单机部署 - æåç¹å»ç¡®å®ï¼å°±å®æå®æ¶å é¤å¤ä»½ä½ä¸ä»»å¡ï¼å¦ä¸å¾ï¼å¯ä»¥å°3个ä½ä¸ä»»å¡ï¼â
4.å¯ä»¥æ¥è¯¢ä½ä¸æ§è¡æ åµï¼ç¹å»ä½ä¸å³é®ï¼æ¥çä½ä¸åå²ä¿¡æ¯ï¼å¦ä¸å¾:â
æ°æ®åºé ç½®åæ°çä¼å
-
æ ¹æ®èæ¬çææ§è¡è¯å¥ï¼é»è®¤ä¿®æ¹è¿4个åæ°:âexec_mode int:=1; 表示ç´æ¥æ§è¡èæ¬ä¿®æ¹åæ°ï¼1表示ä¸ç´æ¥ä¿®æ¹åæ°ï¼æå°è®¾ç½®åæ°çè¯å¥ï¼è®¾ç½®ä¸º1åï¼å¿ é¡»è°æ´v_mem_mbåv_cpusâ
â
Mem_per int:=90;é»è®¤ææçå åå½è¾¾æ¢¦æ°æ®åºä½¿ç¨ï¼å¦å®é ä¸è½100%å¯ç¨ï¼å¯ä»¥è°æ´æ¤åæ°â
v_mem_mb int:= 16000; --æ ¹æ®æºå¨æ¶é´å åè°æ´æ¤åæ°â
v_cpus int:= 2; --æ ¹æ®æºå¨CPUæ ¸æ°è°æ´æ¤åæ°â
èæ¬å¦ä¸â
---------------------------------------------------------------------------------------------------------------------------------â
declareâ
exec_mode int:= 1; â
mem_per int:= 90; â
v_mem_mb int:= 16000;â
v_cpus int:= 2; â
tname varchar(100);â
MEMORY_POOL int;â
MEMORY_N_POOLS int;â
MEMORY_TARGET int;â
BUFFER INT;â
MAX_BUFFER INT;â
RECYCLE int;â
CACHE_POOL_SIZE int;â
BUFFER_POOLS int;â
RECYCLE_POOLS int;â
SORT_BUF_SIZE int;â
SORT_BUF_GLOBAL_SIZE INT;â
DICT_BUF_SIZE INT;â
HJ_BUF_SIZE INT;â
HAGR_BUF_SIZE INT;â
HJ_BUF_GLOBAL_SIZE INT;â
HAGR_BUF_GLOBAL_SIZE INT;â
SORT_FLAG INT;â
SORT_BLK_SIZE INT;â
RLOG_POOL_SIZE INT;â
TASK_THREADS INT;â
IO_THR_GROUPS INT;â
FAST_POOL_PAGES INT :=3000;â
FAST_ROLL_PAGES INT :=1000;â
CNT INT;â
beginâ
CNT :=0;â
if exec_mode=0 then â
SELECT TOP 1 N_CPU,TOTAL_PHY_SIZE/1024/1024 INTO v_cpus,v_mem_mb FROM V$SYSTEMINFO;â
end if;â
v_mem_mb := v_mem_mb * (mem_per/100.0);â
v_mem_mb=round(v_mem_mb,-3);â
IF v_mem_mb <= 2000 THENâ
goto return_2000;â
END IF;â
IF v_mem_mb > 512000 THEN â
v_mem_mb :=v_mem_mb*0.8;â
END IF;â
MEMORY_TARGET=round(cast(v_mem_mb * 0.12 as int),-3);â
TASK_THREADS :=4;â
IO_THR_GROUPS :=4;â
IF v_cpus < 8 THEN â
TASK_THREADS :=4;â
IO_THR_GROUPS :=2;â
END IF;â
IF v_cpus >= 64 THEN â
v_cpus := 64; â
TASK_THREADS :=16;â
IO_THR_GROUPS :=8;â
END IF;â
BUFFER := round(cast(v_mem_mb * 0.4 as int),-3);â
MAX_BUFFER := BUFFER;â
RECYCLE :=cast(v_mem_mb * 0.04 as int);â
IF v_mem_mb < 70000 THENâ
with t asâ
(â
select rownum rn from dual connect by level <= 100â
) ,â
t1 asâ
(â
select * from t where rn > 1 minusâ
selectâ
ta.rn * tb.rnâ
fromâ
t ta,â
t tbâ
whereâ
ta.rn <= tb.rnâ
and ta.rn > 1â
and tb.rn > 1â
)â
select top 1 rn into BUFFER_POOLS from t1 where rn > v_mem_mb/800 order by 1;â
with t asâ
(â
select rownum rn from dual connect by level <= 100â
) ,â
t1 asâ
(â
select * from t where rn > 1 minusâ
selectâ
ta.rn * tb.rnâ
fromâ
t ta,â
t tbâ
whereâ
ta.rn <= tb.rnâ
and ta.rn > 1â
and tb.rn > 1â
)â
select top 1 rn into RECYCLE_POOLS from t1 where rn > v_mem_mb/800/3 order by 1;â
â
â
ELSEâ
BUFFER_POOLS := 101;â
RECYCLE_POOLS := 41;â
END IF;â
IF v_mem_mb >= 16000 THEN â
IF v_mem_mb= 16000 THENâ
MEMORY_POOL := 1500;â
SORT_BUF_GLOBAL_SIZE := 1000;â
MEMORY_N_POOLS := 3;â
CACHE_POOL_SIZE := 512;â
ELSEâ
MEMORY_POOL := 2000;â
SORT_BUF_GLOBAL_SIZE := 2000;â
MEMORY_N_POOLS := 37;â
CACHE_POOL_SIZE := 1024;â
END IF; â
FAST_POOL_PAGES :=9999;â
SORT_FLAG = 0;â
SORT_BLK_SIZE=1;â
SORT_BUF_SIZE := 10;â
RLOG_POOL_SIZE := 1024;â
HJ_BUF_GLOBAL_SIZE := LEAST(cast(v_mem_mb * 0.0625 as int),10000);â
HAGR_BUF_GLOBAL_SIZE := LEAST(cast(v_mem_mb * 0.0625 as int),10000);â
HJ_BUF_SIZE :=250;â
HAGR_BUF_SIZE :=250;â
RECYCLE :=round(RECYCLE,-3);â
IF v_mem_mb >= 64000 THENâ
FAST_POOL_PAGES :=99999;â
FAST_ROLL_PAGES :=9999;â
BUFFER :=BUFFER-3000;â
MAX_BUFFER :=BUFFER;â
CACHE_POOL_SIZE := 2048;â
RLOG_POOL_SIZE := 2048;â
SORT_FLAG = 1;â
SORT_BLK_SIZE=1;â
SORT_BUF_SIZE=50; â
SORT_BUF_GLOBAL_SIZE= cast(v_mem_mb * 0.02 as int);â
HJ_BUF_GLOBAL_SIZE := cast(v_mem_mb * 0.15625 as int);â
HAGR_BUF_GLOBAL_SIZE := cast(v_mem_mb * 0.04 as int);â
HJ_BUF_SIZE :=512;â
HAGR_BUF_SIZE :=512;â
MEMORY_N_POOLS := 59;â
END IF;â
DICT_BUF_SIZE := 50;â
HJ_BUF_GLOBAL_SIZE :=round(HJ_BUF_GLOBAL_SIZE,-3);â
HAGR_BUF_GLOBAL_SIZE :=round(HAGR_BUF_GLOBAL_SIZE,-3);â
SORT_BUF_GLOBAL_SIZE :=round(SORT_BUF_GLOBAL_SIZE,-3);â
RECYCLE :=round(RECYCLE,-3);â
ELSEâ
MEMORY_POOL :=GREAT(cast(v_mem_mb * 0.0625 as int),100);â
MEMORY_N_POOLS := 1;â
CACHE_POOL_SIZE := 200;â
RLOG_POOL_SIZE := 256;â
SORT_BUF_SIZE := 10;â
SORT_BUF_GLOBAL_SIZE := 500;â
DICT_BUF_SIZE := 50;â
SORT_FLAG = 0;â
SORT_BLK_SIZE=1;â
HJ_BUF_GLOBAL_SIZE := GREAT(cast(v_mem_mb * 0.0625 as int),500);â
HAGR_BUF_GLOBAL_SIZE := GREAT(cast(v_mem_mb * 0.0625 as int),500);â
HJ_BUF_SIZE := GREAT(cast(v_mem_mb * 0.00625 as int),50);â
HAGR_BUF_SIZE :=GREAT(cast(v_mem_mb * 0.00625 as int),50);â
END IF; â
tname :='BAK_DMINI_' || to_char(sysdate,'yymmdd');â
execute IMMEDIATE 'select count(*) from USER_ALL_TABLES where table_name= ?' into CNT using tname;â
IF CNT=0 THEN â
execute IMMEDIATE 'CREATE TABLE BAK_DMINI_' || to_char(sysdate,'yymmdd') || ' as select *,sysdate uptime from v$dm_ini';â
ELSE â
execute IMMEDIATE 'INSERT INTO BAK_DMINI_' || to_char(sysdate,'yymmdd') || ' select *,sysdate uptime from v$dm_ini';â
END IF;â
IF exec_mode=0 THENâ
SP_SET_PARA_VALUE(2,'WORKER_THREADS',v_cpus);â
SP_SET_PARA_VALUE(2,'TASK_THREADS',TASK_THREADS);â
SP_SET_PARA_VALUE(2,'IO_THR_GROUPS',IO_THR_GROUPS);â
SP_SET_PARA_VALUE(2,'MAX_OS_MEMORY', mem_per);â
SP_SET_PARA_VALUE(2,'MEMORY_POOL', MEMORY_POOL);â
SP_SET_PARA_VALUE(2,'MEMORY_N_POOLS', MEMORY_N_POOLS);â
SP_SET_PARA_VALUE(2,'MEMORY_TARGET', MEMORY_TARGET); â
SP_SET_PARA_VALUE(2,'MEMORY_MAGIC_CHECK', 1);â
if exists(select 1 from v$instance where dsc_role = 'NULL') thenâ
SP_SET_PARA_VALUE(2,'ENABLE_FREQROOTS', 1); â
end if;â
SP_SET_PARA_VALUE(2,'BUFFER', BUFFER);â
SP_SET_PARA_VALUE(2,'MAX_BUFFER', MAX_BUFFER);â
SP_SET_PARA_VALUE(2,'BUFFER_POOLS', BUFFER_POOLS);â
SP_SET_PARA_VALUE(2,'RECYCLE', RECYCLE); â
SP_SET_PARA_VALUE(2,'RECYCLE_POOLS', RECYCLE_POOLS);â
SP_SET_PARA_VALUE(2,'FAST_POOL_PAGES', FAST_POOL_PAGES); â
SP_SET_PARA_VALUE(2,'FAST_ROLL_PAGES', FAST_ROLL_PAGES);â
SP_SET_PARA_VALUE(1,'HJ_BUF_GLOBAL_SIZE', HJ_BUF_GLOBAL_SIZE);â
SP_SET_PARA_VALUE(1,'HJ_BUF_SIZE', HJ_BUF_SIZE );â
SP_SET_PARA_VALUE(1,'HAGR_BUF_GLOBAL_SIZE',HAGR_BUF_GLOBAL_SIZE);â
SP_SET_PARA_VALUE(1,'HAGR_BUF_SIZE', HAGR_BUF_SIZE );â
SP_SET_PARA_VALUE(2,'SORT_FLAG',SORT_FLAG);â
SP_SET_PARA_VALUE(2,'SORT_BLK_SIZE',SORT_BLK_SIZE);â
SP_SET_PARA_VALUE(2,'SORT_BUF_SIZE', SORT_BUF_SIZE);â
SP_SET_PARA_VALUE(2,'SORT_BUF_GLOBAL_SIZE', SORT_BUF_GLOBAL_SIZE);â
SP_SET_PARA_VALUE(2,'RLOG_POOL_SIZE', RLOG_POOL_SIZE);â
SP_SET_PARA_VALUE(2,'CACHE_POOL_SIZE', CACHE_POOL_SIZE); â
SP_SET_PARA_VALUE(2,'DICT_BUF_SIZE', DICT_BUF_SIZE); â
SP_SET_PARA_VALUE(2,'VM_POOL_TARGET', 16384); â
SP_SET_PARA_VALUE(2,'SESS_POOL_TARGET', 16384); â
SP_SET_PARA_VALUE(2,'USE_PLN_POOL', 1); â
SP_SET_PARA_VALUE(2,'ENABLE_MONITOR', 1); â
SP_SET_PARA_VALUE(2,'SVR_LOG', 0); â
SP_SET_PARA_VALUE(2,'TEMP_SIZE', 1024);â
SP_SET_PARA_VALUE(2,'TEMP_SPACE_LIMIT', 102400); â
SP_SET_PARA_VALUE(2,'MAX_SESSIONS', 1500); â
SP_SET_PARA_VALUE(2,'MAX_SESSION_STATEMENT', 20000); â
SP_SET_PARA_VALUE(2,'PK_WITH_CLUSTER', 0); â
SP_SET_PARA_VALUE(2,'ENABLE_ENCRYPT',0); â
SP_SET_PARA_VALUE(2,'OLAP_FLAG',2); â
SP_SET_PARA_VALUE(2,'VIEW_PULLUP_FLAG',1); â
SP_SET_PARA_VALUE(2,'OPTIMIZER_MODE',1); â
SP_SET_PARA_VALUE(2,'ADAPTIVE_NPLN_FLAG',0); â
SP_SET_PARA_VALUE(2,'PARALLEL_PURGE_FLAG',1);â
SP_SET_PARA_VALUE(2,'PARALLEL_POLICY',2);â
SP_SET_PARA_VALUE(2,'UNDO_EXTENT_NUM',16);â
SP_SET_PARA_VALUE(2,'ENABLE_INJECT_HINT',1);â
ELSEâ
PRINT 'SP_SET_PARA_VALUE(2,''WORKER_THREADS'','||v_cpus||');';â
PRINT 'SP_SET_PARA_VALUE(2,''TASK_THREADS'','||TASK_THREADS||');';â
PRINT 'SP_SET_PARA_VALUE(2,''IO_THR_GROUPS'','||IO_THR_GROUPS||');';â
PRINT 'SP_SET_PARA_VALUE(2,''MAX_OS_MEMORY'', '||mem_per||');';â
PRINT 'SP_SET_PARA_VALUE(2,''MEMORY_POOL'', '||MEMORY_POOL||');';â
PRINT 'SP_SET_PARA_VALUE(2,''MEMORY_N_POOLS'', '||MEMORY_N_POOLS||');';â
PRINT 'SP_SET_PARA_VALUE(2,''MEMORY_TARGET'', '||MEMORY_TARGET||');';â
PRINT 'SP_SET_PARA_VALUE(2,''BUFFER'', '||BUFFER||');';â
PRINT 'SP_SET_PARA_VALUE(2,''MAX_BUFFER'', '||MAX_BUFFER||');';â
PRINT 'SP_SET_PARA_VALUE(2,''BUFFER_POOLS'', '||BUFFER_POOLS||');';â
PRINT 'SP_SET_PARA_VALUE(2,''RECYCLE'', '||RECYCLE||');';â
PRINT 'SP_SET_PARA_VALUE(2,''RECYCLE_POOLS'', '||RECYCLE_POOLS||');';â
PRINT 'SP_SET_PARA_VALUE(2,''FAST_POOL_PAGES'', '||FAST_POOL_PAGES||');';â
PRINT 'SP_SET_PARA_VALUE(2,''FAST_ROLL_PAGES'', '||FAST_ROLL_PAGES||');';â
â
PRINT 'SP_SET_PARA_VALUE(2,''MEMORY_MAGIC_CHECK'', 1);';â
if exists(select 1 from v$instance where dsc_role = 'NULL') thenâ
PRINT 'SP_SET_PARA_VALUE(2,''ENABLE_FREQROOTS'', 1);'; â
end if;â
PRINT 'SP_SET_PARA_VALUE(1,''HJ_BUF_GLOBAL_SIZE'', '||HJ_BUF_GLOBAL_SIZE||');';â
PRINT 'SP_SET_PARA_VALUE(1,''HJ_BUF_SIZE'', '||HJ_BUF_SIZE||');';â
PRINT 'SP_SET_PARA_VALUE(1,''HAGR_BUF_GLOBAL_SIZE'','||HAGR_BUF_GLOBAL_SIZE||');';â
PRINT 'SP_SET_PARA_VALUE(1,''HAGR_BUF_SIZE'', '||HAGR_BUF_SIZE||');';â
â
PRINT 'SP_SET_PARA_VALUE(2,''SORT_FLAG'','||SORT_FLAG||');';â
PRINT 'SP_SET_PARA_VALUE(2,''SORT_BLK_SIZE'','||SORT_BLK_SIZE||');';â
PRINT 'SP_SET_PARA_VALUE(2,''SORT_BUF_SIZE'', '||SORT_BUF_SIZE||');';â
PRINT 'SP_SET_PARA_VALUE(2,''SORT_BUF_GLOBAL_SIZE'', '||SORT_BUF_GLOBAL_SIZE||');';â
PRINT 'SP_SET_PARA_VALUE(2,''RLOG_POOL_SIZE'', '||RLOG_POOL_SIZE||');';â
PRINT 'SP_SET_PARA_VALUE(2,''CACHE_POOL_SIZE'', '||CACHE_POOL_SIZE||');';â
PRINT 'SP_SET_PARA_VALUE(2,''DICT_BUF_SIZE'', '||DICT_BUF_SIZE||');'; â
PRINT 'SP_SET_PARA_VALUE(2,''VM_POOL_TARGET'', 16384);';â
PRINT 'SP_SET_PARA_VALUE(2,''SESS_POOL_TARGET'', 16384);';â
PRINT 'SP_SET_PARA_VALUE(2,''USE_PLN_POOL'', 1);';â
PRINT 'SP_SET_PARA_VALUE(2,''ENABLE_MONITOR'', 1);'; â
PRINT 'SP_SET_PARA_VALUE(2,''SVR_LOG'', 0);'; â
PRINT 'SP_SET_PARA_VALUE(2,''TEMP_SIZE'', 1024);';â
PRINT 'SP_SET_PARA_VALUE(2,''TEMP_SPACE_LIMIT'', 102400);';â
PRINT 'SP_SET_PARA_VALUE(2,''MAX_SESSIONS'', 1500);';â
PRINT 'SP_SET_PARA_VALUE(2,''MAX_SESSION_STATEMENT'', 20000);';â
PRINT 'SP_SET_PARA_VALUE(2,''PK_WITH_CLUSTER'', 0);';â
PRINT 'SP_SET_PARA_VALUE(2,''ENABLE_ENCRYPT'',0);';â
PRINT 'SP_SET_PARA_VALUE(2,''OLAP_FLAG'',2);';â
PRINT 'SP_SET_PARA_VALUE(2,''VIEW_PULLUP_FLAG'',1);';â
PRINT 'SP_SET_PARA_VALUE(2,''OPTIMIZER_MODE'',1);';â
PRINT 'SP_SET_PARA_VALUE(2,''ADAPTIVE_NPLN_FLAG'',0);';â
PRINT 'SP_SET_PARA_VALUE(2,''PARALLEL_PURGE_FLAG'',1);';â
PRINT 'SP_SET_PARA_VALUE(2,''PARALLEL_POLICY'',2);';â
PRINT 'SP_SET_PARA_VALUE(2,''UNDO_EXTENT_NUM'',16);';â
PRINT 'SP_SET_PARA_VALUE(2,''ENABLE_INJECT_HINT'',1);';â
END IF;â
select MEMORY_TARGET+BUFFER+RECYCLE+HJ_BUF_GLOBAL_SIZE+HAGR_BUF_GLOBAL_SIZE+CACHE_POOL_SIZEâ
+DICT_BUF_SIZE+SORT_BUF_GLOBAL_SIZE+RLOG_POOL_SIZE;â
exceptionâ
when others thenâ
æ§è¡å¤±è´¥, '||SQLCODE||' '||SQLERRM||' '||dbms_utility.format_error_backtrace , 1, 400));â
<<return_2000>> null;â
end;â
-
æ ¹æ®æå¡å¨å®é çåæ°æ§è¡ä¸é¢èæ¬å¯ä»¥å¾å°ä¸ä¸ç»æ:âSP_SET_PARA_VALUE(2,'WORKER_THREADS',2);â
SP_SET_PARA_VALUE(2,'TASK_THREADS',4);â
SP_SET_PARA_VALUE(2,'IO_THR_GROUPS',2);â
SP_SET_PARA_VALUE(2,'MAX_OS_MEMORY', 90);â
SP_SET_PARA_VALUE(2,'MEMORY_POOL', 875);â
SP_SET_PARA_VALUE(2,'MEMORY_N_POOLS', 1);â
SP_SET_PARA_VALUE(2,'MEMORY_TARGET', 2000);â
SP_SET_PARA_VALUE(2,'BUFFER', 1024);â
SP_SET_PARA_VALUE(2,'MAX_BUFFER', 6000);â
SP_SET_PARA_VALUE(2,'BUFFER_POOLS', 19);â
SP_SET_PARA_VALUE(2,'RECYCLE', 560);â
SP_SET_PARA_VALUE(2,'RECYCLE_POOLS', 7);â
SP_SET_PARA_VALUE(2,'FAST_POOL_PAGES', 3000);â
SP_SET_PARA_VALUE(2,'FAST_ROLL_PAGES', 1000);â
SP_SET_PARA_VALUE(2,'MEMORY_MAGIC_CHECK', 1);â
SP_SET_PARA_VALUE(2,'ENABLE_FREQROOTS', 1);â
SP_SET_PARA_VALUE(1,'HJ_BUF_GLOBAL_SIZE', 875);â
SP_SET_PARA_VALUE(1,'HJ_BUF_SIZE', 88);â
SP_SET_PARA_VALUE(1,'HAGR_BUF_GLOBAL_SIZE',875);â
SP_SET_PARA_VALUE(1,'HAGR_BUF_SIZE', 88);â
SP_SET_PARA_VALUE(2,'SORT_FLAG',0);â
SP_SET_PARA_VALUE(2,'SORT_BLK_SIZE',1);â
SP_SET_PARA_VALUE(2,'SORT_BUF_SIZE', 10);â
SP_SET_PARA_VALUE(2,'SORT_BUF_GLOBAL_SIZE', 500);â
SP_SET_PARA_VALUE(2,'RLOG_POOL_SIZE', 256);â
SP_SET_PARA_VALUE(2,'CACHE_POOL_SIZE', 200);â
SP_SET_PARA_VALUE(2,'DICT_BUF_SIZE', 50);â
SP_SET_PARA_VALUE(2,'VM_POOL_TARGET', 16384);â
SP_SET_PARA_VALUE(2,'SESS_POOL_TARGET', 16384);â
SP_SET_PARA_VALUE(2,'USE_PLN_POOL', 1);â
SP_SET_PARA_VALUE(2,'ENABLE_MONITOR', 1);â
SP_SET_PARA_VALUE(2,'SVR_LOG', 0);â
SP_SET_PARA_VALUE(2,'TEMP_SIZE', 1024);â
SP_SET_PARA_VALUE(2,'TEMP_SPACE_LIMIT', 102400);â
SP_SET_PARA_VALUE(2,'MAX_SESSIONS', 1500);â
SP_SET_PARA_VALUE(2,'MAX_SESSION_STATEMENT', 20000);â
SP_SET_PARA_VALUE(2,'PK_WITH_CLUSTER', 0);â
SP_SET_PARA_VALUE(2,'ENABLE_ENCRYPT',0);â
SP_SET_PARA_VALUE(2,'OLAP_FLAG',2);â
SP_SET_PARA_VALUE(2,'VIEW_PULLUP_FLAG',1);â
SP_SET_PARA_VALUE(2,'OPTIMIZER_MODE',1);â
SP_SET_PARA_VALUE(2,'ADAPTIVE_NPLN_FLAG',0);â
SP_SET_PARA_VALUE(2,'PARALLEL_PURGE_FLAG',1);â
SP_SET_PARA_VALUE(2,'PARALLEL_POLICY',2);â
SP_SET_PARA_VALUE(2,'UNDO_EXTENT_NUM',16);â
SP_SET_PARA_VALUE(2,'ENABLE_INJECT_HINT',1);â
- æ§è¡ç¬¬ä¸æ¥æ§è¡çèæ¬ï¼å¾å°ä¸é¢ç»æï¼æ·è´å°å½ä»¤è¡æ§è¡ï¼å¦ä¸å¾æ示â
-
达梦DM8数据库的单机部署 - æ§è¡å®æ以åï¼éå¯æ°æ®åº,åæ¢å°æ°æ®åºå®è£ ç®å½binä¸é¢â