Day 1-Training

[SarahShafira]

01. Install VMWare Workstation Player VMware-player-full-16.2.5-20904516.exe

[SarahShafira]

---

02. Extract Image Virtual Machine VM-Server.zip

---

03. Startup VM :

• Open file : "Oracle Linux 8 64-bit.vmx"
• Pilih -> "I Copied It" username : root, admin password : Welcome1

[SarahShafira]

=== Install Oracle Database Software ===

01. Install prerequisite Oracle Database 19c

$ su -
    Password : Welcome1

# dnf install oracle-database-preinstall-19c

    Installed:
      oracle-database-preinstall-19c-1.0-2.el8.x86_64                               
      ksh-20120801-257.0.1.el8.x86_64                                               
      libXxf86dga-1.1.5-1.el8.x86_64                                                
      libdmx-1.1.4-3.el8.x86_64                                                     
      libstdc++-devel-8.2.1-3.5.0.1.el8.x86_64                                      
      sysstat-11.7.3-9.0.1.el8.x86_64                                               
      xorg-x11-utils-7.5-28.el8.x86_64                                              
      glibc-devel-2.28-42.0.1.el8.x86_64                                            
      libaio-devel-0.3.112-1.el8.x86_64                                             
      libnsl-2.28-42.0.1.el8.x86_64                                                 
      libxcrypt-devel-4.1.1-4.el8.x86_64                                            
      lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                        
      make-1:4.2.1-11.el8.x86_64                                                    

    Complete!

# passwd oracle

    password : Welcome1

---

02. Login di VM sebagai user oracle

---

03. Install MobaXterm

kalo ada error ini, pindahin .dat nya ke path yang diminta > retry

---

SKIP

Start using Oracle Linux Server

---

03. Connect MobaXterm ke VM login di vm buat cek ini $ hostname vmserver.com

$ ifconfig
    ens160: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
            inet 192.11.12.20  netmask 255.255.255.0  broadcast 192.11.12.255

    ens192: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
            inet 192.168.161.129  netmask 255.255.255.0  broadcast 192.168.182.255

---

04. Buat directory untuk kebutuhan Oracle Database

• Login sebagai user oracle

  $ su -

  mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1

  chown -R oracle:oinstall /u01

  chmod -R 755 /u01

  exit

---

05. Configure .bash_profile

**$ pwd**
    /home/oracle
**$ ls
$ ls -a
$ more .bash_profile**

**$ nano .bash_profile**

    # .bash_profile

    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
            . ~/.bashrc
    fi

    # User specific environment and startup programs

    # Oracle Settings
    export TMP=/tmp
    export TMPDIR=$TMP

    export ORACLE_HOSTNAME=vmserver.com
    export ORACLE_BASE=/u01/app/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
    export ORA_INVENTORY=/u01/app/oraInventory
    export ORACLE_SID=prod

    export PATH=/usr/sbin:/usr/local/bin:$PATH
    export PATH=$ORACLE_HOME/bin:$PATH

    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
    export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

**$ more .bash_profile**

    - Check setting di .bash_profile sesuai dengan realnya
        - ORACLE_HOSTNAME
        - ORACLE_BASE
        - ORACLE_HOME

---

[SarahShafira]

---

04. Test Env. Variable

- Logout
- Login lagi sebagai user oracle -> di mobaexterm

**$ echo $ORACLE_HOSTNAME**
    vmserver.com

**$ echo $ORACLE_HOME**
    /u01/app/oracle/product/19.0.0/dbhome_1

---

05. Copy installer Oracle DB 19c EE => /home/oracle drag and drop --> dari windows nyimpen file ke mobaexterm

    LINUX.X64_193000_db_home.zip => /home/oracle

$ cd /home/oracle
$ ls
    LINUX.X64_193000_db_home.zip

---

06. Extract LINUX.X64_193000_db_home.zip

$ cd $ORACLE_HOME
$ pwd
    /u01/app/oracle/product/19.0.0/dbhome_1

$ unzip -oq /home/oracle/LINUX.X64_193000_db_home.zip
$ ls