{"id":7181,"date":"2024-11-17T16:30:52","date_gmt":"2024-11-17T07:30:52","guid":{"rendered":"https:\/\/pecos.ddns.net\/wordpress\/?p=7181"},"modified":"2024-11-17T20:06:40","modified_gmt":"2024-11-17T11:06:40","slug":"oracle-19c-docker-%e4%bd%9c%e6%88%90%e3%81%a8%e4%bd%bf%e7%94%a8%e6%ba%96%e5%82%99","status":"publish","type":"post","link":"https:\/\/pecos.ddns.net\/wordpress\/?p=7181","title":{"rendered":"Oracle 19c docker \u4f5c\u6210\u3068\u4f7f\u7528\u6e96\u5099"},"content":{"rendered":"

\u624b\u9806\u3092\u5fd8\u308c\u3066\u3057\u307e\u3044\u305d\u3046\u306a\u306e\u3067\uff64\uff64\uff64\u30e1\u30e2<\/p>\n

linux\u7528\u306eoracle\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304a\u304f<\/p>\n

https:\/\/www.oracle.com\/jp\/database\/technologies\/oracle-database-18c\/enterprise-edition.html<\/p>\n

docker image\u4f5c\u6210 (standard edition\u3067\u4f5c\u6210)<\/p>\n

\r\n$ git clone https:\/\/github.com\/oracle\/docker-images.git\r\n$ cd docker-images\/OracleDatabase\/SingleInstance\/dockerfiles\/19.3.0\r\n$ cp <path-to-zip>\/LINUX.X64_193000_db_home.zip .\r\n$ cd ..\r\n$ .\/buildContainerImage.sh -v 19.3.0 -s\r\n$ mkdir dump\r\n$ chmod 777 dump\r\n$ mkdir oradata\r\n$ chmod 777 oradata\r\n<\/pre>\n
docker\u3092\u8d77\u52d5\u3057\u3066\u3001PDB\u306b\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210\u3057\u3001\u30a4\u30f3\u30dd\u30fc\u30c8\u7528\u306edir\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057\u30a4\u30f3\u30dd\u30fc\u30c8\u3092\u5b9f\u884c\u3059\u308b\u307e\u3067
\n(dump\u304c\u53e4\u3044\u306e\u3067shift-jis\u3067\u4f5c\u308b)<\/p>\n
\r\nservices:\r\n  db:\r\n    image: oracle\/database:19.3.0-se2\r\n    ports:\r\n      - 1521:1521\r\n      - 5500:5500\r\n    volumes:\r\n      - .\/oradata:\/opt\/oracle\/oradata\r\n      - .\/dump:\/opt\/oracle\/dump\r\n    environment:\r\n      - ORACLE_PWD=<SYSPASS>\r\n      - ORACLE_PDB=<PDB>\r\n      - ORACLE_CHARACTERSET=JA16SJISTILDE\r\n<\/pre>\n
\r\n$ docker compose up -d\r\n$ docker compose exec db bash\r\n<\/pre>\n
\r\nbash$ sqlplus \/ as sysdba\r\nSQL> SELECT NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')),NLS_CHARSET_NAME(NLS_CHARSET_ID('NCHAR_CS')) FROM DUAL;\r\nSQL> alter session set container = <PDB>;\r\nSQL> create user <USER> identified by <PASS>;\r\nSQL> grant dba to <USER>;\r\nSQL> create directory DUMPDIR as '\/opt\/oracle\/dump\/';\r\nSQL> grant read on directory DUMPDIR to <USER>;\r\nSQL> grant write on directory DUMPDIR to <USER>;\r\nSQL> exit\r\nbash$ impdp <USER>\/<PASS>@<PDB> remap_schema=<USER>:<USER> DIRECTORY=DUMPDIR dumpfile=DATA.DMP logfile=DATA.log\r\nbash$ exit\r\n<\/pre>\n
\r\n$ docker compose down\r\n<\/pre>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6587\u5b57\u30bb\u30c3\u30c8\u5909\u63db\u3092\u3057\u305f\u3089\u58ca\u308c\u305f\uff57<\/p>\n
\r\nSQL> SHUTDOWN IMMEDIATE;\r\nSTARTUP MOUNT;\r\nALTER SYSTEM ENABLE RESTRICTED SESSION;\r\nALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;\r\nALTER SYSTEM SET AQ_TM_PROCESSES=0;\r\nALTER DATABASE OPEN;\r\nALTER DATABASE CHARACTER SET INTERNAL_USE JA16SJISTILDE;\r\nSHUTDOWN IMMEDIATE;\r\nSTARTUP;\r\nTotal System Global Area 1610609928 bytes\r\nFixed Size                  9135368 bytes\r\nVariable Size             452984832 bytes\r\nDatabase Buffers         1140850688 bytes\r\nRedo Buffers                7639040 bytes\r\nSQL> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';\r\nSQL>\r\nVALUE\r\n--------------------------------------------------------------------------------\r\nJA16SJISTILDE\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
\u624b\u9806\u3092\u5fd8\u308c\u3066\u3057\u307e\u3044\u305d\u3046\u306a\u306e\u3067\uff64\uff64\uff64\u30e1\u30e2 linux\u7528\u306eoracle\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304a\u304f https:\/\/www.oracle.com\/jp\/database\/technologies\/oracle-database-1 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,5],"tags":[],"class_list":["post-7181","post","type-post","status-publish","format-standard","hentry","category-pc","category-5"],"_links":{"self":[{"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/7181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7181"}],"version-history":[{"count":12,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/7181\/revisions"}],"predecessor-version":[{"id":7193,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/7181\/revisions\/7193"}],"wp:attachment":[{"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}