[Oracle 11 G] Install Oracle 11G
install #oracle di #igosnusantara
Ekstrak file oracle :
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
tentukan parameter kernel
sudo nano /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
menambahkan parameter limit pada /etc/security/limits.conf
#oracle limits
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
agar konfigurasi lebih mudah hapus firewall
sudo yum -y remove firewalld
#note : hanya untuk belajar.
Set SELinux /etc/selinux/config
SELINUX=permissive
Install software-software development tools
sudo yum groupinstall “Development Tools”
diantaranya :
Group-Id: development-tools
Description: These tools include general development tools such as git and cvs.
Mandatory Packages:
gettext
Default Packages:
=cvs
=diffstat
=doxygen
git
=patchutils
=rcs
=subversion
=systemtap
Optional Packages:
-archmage
-buildbot
-bzr
-bzr-explorer
-colordiff
-cvs2cl
-cvsgraph
-cvsps
-darcs
-dejagnu
-expect
-gambas3-ide
-giggle
-git-annex
-git-cola
-git2cl
-gitg
-gtranslator
-highlight
-lcov
-manedit
meld
-mercurial
-monotone
-mr
-nemiver
-qgit
-quilt
-rapidsvn
-robodoc
-scanmem
-svn2cl
-tailor
-tig
-tkcvs
-tortoisehg
-translate-toolkit
-utrac
Install sistem tools :
sudo yum groupinstall “System Tools”
Loaded plugins: priorities
Group: System Tools
Group-Id: system-tools
Description: This group is a collection of various tools for the system, such as the client for connecting to SMB shares and tools to monitor network traffic.
Default Packages:
=BackupPC
NetworkManager-l2tp
NetworkManager-openconnect
NetworkManager-openvpn
NetworkManager-vpnc
=bonnie++
chrony
=cifs-utils
=jigdo
libreswan
nmap
ntfs-3g
openconnect
=openldap-clients
openvpn
samba-client
screen
=setserial
tigervnc
vpnc
=xdelta
yum-utils
=zisofs-tools
zsh
Optional Packages:
-PackageKit-command-not-found
-aide
-aircrack-ng
-airsnort
-am-utils
-amanda-client
-apcupsd
-apcupsd-gui
-apg
-apt
-arc
-arj
-arptables_jf
-arpwatch
autofs
-avahi-tools
-bochs
cabextract
-catfish
-cfengine
-chrpath
-conman
-connect-proxy
-convmv
-crack
-crash
createrepo
-dar
-ddclient
-denyhosts
dkms
-dnrd
-dstat
-dtach
ebtables
-ed2k_hash
-eiciel
-emelfm2
enca
-environment-modules
-epylog
-etherbat
-ettercap
-fatsort
-fdupes
-fedora-package-config-apt
-fedora-package-config-smart
-festival
-foremost
-freeze
fuse
-fwbuilder
-fwknop
-fwrestart
-ganglia
geoclue
-ghasher
-ghex
-gigolo
-gkrellm
-gnokii
-gnutls-utils
-greadelf
-grepmail
-grsync
gssdp
-gtkhash
-gtkterm
gupnp
-gxemul
-hercules
hfsplus-tools
htop
-hyperestraier
-ibmonitor
-iftop
-inadyn-mt
-incron
-iotop
-ip6sic
-ipsec-tools
-ircp-tray
-isic
-jfbterm
-john
-kdirstat
-keychain
-ksmarttray
-limph
-lirc
-liveusb-creator
-lzop
-macchanger
mc
-mmv
-mrtg
-mtx
-munin
-nagios
-net-snmp-utils
-netgo
-nethogs
-netstat-nat
-nfswatch
-nmap-frontend
-noip
-nomarch
-nrg2iso
ntp
-ntp-perl
ntpdate
-nut
-nx
-obexfs
-obexftp
-oddjob
-oddjob-mkhomedir
-p0f
p7zip
-p7zip-plugins
-par2cmdline
pbzip2
-portecle
-powerman
powertop
-prelude-manager
-procinfo
-puppet
-pwgen
-qdbm
-qstat
-radeontool
rdesktop
-rdiff-backup
-rear
-remmina
-remmina-plugins-nx
-remmina-plugins-rdp
-remmina-plugins-telepathy
-remmina-plugins-xdmcp
-reptyr
-rmanage
-rootsh
-rsnapshot
-sabayon
-scrub
-sec
-shorewall
-smart
-smart-gui
socat
-stripesnoop
-swaks
-swatch
-synaptic
-syslog-ng
-sysstat
-testdisk
-tiobench
-tn5250
-torque-client
-torque-gui
-ttywatch
-tunctl
-unison213
-unison227
-upx
-uucp
-vnstat
-w_scan
wine
-wireshark-gnome
-wlassistant
-x3270-x11
-xmobar
-xsel
-xsupplicant
-zidrav
Lalu install tools untuk builder
#yum install binutils
#yum install compat-libstdc++-33
#yum install compat-libstdc++-33.i686
#yum install elfutils-libelf
#yum install elfutils-libelf-devel
#yum install gcc
#yum install gcc-c++
#yum install glibc
#yum install glibc.i686
#yum install glibc-common
#yum install glibc-devel
#yum install glibc-headers
#yum install glibc-devel.i686
#yum install zsh
#yum install libaio
#yum install libaio.i686
#yum install libaio-devel
#yum install libaio-devel.i686
#yum install libgcc
#yum install libgcc.i686
#yum install libstdc++
#yum install libstdc++.i686
#yum install libstdc++-devel
#yum install make
#yum install numactl
#yum install numactl-devel
#yum install sysstat
#yum install unixODBC
#yum install unixODBC.i686
#yum install unixODBC-devel
#yum install unixODBC-devel.i686
membuat user dan group oracle
#groupadd oinstall
#groupadd dba
#useradd -g oinstall -G dba oracle
#passwd oracle
user oracle jadikan sudoers:
sudo nano /etc/sudoers
tambahkan
oracle ALL=(ALL) ALL
Sistem akan ditanamkan di /opt maka
membuat direktori :
sudo mkdir -p /opt/oracle/product/11.2.0/db_1
Mengubah owner :
sudo chown -R oracle:oinstall /opt/oracle
Mengubah akses :
sudo chmod -R 775 /opt/oracle
non-aktifkan host
xhost +
[1]Melihat hostname
hostname
output : igosnusantara
membuat environment path untuk oracle pada shell. jika menggunakan zsh maka file konfigurasi ~/.zshrc jika bash ~/.bashrc
sebelumnya login pada user oracle :
su oracle
lihat shell :
echo $SHELL
jika bash
nano ~/.bashrc
jika zsh
nano ~/.zshrc
lalu isi file dibawah ini pada .bashrc/.zshrc
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=igosnusantara; export ORACLE_HOSTNAME
ORACLE_UNQNAME=basedata; export ORACLE_UNQNAME
ORACLE_BASE=/opt/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=basedata; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
##=====================================================
ORACLE_HOSTNAME, didapat pada [1]
ORACLE_UNQNAME, nama database
ORACLE_BASE, basis direktori oracle
ORACLE_HOME, beranda direktori oracle
masuk pada folder oracle yang sudah di ekstrak dan jalankan untuk instalasi :
./runInstaller
proses instalasi :
[a]Installation option
hapus ceklis pada ‘I wish to recieve security update via my Oracle suport’
lalu next
[b]Grid options
pilih opsi : install database software only
lalu next
[c]install type
pilih opsi : single instance database installation
lalu next
[d]Product language
pilih bahasa inggris atau bahasa indonesia
tekan next
[e]database edition
pilih enterprise edition
tekan next
[f]installation location
base : /opt/oracle
home : /opt/oracle/product/11.2.0/db_1
[g]create inventory
sudo mkdir -p /opt/oraInventory
sudo chown oracle:oinstall -R /opt/oraInventory
inventory direktori : /opt/oraInventory
orainventory group : oinstall
[h]operating system group
OSDBA(Database Administrator Group) : dba
OSOPER(Database Operator) : dba
[i]prerequisite Checks
ceklis : ignore all
next
[j]summary
tekan button finish
[k]install product
dalam proses instalasi ini terdapat error 2 kali. ketentuan abaikan lanjutkan atau solving trouble dengan membaca log.
salah satunya adalah ins_emagent.mk
solving :
ganti:
$(SYSMANBIN)emdctl: $(MK_EMAGENT_NMECTL)
dengan:
$(SYSMANBIN)emdctl: $(MK_EMAGENT_NMECTL) -lnnz11
pada opsi execute root scipt jalankan :
sudo sh /opt/oraInventory/orainstRoot.sh
sudo sh $ORACLE_HOME/oot.sh
[l]finish