I plan to explain the connection from .NET (Framework, Core, 5.0 comprehensively) to Oracle Database, focusing on ODP.NET Managed Driver, but first of all, in order to build the essential Oracle Database, I will explain how to install Oracle Linux with images very carefully (I also use it as a study memo).
This time it's the first part, and the second part is going to install Oracle Database 19c on Oracle Linux 8.3.
Oracle Linux is based on Red Hat, but it seems easy to build an Oracle Database (since it is easy to install Windows Server but the environment cannot be prepared), so this time I will use this for the DB server.
Probably the most polite procedure to explain the latest Oracle Linux 8.3 installation ...
The second part of installing and building Oracle Database 19c is ↓. -Building Oracle Database 19c on Oracle Linux 8.3 (DB building part 2)
As stated on the Official Site, the OS itself can be downloaded and used for free (support is charged).
Also, as I will write in the second part, since Oracle Database has an OTN developer license, it can be used free of charge for limited purposes other than production use such as learning, development, testing (explained in the link below). There is). Moreover, the software can be downloaded from the official website.
Then, the following is the explanation of the installation method.
↓ is the official website of Oracle Linux.
The link at the top right of the site will take you to the download page.
Sign in You need to create an account, so if you don't have one, create one.
Next, the product selection screen will appear. Enter "** Oracle Linux **", search for it, and select the latest version (8.3 at the time of writing).
Click "Continue" in "View Items" at the top right of the ↑ screen to go to the next screen. Select "x86 64bit" in "Platforms / Languages" (please match your environment) and click "Continue".
The license screen will appear, so check it and click "Continue".
Some ISO images will appear, but only "** V1004253-01.iso Oracle Linux Release 8 Update 3 for x86 (64 bit), 8.6 GB **" is OK. Press "Download".
If the download program is dropped, execute it.
You will be asked for the save destination path, so specify an appropriate location and click "Next"
The download will start. Let's wait patiently.
Once downloaded, load the ISO image and start the installation. This time, install it on the virtual environment. You will be using VMware Workstation 15 Player. I think that the installation procedure itself is the same for Hyper-V (I think that it is physically different, so I would be grateful if you could check it yourself ...).
At the top, select "Install Oracle Linux 8.3.0" and press Enter (white is selected).
Select a language. Here, select Japanese. If you select it, the screen will change to Japanese.
Next, the installation setting screen will appear.
Are the required items as follows?
-** Time and date **
In "Software Selection", you can select the server type and software, such as GUI or console only. I think the GUI consumes more resources, but this time I chose "server (using the GUI)" with an emphasis on ease of use and comprehension (although I would like to try it).
In addition, you can create an individual user other than root in "User settings", but it is not essential, so please do it according to your purpose (created in this article).
Below are the specific setting items.
For "Date and time", select the time zone of Tokyo.
Since there is only one installation destination (in this case), it is selected by default, so just select "Finish".
Set "Next network and host name". At first, the switch on the right is "Off", so turn it "On" and press "Set". The default is DHCP, but with this, the IP address changes each time you start up, so use a static IP address. Well, it's OK if you can connect from the outside
Click the "IPv4" tab, click the "Add" button, and enter the address, netmask, and gateway. Enter the DNS server as well (please set your own settings here). If you can, click "Save". By the way, in my environment, the VMware network is "bridge: directly connected to the physical network".
Make sure the IP address is set and click Finish.
You will be returned to the initial settings screen, but the root password settings are at the bottom, so scroll down and select "root password".
Enter the root password. If you can, click "Finish".
To create a general user, go to "Create User". It's not essential, so if you are interested, please ... Even in a virtual environment, I always feel that it is not good to be root, so I will create it.
This completes the settings. Check again if there are any problems with the contents, and press "Start Installation".
The installation will start. Drink coffee and wait patiently.
When you're done, the "Restart System" button will turn blue, so press it to reboot.
If you reboot and don't touch anything on the first selection screen, you'll see something like this. Since the license has not been activated, click the icon in the middle.
Check it and press "Finish".
Click "Complete settings" at the bottom right.
The login screen will appear, so log in with the account created during the setup work before installation.
The welcome screen will appear, so select "Japanese".
Select "Japanese" for the keyboard layout.
You can choose "Location Services" as you like (I turned it off).
"Connect to an online account" is your choice. This time it is not for the purpose of creating a DB server.
Setup is complete.
A screen like this will appear, but if you press the x in the upper right, you will be taken to the desktop screen.
It looks like this. This completes the installation of Oracle Linux.
If you can't do this, it will be troublesome, so let's set it.
Launch the terminal. Click "Activity" on the upper left, and a menu will appear on the left. Click the second terminal from the bottom.
Elevate to root once with
su and give user administrator privileges.
$ su [password input] $ usermod -aG wheel user
It will not be reflected unless you log in again, so log out and log in again. If you click the power button on the upper right, there is a place where the user is displayed, so there is "Logout" in it.
Let's check if it was reflected. Also, launch the terminal and check if it is added to the group with the following command.
$ id -Gn
If wheel is added, it's OK.
Now you can use
For the time being, let's keep the software up to date.
$ sudo yum update
Next time, I would like to build Oracle Database 19c in this.