PHP Classes

File: fwphp/glomodul/mkd/01/001_instalac/001_vbox/OraDB21cXEInstalac_on_OraLinux_8_3_Offline_RPM_vbox.txt

Recommend this page to a friend!
  Classes of Slavko Srakocic   B12 PHP FW   fwphp/glomodul/mkd/01/001_instalac/001_vbox/OraDB21cXEInstalac_on_OraLinux_8_3_Offline_RPM_vbox.txt   Download  
File: fwphp/glomodul/mkd/01/001_instalac/001_vbox/OraDB21cXEInstalac_on_OraLinux_8_3_Offline_RPM_vbox.txt
Role: Documentation
Content type: text/plain
Description: Documentation
Class: B12 PHP FW
Manage database records with a PDO CRUD interface
Author: By
Last change: Update of fwphp/glomodul/mkd/01/001_instalac/001_vbox/OraDB21cXEInstalac_on_OraLinux_8_3_Offline_RPM_vbox.txt
Date: 1 year ago
Size: 9,312 bytes


Class file image Download
L:\_instalac_ISO\1_instalac\1_instalirano\linux\2_oralinux J:\app\vbox 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 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 ================================================================================================= 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 oracle-database-xe-21c-1.0-1.ol8.x86_64.rpm can be downloaded from 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: Video 2: 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 ================================================================================================= 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 wget 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 && Unzip cp /opt/ cd /opt unzip 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 /opt/oracle/ords unzip 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 #!/bin/bash java -Dorg.eclipse.jetty.server.Request.maxFormContentSize=20971520 -jar ords.war standalone chmod 755 ./