Ubuntu 18.0.4 LTS and Oracle VirtualBox

Need Ubuntu 18.0.4 –

• Ubuntu Server 18.04.2 LTS

https://www.ubuntu.com/download/server

• Download VirtualBox

https://www.virtualbox.org/wiki/Downloads

Ubuntu is light weight, once installUbuntu: CTL+ALT+ T to create the terminal session

Make sure that the computer is connected to the internet for all updates, including VirtualBox

$sudo apt install virtualbox

$sudo apt install virtualbox-ext-pack (press <TAB> to highlight the <ok> option and install

Setting up VirtualBox

• CPU 4,
• memory: 4GB,
• network Bridged and
• filesize 50Gb
• Virtual CD/DVD-ISO use the Oracle linux 7.5 ISO, it will boot the Oracle linux installation
  • Install with GUI option
  • select all tools option
  • reclaim all spaces
  • Internet enable

Steps to pre-install global settings for Oracle 11g.

How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6

https://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html

1. As an authorized user (for example, root), retrieve the file that configures repository locations:

   # cd /etc/yum.repos.d
   
   # wget http://yum.oracle.com/public-yum-ol6.repo
   
   

2. Using a text editor, modify the file, changing the field enabled=0 to enabled=1 to reflect repositories that correspond to the machine’s operating system release.Here is an excerpt of public-yum-old6.repo with the changed lines in boldface.

   [ol6_latest]
   
   name=Oracle Linux $releasever Latest ($basearch)
   
   baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/
   
   gpgkey=http://yum.oracle.com/RPM-GPG-KEY-oracle-ol6
   
   gpgcheck=1
   
   enabled=1
   
   
   
   
   
   [ol6_UEK_latest]
   
   name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)
   
   baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/
   
   gpgkey=http://yum.oracle.com/RPM-GPG-KEY-oracle-ol6
   
   gpgcheck=1
   
   enabled=1
   

   Because the target system is running Oracle Linux Release 6 Update 4 for x86_64, which installs the Oracle Unbreakable Enterprise Kernel by default, there are two repositories to enable, [ol6_latest] and [ol6_UEK_latest].

3. Next, install the oracle-rdbms-server-11gR2-preinstall RPM using the yum install command. If you are using Oracle Database 12c, then you would type yum install.The output in Listing 1 shows how the installation checks dependencies and then downloads and installs the required packages.

   # yum install oracle-rdbms-server-11gR2-preinstall 

   # yum install oracle-rdbms-server-12cR2-preinstall

# groupadd dba
# groupadd oinstall
# useradd -m -g oinstall -G dba oracle

# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app
# chmod -R 775 /u01/app

sftp oracle 11 zipped files or USB

unzip files-01.zip
unzip files-02.zip

Moba Xterm

https://mobaxterm.mobatek.net/download-home-edition.html

https://download.mobatek.net/1112019010310554/MobaXterm_Portable_v11.1.zip

$ssh -XY oracle@

Refresh/restart icfonfig

#/etc/i,initd/network restart

#ifconfig

Root:
1. disable firewall
#vi /etc/selinux/config
SELINUX=disabled
#serice iptables stop
#service network restart

2. 11g.sh

export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export PATH=/usr/bin:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib64
export CLASSPATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib

mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/11.2.0/db_1

#vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 4194304 4194304 4194304

# /sbin/sysctl -p
# /sbin/sysctl -a