{"id":7853,"date":"2025-04-02T18:12:28","date_gmt":"2025-04-02T09:12:28","guid":{"rendered":"https:\/\/www.climb.co.jp\/blog_dbmoto\/?p=7853"},"modified":"2025-04-02T18:16:20","modified_gmt":"2025-04-02T09:16:20","slug":"oracle-rac-one-node%e7%92%b0%e5%a2%83%e3%82%92%e6%a7%8b%e6%88%90%e3%81%97%e3%81%a6%e3%81%bf%e3%81%be%e3%81%97%e3%81%9f-%e8%a3%9c%e8%b6%b3-syniti-replicate%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%97%e3%81%a6","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7853","title":{"rendered":"Oracle RAC One Node\u74b0\u5883\u3092\u69cb\u6210\u3057\u3066\u307f\u307e\u3057\u305f \u88dc\u8db3 Syniti Replicate\u3092\u4f7f\u7528\u3057\u3066\u7570\u7a2eDB\u3078\u9023\u643a"},"content":{"rendered":"\n<p><strong><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7483\" data-type=\"link\" data-id=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7483\" target=\"_blank\" rel=\"noreferrer noopener\">\u524d\u56de\u307e\u3067\u306e\u8a18\u4e8b\u306e\u4f5c\u696d<\/a><\/strong>\u306b\u3088\u308a\u3001<strong>Oracle RAC One node\u74b0\u5883\u306e\u69cb\u6210<\/strong>\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u88dc\u8db3\u30d1\u30fc\u30c8\u3068\u3057\u3066\u3001\u5f0a\u793e\u53d6\u308a\u6271\u3044\u88fd\u54c1\u3067\u3042\u308b<strong><a href=\"https:\/\/www.climb.co.jp\/soft\/dbmoto\/\" data-type=\"link\" data-id=\"https:\/\/www.climb.co.jp\/soft\/dbmoto\/\" target=\"_blank\" rel=\"noreferrer noopener\">Syniti Replicate<\/a><\/strong>\u3092\u4f7f\u7528\u3057\u3066\u3001\u69cb\u6210\u3057\u305f<strong>Oracle RAC One node\u304b\u3089\u7570\u7a2e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3042\u308bSQL Server\u3078\u306e\u30c7\u30fc\u30bf\u9023\u643a<\/strong>\u3092\u5b9f\u65bd\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc<br><strong>\u25bdOracle RAC One node\u69cb\u6210\u95a2\u9023\u30d6\u30ed\u30b0<\/strong><br>\u3000<strong><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/6857\" target=\"_blank\" rel=\"noreferrer noopener\">\u30b9\u30c6\u30c3\u30d7\uff11\uff1aOracle Linux\u74b0\u5883\u306e\u5c0e\u5165<\/a><\/strong><br><strong>\u3000<a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/6925\" target=\"_blank\" rel=\"noreferrer noopener\">\u30b9\u30c6\u30c3\u30d7\uff12\uff1aOracle Grid Infrastructure\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u6e96\u5099<\/a><br>\u3000<a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7220\" target=\"_blank\" rel=\"noreferrer noopener\">\u30b9\u30c6\u30c3\u30d7\uff13\uff1a\u5225Oracle\u30ce\u30fc\u30c9\u306e\u69cb\u6210\u3068\u5171\u6709\u30c7\u30a3\u30b9\u30af\u306e\u8a2d\u5b9a<\/a><\/strong><br>\u3000<strong><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7271\" target=\"_blank\" rel=\"noreferrer noopener\">\u30b9\u30c6\u30c3\u30d7\uff14\uff1aOracle Grid Infrastructure\u306e\u5c0e\u5165<\/a><\/strong><br>\u3000<strong><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7483\" data-type=\"link\" data-id=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7483\" target=\"_blank\" rel=\"noreferrer noopener\">\u30b9\u30c6\u30c3\u30d7\uff15\uff1aOracle RAC One node\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/a><\/strong><br><strong>\u3000\u88dc\u8db3\uff1aSyniti Replicate\u3092\u4f7f\u7528\u3057\u3066\u7570\u7a2eDB\u3078\u9023\u643a \u2190 \u4eca\u56de\u306e\u8a18\u4e8b<br><\/strong>\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/eaea6cc56280fc8b59a73872c4742300.png\"><img loading=\"lazy\" decoding=\"async\" width=\"761\" height=\"384\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/eaea6cc56280fc8b59a73872c4742300.png\" alt=\"\" class=\"wp-image-7858\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/eaea6cc56280fc8b59a73872c4742300.png 761w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/eaea6cc56280fc8b59a73872c4742300-300x151.png 300w\" sizes=\"auto, (max-width: 761px) 100vw, 761px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Oracle RAC One node\u74b0\u5883\u306bSyniti\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5b9f\u65bd\u306e\u305f\u3081\u306e\u30e6\u30fc\u30b6\u3068\u30c6\u30b9\u30c8\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210<\/strong><\/h2>\n\n\n\n<p>\u307e\u305a\u306f\u3001\u524d\u56de\u4f5c\u6210\u3057\u305f<strong>Oracle RAC One node\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/strong>\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u3001<strong>Oracle\u304c\u7a3c\u50cd\u3057\u3066\u3044\u308b\u30ce\u30fc\u30c9<\/strong>\u306b<strong>oracle\u30e6\u30fc\u30b6\u3067SSH\u30ed\u30b0\u30a4\u30f3<\/strong>\u3057<strong>\u3001sqlplus<\/strong>\u30b3\u30de\u30f3\u30c9\u3088\u308a\u63a5\u7d9a\u3057\u307e\u3059\u3002\u305d\u306e\u5f8c<strong>show pdbs<\/strong>\u30b3\u30de\u30f3\u30c9\u3088\u308a\u4f5c\u6210\u3055\u308c\u3066\u3044\u308b\u30d7\u30e9\u30ac\u30d6\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\nshow pdbs\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/2bc645ae9e4896443f3dfd1d0794ae0e.png\"><img loading=\"lazy\" decoding=\"async\" width=\"710\" height=\"436\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/2bc645ae9e4896443f3dfd1d0794ae0e.png\" alt=\"\" class=\"wp-image-7859\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/2bc645ae9e4896443f3dfd1d0794ae0e.png 710w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/2bc645ae9e4896443f3dfd1d0794ae0e-300x184.png 300w\" sizes=\"auto, (max-width: 710px) 100vw, 710px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u4f5c\u6210\u3055\u308c\u3066\u3044\u308b\u300c<strong>PDB<\/strong>\u300d\u3068\u3044\u3046\u540d\u524d\u306e\u30d7\u30e9\u30ac\u30d6\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u3001\u4e0b\u8a18<strong>Alter<\/strong>\u30b3\u30de\u30f3\u30c9\u3088\u308aPDB\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a<strong>OPEN MODE<\/strong>\u304c<strong>READ WRITE\u306b<\/strong>\u5909\u66f4\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalter pluggable database PDB open;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/9f0ab91755d8a810f28ce913a4eb62af.png\"><img loading=\"lazy\" decoding=\"async\" width=\"722\" height=\"302\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/9f0ab91755d8a810f28ce913a4eb62af.png\" alt=\"\" class=\"wp-image-7860\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/9f0ab91755d8a810f28ce913a4eb62af.png 722w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/9f0ab91755d8a810f28ce913a4eb62af-300x125.png 300w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u8d77\u52d5\u3057\u305fPDB\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u3001\u4e0b\u8a18<strong>alter session<\/strong>\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<strong>show con_name<\/strong>\u30b3\u30de\u30f3\u30c9\u3088\u308aPDB\u306b\u63a5\u7d9a\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002 <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalter session set container = PDB;\nshow con_name\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b2943ed3b931dd0c7681f8bffb0d9330.png\"><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"374\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b2943ed3b931dd0c7681f8bffb0d9330.png\" alt=\"\" class=\"wp-image-7861\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b2943ed3b931dd0c7681f8bffb0d9330.png 414w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b2943ed3b931dd0c7681f8bffb0d9330-300x271.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>PDB\u63a5\u7d9a\u5f8c\u306f\u3001<strong>Syniti\u30c7\u30fc\u30bf\u9023\u643a\u3067\u4f7f\u7528\u3059\u308bOracle\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3057\u307e\u3059<\/strong>\u3002\u4eca\u56de\u306f\u30e6\u30fc\u30b6\u540d\/\u30d1\u30b9\u30ef\u30fc\u30c9\u5171\u306b\u300c<strong>syniti<\/strong>\u300d\u3068\u3044\u3046\u30e6\u30fc\u30b6\u3092<strong>create user<\/strong>\u30b3\u30de\u30f3\u30c9\u3088\u308a\u4f5c\u6210\u3057\u3001Syniti\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5b9f\u65bd\u306e\u305f\u3081\u306b\u5fc5\u8981\u306a\u6a29\u9650\u3092\u4ed8\u4e0e\u3059\u308b\u305f\u3081\u306b\u3001\u4e0b\u8a18<strong>grant<\/strong>\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ncreate user syniti identified by syniti;\ngrant create session to syniti;\ngrant select any table to syniti;\ngrant insert any table, update any table, delete any table to syniti;\ngrant unlimited tablespace to syniti;\ngrant create any table to syniti;\ngrant create any index to syniti;\ngrant alter any table to syniti;\ngrant drop any table to syniti;\ngrant create any trigger to syniti;\ngrant drop any trigger to syniti;\ngrant create any sequence to syniti;\ngrant drop any sequence to syniti;\ngrant select any sequence to syniti;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/bd367dc19f12bdf8161e8f0607c884ce.png\"><img loading=\"lazy\" decoding=\"async\" width=\"635\" height=\"1024\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/bd367dc19f12bdf8161e8f0607c884ce-635x1024.png\" alt=\"\" class=\"wp-image-7862\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/bd367dc19f12bdf8161e8f0607c884ce-635x1024.png 635w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/bd367dc19f12bdf8161e8f0607c884ce-186x300.png 186w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/bd367dc19f12bdf8161e8f0607c884ce.png 659w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p><br><strong>Syniti\u30c7\u30fc\u30bf\u9023\u643a\u3092\u30c6\u30b9\u30c8\u3059\u308b\u305f\u3081\u306e\u30c6\u30fc\u30d6\u30eb\u3082\u4f5c\u6210\u3057\u307e\u3059<\/strong>\u3002\u4eca\u56de\u306f\u4e0b\u8a18<strong>create table<\/strong>\u30b3\u30de\u30f3\u30c9\u3088\u308a<strong>syniti\u30b9\u30ad\u30fc\u30de\u5185<\/strong>\u306b\u300c<strong>TESTTABLE<\/strong>\u300d\u3068\u3044\u3046\u540d\u524d\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3001<strong>insert<\/strong>\u30af\u30a8\u30ea\u3088\u308a\u300c<strong>1, aaa<\/strong>\u300d\u3068\u300c<strong>2, bbb<\/strong>\u300d\u3068\u3044\u3046\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ncreate table syniti.TESTTABLE\n(\n   C1 varchar(20) NOT NULL ,\n   C2 varchar(20) NULL ,\n   primary key(C1)\n)\n;\n\ninsert into syniti.TESTTABLE values (&#039;1&#039;, &#039;aaa&#039;);\ninsert into syniti.TESTTABLE values (&#039;2&#039;, &#039;bbb&#039;);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/2b09f81be3b882af2cb9fe9615fb0486.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"738\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/2b09f81be3b882af2cb9fe9615fb0486.png\" alt=\"\" class=\"wp-image-7863\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/2b09f81be3b882af2cb9fe9615fb0486.png 667w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/2b09f81be3b882af2cb9fe9615fb0486-271x300.png 271w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u6700\u5f8c\u306b\u4e0b\u8a18<strong>show parameter service_name\u30b3<\/strong>\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001Syniti\u304b\u3089\u306e\u63a5\u7d9a\u8a2d\u5b9a\u6642\u306b\u5fc5\u8981\u3068\u306a\u308b<strong>Oracle\u30b5\u30fc\u30d3\u30b9\u540d<\/strong>\u3092\u78ba\u8a8d\u3057\u3066\u304a\u304d\u307e\u3059\u3002\u4eca\u56de\u306e\u30b1\u30fc\u30b9\u3067\u306f\u300corcl.oracle.com\u300d\u304c\u30b5\u30fc\u30d3\u30b9\u540d\u3060\u3063\u305f\u306e\u3067\u3001SID\u3067\u3042\u308borcl\u90e8\u5206\u3092pdb\u540d\u306b\u5909\u66f4\u3057\u305f\u300c<strong>pdb.oracle.com<\/strong>\u300d\u304cSyniti\u63a5\u7d9a\u5148\u306e\u30b5\u30fc\u30d3\u30b9\u540d\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nshow parameter service_name\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/ee2c375df8b620f66b51607b41eaa99a.png\"><img loading=\"lazy\" decoding=\"async\" width=\"554\" height=\"320\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/ee2c375df8b620f66b51607b41eaa99a.png\" alt=\"\" class=\"wp-image-7865\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/ee2c375df8b620f66b51607b41eaa99a.png 554w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/ee2c375df8b620f66b51607b41eaa99a-300x173.png 300w\" sizes=\"auto, (max-width: 554px) 100vw, 554px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3053\u308c\u3067Oracle\u5074\u306e\u6e96\u5099\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002\u3053\u3053\u304b\u3089\u306fSyniti\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305fWindows\u30de\u30b7\u30f3\u4e0a\u3067\u958b\u3044\u305f\u3001Syniti\u7ba1\u7406\u753b\u9762\u304b\u3089\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a\u3092\u884c\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Syniti\u306b\u3088\u308bOracle RAC One node\u304b\u3089SQL Server\u3078\u306e\u30c7\u30fc\u30bf\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/strong><\/h2>\n\n\n\n<p>Syniti\u304cOracle RAC One node\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306b\u306f\u3001<strong><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/268\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle Client\u5c0e\u5165\u6642<\/a><\/strong>\u306b\u5c55\u958b\u3055\u308c\u308b<strong>tnsnames.ora<\/strong>\u30d5\u30a1\u30a4\u30eb\u306b\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306a\u63a5\u7d9a\u60c5\u5831\u3092\u8ffd\u8a18\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p> <strong>\u63a5\u7d9a\u6587\u5b57\u5217(\u4efb\u610f) <\/strong>=<br>(DESCRIPTION =<br>(ADDRESS_LIST =<br>(ADDRESS = (PROTOCOL = TCP)(HOST = <strong>\u30ce\u30fc\u30c91\u306eIP\u30a2\u30c9\u30ec\u30b9<\/strong>)(PORT = 1521))<br>(ADDRESS = (PROTOCOL = TCP)(HOST = <strong>\u30ce\u30fc\u30c92\u306eIP\u30a2\u30c9\u30ec\u30b9<\/strong>)(PORT = 1521))<br>)<br>(CONNECT_DATA =<br>(SERVICE_NAME = <strong>Oracle\u30b5\u30fc\u30d3\u30b9\u540d<\/strong>)<br>)<br>)<\/p>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u30ce\u30fc\u30c91\u3068\u30ce\u30fc\u30c92\u306e\u53cc\u65b9\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u8a18\u8f09\u3059\u308b\u3053\u3068\u3067\u3001\u969c\u5bb3\u3084\u30e9\u30a4\u30d6\u30d5\u30a7\u30a4\u30eb\u30aa\u30fc\u30d0\u306a\u3069\u3067\u7a3c\u50cd\u3057\u3066\u3044\u308bOracle\u30ce\u30fc\u30c9\u304c\u5207\u308a\u66ff\u308f\u3063\u305f\u3068\u3057\u3066\u3082\u3001\u7d99\u7d9a\u3057\u3066\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u63a5\u7d9a\u6587\u5b57\u5217\u3092\u300c<strong>ORAPDB<\/strong>\u300d\u306b\u3001HOST\u306fOracle RAC One node\u69cb\u7bc9\u6642\u306b\u5404\u30ce\u30fc\u30c9\u306b\u6307\u5b9a\u3057\u305fIP\u30a2\u30c9\u30ec\u30b9\u3001Oracle\u30b5\u30fc\u30d3\u30b9\u540d\u306f\u5148\u307b\u3069\u78ba\u8a8d\u3057\u305f\u300c<strong>pdb.oracle.com<\/strong>\u300d\u3068\u306a\u308b\u306e\u3067\u3001\u4e0b\u8a18\u753b\u50cf\u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b79ee794dbefb68a1ca73d9babc2d262.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1014\" height=\"291\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b79ee794dbefb68a1ca73d9babc2d262.png\" alt=\"\" class=\"wp-image-7866\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b79ee794dbefb68a1ca73d9babc2d262.png 1014w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b79ee794dbefb68a1ca73d9babc2d262-300x86.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/03\/b79ee794dbefb68a1ca73d9babc2d262-768x220.png 768w\" sizes=\"auto, (max-width: 1014px) 100vw, 1014px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u8a2d\u5b9a\u5f8c\u3001Syniti\u7ba1\u7406\u753b\u9762\u304b\u3089Oracle RAC One node\u74b0\u5883\u3078\u306e\u63a5\u7d9a\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002\u4eca\u56de\u306f<strong>Data Souce<\/strong>\u9805\u76ee\u306btnsnames.ora\u30d5\u30a1\u30a4\u30eb\u306b\u8a18\u8f09\u3057\u305f\u63a5\u7d9a\u6587\u5b57\u5217\u3067\u3042\u308b\u300c<strong>ORAPDB<\/strong>\u300d\u3092\u3001User ID\u3068Password\u9805\u76ee\u306bOracle RAC One node\u74b0\u5883\u3067\u4f5c\u6210\u3057\u305f\u300c<strong>syniti\u300d\u30e6\u30fc\u30b6<\/strong>\u306e\u8a8d\u8a3c\u60c5\u5831\u3092\u5165\u529b\u3057\u300c\u30c6\u30b9\u30c8\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u4e0b\u3057\u307e\u3059\u3002<strong>\u300c\u30c6\u30b9\u30c8\u6210\u529f!<\/strong>\u300d\u3068\u51fa\u529b\u3057\u305f\u306e\u3067\u3001\u3053\u308c\u306b\u3088\u308aSyniti\u30b5\u30fc\u30d0\u304b\u3089Oracle RAC One node\u74b0\u5883\u3078\u306e\u63a5\u7d9a\u304c\u5b9f\u65bd\u3067\u304d\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/70e28b025358c0919bd568bb0478d707.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"449\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/70e28b025358c0919bd568bb0478d707-1024x449.png\" alt=\"\" class=\"wp-image-7869\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/70e28b025358c0919bd568bb0478d707-1024x449.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/70e28b025358c0919bd568bb0478d707-300x132.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/70e28b025358c0919bd568bb0478d707-768x337.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/70e28b025358c0919bd568bb0478d707.png 1282w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u3001Syniti\u30b9\u30ad\u30fc\u30de\u5185\u306b\u4f5c\u6210\u3057\u305f\u30c6\u30b9\u30c8\u30c6\u30fc\u30d6\u30eb\u3067\u3042\u308b\u300c<strong>TESTTABLE<\/strong>\u300d\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u3053\u3061\u3089\u3092\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5bfe\u8c61\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u8a2d\u5b9a\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/b3644ffca073d60e35c30f3128c3b31f.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"500\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/b3644ffca073d60e35c30f3128c3b31f-1024x500.png\" alt=\"\" class=\"wp-image-7870\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/b3644ffca073d60e35c30f3128c3b31f-1024x500.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/b3644ffca073d60e35c30f3128c3b31f-300x146.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/b3644ffca073d60e35c30f3128c3b31f-768x375.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/b3644ffca073d60e35c30f3128c3b31f.png 1285w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Syniti\u753b\u9762\u304b\u3089\u3082\u4f5c\u6210\u3057\u305f\u300c<strong>TESTTABLE<\/strong>\u300d\u306e\u30ec\u30b3\u30fc\u30c9\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/8e1901f4575cefdd58fbb17e0320e84b.png\"><img loading=\"lazy\" decoding=\"async\" width=\"851\" height=\"436\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/8e1901f4575cefdd58fbb17e0320e84b.png\" alt=\"\" class=\"wp-image-7880\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/8e1901f4575cefdd58fbb17e0320e84b.png 851w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/8e1901f4575cefdd58fbb17e0320e84b-300x154.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/8e1901f4575cefdd58fbb17e0320e84b-768x393.png 768w\" sizes=\"auto, (max-width: 851px) 100vw, 851px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u307e\u305f\u3001Oracle RAC One node\u74b0\u5883\u304b\u3089\u306e\u5dee\u5206\u9023\u643a\u5b9f\u65bd\u306e\u305f\u3081\u306b\u306f\u3001\u5dee\u5206\u9023\u643a\u65b9\u5f0f\u3068\u3057\u3066\u300c<strong>Trigger<\/strong>\u300d(\u30c8\u30ea\u30ac\u30fc)\u3092\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3001\u30c8\u30ea\u30ac\u30fc\u306e\u8a2d\u5b9a\u3068syniti\u30b9\u30ad\u30fc\u30de\u5185\u306b\u30c8\u30ea\u30ac\u30fc\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u3088\u3046\u306b\u8a2d\u8a08\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/d08edf66950dd2edacacc82f19e80452.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"424\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/d08edf66950dd2edacacc82f19e80452-1024x424.png\" alt=\"\" class=\"wp-image-7871\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/d08edf66950dd2edacacc82f19e80452-1024x424.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/d08edf66950dd2edacacc82f19e80452-300x124.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/d08edf66950dd2edacacc82f19e80452-768x318.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/d08edf66950dd2edacacc82f19e80452-1536x636.png 1536w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/d08edf66950dd2edacacc82f19e80452.png 1702w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u5f8c\u306f\u901a\u5e38\u306e\u5dee\u5206\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a\u3068\u540c\u69d8\u306b\u5b9f\u65bd\u3067\u304d\u307e\u3059\u3002SQL Server\u3068\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a\u3092\u884c\u3044\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001\u300c<strong>TESTTABLE<\/strong>\u300d\u5185\u306e\u30b5\u30f3\u30d7\u30eb\u30ec\u30b3\u30fc\u30c9\u3092SQL Server\u5074\u306e\u30c6\u30fc\u30d6\u30eb\u3078\u9023\u643a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3053\u3068\u3084\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/5ac82127342f9e43a93f3f223d35f297.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/5ac82127342f9e43a93f3f223d35f297-1024x510.png\" alt=\"\" class=\"wp-image-7873\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/5ac82127342f9e43a93f3f223d35f297-1024x510.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/5ac82127342f9e43a93f3f223d35f297-300x150.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/5ac82127342f9e43a93f3f223d35f297-768x383.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/5ac82127342f9e43a93f3f223d35f297.png 1509w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u3000\u3000<\/p>\n\n\n\n<p>\uff11\u3064\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u66f4\u65b0\u3057\u3001\u5dee\u5206\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u5b9f\u884c\u3067\u304d\u308b\u3053\u3068\u3082\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/ab7cfd2e3f65d4565b57e22006a155a6.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"400\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/ab7cfd2e3f65d4565b57e22006a155a6-1024x400.png\" alt=\"\" class=\"wp-image-7874\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/ab7cfd2e3f65d4565b57e22006a155a6-1024x400.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/ab7cfd2e3f65d4565b57e22006a155a6-300x117.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/ab7cfd2e3f65d4565b57e22006a155a6-768x300.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/ab7cfd2e3f65d4565b57e22006a155a6-1536x600.png 1536w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2025\/04\/ab7cfd2e3f65d4565b57e22006a155a6.png 1732w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u524d\u56de\u307e\u3067\u306e\u8a18\u4e8b\u306e\u4f5c\u696d\u306b\u3088\u308a\u3001Oracle RAC One node\u74b0\u5883\u306e\u69cb\u6210\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u88dc\u8db3\u30d1\u30fc\u30c8\u3068\u3057\u3066\u3001\u5f0a\u793e\u53d6\u308a\u6271\u3044\u88fd\u54c1\u3067\u3042\u308bSyniti Replicate\u3092\u4f7f\u7528\u3057\u3066\u3001\u69cb\u6210\u3057\u305fOracle RAC One  &hellip; <a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7853\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-7853","post","type-post","status-publish","format-standard","hentry","category-syniti"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/7853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=7853"}],"version-history":[{"count":11,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/7853\/revisions"}],"predecessor-version":[{"id":7882,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/7853\/revisions\/7882"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=7853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=7853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=7853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}