北部湾数智履职
重要
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
3. HBuilderX ok
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