北部湾数智履职

来自ling
跳转至: 导航搜索

重要

aarch64

达梦数据库等

https://blog.csdn.net/yujiubo2008/article/details/128973760

https://eco.dameng.com/download/

https://blog.csdn.net/qq798280904/article/details/129782153

docker load -i dm8_20220822_rev166351_x86_rh6_64_ctm.tar
docker run -d -p 5236:5236 --restart=always --name dm8_01 --privileged=true -e PAGE_SIZE=16 -e LD_LIBRARY_PATH=/opt/dmdbms/bin -e INSTANCE_NAME=dm8_01 -v /alidata/dm/data/dm8_01:/opt/dmdbms/data dm8_single:v8.1.2.128_ent_x86_64_ctm_pack4

docker logs -f dm8_01

docker run -d -p 5237:5236 --restart=always --name dm8_02 --privileged=true -e PAGE_SIZE=32 -e CASE_SENSITIVE=0 -e UNICODE_FLAG=1 -e LD_LIBRARY_PATH=/opt/dmdbms/bin -e INSTANCE_NAME=dm8_02 -v /alidata/dm/data/dm8_02:/opt/dmdbms/data dm8_single:v8.1.2.128_ent_x86_64_ctm_pack4
docker run -d -p 5236:5236 --restart=always --name dm8_02 --privileged=true -e PAGE_SIZE=32 -e CASE_SENSITIVE=0 -e UNICODE_FLAG=1 -e LD_LIBRARY_PATH=/opt/dmdbms/bin -e INSTANCE_NAME=dm8_02 -v /alidata/dm/data/dm8_02:/opt/dmdbms/data dm8_single:v8.1.2.128_ent_x86_64_ctm_pack4
docker logs -f dm8_02


1.如果使用 docker 容器里面的 disql,进入容器后,先执行 source /etc/profile 防止中文乱码。

2.新版本 Docker 镜像中数据库默认用户名/密码为 SYSDBA/SYSDBA001。

java

https://eco.dameng.com/document/dm/zh-cn/start/java-development.html

https://eco.dameng.com/document/dm/zh-cn/start/migrate-mysql-dm.html

达梦

数据文件创建在容器外,授权到期重新创建容器即可

(SELECT '运行环境:CPU核数:'||N_CPU||',物理内存:'||TOTAL_PHY_SIZE/1024/1024 "查询信息" FROM V$SYSTEMINFO LIMIT 0,1) UNION
SELECT '授权信息:产品编号:'||TO_CHAR(SERIES_NO)||',期限:'||TO_CHAR(EXPIRED_DATE)||',授权CPU:'||TO_CHAR(MAX_CPU_NUM)||',用户:'||TO_CHAR(AUTHORIZED_CUSTOMER)||',项目:'||TO_CHAR(PROJECT_NAME)||',文件版本'||TO_CHAR(LIC_VERSION) FROM V$LICENSE UNION
--(SELECT '数据库版本:' ||BANNER FROM V$VERSION LIMIT 0,1) UNION   --DM7
(SELECT '数据库版本:'||BANNER||' '||ID_CODE FROM V$VERSION LIMIT 0,1) UNION --DM8
SELECT  '实例信息:数据库名 ' ||D.NAME||',实例名:'||I.INSTANCE_NAME||',实例状态:'||I.STATUS$||',实例模式:'||I.MODE$ FROM V$DATABASE D,V$INSTANCE I,V$DM_INI DI UNION
SELECT '基本参数1:数据库永久魔数:'||PERMANENT_MAGIC||',数据库魔数:'||DB_MAGIC||',页:'||TO_CHAR(PAGE)||',蔟:'||SF_GET_EXTENT_SIZE ()||',字符集:'||TO_CHAR(UNICODE)||',大小写敏感:'||TO_CHAR(CASE_SENSITIVE) UNION
SELECT '归档信息:名称:'||ARCH_NAME||',路径:'||ARCH_DEST||',大小:'||TO_CHAR(ARCH_FILE_SIZE)||',最大使用空间:'||TO_CHAR(ARCH_SPACE_LIMIT) FROM V$DM_ARCH_INI UNION
SELECT '数据表空间文件总大小:'||sum(bytes/1024/1024)||' MB'||',数据表空间文件实际使用总大小:'||sum(user_bytes/1024/1024)||' MB' FROM DBA_DATA_FILES WHERE TABLESPACE_NAME NOT IN ('ROLL','TEMP','SYSTEM') UNION
(SELECT * FROM (SELECT '最后一个归档:'||PATH||',创建时间:'||TO_CHAR(CREATE_TIME)||',最后操作时间:'||TO_CHAR(CLOSE_TIME) FROM V$ARCH_FILE ORDER BY CLOSE_TIME DESC  LIMIT 0,1)) UNION
SELECT 'REDO信息:日志组:'||TO_CHAR(GROUP_ID)||',文件号:'||TO_CHAR(FILE_ID)||',路径'||PATH||',大小'||TO_CHAR(RLOG_SIZE/1024/1024) FROM V$RLOGFILE UNION
SELECT '其他参数:'||PARA_NAME||':'||PARA_VALUE FROM V$DM_INI WHERE PARA_NAME IN ('LENGTH_IN_CHAR','BLANK_PAD_MODE','COMPATIBLE_MODE','MS_PARSE_PERMIT','PORT_NUM','MAX_SESSIONS','EXCLUDE_RESERVED_WORDS','PK_WITH_CLUSTER');

开发工具和链接

1. Node.js 版本16以上 ok https://nodejs.org/dist/latest-v16.x/node-v16.20.2-x64.msi

2. Webstorm或者VScode 提供VScode

https://code.visualstudio.com/Download

https://az764295.vo.msecnd.net/stable/6c3e3dba23e8fadc360aed75ce363ba185c49794/VSCodeUserSetup-x64-1.81.1.exe

3. HBuilderX ok

https://www.dcloud.io/?md_download_url=https%3A%2F%2Fqiniu-ecdn.dcloud.net.cn%2Fdownload%2FHBuilderX.3.8.12.20230817.zip&md_download_filename=

5. JDK 8 ok

https://www.oracle.com/java/technologies/downloads/#java8-windows

https://www.openlogic.com/openjdk-downloads

6. Maven 版本 3.8.* ok

https://dlcdn.apache.org/maven/maven-3/3.9.4/binaries/apache-maven-3.9.4-bin.zip

8. Idea ok,社区版

https://download.jetbrains.com.cn/idea/ideaIC-2023.2.exe

11. PostMan ok

https://dl.pstmn.io/download/latest/win64

docker

https://blog.csdn.net/flq18210105507/article/details/130820248

Redis

https://blog.csdn.net/myydan/article/details/131140859