недеља, 21. октобар 2018.

ORACLE 18 C XE 2 cpu 2 gbytes RAM

oracle 18 c XE can be install on centos 7, installation step is like this:



oracle 18 c XE on centos 6/7 need packages as additionaly installing and check is this ok



photo 1 its need 4 packages (libaio development, compat libcat1, compat-libstdc++ 33,  ksh for centos 7 need 10 packages) and finally need run check if can be pass.
time to competed installation depends of CPU power, in my cases its 20-30 minutes



photo 3 finaly completed installation
photo 4 Acces from other pc over 192.168.8.106:5500/em from local hostas SYS as username and password in my case Manager1- without computer name




photo 5
 export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export ORACLE_SID=XEPDB1 just created and ./sqlplus launch sql terminal
need set position for apex folders (4/5/18) and run @apexins SYSAUX SYSAUX TEMP /i/ or other folders


photo 6 plugable database 2 (PDB2) and PDB3 AND PDB4
its max 12 gbytes each.(with compression it could be 20-30 gbytes!!) 

oracle apex version 5.1.4 can be install as simple connect as  /opt/oracle/product/18x/dbhome/bin/sqlplus sys/Manager1-@localhost:1521/XEPDB1 as sysdba starting from sqlplus command line @apexins sysaux sysaux temp /i/ under plugable database XEPDB1

compression:
sqlplus sys/Manager1-@localhost:1521/XE as sysdba
sql>create table space GGG datafile '/opt/oracle/oradata/XE/XEPDB1/GGG.dbf' SIZE 10g DEFAULT COMPRESS FOR OLTP;
and its offer minimum 3 x database spaces (20-30 gbytes)


automatic start oracle 18 c xe database
as root /usr/bin/systemctl daemon-reload, /usr/bin/systemctl enable oracle-xe-18c