IT wiki

VU MIF STSC

User Tools

Site Tools


en:cloud:oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
en:cloud:oracle [2022/07/22 11:07] grikieteen:cloud:oracle [2026/02/19 09:41] (current) mif28585
Line 1: Line 1:
-====== Centos OS 7 + Oracle XE 21c Instructions of Installation ======+====== Oracle Linux 8 + Oracle XE 21c Installation Instructions ======
  
-**How to create a virtual machine (VM) with the Centos OS 7 template**+**How to create a virtual machine (VM) using the prepared template**
  
-Select, mark or enter: +Open https://mif.vu.lt/one 
-  - **VM Name** - //create your VM name //; +
-  - **Hold** - check the box; +
-  - **Memory** - 4 GB; +
-  - **CPU** - 2 +
-  - **VCPU** - 4 +
-  - **centos7** - 20 GB+
  
- {{ :cloud:oracle_1.png}} {{ :cloud:oracle_2.png }}+Go to Virtual Resources -> Virtual Machines and click the green plus button.
  
-Open the virtual machine which you created: +In the template searchtype oracle and select the oracle-xe-21c template.
-  - Add //1521// to **TCP_PORT_FORWARDING 22**; +
-  - Expand the 5th function selection icon in the top menu bar on the right, and press **Release**; +
-  Wait for it to load.+
  
- {{ :cloud:oracle_3.png }}+ {{ :cloud:oracle_1a.png}}
  
-Launch the **Putty** app and add your private key.  
-More about **Putty** and private keys read ****[[en:duk:ssh_key|here]]**** 
  
-{{ :cloud:oracle_5.png }}+In the VM name field enter your desired virtual machine name, and at the bottom of the window in the Custom Attributes field enter your desired Oracle database administrator password. 
 +  
 +Return to the top of the page, click the green Create button and wait about 10 minutes until the server completes the installation automatically.
  
-Copy the login credentials from the server control panel //CONNECT_INFO1//. In **Putty** app enter the SSH key keyword as shown in the example and press **Open**. 
- 
-{{ :cloud:oracle_4.png }} 
- 
-On the command line, write the commands in order. Sometimes you will need to press **"y "**. You must wait until the command you have previously typed has been executed before typing another command. 
- 
-<code> 
-  sudo yum check-update 
-  sudo yum update 
-  sudo yum localinstall https://drive.mif.vu.lt/s/T4Z9WxzDgoDqoey/download/oracle-database-preinstall-21c-1.0-1.el7.x86_64.rpm 
-  sudo yum localinstall https://drive.mif.vu.lt/s/swmrJSjMsfjP5Ax/download/oracle-database-xe-21c-1.0-1.ol7.x86_64.rpm 
-</code> 
- 
-After the installation, which may take some time, you need to enter the configuration command, set the password and wait for the configuration to finish. 
-<code>sudo /etc/init.d/oracle-xe-21c configure</code> 
  
 **How to connect to the Oracle database** **How to connect to the Oracle database**
  
-Register and download [[https://www.oracle.com/tools/downloads/sqldev-downloads.html | SQL DEVELOPER]]. Unzip the files and run the application.+Register and download [[https://www.oracle.com/tools/downloads/sqldev-downloads.html | SQL DEVELOPER]]. Extract the files and launch the program.
  
-At the top right with the right mouse buttonclick on **Oracle Connections** and select **New Connection**. In the window that appearsin the appropriate fields, type:+Right-click, in the top right, on **Oracle Connections** and select **New Connection**. In the opened window, enter the following information into the appropriate fields:
  
-  - **Name** - session title+  - **Name** - session name
-  - **Username** - the first time you log in, the SYSTEM user is activeothers can be created later. +  - **Username** - username. When connecting for the first time, use the SYSTEM user, later you can create others
-  - **Password** - the one you set during installation. +  - **Password** - the one you entered in the Custom Attributes field  
-  - **Hostname** - the external IP address that has been assigned. {{ :cloud:oracle_6.png }} +  - **Hostname** - the external IP address that was assigned (193.219.91.103). {{ :cloud:oracle_6.png }} 
-  - **Port** - port attributed by the //OPEN NEBULA//. You will find it in the main server panel, next to the **1521** you entered.+  - **Port** - the port assigned by //OPEN NEBULA//. You can find it in the main server panel under TCP_PORT_FORWARDING as **1521**.
  
 {{ :cloud:oracle_7.png }} {{ :cloud:oracle_7.png }}
  
-**NOTE**: If no new users can be created, enter ''alter session set "_ORACLE_SCRIPT"=true;''+**NOTE**: If you are unable to create new users, enter ''alter session set "_ORACLE_SCRIPT"=true;'' 
en/cloud/oracle.txt · Last modified: by mif28585

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki