Step by Step Cara Instalasi Database Oracle 10g atau 11g di Linux Red Hat atau Fedora

ORACLE INSTALLATION 11gR2 ON FEDORA :
=====================================

 

Guidance ini juga bisa digunakan untuk instalasi Oracle 10g atau 11g di Operating Sistem Linux Redhat, Fedora, Centos, Mandriva
1. Ekstrak file Oracle

unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
2. Rubah File /etc/hosts

<IP-address> <fully-qualified-machine-name> <machine-name>
3. /sbin/sysctl -a

Rubah di = “/etc/sysctl.conf”

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586

Eksekusi = /sbin/sysctl -p
4. Tambahkan isi di = “/etc/security/limits.conf” file

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
5. Tambahkan di = “/etc/pam.d/login”

session required pam_limits.so
6. Matikan Firewall = (System > Administration > Firewall). Click the “Disable”
atau :
# /sbin/service iptables save
# /sbin/service iptables stop
7. Disable Secure Linux di = “/etc/selinux/config”

SELINUX=disabled
8. Pastikan semua Paket yang perlu di-Install sudah terinstall dengan baik = (terutama compiler)

Jika ingin melakukan yum install melalui Local Repository agar mempermudah instalasi, maka lakukan ini :
# mount /dev/cdrom1 /mnt/ (Here cdrom1 is my local cdrom device)
# cd /mnt/Packages
# rpm -ivh createrepo-0.9.8-5.el6.noarch.rpm
# mkdir -p /opt/localyumserver
# cp -ar *.* /opt/localyumserver
# vim /etc/yum.repos.d/localyumserver.repo
[localyumserver]
name=”Local Yum Server”
baseurl=file:///opt/localyumserver
gpgcheck=0
enabled=1
# createrepo -v /var/ftp/pub/localyumserver
# yum clean all
# yum update

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-devel.i686
yum install glibc-headers
yum install ksh
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-devel
yum install sysstat
yum install unixODBC
yum install unixODBC.i686
yum install unixODBC-devel
yum install unixODBC-devel.i686
yum install libXp
yum install libXp-devel
9. Tambah Group dan User =

groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin

useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle
10. Buat Direktori untuk Oracle =

mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
11. Login sebagai Root, jalankan ini =

xhost +<machine-name>
12. Edit file “/etc/redhat-release”

# cp /etc/redhat-release /etc/redhat-release.original

Ganti isinya menjadi = redhat release 5
13. Login sebagai Oracle, buka file “.bash_profile”

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

ORACLE_HOSTNAME=fedora14.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; 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

if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

14. Lakukan Instalasi =

Agar X bisa jalan, maka lakukan ini :
a. sebagai normal user lakukan perintah $ xhost + agar semua orang bisa connect ke local display
b. menjadi root using su –
c. lakukan perintah # export DISPLAY=:0.0
d. jalankan program xclock untuk verifikasi

15. ./runInstaller

16. Selesai Instalasi, lakukan =

Kembalikan isi File “/etc/redhat-release”

17. Edit file = “/etc/oratab”
Rubah menjadi : DB11G:/u01/app/oracle/product/11.2.0/db_1:Y

Jika service Oracle mati, maka lakukan perintah ini untuk menaikkan secar manual :
18. $ emctl start dbconsole
19. $ sqlplus /nolog ; conn / as sysdba ; startup
20. $ lsnrctl start

Buka browser anda dan koneksi ke Enterprise Manager di http://localhost:1158/em

Configure a Wi-Fi router to share your computer’s 3G data stick connection

How to configure a Wi-Fi router to share your computer’s 3G data stick connection to everyone.

  1. Connect to the Internet on your 3G data stick.
  2. Plug your laptop to one of the router’s LAN ports. Wait until the router connects correctly.
  3. Click Start > Control Panel > View Network status and tasks > Change adapter settings
  4. Right click the modem (or the connection where you get Internet from) > Status > Details. Write down the “IPv4 DNS Servers” on a piece of paper. Click Close once.
  5. Right click the Local Area Network > Status > Details. Write down the “IPv4 Default Gateway”. Click Close > Close.
  6. Open the browser and type the IPv4 Default Gateway on the addressbar. Routers are all different so you need to figure out where to find and configure the following:
    • Review your wireless security settings. What is your SSID? What is your security key? Write this down.
    • Under WAN, choose “Static IP” instead of “PPPoE” or “Automatic – DHCP”.
    • Under WAN, set the WAN IP to 192.168.137.2
    • Under WAN, set the Netmask to 255.255.255.0
    • Under WAN, set the Gateway to 192.168.137.1
    • Under WAN, set the DNS Server(s) to the “IPv4 DNS Servers” you got from step 4.
    • Click Save.
  7. Unplug your laptop from the router’s LAN port and plug it to the WAN port. Wait until the router connects correctly.
  8. Go back to the “Network connection” screen on Step 4 > Properties > Sharing >
    • Check “Allow other network users to connect through this computer’s Internet connection.”
    • Under Home networking connection choose “Local Area Connection”
    • Click OK then OK.
  9. Right click the Local Area Network > Status > Details. Is the IPv4 address “192.168.137.1”? If yes, then you’re done! Tell everyone to connect to the wireless router and they will be online.

NOTE: There’s a router-less method using “ad-hoc networks”, but using a router provides more range and can handle more connected computers or wifi phones.


To put things back to before.

  1. Uncheck the “Allow other network users to connect through this computer’s Internet connection.” on Step 7. Click OK.
  2. Unplug the laptop from the router’s WAN port and plug it into one of its LAN ports.
  3. Open a browser and visit the “IPv4 Default Gateway” address you got from Step 5.
  4. Switch the WAN setting from “Fixed IP” back to “Automatic – DHCP”. Save changes.
  5. You’re done!

Only one more thing: Sometimes, after the configuration, it is necessary to restart your modem, computer and router. In one situation, I connected them in this way. Modem ? My Computer ? Router ? all other devices (like laptop, network printer, other computer).

 

Source : http://superuser.com/questions/241651/setting-up-wifi-router-as-a-switch-for-internet-connection-sharing