HOW TO INSTALL ORACLE 19C/21c ON ORACLE LINUX 8 - USING WEBMIN

 

(Caution if you have never used Unix/Linux Command line tools... this set of instructions is a triple black diamond)...but if you have familiarity with Linux/Unix system administration you can get this working in less than 2 hours.... 

[BTW THE WINDOWS INSTALLATION IS MUCH EASIER... AS THE INSTALLER CREATES WIZARDS FOR THE LISTENER AND DBMS CONFIGURATION]

STEP1 - LOGIN TO YOUR LINUX INSTANCE AS ROOT & MAKE SURE WGET IS INSTALLED

    sudo dnf update

    sudo dnf upgrade

    sudo dnf install wget

STEP2 - CHANGE INTO THE ROOT DOWNLOADS DIRECTORY

    cd /root/Downloads

STEP3 - DOWNLOAD AND INSTALL WEBMIN

    wget "grab the latest link from webmin.com for RPM.... such as"

    wget http://prdownloads.sourceforge.net/webadmin/webmin-1.984-1.noarch.rpm

    dnf install ./webmin*.rpm (Or for the superstar rpm -ivh ./webmin*.rpm)

    change into /etc/webmin/ and modify miniserv to appropriate port (10000 default, 8080, 8443                 recommended if you need it remotely)

STEP4 - DOWNLOAD THE RPM FROM ORACLE.com

    create a login if you dont have one

    download latest DBMS system 19c/21c or your target to your local drive

STEP5 - LOGIN INTO WEBMIN FROM YOUR LOCAL WEB BROWSER AND UPLOAD RPM

    https://10.X.X.X:10000 (WEBMIN DEFAULT PORT IS 10000)

    go to file manager under tools

    create a directory /OPT/ORACLE

    upload RPM to /OPT/ORACLE

Some Webmin shots below show how easy it is to add a new directory named /opt/oracle/

(We think you will thank us for that part alone - even if you think you are an expert Linux Administrator... some of the tools for DNS, and MySQL could take years to learn even for expert users of many systems like us)....

STEP6 - RUN THE ORACLE PRE-INSTALLER & INSTALL JAVA

    make sure java is installed

    dnf install java

    make sure oracle version of epel is installed

    dns install -y oracle-epel-release-el8

    dnf install -y oracle-database-preinstall-19c (or 21c)

STEP7 - CREATE THE ORACLE USER AND GIVE oracle rights to the directory you just created and the RPM you just upgraded.

    

    useradd oracle;

    su root;

    passwd oracle; (set the oracle user password to something you know)

    cd /opt

    chown -R oracle:oinstall /opt/oracle

    cd /opt/oracle

    chown -R oracle:oinstall oracle*.rpm

STEP8 - RUN THE RPM INSTALL

    (If you uploaded things correct oracledbms RPM(archive file) will be in /opt/oracle)

    cd /opt/oracle 

    rpm -ivg oracle*.rpm OR dnf install ./oracle*.rpm if you prefer.

STEP9 - RUN THE WIZARD INSTALL AND CREATE THE TARGET DB ORCLCDB

/etc/init.d/oracldb_ORCLDB-19c configure

STEP10 - EXPORT THE DBPATH

     ORACLE_HOME=/opt/oracle/product/19c/dbhome_1;

     export ORACLE_HOME;

  ORACLE_SID=ORCLCDB; 

  export ORACLE_SID

STEP11 - INCLUDE PATH IN EACH USERS .bashrc files (runs the environment on shell start) who will use oracle with the same statements above path = /home/username/.bashrc

    pico /home/linuxusername/.bashrc

STEP12 - INSTALL OIC CLIENT, SQL DEVELOPER IN THE SAME WAY

    download the RPMs from Oracle

    create a directory /opt/oracle/oic (Instant client) for the oic rpm.

    create a directory /opt/oracle/sqlplus for the sqlplus rpm.

    change into the right directory and run

    dnf install /opt/oracle/oic/oracle*.rpm

    dnf install /opt/oracle/sqlplus/sqlplus*.rpm or whatever you named it.

STEP13 - UPDATE THE LISTENER.ORA FILE AS FOLLOWS

   /opt/oracle/product/19c/admin/network/listener.ora

    SET SID to ORCLCDB

    SET IP ADDRESS TO HOST IP OR 127.0.0.1 for LOCALHOST

STEP14 - START THE LISTENER

    lsnrctrl start/stop.

STEP15 - CONNECT TO SQLPLUS AND CREATE ADDITIONAL USERS

    sqlplus '/as sysdba' (exactly as it looks).

    startup (start the dbms if it says idle)

    

    create user 'stewart01' identified by reallycoolpasswd333;