{"id":15726,"date":"2024-10-22T01:40:00","date_gmt":"2024-10-22T00:40:00","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=15726"},"modified":"2024-10-22T09:24:12","modified_gmt":"2024-10-22T08:24:12","slug":"oracle-database-23ai-install","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2024\/10\/22\/oracle-database-23ai-install\/","title":{"rendered":"Oracle Database 23ai : Install, vector search"},"content":{"rendered":"\n<p><strong>Check:<\/strong><\/p>\n\n\n\n<p>dnf -y install oracle-database-preinstall-23ai<\/p>\n\n\n\n<p><strong>Prenos softvera:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.oracle.com\/database\/technologies\/free-downloads.html\">https:\/\/www.oracle.com\/database\/technologies\/free-downloads.html<\/a><\/p>\n\n\n\n<p>dnf -y install oracle-database-free-23ai-1.0-1.el8.x86_64.rpm<\/p>\n\n\n\n<p><strong>Konfiguriranje :<\/strong>  \/etc\/init.d\/oracle-free-23ai configure<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Lokacije programske opreme<\/th><th>Namen<\/th><\/tr><\/thead><tbody><tr><td><code>\/opt\/oracle<\/code><\/td><td>Oracle base. This is the root of the Oracle Database Free directory tree.<\/td><\/tr><tr><td><code>\/opt\/oracle\/product\/23ai\/dbhomeFree<\/code><\/td><td>Oracle home. This home is where the Oracle Database Free is installed. It contains the directories of the Oracle Database Free executables and network files.<\/td><\/tr><tr><td><code>\/opt\/oracle\/oradata\/FREE<\/code><\/td><td>Database files.<\/td><\/tr><tr><td><code>\/opt\/oracle\/diag<\/code>&nbsp;subdirectories<\/td><td>Diagnostic logs. The database alert log is&nbsp;<code>\/opt\/oracle\/diag\/rdbms\/free\/FREE\/trace\/alert_FREE.log<\/code><\/td><\/tr><tr><td><code>\/opt\/oracle\/cfgtoollogs\/dbca\/FREE<\/code><\/td><td>Database creation logs. The&nbsp;<code>FREE.log<\/code>&nbsp;file contains the results of the database creation script execution.<\/td><\/tr><tr><td><code>\/etc\/sysconfig\/oracle-free-23ai.conf<\/code><\/td><td>Configuration default parameters.<\/td><\/tr><tr><td><code>\/etc\/init.d\/oracle-free-23ai<\/code><\/td><td>Configuration and services script.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Nastavitev spremenljivk po namestitvi<\/strong><\/p>\n\n\n\n<p><code>export ORACLE_SID=FREE <br>export ORAENV_ASK=NO <br>. \/opt\/oracle\/product\/23ai\/dbhomeFree\/bin\/oraen<\/code>v<\/p>\n\n\n\n<p><strong>Start baze<\/strong><\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>startup<\/p>\n\n\n\n<p>lsnrctl start<\/p>\n\n\n\n<p><strong>Preveri po\u017earno pregrado<\/strong><\/p>\n\n\n\n<p># systemctl status firewalld<\/p>\n\n\n\n<p>Po potrebi stopiraj<\/p>\n\n\n\n<p># systemctl stop firewalld<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Link :  <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/xeinl\/installing-oracle-database-free.html#GUID-A5FCC804-5786-4B4B-B1B4-60E36E80B73F\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/xeinl\/installing-oracle-database-free.html#GUID-A5FCC804-5786-4B4B-B1B4-60E36E80B73F<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><em>Getting Started with Vector Search in 23c AI<\/em> | Vili Tajni\u0107<\/strong><\/h2>\n\n\n\n<p>Link:<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/ViliTajnic\/OracleVectorSearch23ai\">https:\/\/github.com\/ViliTajnic\/OracleVectorSearch23ai<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle Database 23ai &#8211; Oracle AI Vector Search &amp; Retrieval Augmented Generation (RAG) with Oracle APEX | <a href=\"https:\/\/www.linkedin.com\/in\/madhusudhanraobm\/\">Madhusudhan Rao<\/a><\/h2>\n\n\n\n<p><a href=\"https:\/\/www.linkedin.com\/in\/madhusudhanraobm\/\"><\/a><\/p>\n\n\n\n<p id=\"ember49\">This&nbsp;is part 2 of the Oracle Database 23ai series of technical articles. While searching for large external language models to get answers to the questions will solve one type of problem, the requirements might also differ slightly from searching for Corporate internal knowledge repositories and datasets.<\/p>\n\n\n\n<p id=\"ember50\">For example, consider that your company is working on internal research and has several internal PDFs that should be searched by the AI Search engine rather than going and looking for public LLM for questions that concern us. Also, the possibility of traditional RDBMS queries along with Gen AI queries will make it more powerful.<\/p>\n\n\n\n<p id=\"ember51\">In this article, we will understand Open Neural Network Exchange (ONNX) concepts, create our own ONNX models, Use these models to read PDFs and vectorise content, and Develop an Oracle APEX Vector-based search engine that can query internal knowledge repositories or sometimes also query external large language models.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"ember52\">About Retrieval augmented generation (RAG)<\/h3>\n\n\n\n<p id=\"ember53\">RAG uses the results of <strong>similarity search to improve the accuracy and contextual relevance of large language model responses to questions about business data<\/strong>. RAG helps identify contextually relevant private data that the LLM may not have been trained on and then uses it to augment user prompts so LLMs can respond with greater accuracy. RAG helps organizations provide customized answers to business questions without the high cost of retraining or fine-tuning the LLMs.<\/p>\n\n\n\n<p id=\"ember54\">The desire to get higher quality answers from LLMs is universal, spanning many industries. Some examples of using RAG for improved accuracy include the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Chatbots for internal and external users<\/strong><\/li>\n\n\n\n<li><strong>Document searches and summaries<\/strong><\/li>\n\n\n\n<li>Language to code synthesis<\/li>\n\n\n\n<li>Answers to questions that require specialized, <strong>domain-specific knowledge<\/strong><\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/www.linkedin.com\/pulse\/oracle-database-23ai-ai-vector-search-retrieval-augmented-rao-bqkcf\">https:\/\/www.linkedin.com\/pulse\/oracle-database-23ai-ai-vector-search-retrieval-augmented-rao-bqkcf<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Check: dnf -y install oracle-database-preinstall-23ai Prenos softvera: https:\/\/www.oracle.com\/database\/technologies\/free-downloads.html dnf -y install oracle-database-free-23ai-1.0-1.el8.x86_64.rpm Konfiguriranje : \/etc\/init.d\/oracle-free-23ai configure Lokacije programske opreme Namen \/opt\/oracle Oracle base. This is the root of the Oracle Database Free directory tree. \/opt\/oracle\/product\/23ai\/dbhomeFree Oracle home. This home is where the Oracle Database Free is installed. It contains the directories of the Oracle Database&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2024\/10\/22\/oracle-database-23ai-install\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Oracle Database 23ai : Install, vector search<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":15730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[384,1047,1048],"tags":[],"class_list":["post-15726","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computer-science","category-oracle-it-vendors","category-oracle-blog-oracle-it-vendors"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/15726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=15726"}],"version-history":[{"count":2,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/15726\/revisions"}],"predecessor-version":[{"id":15729,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/15726\/revisions\/15729"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media\/15730"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=15726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=15726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=15726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}