L:\_instalac_ISO\1_instalac\1_instalirano\linux\2_oralinux
J:\app\vbox
https://yum.oracle.com/oracle-linux-isos.html
L:\3_sw_video\4_db\2_oracle\21c_oracle\21cXE_instalac_img
su -
dnf update
reboot
df -h
df -h | grep -v tmpfs
cat /etc/os-release
uname -a
top
free -m
Oracle_VM_VirtualBox_Extension_Pack-6.1.32.vbox-extpack
Download Oracle VM Extension Pack https://www.virtualbox.org/wiki/Downloads
to J:\a_instl\linux\2_oralinux
**double-click on the package** and a Network Operations Manager window will appear, guiding you through steps.
>Extension pack provides the following added functionality:
>1. The virtual USB 2.0 (EHCI) device. See chapter 3.11.1, USB Settings, page 60.
>2. The virtual USB 3.0 (xHCI) device. See chapter 3.11.1, USB Settings, page 60.
>3. VirtualBox Remote Desktop Protocol (VRDP) support. See chapter 7.1, Remote Display (VRDP Support), page 116.
> Allows for high-performance remote access to any running virtual machine.
This extension supports Remote Desktop Protocol (RDP) >originally built into Microsoft Windows,
with special additions for full client USB support.
>4. Host webcam passthrough. See chapter 9.5, Webcam Passthrough, page 247.
>5. Intel PXE boot ROM.
>6. Disk image encryption with AES algorithm. See chapter 9.28, Encryption of Disk Images, page 286.
>Extension Pack is for All supported platforms - Install it with same version as installed version of VirtualBox.
>To view the extension packs that are currently installed, start VirtualBox Manager ->
File menu -> select Preferences-> go to Extensions category - allows you to remove a package or add a new one.
>Alternatively you can use VBoxManage on the command line: see chapter 8.41, VBoxManage extpack, page 184 for details.
1. VBOX
when I want to install 64-bit Linux, the New->Create Virtual Machine only displays 32-bit option,
no 64-bit option.
Control Panel\All Control Panel Items\Programs and Features and Turn Windows Features on or off.
CHECK "Virtual Machine Platform" -> OK
UNCHECK the Hyper-V feature that was installed. After rebooting the machine, the 64bit options were displayed
=================================================================================================
https://www.youtube.com/watch?v=E3awCYkC1A8 Oct 10, 2021
Oracle Database 21c Express Edition (XE) Installation on Oracle Linux 8.3 - Offline RPM install
=================================================================================================
RPMs can be obtained from below links:
oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm can be downloaded from
https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/index.html
oracle-database-xe-21c-1.0-1.ol8.x86_64.rpm can be downloaded from
https://www.oracle.com/database/technologies/xe-downloads.html
Oracle Database 21c Express Edition has following Limitations:
Supports Up to 2 GB RAM, 2 Core Processor and 12GB Data.
Up to 3 Pluggable Databases.
Single Instance of CDB. Does not support clusters.
We are going to learn
1. Database Installation.
2. Connect from SQL Plus tool
3. Unblock Oracle Database ports from linux firewall.
4. Connect from SQL Developer.
5. Start and shutdown database instance using systemctl command.
6. Create common user in container database XE and create table and insert records.
7. Connect to Pluggable database XEPDB1 and grant priviliges to PDBADMIN.
8. Start and Stop Pluggable Database.
=================================================================================================
Video 1: Ora. Linux 8.3 Inst. in Virtual Box. Foundation for Ora. XE DB + APEX: https://www.youtube.com/watch?v=6m7KEO4spmw
Video 2: https://www.youtube.com/watch?v=2EYakyw53iE
Ora. DB 21c Express Edition (XE) Installation on Oracle Linux 8.3 - Offline RPM install
Video 3: Ora Apex and ORDS inst. in Ora. XE running Ora. Linux https://www.youtube.com/watch?v=2h_B0Fuv_pM
=================================================================================================
This second video base the foundation of Oracle Linux to install the Orcle XE Express Edition
as the foundation for Oracle Apex validating the package requirements, installing dependencies
and ultimately installing and configuring Oracle XE. The easiest installation of Oracle so far.
First Validate package dependencies: oracle-database-preinstall-18c
compat-libcap1
compat-libstdc++-33
glibc-devel
ksh
libaio-devel
libstdc++=devel
make
sysstat
To Solve Dependencies:
dnf install -y compat*
dnf install -y libstdc++*
dnf install -y libaio-devel*
dnf install -y ksh*
dnf install -y sysstat*
dnf install -y gcc-c++ make
dnf install -y ksh
dnf install -y sysstat
dnf install -y xorg-x11-utils
dnf install -y java-11-openjdk-devel
dnf install -y libnsl
wget https://yum.oracle.com/repo/OracleLin...
wget https://yum.oracle.com/repo/OracleLin...
chmod 755 compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
chmod 755 compat-libcap1-1.10-7.el7.x86_64.rpm
ls compat*.rpm | xargs rpm -ivh
rpm -ivh oracle-database-preinstall-18c-1.0-1.el6.x86_64.rpm
Lets Install the Oracle XE Database
rpm -ivh ./oracle-database-xe-18c-1.0-1.x86_64.rpm
Oracle XE Configuration
vi /etc/sysconfig/oracle-xe-18c.conf
/etc/init.d/oracle-xe-18c configure
Once Installed and Configure. Post Installation Commands:
passwd oracle
vi ./.bash_profile
export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export ORACLE_SID=XE
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
Add IPTables 1521
firewall-cmd --permanent --add-port=1521/tcp
firewall-cmd --permanent --add-port=5500/tcp
firewall-cmd --reload
dnf install nmap
nmap localhost
Check Listener
sqlplus '/ as sysdba'
startup;
select * from tab;
show pdbs;
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
===========================================================
3. APEX installation on Linux - Step by Step
===========================================================
su - oracle
lsnrctl status
lsnrctl start
sqlplus /nolog
connect / as sysdba
select user from dual;
startup
select user from dual;
Copy the apex_20.2_en.zip && Unzip
cp apex_20.2_en.zip /opt/
cd /opt
unzip apex_20.2_en.zip
chown -R oracle.oinstall apex
su - oracle
cd /opt/apex
tnsping XE
sqlplus /nolog
conn / as sysdba
select user from dual;
select * from tabs;
show parameter sga_target;
show parameter pga;
select name from v$containers;
alter session set container=XEPDB1;
alter profile DEFAULT limit password_life_time UNLIMITED;
@apexins.sql SYSAUX SYSAUX TEMP /i/
sqlplus /nolog
conn / as sysdba
alter session set container=XEPDB1;
select username from dba_users order by username asc;
sqlplus /nolog
conn / as sysdba
alter session set container=XEPDB1;
@apxchpwd.sql
sqlplus /nolog
conn / as sysdba
alter session set container=XEPDB1;
alter user APEX_PUBLIC_USER account unlock;
alter user APEX_PUBLIC_USER identified by "Apex_2021";
sqlplus /nolog
conn / as sysdba
alter session set container=XEPDB1;
@apex_rest_config.sql
Add to the ./.bash_profile
export ORACLE_BASE=/opt/oracle
echo $ORACLE_BASE
/opt/oracle
su - oracle
mkdir -p $ORACLE_BASE/ords
cd $ORACLE_BASE/ords
pwd
/opt/oracle/ords
cp ords-20.4.3.050.1904.zip /opt/oracle/ords
unzip ords-20.4.3.050.1904.zip
mkdir conf
mkdir images
java -version
java -jar ords.war install advanced
/opt/oracle/ords
(1) Basic
(localhost)
(1521)
(1) database service name
xepdb1
(1) verify/install Oracle REST Data Services schema
ORDS_PUBLIC_USER
Confirm password:
administrator username:SYS AS SYSDBA
password for SYS AS SYSDBA:
Confirm password:
default tablespace for ORDS_METADATA (SYSAUX)
temporary tablespace for ORDS_METADATA (TEMP)
default tablespace for ORDS_PUBLIC_USER (SYSAUX)
temporary tablespace for ORDS_PUBLIC_USER (TEMP)
(1) Oracle Application Express
PL/SQL Gateway database user name (APEX_PUBLIC_USER)
database password for APEX_PUBLIC_USER:
Confirm password:
(1) specify passwords for Application Express
database password for APEX_LISTENER
Confirm password:
database password for APEX_REST_PUBLIC_USER
Confirm password:
(1) SQL Developer Web (Enables all features)
Enter 1 if you wish to start in standalone mode or 2 to exit (1):2
java -jar ords.war validate
cp -R /home/oracle/apex202/apex/images/* /home/oracle/ords2043/images
*/
cd /home/oracle/ords2043
java -jar ords.war standalone
APEX static resources location: /home/oracle/ords2043/images
(1): HTTP
HTTP port (8080): 8090
sudo firewall-cmd --permanent --add-port=8080/tcp
sudo firewall-cmd --reload
sudo firewall-cmd --list-ports
alter session set container=XEPDB1;
alter user APEX_200200 identified by oracle account unlock;
alter user APEX_REST_PUBLIC_USER identified by oracle account unlock;
alter user APEX_INSTANCE_ADMIN_USER identified by oracle account unlock;
alter user APEX_PUBLIC_USER identified by oracle account unlock;
alter user APEX_LISTENER identified by oracle account unlock;
vi /opt/oracle/ords/ords/defaults.xml
NOTE :: Replace GT and LT for the XML.
GTentry key="jdbc.InitialLimit"LT5GT/entryLT
GTentry key="jdbc.MaxLimit"LT20GT/entryLT
cd /opt/oracle/ords/
vi start_ords.sh
#!/bin/bash
java -Dorg.eclipse.jetty.server.Request.maxFormContentSize=20971520 -jar ords.war standalone
chmod 755 start_ords.sh
./start_ords.sh
|
Download
