{"id":10,"date":"2015-12-18T08:56:18","date_gmt":"2015-12-18T01:56:18","guid":{"rendered":"https:\/\/oracletutorial.com\/?page_id=10"},"modified":"2025-04-25T20:31:06","modified_gmt":"2025-04-26T03:31:06","slug":"install-oracle","status":"publish","type":"page","link":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/","title":{"rendered":"Install Oracle"},"content":{"rendered":"\r\n<p><strong>Summary<\/strong>: In this tutorial, you&#8217;ll learn how to download, install, and configure Oracle 23ai database using Oracle VirtualBox<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id='prerequisites'>Prerequisites <a href=\"#prerequisites\" class=\"anchor\" id=\"prerequisites\" title=\"Anchor for Prerequisites\">#<\/a><\/h2>\r\n\r\n\r\n\r\n<p>Your computer should meet the following requirements:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Windows 11.<\/li>\r\n\r\n\r\n\r\n<li>Having at least 8GB of RAM.<\/li>\r\n\r\n\r\n\r\n<li>20GB free disk space.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id='oracle-virtualbox'>Oracle VirtualBox <a href=\"#oracle-virtualbox\" class=\"anchor\" id=\"oracle-virtualbox\" title=\"Anchor for Oracle VirtualBox\">#<\/a><\/h2>\r\n\r\n\r\n\r\n<p>Oracle VirtualBox is a free software that allows you to run other operating systems, such as Linux and Windows, inside your computer as if they were regular applications. In other words, VirtualBox lets you run a virtual computer or virtual machine (VM) within your physical computer.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-1-download-oracle-virtualbox'>Step 1: Download Oracle VirtualBox <a href=\"#step-1-download-oracle-virtualbox\" class=\"anchor\" id=\"step-1-download-oracle-virtualbox\" title=\"Anchor for Step 1: Download Oracle VirtualBox\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\" start=\"1\">\r\n<li>Launch your web browser and go to the VirtualBox official website <a href=\"https:\/\/www.virtualbox.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.virtualbox.org\/<\/a><\/li>\r\n\r\n\r\n\r\n<li>Click the <strong>&#8220;Download VirtualBox&#8221;<\/strong> link.<\/li>\r\n\r\n\r\n\r\n<li>Under\u00a0<strong>&#8220;VirtualBox Platform Packages&#8221;<\/strong>, select the <strong>Windows hosts<\/strong> file to download.<\/li>\r\n\r\n\r\n\r\n<li>Wait for the download to complete.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-2-install-oracle-virtualbox'>Step 2. Install Oracle VirtualBox <a href=\"#step-2-install-oracle-virtualbox\" class=\"anchor\" id=\"step-2-install-oracle-virtualbox\" title=\"Anchor for Step 2. Install Oracle VirtualBox\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\" start=\"1\">\r\n<li>Execute the downloaded installer file.<\/li>\r\n\r\n\r\n\r\n<li>Click\u00a0<strong>Next<\/strong>\u00a0\u2192 Accept the\u00a0<strong>license agreement<\/strong>\u00a0\u2192\u00a0<strong>Next<\/strong>.<\/li>\r\n\r\n\r\n\r\n<li>Keep the\u00a0default settings.<\/li>\r\n\r\n\r\n\r\n<li>Click\u00a0<strong>&#8220;Yes&#8221;<\/strong>\u00a0if prompted for\u00a0<strong>network installation<\/strong> (required\u00a0for connecting from your computer).<\/li>\r\n\r\n\r\n\r\n<li>Click\u00a0<strong>Install<\/strong>\u00a0\u2192 Wait for the process to complete.<\/li>\r\n\r\n\r\n\r\n<li>Check\u00a0<strong>&#8220;Start Oracle VirtualBox after installation&#8221;<\/strong>\u00a0\u2192 Click\u00a0<strong>Finish<\/strong>.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<h2 class=\"wp-block-heading\" id='oracle-23ai-database'>Oracle 23AI Database <a href=\"#oracle-23ai-database\" class=\"anchor\" id=\"oracle-23ai-database\" title=\"Anchor for Oracle 23AI Database\">#<\/a><\/h2>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p>Oracle 23ai is the latest version of Oracle Database that combines relational database management with built-in AI features. If you want to get the Oracle 23AI database server up and running quickly, you can use a pre-configure image.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-1-download-the-oracle-23ai-database-ova-file'>Step 1: Download the Oracle 23AI Database OVA File <a href=\"#step-1-download-the-oracle-23ai-database-ova-file\" class=\"anchor\" id=\"step-1-download-the-oracle-23ai-database-ova-file\" title=\"Anchor for Step 1: Download the Oracle 23AI Database OVA File\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>Open your web browser and go to <a href=\"https:\/\/www.oracle.com\/database\/free\/\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle\u2019s official website<\/a>.<\/li>\r\n\r\n\r\n\r\n<li>Navigate to the <a href=\"https:\/\/www.oracle.com\/database\/free\/get-started\/\" target=\"_blank\" rel=\"noreferrer noopener\">Get Started<\/a> section.<\/li>\r\n\r\n\r\n\r\n<li>Locate and download the <strong>Oracle 23AI OVA file, <\/strong>a pre-configured virtual machine.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-2-import-the-ova-file-into-virtualbox'>Step 2: Import the OVA File into VirtualBox <a href=\"#step-2-import-the-ova-file-into-virtualbox\" class=\"anchor\" id=\"step-2-import-the-ova-file-into-virtualbox\" title=\"Anchor for Step 2: Import the OVA File into VirtualBox\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>Open your VirtualBox.<\/li>\r\n\r\n\r\n\r\n<li>In <strong>VirtualBox<\/strong>, go to <strong>File \u2192 Import Appliance<\/strong>.<\/li>\r\n\r\n\r\n\r\n<li>Click <strong>&#8220;Choose File&#8221;<\/strong> and choose the <strong>Oracle 23AI OVA file<\/strong> you downloaded earlier.<\/li>\r\n\r\n\r\n\r\n<li>Click <strong>&#8220;Next&#8221;<\/strong> and review the settings. To have a better performance, you can increase the memory (RAM).<\/li>\r\n\r\n\r\n\r\n<li>Click <strong>&#8220;Import&#8221;<\/strong> and wait for the process to complete.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-3-configure-virtual-machine-settings'>Step 3. Configure Virtual Machine Settings <a href=\"#step-3-configure-virtual-machine-settings\" class=\"anchor\" id=\"step-3-configure-virtual-machine-settings\" title=\"Anchor for Step 3. Configure Virtual Machine Settings\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<p>First, select the <strong>Oracle Database 23ai Free<\/strong>:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"375\" height=\"247\" class=\"wp-image-4439\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-selecting-oracle-db-image.png\" alt=\"\" srcset=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-selecting-oracle-db-image.png 375w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-selecting-oracle-db-image-300x198.png 300w\" sizes=\"auto, (max-width: 375px) 100vw, 375px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Second, click the <strong>Settings<\/strong> button on VirtualBox:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"861\" height=\"265\" class=\"wp-image-4440\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-settings.png\" alt=\"\" srcset=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-settings.png 861w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-settings-300x92.png 300w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-settings-768x236.png 768w\" sizes=\"auto, (max-width: 861px) 100vw, 861px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Third, Select the <strong>Network<\/strong>, check the <strong>Enable Network Adapter<\/strong>, and Change the <strong>Attached to<\/strong> to <strong>&#8220;Bridge Adapter&#8221;<\/strong>:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"901\" height=\"537\" class=\"wp-image-4441\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-network-setting.png\" alt=\"install oracle virtual box - network setting\" srcset=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-network-setting.png 901w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-network-setting-300x179.png 300w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-network-setting-768x458.png 768w\" sizes=\"auto, (max-width: 901px) 100vw, 901px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>This setting will allow you to connect to the Oracle Database 23ai on the virtual machine from your computer.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-4-start-the-oracle-23ai-virtual-machine'>Step 4: Start the Oracle 23ai Virtual Machine <a href=\"#step-4-start-the-oracle-23ai-virtual-machine\" class=\"anchor\" id=\"step-4-start-the-oracle-23ai-virtual-machine\" title=\"Anchor for Step 4: Start the Oracle 23ai Virtual Machine\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Select the <strong>Oracle Database 23ai Free<\/strong> and click <strong>&#8220;Start&#8221;<\/strong>.<\/li>\r\n\r\n\r\n\r\n<li>Please wait for the system to start. Typically, it&#8217;ll take a few minutes.<\/li>\r\n\r\n\r\n\r\n<li>The virtual machine will <b>automatically log in<\/b>\u00a0as the <strong>Oracle <\/strong>user.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Once the virtual machine starts, it&#8217;ll open Oracle Documentation in a web browser.<\/p>\r\n\r\n\r\n\r\n<p>Here&#8217;s important information:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-table\">\r\n<table class=\"has-fixed-layout\">\r\n<thead>\r\n<tr>\r\n<th>Parameter<\/th>\r\n<th>Value<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<tr>\r\n<td>Oracle SID<\/td>\r\n<td><strong>free<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td>Pluggable DB<\/td>\r\n<td><strong>freepdb1<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Open the terminal, and type the following command to get the IP address:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">ip a<\/code><\/span><\/pre>\r\n\r\n\r\n<p>It&#8217;ll return a lot of information. The IP address will look like this:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">192<span class=\"hljs-selector-class\">.168<\/span><span class=\"hljs-selector-class\">.2<\/span><span class=\"hljs-selector-class\">.43<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p>To verify the IP address, you can open a PowerShell or Command Prompt on your computer and ping this IP:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Press <code>Cmd+R<\/code> to open the Run window.<\/li>\r\n\r\n\r\n\r\n<li>Type <code>cmd<\/code> and press <code>Enter<\/code>. It&#8217;ll launch a Command Prompt.<\/li>\r\n\r\n\r\n\r\n<li>Ping the IP address by typing the following command:<\/li>\r\n<\/ul>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">ping<\/span> 192<span class=\"hljs-selector-class\">.168<\/span><span class=\"hljs-selector-class\">.2<\/span><span class=\"hljs-selector-class\">.43<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p>If you see the reply, it means you got the correct IP address:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"HTML, XML\" data-shcb-language-slug=\"xml\"><span><code class=\"hljs language-xml\">C:\\&gt;ping 192.168.2.43\r\n\r\nPinging 192.168.2.43 with 32 bytes of data:\r\nReply from 192.168.2.43: bytes=32 time<span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">1ms<\/span> <span class=\"hljs-attr\">TTL<\/span>=<span class=\"hljs-string\">64<\/span>\r\n<span class=\"hljs-attr\">Reply<\/span> <span class=\"hljs-attr\">from<\/span> <span class=\"hljs-attr\">192.168.2.43:<\/span> <span class=\"hljs-attr\">bytes<\/span>=<span class=\"hljs-string\">32<\/span> <span class=\"hljs-attr\">time<\/span>=<span class=\"hljs-string\">1ms<\/span> <span class=\"hljs-attr\">TTL<\/span>=<span class=\"hljs-string\">64<\/span>\r\n<span class=\"hljs-attr\">Reply<\/span> <span class=\"hljs-attr\">from<\/span> <span class=\"hljs-attr\">192.168.2.43:<\/span> <span class=\"hljs-attr\">bytes<\/span>=<span class=\"hljs-string\">32<\/span> <span class=\"hljs-attr\">time<\/span>=<span class=\"hljs-string\">1ms<\/span> <span class=\"hljs-attr\">TTL<\/span>=<span class=\"hljs-string\">64<\/span>\r\n<span class=\"hljs-attr\">Reply<\/span> <span class=\"hljs-attr\">from<\/span> <span class=\"hljs-attr\">192.168.2.43:<\/span> <span class=\"hljs-attr\">bytes<\/span>=<span class=\"hljs-string\">32<\/span> <span class=\"hljs-attr\">time<\/span>=<span class=\"hljs-string\">1ms<\/span> <span class=\"hljs-attr\">TTL<\/span>=<span class=\"hljs-string\">64<\/span><\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">HTML, XML<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">xml<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-5-allow-remote-connection'>Step 5. Allow remote connection <a href=\"#step-5-allow-remote-connection\" class=\"anchor\" id=\"step-5-allow-remote-connection\" title=\"Anchor for Step 5. Allow remote connection\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<p>By default, you can connect to the Oracle database server from the localhost, meaning the virtual machine.<\/p>\r\n\r\n\r\n\r\n<p><span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">You need to configure the\u00a0<a href=\"https:\/\/www.oracletutorial.com\/oracle-administration\/oracle-listener\/\" target=\"_blank\" rel=\"noopener\">Oracle listener<\/a> to allow remote connections, such as from your computer to the virtual machine.<\/span><\/p>\r\n\r\n\r\n\r\n<p>First, open a text editor on your virtual machine.<\/p>\r\n\r\n\r\n\r\n<p>Second, open the listener file:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">\/opt\/oracle\/product\/23ai\/dbhomeFree\/network\/admin\/listener.ora<\/code><\/span><\/pre>\r\n\r\n\r\n<p>It has a section like:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">LISTENER =\r\n  (DESCRIPTION_LIST =\r\n    (DESCRIPTION =\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))\r\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\r\n    )\r\n  )\r\n<\/code><\/span><\/pre>\r\n\r\n\r\n<p>The <code>HOST = localhost<\/code> tells Oracle Database Server to accept only local connections. You need to change the localhost to <code>0.0.0.0<\/code>:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">\r\nLISTENER =\r\n  (DESCRIPTION_LIST =\r\n    (DESCRIPTION =\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))\r\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\r\n    )\r\n  )<\/code><\/span><\/pre>\r\n\r\n\r\n<p>Save the file, and you&#8217;re done with remote connection configuration.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id='sql-developer'>SQL Developer <a href=\"#sql-developer\" class=\"anchor\" id=\"sql-developer\" title=\"Anchor for SQL Developer\">#<\/a><\/h2>\r\n\r\n\r\n\r\n<p>SQL Developer is a free graphical user interface (GUI) tool that enables you to connect to an Oracle database, run SQL queries, and perform other database-related tasks.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-1-download-sql-developer'>Step 1. Download SQL Developer <a href=\"#step-1-download-sql-developer\" class=\"anchor\" id=\"step-1-download-sql-developer\" title=\"Anchor for Step 1. Download SQL Developer\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Open your web browser and go to the <a href=\"https:\/\/www.oracle.com\/database\/sqldeveloper\/technologies\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle SQL Developer page<\/a>.<\/li>\r\n\r\n\r\n\r\n<li>Download the Windows 64-bit with JDK 17 included. It is a portable version, so you don&#8217;t have to set up.<\/li>\r\n\r\n\r\n\r\n<li>Extract the download file to a directory like D:\\sqldeveloper<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-2-connect-to-the-oracle-database-23ai-from-sql-developer'>Step 2. Connect to the Oracle Database 23ai from SQL Developer <a href=\"#step-2-connect-to-the-oracle-database-23ai-from-sql-developer\" class=\"anchor\" id=\"step-2-connect-to-the-oracle-database-23ai-from-sql-developer\" title=\"Anchor for Step 2. Connect to the Oracle Database 23ai from SQL Developer\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Launch SQL Developer (sqldeveloper.exe)<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>From the <strong>Connection<\/strong> pane, click <strong>New Database Connection&#8230;<\/strong>:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"257\" height=\"179\" class=\"wp-image-4432\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-sql-developer-connect.png\" alt=\"install oracle - sql developer - connect\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Enter the connection parameters:<\/p>\r\n\r\n\r\n\r\n<p>Name: Oracle 23ai. You can choose any name you want<\/p>\r\n\r\n\r\n\r\n<p>User Info:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>username: <strong>system<\/strong><\/li>\r\n\r\n\r\n\r\n<li>password: <strong>oracle<\/strong><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Check the <strong>Save Password<\/strong> checkbox.<\/p>\r\n\r\n\r\n\r\n<p>Details:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Hostname: <strong>192.168.2.43<\/strong>. Replace it with your virtual machine&#8217;s IP address.<\/li>\r\n\r\n\r\n\r\n<li>Port: <strong>1521<\/strong><\/li>\r\n\r\n\r\n\r\n<li>SID: <strong>free<\/strong><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>The connection parameters look like the following picture:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"766\" height=\"493\" class=\"wp-image-4433\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-sql-developer-connection.png\" alt=\"install oracle - sql developer - connection\" srcset=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-sql-developer-connection.png 766w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-sql-developer-connection-300x193.png 300w\" sizes=\"auto, (max-width: 766px) 100vw, 766px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Click the <strong>Test<\/strong> button to test the connection. If you see\u00a0<span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">the&#8217;<strong>\u00a0Success&#8217;<\/strong> message, it means you are<\/span>\u00a0ready to connect to the Oracle Database server.<\/p>\r\n\r\n\r\n\r\n<p>Click the <strong>Connect<\/strong> button to connect. SQL Developer will look like this:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"682\" height=\"276\" class=\"wp-image-4434\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-sql-developer-connected.png\" alt=\"install oracle - sql developer - connected\" srcset=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-sql-developer-connected.png 682w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-sql-developer-connected-300x121.png 300w\" sizes=\"auto, (max-width: 682px) 100vw, 682px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id='step-3-executing-sql-statements'>Step 3. Executing SQL Statements <a href=\"#step-3-executing-sql-statements\" class=\"anchor\" id=\"step-3-executing-sql-statements\" title=\"Anchor for Step 3. Executing SQL Statements\">#<\/a><\/h3>\r\n\r\n\r\n\r\n<p>SQL is a language you use to communicate with the Oracle database. SQL Developer allows you to execute a single SQL statement and multiple SQL statements.<\/p>\r\n\r\n\r\n\r\n<p>Here are the steps for executing a single SQL statement:<\/p>\r\n\r\n\r\n\r\n<p>First, enter a statement <code>SELECT 1 + 1;<\/code> in the editor (1). This is a simple SQL statement that returns the sum of 1 and 1.<\/p>\r\n\r\n\r\n\r\n<p>Second, click the <strong>Run Statement<\/strong> button (2) to execute the statement. SQL Developer will execute the statement at the cursor and display the result on the grid (3)<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"427\" height=\"384\" class=\"wp-image-4442\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/sql-developer-execute-a-statement.png\" alt=\"\" srcset=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/sql-developer-execute-a-statement.png 427w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/sql-developer-execute-a-statement-300x270.png 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>To execute multiple SQL statements, you follow these steps:<\/p>\r\n\r\n\r\n\r\n<p>First, enter multiple statements in the editor (1).<\/p>\r\n\r\n\r\n\r\n<p>Second, click the <strong>Run Script <\/strong>button (2). The SQL developer will execute all the statements in the editor and display the output in the\u00a0<strong>script output<\/strong> (text-based).<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"436\" height=\"481\" class=\"wp-image-4443\" src=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/sql-developer-execute-a-script.png\" alt=\"sql developer execute a script\" srcset=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/sql-developer-execute-a-script.png 436w, https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/sql-developer-execute-a-script-272x300.png 272w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/figure>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id='summary'>Summary <a href=\"#summary\" class=\"anchor\" id=\"summary\" title=\"Anchor for Summary\">#<\/a><\/h2>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>VirtualBox enables you to run an operating system on your computer.<\/li>\r\n\r\n\r\n\r\n<li>The Oracle Database 23ai image enables you to bring the Oracle Database Server up and running quickly.<\/li>\r\n\r\n\r\n\r\n<li>SQL Developer enables you to interact with the Oracle Database Server, allowing you to execute queries.<\/li>\r\n<\/ul>\r\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"10\"\n\t\t\t\tdata-post-url=\"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/\"\n\t\t\t\tdata-post-title=\"Install Oracle\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"10\"\n\t\t\t\tdata-post-url=\"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/\"\n\t\t\t\tdata-post-title=\"Install Oracle\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you&#8217;ll learn how to download, install, and configure Oracle 23ai database using Oracle VirtualBox.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":149,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-10","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Install Oracle Database<\/title>\n<meta name=\"description\" content=\"This tutorial guides you step by step through the installation of Oracle Database on your computer and shows how to connect to it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install Oracle Database\" \/>\n<meta property=\"og:description\" content=\"This tutorial guides you step by step through the installation of Oracle Database on your computer and shows how to connect to it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Oracle Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-26T03:31:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-selecting-oracle-db-image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"375\" \/>\n\t<meta property=\"og:image:height\" content=\"247\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/install-oracle\\\/\",\"url\":\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/install-oracle\\\/\",\"name\":\"Install Oracle Database\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/install-oracle\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/install-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.oracletutorial.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/install-oracle-virtual-box-selecting-oracle-db-image.png\",\"datePublished\":\"2015-12-18T01:56:18+00:00\",\"dateModified\":\"2025-04-26T03:31:06+00:00\",\"description\":\"This tutorial guides you step by step through the installation of Oracle Database on your computer and shows how to connect to it.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/install-oracle\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/install-oracle\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/install-oracle\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.oracletutorial.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/install-oracle-virtual-box-selecting-oracle-db-image.png\",\"contentUrl\":\"https:\\\/\\\/www.oracletutorial.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/install-oracle-virtual-box-selecting-oracle-db-image.png\",\"width\":375,\"height\":247},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/install-oracle\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.oracletutorial.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting Started with Oracle Database\",\"item\":\"https:\\\/\\\/www.oracletutorial.com\\\/getting-started\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Install Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.oracletutorial.com\\\/#website\",\"url\":\"https:\\\/\\\/www.oracletutorial.com\\\/\",\"name\":\"Oracle Tutorial\",\"description\":\"Oracle Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.oracletutorial.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install Oracle Database","description":"This tutorial guides you step by step through the installation of Oracle Database on your computer and shows how to connect to it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Install Oracle Database","og_description":"This tutorial guides you step by step through the installation of Oracle Database on your computer and shows how to connect to it.","og_url":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/","og_site_name":"Oracle Tutorial","article_modified_time":"2025-04-26T03:31:06+00:00","og_image":[{"width":375,"height":247,"url":"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-selecting-oracle-db-image.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/","url":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/","name":"Install Oracle Database","isPartOf":{"@id":"https:\/\/www.oracletutorial.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/#primaryimage"},"image":{"@id":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-selecting-oracle-db-image.png","datePublished":"2015-12-18T01:56:18+00:00","dateModified":"2025-04-26T03:31:06+00:00","description":"This tutorial guides you step by step through the installation of Oracle Database on your computer and shows how to connect to it.","breadcrumb":{"@id":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/#primaryimage","url":"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-selecting-oracle-db-image.png","contentUrl":"https:\/\/www.oracletutorial.com\/wp-content\/uploads\/2025\/04\/install-oracle-virtual-box-selecting-oracle-db-image.png","width":375,"height":247},{"@type":"BreadcrumbList","@id":"https:\/\/www.oracletutorial.com\/getting-started\/install-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.oracletutorial.com\/"},{"@type":"ListItem","position":2,"name":"Getting Started with Oracle Database","item":"https:\/\/www.oracletutorial.com\/getting-started\/"},{"@type":"ListItem","position":3,"name":"Install Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.oracletutorial.com\/#website","url":"https:\/\/www.oracletutorial.com\/","name":"Oracle Tutorial","description":"Oracle Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.oracletutorial.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/pages\/10","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/comments?post=10"}],"version-history":[{"count":0,"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/pages\/10\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/pages\/149"}],"wp:attachment":[{"href":"https:\/\/www.oracletutorial.com\/wp-json\/wp\/v2\/media?parent=10"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}