Tag: 18c

Podigao Centos 8 na Hetzneru. U /etc/hosts obriši IPV6 adrese jer to nisam ni podešavao, a u liniji sa imenom servera upiši javnu IP adresu servera a ne 127.0.0.1

a.b.c.d mms-link-shortener mms-link-shortener
127.0.0.1 localhost.localdomain localhost
127.0.0.1 localhost4.localdomain4 localhost4

Prvo moraš instalirati ove pakete. Pored njih sam instalirao i mc, nano, wget, git, docker itd.

yum install -y gcc-c++ make
yum install -y ksh
yum install -y sysstat
yum install -y xorg-x11-utils
yum install -y libnsl
yum install java-11-openjdk-devel
rpm -ivh libaio-devel-0.3.110-12.el8.x86_64.rpm
rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
rpm -ivh compat-libcap1-1.10-7.el7.x86_64.rpm

Ove rpm fajlove potražiš na internetu pa ih downlodzješ ili direktno instaliraš sa

wget http://mirror.centos.org/centos/8/BaseOS/x86_64/os/Packages/libaio-devel-0.3.112-1.el8.x86_64.rpm
rpm -ivx libaio-devel-0.3.112-1.el8.x86_64.rpmrpm -ivh http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
rpm -ivh http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libcap1-1.10-7.el7.x86_64.rpm

Preinstall fajl sam skinuo sa Oraclove stranice (imaš u futeru) a instalaciju sa ovim wget-om. Ne znam kako jemoguće da radi ali radi.

wget https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm

rpm -ivh oracle-database-preinstall-18c-1.0-1.el7.x86_64
rpm -ivh oracle-database-xe-18c-1.0-1.x86_64.rpm

Na kraju možeš pogledati sadržaj fajla na putanji /etc/sysconfig/oracle-xe-18c.conf i onda kao root startuješ skriptu /etc/init.d/oracle-xe-18c configure. Rezultat je:

Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database XE.
Enter SYS user password:
**********************
Enter SYSTEM user password:
*******************
Enter PDBADMIN User Password:
******************
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
31% complete
34% complete
38% complete
41% complete
43% complete
Completing Database Creation
47% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/XE.
Database Information:
Global Database Name:XE
System Identifier(SID):XE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.

Connect to Oracle Database using one of the connect strings:
     Pluggable database: mms-link-shortener:1539/XEPDB1
     Multitenant container database: mms-link-shortener:1539
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE

Ako hočeš da se Oralce XE 18c automatski startuje onda otkucaš kao root

[root@mms-link-shortener ~]# systemctl daemon-reload
[root@mms-link-shortener ~]# systemctl enable oracle-xe-18c

Ako hočeš da se environment varijable za Oracle automatski postavepo logogovanju otvori fajl sa

nano /etc/profile.d/set_oraenv.sh

I u njega dokucaj

nano /etc/profile.d/set_oraenv.sh

export ORACLE_SID=XE
export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export ORACLE_BASE=/opt/oracle
export PATH=$PATH:/opt/oracle/product/18c/dbhomeXE/bin

Po otključavaj portove i pazi da po defaultu listener port nije 1521 već 1539. SID je XE. Ako firewalld nije instaliran instaliraj ga sa

dnf install firewalld

[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --permanent --add-service=https
success
[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --permanent --add-service=http
success
[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --reload
success
[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --permanent --zone=public --add-port=1521/tcp
success
[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --permanent --zone=public --add-port=1539/tcp
success
[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --reload