æ¬èšäºã¯ 2026 幎 8 æ 11 æ¥ ã«å
¬éãããã Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock ãã翻蚳ãããã®ã§ãã Amazon Relational Database Service (Amazon RDS) for Oracle ã§ Oracle Database 26ai ãå©çšå¯èœã«ãªããŸãããAmazon RDS ã«ããã Oracle åã® AI ãã€ãã£ããªããŒã¿ããŒã¹ãªãªãŒã¹ã§ãçæ AIããã¯ãã«æ€çŽ¢ãæ©æ¢°åŠç¿ããšã³ãžã³ã«çŽæ¥çµã¿èŸŒãŸããŠããŸããããã¯ã¢ããããããé©çšããã«ã AZ ã«ããé«å¯çšæ§ããªãŒãã¬ããªã«ã¯ Amazon RDS ãåŠçãããããã€ã³ãã©ã¹ãã©ã¯ãã£ã®ç®¡çã§ã¯ãªã AI ã¢ããªã±ãŒã·ã§ã³ã®æ§ç¯ã«éäžã§ããŸãã æ¬èšäºã§ã¯ãæ°æ©èœã®ãªãã§ãç¹ã«å¹æã®å€§ãã Select AI ã玹ä»ããŸããSelect AI ã§ã¯ãAmazon Bedrock ã®åºç€ã¢ãã« (FM) ã䜿ããèªç¶èšèªã®ããã³ããã§ãªã¬ãŒã·ã§ãã«ããŒã¿ãç
§äŒã§ããŸãããä»ååæã®å£²äžäžäœ 5 瀟ã®é¡§å®¢ã¯?ããšããŒã¿ããŒã¹ã«å°ããã°ãã³ãŒãã 1 è¡ãæžããã«ãæ£ãã SQL ãšãã®å®è¡çµæãè¿ã£ãŠããŸããå
éšã§ã¯ãOracle ã® DBMS_CLOUD_AI ããã±ãŒãžãããŒãã«ã®ã¹ããŒããå«ãããã³ãããçµã¿ç«ãŠãéžæããåºç€ã¢ãã«ã«éä¿¡ããŸããçæããã SQL ãå®ããŒã¿ã«å¯ŸããŠå®è¡ããçµæãè¿ããŸã§ã®ãã¹ãŠãåäžã®ããŒã¿ããŒã¹ã»ãã·ã§ã³å
ã§å®çµããŸãã ãã®ã¢ãŒããã¯ãã£ãªããAI ã€ã³ãã©ã¹ãã©ã¯ãã£ãèªåã§æ§ç¯ããéçšè² è·ããªããªããŸããAmazon Bedrock ã¯ãã«ãããŒãžããã€ãµãŒããŒã¬ã¹ã§ããããããžã§ãã³ã°ãã GPU ãããã¹ãããã¢ãã«ããç¶æããæšè«ãšã³ããã€ã³ãããããŸãããAnthropicãMetaãAmazon ãšãã£ããããã€ããŒã®åºç€ã¢ãã«ã«åäžã® API ã§ã¢ã¯ã»ã¹ã§ãã DBMS_CLOUD_AI ãããã¡ã€ã«ã®å±æ§ã 1 ã€å€ããã ãã§ã¢ãã«ãåãæ¿ããããŸããã»ãã¥ãªãã£ã¯ããã§ã«äœ¿ãæ
£ãã Amazon RDS ã®ã¢ãã«ã«åŸããŸããSelect AI ã®ãªã¯ãšã¹ã㯠Virtual Private Cloud (VPC) ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ããçµç±ãããããããŒã¿ã¯ VPC å
ã«çãŸãããããªãã¯ã€ã³ã¿ãŒããããéããŸããã DBMS_CLOUD_AI ã¯ãã€ãã£ã㪠PL/SQL ãªã®ã§ããã§ã«æã£ãŠãã SQL ã®ã¹ãã«ã§çæ AI æ©èœãæ§ç¯ã§ããŸããå¥é AI ã¹ã¿ãã¯ãåŠãã ãç¶æãããããå¿
èŠã¯ãããŸããã æ¬èšäºã¯ãAmazon RDS äžã® Oracle Database 26ai ã® AI æ©èœãæ±ã 3 åã·ãªãŒãºã®ç¬¬ 1 åã§ããä»åã¯ãAmazon Bedrock ã®èªèšŒæ
å ±ã®èšå®ããèªç¶èšèªã¯ãšãªã®å®è¡ãŸã§ãSelect AI ãäžéã解説ããŸãã第 2 åã§ã¯ Oracle AI Vector Search ã«ãã Retrieval Augmented Generation (RAG) ãã第 3 åã§ã¯ SQL ããããã£ã°ã©ãã䜿ã£ã GraphRAG ãåãäžããã°ã©ãæ¢çŽ¢ããã¯ãã«æ€çŽ¢ããªã¬ãŒã·ã§ãã«ãªãã£ã«ã¿ãªã³ã°ã 1 ã€ã® SQL ã¯ãšãªã§çµã¿åãããæ¹æ³ã玹ä»ããŸãã Amazon RDS äžã® Oracle Database 26ai ã® AI æ©èœ Amazon RDS äžã® Oracle Database 26ai ãš Amazon Bedrock ãçµã¿åããããšãæ¬¡ã®æ©èœã䜿ããŸãã æ©èœ å
容 ãŠãŒã¹ã±ãŒã¹ã®äŸ Select AI (NL2SQL) èªç¶èšèªã®ããã³ããã SQL ã«å€æããã¯ãšãªãå®è¡ããŠãåäžã® SQL ã»ãã·ã§ã³å
ã§çµæãè¿ã ããžãã¹ã¢ããªã¹ãã SQL ãæžããã«å£²äžããŒã¿ãç
§äŒãããçµå¶å±€ãããã·ã¥ããŒãããå³åº§ã«çããåŸã DBMS_CLOUD_AI.GENERATE PL/SQL ããåºç€ã¢ãã«ãåŒã³åºãããã£ãããèŠçŽã翻蚳ãåæããŒã¿çæãè¡ã CLOB åã«æ ŒçŽããããµããŒããã±ãããèŠçŽãããéçº/QA ç°å¢åãã«çŸå®çãªãã¹ãããŒã¿ãçæããã補å説æã翻蚳ãã Oracle AI Vector Search æšæºç㪠SQL ã§ãã¯ãã«åã蟌ã¿ããªã¬ãŒã·ã§ãã«ããŒã¿ãšäžŠã¹ãŠä¿åãã€ã³ããã¯ã¹åãæ€çŽ¢ãã 補åã«ã¿ãã°ã®ã»ãã³ãã£ãã¯æ€çŽ¢ãé¡äŒŒãã顧客ãããã¡ã€ã«ã®æ€çŽ¢ãã¬ã³ã¡ã³ããŒã·ã§ã³ãšã³ãžã³ã®å®çŸ Retrieval Augmented Generation (RAG) ãã¯ãã«æ€çŽ¢ãšå€§èŠæš¡èšèªã¢ãã« (LLM) ã®çæãçµã¿åãããAI ã®åçãå®éã®ããžãã¹ããŒã¿ã«åºã¥ããã 瀟å
ææžãããŒã¿ããŒã¹ã®ã¬ã³ãŒãã䜿ã£ãŠè³ªåã«çãã AI ã¢ã·ã¹ã¿ã³ã ããŒã¿ããŒã¹å
ONNX æšè« åã蟌ã¿ãåé¡ãååž°ãªã©ã® ML ã¢ãã«ããå€éš API ãåŒã³åºããã« Oracle å
éšã§å®è¡ãã æ¿å
¥æã«åã蟌ã¿ãçæãããäžæ£ãªååŒããªã¢ã«ã¿ã€ã ã§åé¡ãããã©ãŠã³ãããªãããªãã§ãªãŒããã¹ã³ã¢ãªã³ã°ãã ããããã£ã°ã©ãã§ã® Select AI SQL ããããã£ã°ã©ãã«å¯ŸããŠãèªç¶èšèªã®ããã³ããã§ã°ã©ãã®é¢ä¿ãç
§äŒãã ããµãã©ã€ã€ãŒ X ãšé¡§å®¢ Y ã®éã®æçãµãã©ã€ãã§ãŒã³çµè·¯ãèŠããŠã ãœãªã¥ãŒã·ã§ã³ã®æŠèŠ ãã®æé ãçµãããšã次ã®ããšãã§ããããã«ãªããŸãã AWS Identity and Access Management (IAM) ã®èªèšŒæ
å ±ãäœæãã DBMS_CLOUD.CREATE_CREDENTIAL ã§ Oracle å
ã«æ ŒçŽããã VPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ããèšå®ãããã©ã€ããŒã㪠Amazon RDS ã€ã³ã¹ã¿ã³ã¹ããã€ã³ã¿ãŒããããçµç±ããã« Amazon Bedrock ã«å°éã§ããããã«ããã Claude Sonnet ã Amazon Nova ãªã©ã® Amazon Bedrock ã®åºç€ã¢ãã«ãæã DBMS_CLOUD_AI ãããã¡ã€ã«ãäœæã管çããã LLM ãã Oracle ã®ããŒãã«ã«åæãã¹ãããŒã¿ãçŽæ¥çæããã SELECT AI ã® SQL æ§æã䜿ããèªåã®ããŒãã«ã«å¯ŸããŠèªç¶èšèªã¯ãšãªãå®è¡ããã DBMS_CLOUD_AI.GENERATE() ããã£ãããSQL ã®èª¬æãèŠçŽã«äœ¿ãã æ¬¡ã®å³ã¯å
šäœã®ã¢ãŒããã¯ãã£ã§ãã å³ 1: Amazon RDS for Oracle 26ai ãš Amazon Bedrock ã«ãã Select AI äž»ãªã³ã³ããŒãã³ãã¯æ¬¡ã®ãšããã§ãã ã³ã³ããŒãã³ã åœ¹å² Amazon RDS for Oracle Database 26ai DBMS_CLOUD_AI ãå«ã¿ãSelect AI ã®ã¯ãšãªãå®è¡ãã Amazon Bedrock åºç€ã¢ãã« (ClaudeãNova) ãžã®ãããŒãžããªã¢ã¯ã»ã¹ãæäŸãã VPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ã ( bedrock-runtime ) ãã©ã€ããŒã㪠Amazon RDS ã®ãµããããããã® Amazon Bedrock API åŒã³åºãããã€ã³ã¿ãŒããããçµç±ããã«ã«ãŒãã£ã³ã°ãã IAM èªèšŒæ
å ± DBMS_CLOUD.CREATE_CREDENTIAL ã§ Oracle ã«æ ŒçŽããã¢ã¯ã»ã¹ã㌠ID ãšã·ãŒã¯ã¬ãããOracle ããã¹ãŠã® Amazon Bedrock åŒã³åºãã SigV4 ã§çœ²åããããã«äœ¿ã åäœã®æµã: ãŠãŒã¶ãŒã SQL ã¯ã©ã€ã¢ã³ãã§èªç¶èšèªã®è³ªåãå
¥åããŸããOracle ã SELECT AI ã¹ããŒãã¡ã³ããåãåãã質åãšå¯Ÿè±¡ããŒãã«ã®ã¹ããŒãã¡ã¿ããŒã¿ãå«ãããã³ãããæ§ç¯ããŸãããã㊠IAM ãŠãŒã¶ãŒã®ã¢ã¯ã»ã¹ããŒã§çœ²åãããªã¯ãšã¹ãããVPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ãçµç±ã§ HTTPS ã«ãã Amazon Bedrock ã«éä¿¡ããŸããLLM ãè¿ãã SQL ã Oracle ãå®ããŒã¿ã«å¯ŸããŠå®è¡ããçµæã»ãããè¿ããŸãããããŸã§ã®ãã¹ãŠãåäžã® SQL ã»ãã·ã§ã³å
ã§è¡ãããŸãã åææ¡ä»¶ å§ããåã«ã次ã確èªããŠãã ããã ãã©ã€ããŒã㪠VPC ãµããããã«ãããã€ãã Amazon RDS for Oracle Database 26ai ã€ã³ã¹ã¿ã³ã¹ãæ¬èšäºã§ã¯ãããŒã¿ããŒã¹ã€ã³ã¹ã¿ã³ã¹ãšããŠäžè¬çãªãã¿ãŒã³ãã€æšå¥šæ§æã§ããããã©ã€ããŒã㪠Amazon RDS for Oracle ã€ã³ã¹ã¿ã³ã¹ãåæãšããŸãããã¹ãç®çã§ããã°ãã€ã³ã¹ã¿ã³ã¹ããããªãã¯ã«å
¬éããããšãã§ããŸãã DBMS_CLOUD ããã±ãŒãžãš DBMS_CLOUD_AI ããã±ãŒãžãã€ã³ã¹ããŒã«ãããŠããããš (ç¢ºèªæ¹æ³ã¯ã¹ããã 1 ã§èª¬æããŸã)ã IAM ãŠãŒã¶ãŒãš VPC ãšã³ããã€ã³ããäœæããæš©éãæã€ AWS ã¢ã«ãŠã³ãã 察象㮠AWS ãªãŒãžã§ã³ã§ Amazon Bedrock ãå©çšã§ããããšãAmazon Bedrock ã§ã¯ã»ãšãã©ã®åºç€ã¢ãã«ãããã©ã«ãã§å©çšå¯èœã§ããå¿
èŠã«å¿ã㊠Amazon Bedrock ã³ã³ãœãŒã«ã® ã¢ãã«ã¢ã¯ã»ã¹ ã§ç¢ºèªããŠãã ããã èžã¿å°ãã¹ããŸã㯠AWS Systems Manager Session Manager ã®ããŒããã©ã¯ãŒãã£ã³ã°çµç±ã§ Amazon RDS ã€ã³ã¹ã¿ã³ã¹ã«æ¥ç¶ãã SQL DeveloperãSQLclããã®ä»ã® Oracle SQL ã¯ã©ã€ã¢ã³ãã Amazon RDS ã€ã³ã¹ã¿ã³ã¹ã«é¢é£ä»ãããã VPC IDããµãããã IDãã»ãã¥ãªãã£ã°ã«ãŒã IDã DBMS_CLOUD ãš DBMS_CLOUD_AI ã®äž¡æ¹ã« EXECUTE æš©éãæã€ããŒã¿ããŒã¹ãŠãŒã¶ãŒ (äŸ: AIUSER)ãå¿
èŠãªããå
ã«äœæããŠãããŸãã GRANT EXECUTE ON DBMS_CLOUD TO AIUSER; GRANT EXECUTE ON DBMS_CLOUD_AI TO AIUSER; ã¹ããã 1: DBMS_CLOUD_AI ãå©çšå¯èœã確èªãã èšå®ãå§ããåã«ãå¿
èŠãªããã±ãŒãžãã€ã³ã¹ããŒã«ãããŠããããšã確èªããŸããAmazon RDS for Oracle 26ai ã§ã¯ãã€ã³ã¹ã¿ã³ã¹äœææã« DBMS_CLOUD ãš DBMS_CLOUD_AI ãããã©ã«ãã§ã€ã³ã¹ããŒã«ãããŸãã SELECT object_name, object_type, status FROM dba_objects WHERE object_name IN ('DBMS_CLOUD', 'DBMS_CLOUD_AI') AND object_type IN ('PACKAGE', 'PACKAGE BODY') ORDER BY 1, 2; 4 è¡ãè¿ãã¯ãã§ãã DBMS_CLOUD ãš DBMS_CLOUD_AI ã®ããããã«ã€ã㊠PACKAGE ãš PACKAGE BODY ã§ããããã±ãŒãžãèŠã€ãããªãå Žåã¯ãAmazon RDS ã€ã³ã¹ã¿ã³ã¹ã Oracle Database 26ai ã§åäœããŠããã確èªããŠãã ããã ã¹ããã 2: Amazon Bedrock ã©ã³ã¿ã€ã çšã® VPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ããäœæãã Amazon RDS for Oracle DB ã€ã³ã¹ã¿ã³ã¹ã¯ãããŒã 443 (HTTPS) ã§ Amazon Bedrock ã©ã³ã¿ã€ã ã®ãšã³ããã€ã³ã ( bedrock-runtime.<region>.amazonaws.com ) ã«å°éã§ããå¿
èŠããããŸãããã®éä¿¡ã AWS ãããã¯ãŒã¯å
ã®ãã©ã€ããŒããªçµè·¯ã«çããã€ã³ã¿ãŒãããã¢ã¯ã»ã¹ãäžèŠã«ããã«ã¯ãAmazon Bedrock ã©ã³ã¿ã€ã ãµãŒãã¹çšã® VPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ããäœæããŸããAmazon RDS ã€ã³ã¹ã¿ã³ã¹ããã©ã€ããŒãã«ä¿ãŠããããVPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ãã®å©çšãæšå¥šãããŸããæ¬èšäºã®äŸã§ã VPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ãã䜿ããŸãã ãã 1 ã€ã®éžæè¢ã¯ NAT ã²ãŒããŠã§ã€ã§ããNAT ã²ãŒããŠã§ã€ã䜿ãå ŽåãDB ã€ã³ã¹ã¿ã³ã¹ã®ãµããããã« NAT ã²ãŒããŠã§ã€çµç±ã§ã€ã³ã¿ãŒããããžåããã«ãŒããå¿
èŠã§ããNAT ã²ãŒããŠã§ã€ã®èšå®ã¯ã ããã¥ã¡ã³ã ã®ãAmazon VPC network requirementsãã»ã¯ã·ã§ã³ã®ãªãã·ã§ã³ 2 ãåç
§ããŠãã ããã ãšã³ããã€ã³ããäœæãã AWS ãããžã¡ã³ãã³ã³ãœãŒã«ã§ VPC ã ãšã³ããã€ã³ã ã ãšã³ããã€ã³ããäœæ ã®é ã«ç§»åããŸãã ãµãŒãã¹ã«ããŽãª ã§ AWS ãµãŒãã¹ ãéžæããŸãã ãµãŒãã¹å ã®æ€çŽ¢ã§ bedrock-runtime ãšå
¥åãã com.amazonaws.<your-region>.bedrock-runtime ãéžæããŸãã VPC ã§ã¯ãAmazon RDS ã€ã³ã¹ã¿ã³ã¹ããã VPC ãéžæããŸãã ãµãããã ã§ã¯ãAmazon RDS ã® DB ãµããããã°ã«ãŒãã䜿ã£ãŠãããµãããããšåããã®ãéžæããŸãã ã»ãã¥ãªãã£ã°ã«ãŒã ã§ã¯ãAmazon RDS ã€ã³ã¹ã¿ã³ã¹ã®ã»ãã¥ãªãã£ã°ã«ãŒãããã® ã€ã³ããŠã³ã TCP ããŒã 443 ãèš±å¯ããã»ãã¥ãªãã£ã°ã«ãŒããã¢ã¿ããããŸãã ããªã·ãŒ ã§ã¯ ãã«ã¢ã¯ã»ã¹ ãéžæããŸãã ãã©ã€ããŒã DNS å ãæå¹ã«ããŸãããããéèŠã§ããæå¹ã«ããããšã§ Oracle ã bedrock-runtime.<region>.amazonaws.com ããã©ã€ããŒã IP ã«è§£æ±ºããéä¿¡ã VPC å
ã§ã«ãŒãã£ã³ã°ãããŸãã ãšã³ããã€ã³ããäœæ ãéžæããç¶æ
ã å©çšå¯èœ ã«ãªããŸã§åŸ
ã¡ãŸãã ã¹ããã 3: Amazon Bedrock ãšã³ããã€ã³ããžã®ãããã¯ãŒã¯ ACL ã¢ã¯ã»ã¹ãèš±å¯ãã Oracle ã¯ã¢ã¯ã»ã¹ã³ã³ãããŒã«ãªã¹ã (ACL) ã§ã¢ãŠãããŠã³ãã®ãããã¯ãŒã¯ã¢ã¯ã»ã¹ãå¶åŸ¡ããŸããAIUSER ãŠãŒã¶ãŒã«ã bedrock-runtime.<your-region>.amazonaws.com ãžã® HTTP/HTTPS ã®ã¢ãŠãããŠã³ãæ¥ç¶ãèš±å¯ããŸãã BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => 'bedrock-runtime.<your-region>.amazonaws.com', ace => xs$ace_type( privilege_list => xs$name_list('connect', 'resolve', 'http'), principal_name => 'AIUSER', principal_type => xs_acl.ptype_db ) ); END; / DNS 解決ã確èªãã ãšã³ããã€ã³ããæå¹ã«ãªã£ãããOracle ã Amazon Bedrock ã®ãã¹ãåããã©ã€ããŒã IP ã«è§£æ±ºããããšã確èªããŸãã -- Should return a private IP, not a public AWS IP SELECT UTL_INADDR.GET_HOST_ADDRESS( 'bedrock-runtime.<your-region>.amazonaws.com' ) AS resolved_ip FROM dual; åºåäŸ: RESOLVED_IP --------------- 172.31.17.236 ã¹ããã 4: AWS ã®èªèšŒæ
å ±ãäœæã Oracle Database ã«æ ŒçŽãã DBMS_CLOUD_AI 㯠IAM ã®ã¢ã¯ã»ã¹ã㌠ID ãšã·ãŒã¯ã¬ããã¢ã¯ã»ã¹ããŒã§ Amazon Bedrock ã«èªèšŒããŸããèšå®æé ãšããŠã¯ãAmazon Bedrock ã®åºç€ã¢ãã«åŒã³åºãã«å¿
èŠãªæå°éã®æš©éã ããä»äžããå°çšã® IAM ãŠãŒã¶ãŒãäœæãããã®ãŠãŒã¶ãŒã®ã¢ã¯ã»ã¹ããŒãçºè¡ããŸããèªèšŒæ
å ±ãååŸãããã DBMS_CLOUD.CREATE_CREDENTIAL ãåŒã³åºã㊠Oracle ããŒã¿ããŒã¹å
ã«æ ŒçŽããŸããOracle ã¯ããŒãä¿åæã«æå·åãã DBMS_CLOUD_AI ãã¢ãŠãããŠã³ãã® Amazon Bedrock API ãªã¯ãšã¹ãã®çœ²åã«èªåçã«äœ¿çšããŸãã ã¹ããã 4a: Amazon Bedrock ã¢ã¯ã»ã¹çšã® IAM ãŠãŒã¶ãŒãäœæãã æ¬¡ã®ããªã·ãŒãæã€ IAM ãŠãŒã¶ãŒãŸãã¯ããŒã«ãäœæããŸã (æ¢åã® ID ã«ã¢ã¿ããããŠãæ§ããŸãã)ã { "Version": "2012-10-17", "Statement": [{ "Sid": "BedrockInvoke", "Effect": "Allow", "Action": ["bedrock:InvokeModel", "bedrock:InvokeModelWithResponseStream"], "Resource": ["arn:aws:bedrock:region::foundation-model/*"] }] } ç¹å®ã®ã¢ãã«ã ãã«ã¢ã¯ã»ã¹ãå¶éããã«ã¯ãã¯ã€ã«ãã«ãŒããæ¬¡ã®ããã«åå¥ã®ã¢ãã« ARN ã«çœ®ãæããŸãã arn:aws:bedrock:us-east-1::foundation-model/anthropic.claude-sonnet-4-5-20250929-v1:0 ã¹ããã 4b: ã¢ã¯ã»ã¹ããŒãçºè¡ãã äœæãããŠãŒã¶ãŒãéãã ã»ãã¥ãªãã£èªèšŒæ
å ± ã¿ãã«ç§»åããŸãã ã¢ã¯ã»ã¹ã㌠㧠ã¢ã¯ã»ã¹ããŒãäœæ ãéžæããŸãã ãŠãŒã¹ã±ãŒã¹ãéžæãã ã¢ã¯ã»ã¹ããŒãäœæ ãéžæããŸãã ã¢ã¯ã»ã¹ã㌠ID ãšã·ãŒã¯ã¬ããã¢ã¯ã»ã¹ããŒãã³ããŒãŸãã¯ããŠã³ããŒãããŸãã ã»ãã¥ãªãã£ã«é¢ããæ³šæ: ã¢ã¯ã»ã¹ããŒã¯é·æçãªèªèšŒæ
å ±ã§ããæ¬çªç°å¢ã§ã¯ãIAM ã³ã³ãœãŒã«ã§å®æçã«ããŒããŒã·ã§ã³ããããšãæ€èšããŠãã ããããã® IAM ãŠãŒã¶ãŒã«ã¯ã³ã³ãœãŒã«ã¢ã¯ã»ã¹ (ãã¹ã¯ãŒã) ãäžããªãããã«ããŸãã ã¹ããã 4c: IAM ãŠãŒã¶ãŒã®ã¢ã¯ã»ã¹ããŒã Oracle ã«æ ŒçŽãã Amazon Bedrock ã®ã¢ãã«ã¢ã¯ã»ã¹: 2025 幎æç¹ã§ãAmazon Bedrock ã®ã»ãšãã©ã®åºç€ã¢ãã«ã¯ããã©ã«ãã§å©çšå¯èœã§ãæç€ºçãªæå¹åã¯äžèŠã§ããã¢ã«ãŠã³ããšãªãŒãžã§ã³ã§ã®ã¢ãã«ã®å©çšå¯åŠã¯ã Amazon Bedrock ã³ã³ãœãŒã« ã® ã¢ãã«ã¢ã¯ã»ã¹ ã§ç¢ºèªãŸãã¯å€æŽã§ããŸããAmazon RDS for Oracle 26ai ã® DBMS_CLOUD_AI ã§åäœãæ€èšŒæžã¿ã®ã¢ãã«ã¯æ¬¡ã®ãšããã§ãã ã¢ãã«å ã¢ãã« ID åè Anthropic Claude Sonnet 4.6 us.anthropic.claude-sonnet-4-6 NL2SQL ã®ç²ŸåºŠãæãé«ã (æšå¥š) Anthropic Claude Haiku 4.5 us.anthropic.claude-haiku-4-5-20251001-v1:0 æé / æäœã³ã¹ã Amazon Nova Pro us.amazon.nova-pro-v1:0 髿§èœãª AWS ãã€ãã£ãã¢ãã« Amazon Nova Lite amazon.nova-lite-v1:0 åçŽãªã¯ãšãªåãã®è¶
é«éã¢ãã« éèŠ: ã¯ãã¹ãªãŒãžã§ã³æšè«ã®ãã¬ãã£ãã¯ã¹: Anthropic Claude ãš Amazon Nova Pro ã®ã¢ãã« ID ã«ã¯ us. ãã¬ãã£ãã¯ã¹ãå¿
èŠã§ãããã®ãã¬ãã£ãã¯ã¹ã«ãã£ãŠãªã¯ãšã¹ããã¯ãã¹ãªãŒãžã§ã³æšè«ãããã¡ã€ã«çµç±ã§ã«ãŒãã£ã³ã°ãããå¯çšæ§ãé«ãŸããŸãããã¬ãã£ãã¯ã¹ã®ãªãããŒã¹ã¢ãã« ID ã䜿ããš ORA-20400: HTTP 400 ãè¿ããŸãã DBMS_CLOUD.CREATE_CREDENTIAL ã䜿ããã¹ããã 4a ã§ååŸããã¢ã¯ã»ã¹ããŒãšã·ãŒã¯ã¬ããããŒã Oracle ã®èªèšŒæ
å ±ã¹ãã¢ã«æ ŒçŽããŸããOracle ã¯èªèšŒæ
å ±ãæå·åããææãŠãŒã¶ãŒã ããã¢ã¯ã»ã¹ã§ããããã«ããŸãã BEGIN DBMS_CLOUD.CREATE_CREDENTIAL( credential_name => 'AWS', username => '<your-access-key-id>', password => '<your-secret-access-key>' ); END; / èªèšŒæ
å ±ãæ£ããäœæãããã確èªããŸãã SELECT credential_name, username, enabled FROM all_credentials WHERE credential_name = 'AWS'; username åã«ã¯æå®ããã¢ã¯ã»ã¹ã㌠ID ã衚瀺ãããŸããã·ãŒã¯ã¬ããããŒã¯æå·åãããŠæ ŒçŽãããã¯ãšãªã§ã¯è¿ããŸããã ã¹ããã 5: ãµã³ãã«ããŒãã«ãäœæãã Select AI ã®ãã¢ã«ã¯ E ã³ããŒã¹ã®ã¹ããŒãã䜿ããŸããæ¢åã®ããŒãã«ãããå Žåã¯ãã¹ããã 6 ã«é²ãã§ãããã¡ã€ã«ã® object_list ã§èªåã®ããŒãã«ãæå®ããŠãã ããã CREATE TABLE customers ( customer_id NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, first_name VARCHAR2(50), last_name VARCHAR2(50), email VARCHAR2(100), city VARCHAR2(50), country VARCHAR2(50), signup_date DATE, segment VARCHAR2(20) -- 'PREMIUM', 'STANDARD', 'NEW' ); CREATE TABLE products ( product_id NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, product_name VARCHAR2(100), category VARCHAR2(50), unit_price NUMBER(10,2), stock_qty NUMBER ); CREATE TABLE orders ( order_id NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, customer_id NUMBER REFERENCES customers(customer_id), order_date DATE, status VARCHAR2(20), -- 'COMPLETED', 'PENDING', 'CANCELLED' total_amount NUMBER(10,2) ); CREATE TABLE order_items ( item_id NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, order_id NUMBER REFERENCES orders(order_id), product_id NUMBER REFERENCES products(product_id), quantity NUMBER, unit_price NUMBER(10,2) ); ã¹ããã 6: DBMS_CLOUD_AI ãããã¡ã€ã«ãäœæãã ãããã¡ã€ã« 㯠Select AI ã®äžå¿ãšãªãèšå®ãªããžã§ã¯ãã§ããAI ãããã€ããŒãèªèšŒæ
å ±ãåŒã³åºã Amazon Bedrock ã®ã¢ãã«ããããŠããã³ããã®ã³ã³ããã¹ãã«ã¹ããŒããå«ããããŒã¿ããŒã¹ããŒãã«ãæå®ããŸãã DBMS_CLOUD_AI ã¯ããã©ã«ãã§ bedrock-runtime.us-east-1.amazonaws.com ã«æ¥ç¶ããŸããus-east-1 以å€ã®ãªãŒãžã§ã³ã® Amazon Bedrock ã©ã³ã¿ã€ã ãšã³ããã€ã³ãã䜿ãå Žåã¯ããããã¡ã€ã«å±æ§ã® JSON ã« region 屿§ãš target_language 屿§ãå«ããŸãã region ã«ã¯ Amazon Bedrock ã©ã³ã¿ã€ã ãšã³ããã€ã³ãããããªãŒãžã§ã³ (äŸ: us-west-2) ãèšå®ããŸãã region ãèšå®ããå Žåã¯ã target_language (ãŸã㯠source_language ) ãå«ããå¿
èŠããããŸãã chat ã runsql ã®ããã«ç¿»èš³ã䜿ããªãã¢ã¯ã·ã§ã³ã§ãããã® 2 ã€ã®å±æ§ã¯å¿
ãã»ããã§èšå®ããŠãã ããã target_language ã®å€ã圱é¿ããã®ã¯ translate ã¢ã¯ã·ã§ã³ã ãã§ããã»ããã§æå®ããªããã°ãªããªãã®ã¯ãOracle ã® DBMS_CLOUD_AI ããã±ãŒãžã«æ¢ç¥ã®å¶éãããããã§ãã region ãªãã§ target_language ã ããæå®ããå Žåããããã¡ã€ã«ã¯ bedrock-runtime.us-east-1.amazonaws.com ã䜿ãç¶ããŸããVPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ããå¥ã®ãªãŒãžã§ã³ã«ãããšãOracle ã¯ãšã³ããã€ã³ããååšããªããªãŒãžã§ã³ãžãããªãã¯ã€ã³ã¿ãŒãããçµç±ã§æ¥ç¶ã詊ã¿ããããã¯ãŒã¯æ§æã§ãããªãã¯ã¢ã¯ã»ã¹ãèš±å¯ããŠããªãéãããã¹ãŠã®åŒã³åºãã ORA-30699 ã§ã¿ã€ã ã¢ãŠãããŸãã æ¬¡ã®äŸã§ã¯ãAmazon Bedrock ã®ã¯ãã¹ãªãŒãžã§ã³æšè« (CRIS) çµç±ã§ Anthropic Claude Sonnet 4.6 ã䜿ããããã¡ã€ã«ãäœæããŸãã BEGIN DBMS_CLOUD_AI.CREATE_PROFILE( profile_name => 'CLAUDE_SONNET', attributes => '{"provider": "aws", "credential_name": "AWS", "region": "<your-bedrock-region>", "model": "us.anthropic.claude-sonnet-4-6", "target_language": "en", "object_list": [ {"owner": "AIUSER", "name": "CUSTOMERS"}, {"owner": "AIUSER", "name": "PRODUCTS"}, {"owner": "AIUSER", "name": "ORDERS"}, {"owner": "AIUSER", "name": "ORDER_ITEMS"} ] }' ); END; / object_list ã¯ãLLM åãã®ã¹ããŒãã³ã³ããã¹ããæ§ç¯ãããšãã«å«ããããŒãã«ãšãã¥ãŒã Oracle ã«äŒããŸããOracle ã¯ããŒã¿ãã£ã¯ã·ã§ããªããååãããŒã¿åãåã³ã¡ã³ããèªåçã«èªã¿åããããã³ããã«çµã¿èŸŒã¿ãŸããã¹ããŒããæäœæ¥ã§èšè¿°ããå¿
èŠã¯ãããŸããã ç°ãªãã¢ãã«ãæããããã¡ã€ã«ãè€æ°äœæããã»ãã·ã§ã³ããšã«åãæ¿ããããšãã§ããŸãã -- Amazon Nova Pro profile BEGIN DBMS_CLOUD_AI.CREATE_PROFILE( profile_name => 'NOVA_PRO', attributes => '{"provider": "aws", "credential_name": "AWS", "region": "<your-bedrock-region>", "model": "us.amazon.nova-pro-v1:0", "target_language": "en", "object_list": [ {"owner": "AIUSER", "name": "CUSTOMERS"}, {"owner": "AIUSER", "name": "PRODUCTS"}, {"owner": "AIUSER", "name": "ORDERS"}, {"owner": "AIUSER", "name": "ORDER_ITEMS"} ] }' ); END; / ã»ãã·ã§ã³ã§ãããã¡ã€ã«ãæå¹åãã確èªããŸãã EXECUTE DBMS_CLOUD_AI.SET_PROFILE('CLAUDE_SONNET'); -- Confirm active profile SELECT DBMS_CLOUD_AI.GET_PROFILE() FROM dual; -- List all profiles SELECT profile_name, status FROM user_cloud_ai_profiles; ã¹ããã 7: åæããŒã¿ãçæãã Amazon Bedrock ã«ã¢ã¯ã»ã¹ã§ãã AI ãããã¡ã€ã«ãèšå®ãããã DBMS_CLOUD_AI.GENERATE_SYNTHETIC_DATA ã§ããŒãã«ã«çŸå®çãªãã¹ãããŒã¿ãèªåæå
¥ã§ããŸãã GENERATE_SYNTHETIC_DATA ã¯ãæå®ãã AI ãããã¡ã€ã«çµç±ã§ LLM ã䜿ããæèã«æ²¿ã£ãã¬ã³ãŒããçæããŸãã object_list ãã©ã¡ãŒã¿ã«ã¯ã察象ããŒãã«ãšããããã®çæã¬ã³ãŒãæ°ãæå®ãã JSON é
åãæž¡ããŸãã æ¬¡ã® PL/SQL ãããã¯ãå®è¡ããŠã4 ã€ã®ããŒãã«ã«åæããŒã¿ãçæããŸãã BEGIN DBMS_CLOUD_AI.GENERATE_SYNTHETIC_DATA( profile_name => 'CLAUDE_SONNET', object_list => '[ {"owner": "AIUSER", "name": "CUSTOMERS", "record_count": 50}, {"owner": "AIUSER", "name": "PRODUCTS", "record_count": 250}, {"owner": "AIUSER", "name": "ORDERS", "record_count": 500}, {"owner": "AIUSER", "name": "ORDER_ITEMS", "record_count": 1000} ]' ); END; / å®è¡ãããšã顧客 50 ä»¶ã補å 250 ä»¶ãæ³šæ 500 ä»¶ãæ³šææçް 1,000 ä»¶ãçæãããŸãããã¹ãããŒã¿ãæäœæ¥ã§äœã蟌ãŸãªããŠããã¯ãšãªãã¬ããŒããã¢ããªã±ãŒã·ã§ã³ããžãã¯ã®æ€èšŒã«äœ¿ããçŸå®çãªããŒã¿ã»ãããæã«å
¥ããŸãã å
éšã§ã¯ãOracle ã察象ããŒãã«ã® DDLãå¶çŽãã¡ã¿ããŒã¿ãèªã¿åããããŒã¿åãšå€éšããŒãæºããçŸå®çãªè¡ãçæãããã LLM ã«ããã³ãããåºããŸããçææ¹æ³ã¯æ¬¡ã®èŠçŽ ã§ã«ã¹ã¿ãã€ãºã§ããŸãã sample_rows : æ¢åã®ã¬ã³ãŒããäŸãšããŠæž¡ããçæãããããŒã¿ãå®ããŒã¿ã®ã¹ã¿ã€ã«ã«åãããŸãã user_prompt : ãè±åœã®éµäŸ¿çªå·ã®ã¿ãã2009 幎å
¬éã®æ ç»ããšãã£ãã«ãŒã«ãæå®ããŸãã ããŒãã«çµ±èš (ããã©ã«ãã§æå¹): åã®æå€§å€ã»æå°å€ãšåå¥å€ã®ãªã¹ãã䜿ã£ãŠåºåç¯å²ãå¶éããŸãã åã³ã¡ã³ã: åã«ãã³ã (äŸ: èš±å¯ããã Status ã®å€) ãä»ãããšãLLM ã¯çææã«ãã³ãã«åŸããŸãã äžæå¶çŽ: LLM ã®ã¬ã¹ãã³ã¹ããéè€è¡ãèªåçã«ç Žæ£ããŸãã ã¹ããã 8: Select AI ã§èªç¶èšèªã¯ãšãªãå®è¡ãã ãããã¡ã€ã«ãèšå®ããŠããŒã¿ãæå
¥ãããã SELECT AI ã® SQL æ§æã§å¹³æãªè±èªã®ãŸãŸãªã¬ãŒã·ã§ãã«ããŒã¿ãç
§äŒã§ããŸããOracle ã¯ã¹ããŒãã¡ã³ããåãåãã質åãš object_list ã®ããŒãã«ã¹ããŒãã¡ã¿ããŒã¿ãçµã¿åãããããã³ãããæ§ç¯ããAmazon Bedrock ã®ã¢ãã«ãåŒã³åºããŠçµæãè¿ããŸãã å®è¡åã«çæããã SQL ã確èªãã showsql ã䜿ããšãLLM ãçæãã SQL ãå®è¡ããã«ç¢ºèªã§ããŸããç²ŸåºŠã®æ€èšŒãä¿¡é Œæ§ã®ç¢ºèªã«åœ¹ç«ã¡ãŸãã SELECT AI showsql how many customers do we have per country; åºåäŸ: SELECT country, COUNT(*) AS customer_count FROM customers GROUP BY country ORDER BY customer_count DESC å®è¡ããŠçµæãè¿ã runsql ã«åãæ¿ãããšãçæããã SQL ãå®è¡ããŠçµæãè¿ããŸãã SELECT AI runsql how many customers do we have per country; SELECT AI runsql what is the total revenue by product category; SELECT AI runsql who are the top 3 customers by total spend; SELECT AI runsql how many orders were cancelled; SELECT AI runsql show me all pending orders with customer name and amount; çµæãèªç¶èšèªã®æç« ã§è¿ã narrate ã¢ã¯ã·ã§ã³ã¯ãã¯ãšãªçµæãå¹³æãªè±èªã§èŠçŽããŠè¿ããŸããããžãã¹ã¬ããŒããããã·ã¥ããŒãã«é©ããŠããŸãã SELECT AI narrate give me a sales summary for 2024; SELECT AI narrate who are our best customers and what do they buy; 1 ã€ç®ã®ã¯ãšãªã®åºåäŸ: Based on the 2024 sales data, total completed revenue is $14,299.98 across six completed orders. Frank Wilson is the top-spending customer at $7,000.00, followed by Alice Johnson at $6,099.99. The Software category leads all product categories in revenue. Two orders remain in Pending status with a combined value of $2,500.00. æ¢åã® SQL ãå¹³æãªè±èªã§èª¬æãã explainsql ã¢ã¯ã·ã§ã³ã¯ãæ¢åã® SQL ã¯ãšãªãåãåã£ãŠå¹³æãªè±èªã®èª¬æãè¿ããŸããããã¥ã¡ã³ãäœæããªã³ããŒãã£ã³ã°ã«åœ¹ç«ã¡ãŸãã SELECT AI explainsql SELECT c.first_name, c.last_name, SUM(o.total_amount) AS total FROM customers c JOIN orders o ON c.customer_id = o.customer_id WHERE o.status = 'COMPLETED' GROUP BY c.first_name, c.last_name ORDER BY total DESC; åºåäŸ: Query Analysis & Oracle SQL Conversion Original Query Issues: - Missing schema names - Missing double quotes around case-sensitive identifiers - 'COMPLETED' is not in double quotes in the question; must use UPPER() for case-insensitive comparison Converted Oracle SQL: SELECT c."FIRST_NAME" AS first_name, c."LAST_NAME" AS last_name, SUM(o."TOTAL_AMOUNT") AS total FROM "AI_TEST"."CUSTOMERS" c JOIN "AI_TEST"."ORDERS" o ON c."CUSTOMER_ID" = o."CUSTOMER_ID" WHERE UPPER(o."STATUS") = UPPER('COMPLETED') GROUP BY c."FIRST_NAME", c."LAST_NAME" ORDER BY total DESC; ã¹ããã 9: DBMS_CLOUD_AI.GENERATE() ãä»ã® AI ã¿ã¹ã¯ã«äœ¿ã SELECT AI æ§æã«å ããŠã DBMS_CLOUD_AI.GENERATE() ã䜿ããš Amazon Bedrock ã®ã¢ãã«ã«çŽæ¥ã¢ã¯ã»ã¹ã§ããŸããèªç±åœ¢åŒã®ãã£ãããèŠçŽãããã³ããããã® SQL çæã®ããã«ãããŒã¿ããŒã¹ã®ã¹ããŒãã³ã³ããã¹ããå¿
èŠãšããªãã¿ã¹ã¯ã«äœ¿ããŸãã ããã¹ããèŠçŽãã SELECT DBMS_CLOUD_AI.GENERATE( prompt => 'Oracle Database 26ai introduces AI Vector Search, hybrid BM25 and semantic search, an embedded ONNX inference runtime, SQL/PGQ property graph queries, JSON-Relational Duality Views, native BOOLEAN type, and lock-free reservations for high-concurrency workloads.', profile_name => 'CLAUDE_SONNET', action => 'summarize' ) AS summary FROM dual; ã€ã³ã©ã€ã³ã®ããã¹ããèŠçŽããã ãã§ãªãã DBMS_CLOUD_AI.GENERATE ã Amazon Simple Storage Service (Amazon S3) ãã±ããã«ä¿åãããææžãçŽæ¥åŠçããããšãã§ããŸããæ¬¡ã®ã¯ãšãªã¯ Amazon S3 ãã PDF ãååŸãã DBMS_VECTOR_CHAIN.UTL_TO_TEXT ã§ããã¹ãã«å€æããŸãããã®ããã§å
容ã LLM ã«æž¡ããŠèŠçŽãããŸãããããŸã§ã 1 ã€ã® SQL ã¹ããŒãã¡ã³ãã§å®è¡ããŸãã SELECT DBMS_CLOUD_AI.GENERATE( prompt => DBMS_VECTOR_CHAIN.UTL_TO_TEXT( DBMS_CLOUD.GET_OBJECT( credential_name => 'AWS', object_uri => 'https://s3.us-west-2.amazonaws.com/<Bucket Name>/<File Name>')), profile_name => 'CLAUDE_SONNET', action => 'SUMMARIZE') FROM DUAL; / å
éšã§ã¯ã3 ã€ã®é¢æ°ã 1 ã€ã® SQL ã¹ããŒãã¡ã³ãå
ã§é£éããŸãã DBMS_CLOUD.GET_OBJECT ãæå®ããèªèšŒæ
å ±ã䜿ã£ãŠ Amazon S3 ãã±ãããã PDF ææžãååŸããŸãã DBMS_VECTOR_CHAIN.UTL_TO_TEXT ããã€ããªã®å
容ã LLM ãåŠçã§ãããã¬ãŒã³ããã¹ãã«å€æããŸãã DBMS_CLOUD_AI.GENERATE ãæœåºããããã¹ãã AI ãããã¡ã€ã«çµç±ã§ Amazon Bedrock ã«éä¿¡ããèŠçŽãè¿ããŸããAmazon RDS for Oracle ã€ã³ã¹ã¿ã³ã¹ãã Amazon S3 ã«å°éã§ããããã«ããã«ã¯ãåææ¡ä»¶ã 2 ã€è¿œå ã§å¿
èŠã§ãã1 ã€ã¯ Amazon S3 çšã® VPC ã²ãŒããŠã§ã€ãšã³ããã€ã³ãã§ãAmazon RDS ã®ãµããããã«é¢é£ä»ããããã«ãŒãããŒãã«ã«è¿œå ããéä¿¡ããããªãã¯ã€ã³ã¿ãŒãããããåãé¢ããŸãããã 1 ã€ã¯å¯Ÿè±¡ãã±ãããžã® s3:GetObject ãš s3:ListBucket ã®æš©éãä»äžãã IAM ããªã·ãŒã§ãã¹ããã 4a ã§äœæãããŠãŒã¶ãŒã«ã¢ã¿ããããŸãã ãã©ãã«ã·ã¥ãŒãã£ã³ã° 次ã®è¡šã«ãééãããããšã©ãŒãšæ ¹æ¬åå ãå¯ŸåŠæ¹æ³ããŸãšããŸãã ãšã©ãŒ æ ¹æ¬åå å¯ŸåŠ ORA-30699: network connection failed: connection timed out bedrock-runtime ã® VPC ãšã³ããã€ã³ãããªãããŸãã¯ãããã¡ã€ã«ã® "region" ãæªæå®ã誀ã£ãŠãã æ£ãããªãŒãžã§ã³ã« bedrock-runtime ã® VPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ããäœæããããã¹ãŠã®ãããã¡ã€ã«ã« "region": "<your-region>" ã远å ãã DNS ããããªã㯠IP ã«è§£æ±ºããã VPC ãšã³ããã€ã³ãã§ãã©ã€ããŒã DNS åãæå¹ã«ãªã£ãŠããªã ãšã³ããã€ã³ããç·šéããŠãã©ã€ããŒã DNS åãæå¹ã«ãã ORA-20400: HTTP 400 ã¢ãã« ID ãåäžãªãŒãžã§ã³ / ãªã³ããã³ãã®åœ¢åŒ (æ§åœ¢åŒ) ã«ãªã£ãŠãã ã¢ãã« ID ã«ã¯ãã¹ãªãŒãžã§ã³æšè«ã® us. ãã¬ãã£ãã¯ã¹ã远å ãã ORA-20404: HTTP 404 ãã®ãªãŒãžã§ã³ã§ã¢ãã«ãå©çšã§ããªãããŸãã¯ã¢ã¯ã»ã¹ãæå¹ã«ãªã£ãŠããªã Amazon Bedrock â ã¢ãã«ã¢ã¯ã»ã¹ã§ãªãŒãžã§ã³ã§ã®ã¢ãã«ã®å©çšå¯åŠã確èªãããã¢ãã« ID ãæ£ããããšã確èªãã ORA-20400: HTTP 403 IAM ãŠãŒã¶ãŒã« bedrock:InvokeModel ã®æš©éããªã BedrockInvokeModelPolicy ã IAM ãŠãŒã¶ãŒã«ã¢ã¿ãããããŠããã確èªãã ORA-20001: profile not found ãããã¡ã€ã«ãäœæãããŠããªãããŸãã¯ååãééã£ãŠãã SELECT profile_name FROM user_cloud_ai_profiles ãå®è¡ãã ORA-29024: Certificate validation failure Oracle ãŠã©ã¬ããã« Amazon Bedrock ã® CA èšŒææžããªã Amazon RDS ã§ã¯ file:/rdsdbdata/rds-metadata/dbms_cloud_wallet ã«ããªã€ã³ã¹ããŒã«ããããŠã©ã¬ããã«å¿
èŠãª CA ãå«ãŸããŠããããã察å¿ã¯äžèŠ ã¯ãªãŒã³ã¢ãã ãã®æé ã§äœæãããªãœãŒã¹ãåé€ããã«ã¯ã次ãå®è¡ããŸãã -- Drop AI profiles EXECUTE DBMS_CLOUD_AI.DROP_PROFILE('CLAUDE_SONNET'); EXECUTE DBMS_CLOUD_AI.DROP_PROFILE('NOVA_PRO'); -- Drop the Bedrock credential EXECUTE DBMS_CLOUD.DROP_CREDENTIAL('AWS'); -- Drop sample tables (if created for this walkthrough) DROP TABLE order_items; DROP TABLE orders; DROP TABLE products; DROP TABLE customers; AWS ãããžã¡ã³ãã³ã³ãœãŒã«ã§ã¯ãæ¬¡ã®æé ãå®è¡ããŸãã IAM â ãŠãŒã¶ãŒ ã§ãã¹ããã 4a ã§äœæãã IAM ãŠãŒã¶ãŒãåé€ããŸãã VPC â ãšã³ããã€ã³ã ã§ã bedrock-runtime ã® VPC ã€ã³ã¿ãŒãã§ã€ã¹ãšã³ããã€ã³ããåé€ããŸãã ãŸãšã æ¬èšäºã§ã¯ãAI ãããã€ããŒãšã㊠Amazon Bedrock ã䜿ããAmazon RDS for Oracle Database 26ai ã§ Select AI ãèšå®ããäžé£ã®æé ã説æããŸãããIAM ã³ã³ãœãŒã«ã§ã® AWS èªèšŒæ
å ±ã®äœæãOracle ãžã®èªèšŒæ
å ±ã®æ ŒçŽãVPC ãšã³ããã€ã³ãã®ã»ããã¢ãããèªç¶èšèªã¯ãšãªã®å®è¡ãŸã§ãããããªãã¯ã€ã³ã¿ãŒãããã¢ã¯ã»ã¹ã®ãªããã©ã€ããŒã㪠Amazon RDS ã€ã³ã¹ã¿ã³ã¹ã§è¡ããŸããã Select AI ã䜿ãã°ãããŒã¿ã掻çšãã人㫠SQL ã®ã¹ãã«ã¯äžèŠã«ãªããAI ã®ããžãã¯ã¯ä¿¡é Œã§ãã Oracle ç°å¢ã®å
åŽã«çãŸããŸããããžãã¹ã¢ããªã¹ã㯠SQL Developer ã Oracle ã«æ¥ç¶ããããŒã«ãããå¹³æãªè±èªã§æ¬çªããŒã¿ãçŽæ¥ç
§äŒã§ããŸããããŒã¿ããŒã¹ç®¡çè
ã¯ãã¢ãã«ã«å
¬éããããŒãã«ãæå¹ã«ããåºç€ã¢ãã«ã䜿çšãã IAM èªèšŒæ
å ±ãå®å
šã«å¶åŸ¡ãç¶ããããŸãããããã Oracle æšæºã®ãããã¡ã€ã«ãšèªèšŒæ
å ±ã®ä»çµã¿ã§ç®¡çã§ããŸãã æ¬èšäºã¯ Oracle Database 26ai ãš Amazon Bedrock ãæ±ã 3 åã·ãªãŒãºã®ç¬¬ 1 åã§ãã 第 1 å (æ¬èšäº): Amazon RDS ã§ã® Select AI ãš DBMS_CLOUD_AI ã«ããèªç¶èšèªã¯ãšãªã 第 2 å: Oracle 26ai ã®ãã€ãã£ããªãã¯ãã«æ€çŽ¢ãš Amazon Bedrock ã«ãã RAG ãã€ãã©ã€ã³ã®æ§ç¯ã 第 3 å: Amazon RDS äžã® Oracle Database 26ai ãš Amazon Bedrock ã«ããããŒã¿ããŒã¹å
GraphRAGã èè
ã«ã€ã㊠Yamuna Palasamudram Yamuna 㯠AWS ã®ããªã³ã·ãã«ããŒã¿ããŒã¹ã¹ãã·ã£ãªã¹ããœãªã¥ãŒã·ã§ã³ã¢ãŒããã¯ãã§ããAWS ã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ããŒã ã§ãOracle ãªã©ã®åçšããŒã¿ããŒã¹ãšã³ãžã³ãæ
åœããŠããŸããã客æ§ãšååã㊠AWS äžã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã¯ãŒã¯ããŒãã®èšèšããããã€ãæé©åãæ¯æŽããæè¡çãªã¬ã€ãã³ã¹ãæäŸããããšã«ãããããæããŠããŸãã Ibrahim Emara Ibrahim 㯠Amazon Web Services ã®ããŒã¿ããŒã¹ã¹ãã·ã£ãªã¹ããœãªã¥ãŒã·ã§ã³ã¢ãŒããã¯ãã§ãAWS ã®ã客æ§åãã«ããŒã¿ããŒã¹ãœãªã¥ãŒã·ã§ã³ã®èšèšãšå®è£
ãæ
åœããŠããŸããOracleãPostgreSQLãAmazon AuroraãAWS Database Migration Service ã«é¢ããå°éç¥èãæŽ»ãããã¯ã©ãŠãç§»è¡ã®æšé²ãšããŒã¿ããŒã¹ããã©ãŒãã³ã¹ã®æ¹åã«åãçµãã§ããŸãã Minu Hong Minu 㯠AWS ã® Amazon RDS for Oracle ã®ã·ãã¢ãããã¯ããããŒãžã£ãŒã§ããã¯ã©ãŠããã€ãã£ãã〠AI ãæŽ»çšãããœãªã¥ãŒã·ã§ã³ã§ãã客æ§ãããŒã¿ã®å¯èœæ§ãæå€§éã«åŒãåºããããæ¯æŽããããšã«æ
ç±ã泚ãã§ããŸããä»äºä»¥å€ã§ã¯ãæ
è¡ãããã¹ãã¹ããŒãæçãæ¥œããã§ããŸãã ãã®èšäºã¯ Solutions Architect ã® ç¢æš èŠ ã翻蚳ããŸããã