[{"_1":2,"_160":-5,"_161":-5},"loaderData",{"_3":4,"_17":18,"_25":26,"_139":140},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7,"_13":14,"_15":16},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","theme","system","contrast","normal","routes/_layout",{"_19":-5,"_20":21,"_22":21,"_23":11,"_24":21},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_27":28,"_29":-5,"_30":11,"_31":11,"_32":33,"_34":35,"_36":-5,"_37":11,"_38":39,"_88":-5,"_89":90,"_128":-5,"_129":11,"_130":21,"_131":11,"_132":-5,"_133":11,"_134":-5,"_135":136,"_137":91,"_138":-7},"canonicalUrl","https://hub.docker.com/r/qzh3578/oracle/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","qzh3578","reponame","oracle","cloudBuildSource","isAutobuildsAvailable","repo",{"_40":41,"_42":43,"_45":46,"_47":48,"_49":11,"_50":51,"_52":53,"_54":55,"_57":35,"_32":33,"_58":59,"_60":44,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":62,"_69":70,"_71":11,"_72":33,"_73":74,"_79":11,"_80":81,"_85":33,"_86":87},"categories",[],"content_types",[44],"image","date_registered","2021-03-28T08:51:34.401061Z","description","","is_private","last_updated","2021-03-28T09:04:14.991573Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[56],"application/vnd.docker.container.image.v1+json","name","pull_count",129,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","## 镜像文件\n\n```bash\n# Docker Hub 拉取\ndocker pull qzh3578/oracle:19.3.0\n```\n\n## 镜像使用\n\n```bash\ndocker run --name \\\n-p :1521 -p :5500 \\\n-e ORACLE_SID= \\\n-e ORACLE_PDB= \\\n-e ORACLE_PWD= \\\n-e INIT_SGA_SIZE= \\\n-e INIT_PGA_SIZE= \\\n-e ORACLE_EDITION= \\\n-e ORACLE_CHARACTERSET= \\\n-v [:]/opt/oracle/oradata \\\noracle:19.3.0\n\ndocker run --name oracle -p 1521:1521 -p 5500:5500 -d -e ORACLE_SID=orcl -e ORACLE_PDB=orclp -e ORACLE_PWD=qin -e INIT_SGA_SIZE=2048 -e INIT_PGA_SIZE=512 -e ORACLE_EDITION=standard -v oracle-data:/opt/oracle/oradata qzh3578/oracle:19.3.0\n```\n\n### **参数说明**\n\n### `e ORACLE_SID`\n\nOracle SID，默认为 `ORCLCDB`\n\n### `e ORACLE_PDB`\n\nOracle PDB 名称，默认为 `ORCLPDB1`。相关参见：容器数据库`\n\n### `e ORACLE_PWD`\n\nSYS、SYSTEM 和 PDB_ADMIN的密码，默认会在创建窗口时随机生成并打印在控制台\n\n### `e INIT_SGA_SIZE`\n\nSGA 内存大小，单位为 MB，参数为数值（可选）\n\n如 `-e INIT_SGA_SIZE=1536`，不要带单位\n\n仅在初次创建数据库时有效，否则即使传入参数也会被无视\n\n以下的 PGA 相同，不再赘述\n\n### `e INIT_PGA_SIZE`\n\nPGA 内存大小，单位为 MB，参数为数值（可选）\n\n### `e ORACLE_EDITION`\n\nOracle 版本：`enterprise` / `standard`\n\n### `e ORACLE_CHARACTERSET`\n\n数据库字符集，默认为 `AL32UTF8`\n\n### `v`\n\n- `/opt/oracle/oradata`：用于数据库的数据量；必须由容器内的Unix“ oracle”（uid：54321）用户可写；如果如果不配置该选项，数据库将不会持久化，即在关闭之后数据将清空。\n- `/opt/oracle/scripts/startup` ：数据库启动之后执行的自定义脚本目录（可选）\n- `/opt/oracle/scripts/setup`：在数据库 setup 之后执行的脚本目录（可选）\n\n### `p`\n\n- 1521：数据库监听端口\n- 5500：数据库控制台端口\n\n## 数据库连接\n\n```bash\nsqlplus sys/@//localhost:1521/ as sysdba\nsqlplus system/@//localhost:1521/\nsqlplus pdbadmin/@//localhost:1521/\n```\n\n## 密码修改\n\n第一次如果没有传入密码，会生成并输出在控制台。也可以使用脚本在之后修改密码：\n\n```bash\ndocker exec ./setPassword.sh \n```\n\n## 备份与恢复\n\n1. 先将 dump 文件拷贝到 DATA_PUMP_DIR `/opt/oracle/admin/ORCL/dpdump`\n\n ```bash\n docker cp XXX.DMP :/opt/oracle/admin/ORCL/dpdump\n ```\n\n2. 然后进入容器，再执行导入命令\n\n ```bash\n docker exec -it bash\n impdp system/qin@//localhost:1521/orcl directory=DATA_PUMP_DIR dumpfile=XXX.DMP log=imp_XXX.log\n ```","has_starred","hub_user","immutable_tags_settings",{"_75":11,"_76":77},"enabled","rules",[78],".*","is_automated","permissions",{"_82":21,"_83":11,"_84":11},"read","write","admin","user","storage_size",2869324557,"orgData","recentTags",[91],{"_92":44,"_93":94,"_95":96,"_97":98,"_99":100,"_50":117,"_118":94,"_119":33,"_120":56,"_57":121,"_122":123,"_124":108,"_125":117,"_126":66,"_127":21},"content_type","creator",4064165,"full_size",2869316663,"id",143287821,"images",[101],{"_102":103,"_104":105,"_106":48,"_107":108,"_109":110,"_111":112,"_113":48,"_114":-5,"_115":96,"_63":66,"_116":-5},"architecture","amd64","digest","sha256:ed4c2739fbe4bb12da8310eb57614c60c99e4617524a0d1a9420ed21d0d7585d","features","last_pulled","2026-09-27T20:30:52.188625748Z","last_pushed","2021-03-28T09:04:15Z","os","linux","os_features","os_version","size","variant","2021-03-28T09:04:14.639428Z","last_updater","last_updater_username","media_type","19.3.0","repository",11979808,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"selectedTag","attestationsUrl","routes/_layout.r.$namespace.$reponame.tags",{"_38":141,"_148":149,"_135":158,"_159":11},{"_40":142,"_42":143,"_45":46,"_47":48,"_49":11,"_50":51,"_52":53,"_54":144,"_57":35,"_32":33,"_58":59,"_60":44,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":62,"_69":70,"_71":11,"_72":33,"_73":145,"_79":11,"_80":147,"_85":33,"_86":87},[],[44],[56],{"_75":11,"_76":146},[78],{"_82":21,"_83":11,"_84":11},"tags",{"_150":64,"_151":-5,"_152":-5,"_153":154},"count","next","previous","results",[155],{"_92":44,"_93":94,"_95":96,"_97":98,"_99":156,"_50":117,"_118":94,"_119":33,"_120":56,"_57":121,"_122":123,"_124":108,"_125":117,"_126":66,"_127":21},[157],{"_102":103,"_104":105,"_106":48,"_107":108,"_109":110,"_111":112,"_113":48,"_114":-5,"_115":96,"_63":66,"_116":-5},[],"canDeleteTags","actionData","errors"]

qzh3578/oracle

Tags for qzh3578/oracle