Docker 安装 Oracle 11G  镜像docker pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/akaiot/oracle_11g:latestdocker tag swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/akaiot/oracle_11g:latest docker.io/akaiot/oracle_11g:latest创建并启动容器mkdir -p /home/oracle/app/oracle11g/oradata# 容器内端口默认1521，且通过 -p 参数修改不成功,所以只能修改外部的端口docker run -itd --name oracle11g --restart=always -p 1523:1521 -v /home/oracle/app/oracle11g/oradata:/home/oracle/app/oracle11g/oradata docker.io/akaiot/oracle_11g:latest查看日志docker logs -f --tail 100 oracle11g/home/oracle/app/oracle/product/11.2.0/dbhome_2Processing Database instance "helowin": log file /home/oracle/app/oracle/product/11.2.0/dbhome_2/startup.logFixed Size                  2213776 bytesVariable Size             402655344 bytesDatabase Buffers         1174405120 bytesRedo Buffers               24137728 bytesDatabase mounted.Database opened.SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options/home/oracle/app/oracle/product/11.2.0/dbhome_2/bin/dbstart: Database instance "helowin" warm started.tail: unrecognized file system type 0x794c7630 for `/home/oracle/app/oracle/product/11.2.0/dbhome_2/startup.log'. Reverting to polling.登录到容器内docker exec -it oracle11g bash配置环境变量su rootPassword: helowinvi /etc/profileexport ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2export ORACLE_SID=helowinexport PATH=$ORACLE_HOME/bin:$PATHsource /etc/profilevi /home/oracle/.bashrcexport ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2export ORACLE_SID=helowinexport PATH=$ORACLE_HOME/bin:$PATHsource /home/oracle/.bashrc登录# 必须要切到 oracle 用户su oraclesqlplus / as sysdba查询数据库状态SELECT status FROM v$instance;STATUS------------OPEN连接验证• SID 和 Service Name 均为 helowin• 用密码密码： sys/oracle修改密码alter user system identified by test123;alter user sys identified by test123;异常记录ORA-00205: error in identifying control file, check alert log for more info异常原因：运行容器是指定的目录为 /home/oracle/app/oracle/oradata ，该目录是容器内安装Oracle自带的目录，换一个别的新建目录即可删除 Docker 容器docker stop oracle11gdocker rm oracle11g相关阅读• Docker 安装 Oracle 12C 🧐 分享、点赞、在看，给个3连击呗！👇

海量数据库安装使用 安装完毕安装指南[[VASTDATA]Vastbase+G100+V2.2+安装升级指南.pdf](/usr/uploads/2024/12/571749712.pdf)用户手册[[VASTDATA]Vastbase+Data+Studio+V3.3.1+用户手册.pdf](/usr/uploads/2024/12/629516846.pdf)和工具使用手册[[VASTDATA]exBase+V4.4+安装说明文档.pdf](/usr/uploads/2024/12/2793356904.pdf)启用、停止、重启数据库:切换到vastbase用户 vb_ctl <start/stop/restart>连接数据库切换到vastbase用户[root@KylinV10 ~]# su vastbase [vastbase@KylinV10 root]$ vsql -r vsql ((Vastbase G100 V2.2 (Build 15) Release) compiled at 2024-09-26 15:32:03 commit 22518 last mr ) 非SSL连接（安全性要求高时，建议使用SSL连接） 输入 "help" 来获取帮助信息。 vastbase-# \q [vastbase@KylinV10 root]$ vsql -d vastbase -p 5432 vsql ((Vastbase G100 V2.2 (Build 15) Release) compiled at 2024-09-26 15:32:03 commit 22518 last mr ) 非SSL连接（安全性要求高时，建议使用SSL连接） 输入 "help" 来获取帮助信息。创建库vastbase=# CREATE USER test123 WITH PASSWORD "test@123456"; CREATE ROLE vastbase=# GRANT ALL PRIVILEGES TO admin; ALTER ROLE vastbase=# CREATE DATABASE a_test OWNER admin; CREATE DATABASE vastbase=# CREATE DATABASE a_test OWNER admin; CREATE DATABASE vastbase=#以下是几个备份工具的测试操作记录{card-list}{card-list-item}vsql -c -d xj_test -p 5432 -f backup_all.sql vsql -d xj_test -p 5432 -f backup_all.sql vb_probackup init -B /home/vastbase/backup_test vb_probackup show-config -B /home/vastbase/backup_test -D /home/vastbase/data/vastbase/base --instance=my_vastbase_backup_test 全库备份： pg_dump -U ixjkj -W Xj@123456 -h 192.168.0.204 -p5432 -f /home/vastbase/backup_test/backup_A xj_hzgdd 全库恢复 pg_restore -U ixjkj -h 192.168.0.204 -p5432 -C -1 -t xj_hzgdd /home/vastbase/backup_test/backup_A vb_restore -d xj_hzgdd /home/vastbase/backup_test/backup_A -c vb_restore -d vastbase -C /home/vastbase/backup_test/backup_A vsql -d xj_hzgdd -p 5432 -f /home/vastbase/backup_test/backup_A vsql -d xj_lssj -p 5432 -f /home/vastbase/backup_test/backup_A{/card-list-item}{card-list-item} 列表二内容{/card-list-item}{/card-list}