Oracle Linux uzerinde Oracle 11g database (11.2.0.3.0 ) qurulmasi


Ilk once yukleyeceyimiz DB leri oz localimiza endiririk.

# 11.2.0.1

unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip

#11.2.0.2

unzip p10098816_112020_Linux-x86-64_1of7.zip
unzip p10098816_112020_Linux-x86-64_2of7.zip

#11.2.0.3

unzip p10404530_112030_Linux-x86-64_1of7.zip
unzip p10404530_112030_Linux-x86-64_2of7.zip

Linux uzerinde Oracle_krulum deye bir folder olushdururuq  ve lazim olan Oracle .zip fayli ora kopyalyiriq.

[oracle@bakudcsprddb database]$ mkdir oracle_krulum/
[oracle@bakudcsprddb database]$ cd /
[oracle@bakudcsprddb /]$ cd oracle_kurulum/
[oracle@bakudcsprddb oracle_kur]$ pwd
/oracle_kurulum
[oracle@bakudcsprddb oracle_kur]$ ls -latr
total 2442064
drwxr-xr-x.  8 root root       4096 Sep 22  2011 database
-rw-r--r--.  1 root root 1142195302 Jan 24 14:00 p10404530_112030_Linux-x86-64_2of7.zip
-rw-r--r--.  1 root root 1358454646 Jan 24 14:09 p10404530_112030_Linux-x86-64_1of7.zip
drwxr-xr-x.  3 root root       4096 Apr 15 14:20 .
dr-xr-xr-x. 29 root root       4096 Apr 16 09:20 ..

etc/hosts icherisine oz makinemizin hos adini ve ip sini yaziriq

[oracle@bakudcsprddb ~]$ cd /
[oracle@bakudcsprddb /]$ cd etc/
[oracle@bakudcsprddb etc]$ cat hosts
172.30.5.81     bakudcsprddb.kfsaz.local        bakudcsprddb    # Added by NetworkManager
127.0.0.1       localhost.localdomain   localhost
::1     bakudcsprddb.kfsaz.local        bakudcsprddb    localhost6.localdomain6 localhost6

/etc/sysctl.conf icherisinie ashagdaki parametreleri elave edirik:

# Disable netfilter on bridges.
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0
uid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
kernel.shmmax = 4294967295

sysctl -e –p emrini yerine yetiririk ki Linux server restart oldugu zaman deyishikliyi yaddashinda saxlasin.

/etc/security/limits.conf  icherisinde ashagdaki parametreleri elave edirik.

#@student        -       maxlogins       4
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240
# End of file

Iso fayli mount edib ashagdaki komandani icra edirik.

mount -t iso9660 -o ro /dev/cdrom /media

cd media/Packages giririk ve ashadak packageleri root useri ile chalishdiririq.

rpm -Uvh binutils-2*x86_64*
rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686*
rpm -Uvh compat-libstdc++-33*x86_64*
rpm -Uvh glibc-common-2*x86_64*
rpm -Uvh glibc-devel-2*x86_64*
rpm -Uvh glibc-devel-2*i686*
rpm -Uvh glibc-headers-2*x86_64*
rpm -Uvh elfutils-libelf-0*x86_64*
rpm -Uvh elfutils-libelf-devel-0*x86_64*
rpm -Uvh gcc-4*x86_64*
rpm -Uvh gcc-c++-4*x86_64*
rpm -Uvh ksh-*x86_64*
rpm -Uvh libaio-0*x86_64*
rpm -Uvh libaio-devel-0*x86_64*
rpm -Uvh libaio-0*i686*
rpm -Uvh libaio-devel-0*i686*
rpm -Uvh libgcc-4*x86_64*
rpm -Uvh libgcc-4*i686*
rpm -Uvh libstdc++-4*x86_64*
rpm -Uvh libstdc++-4*i686*
rpm -Uvh libstdc++-devel-4*x86_64*
rpm -Uvh make-3.81*x86_64*
rpm -Uvh numactl-devel-2*x86_64*
rpm -Uvh sysstat-9*x86_64*
rpm -Uvh compat-libstdc++-33*i686*
rpm -Uvh compat-libcap*

Grouplari olushdurmaga bashlayiriq.

groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 asmadmin
groupadd -g 506 asmdba
groupadd -g 505 asmoper
useradd -u 502 -g oinstall -G dba,asmdba,oper oracle
passwd oracle

/etc/selinux/config icherisinde olan SELINUX parametresini disabled edirik :

SELINUX=disabled

Sonra Oracle nin inistall olunacaq location yaradiriq:

mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

Oracle useri ile “.bash_profile” dosyasina icherisine ashagdakilari elave edirik

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=bakudcsprddb.kfsaz.local; export ORACLE_HOSTNAME
ORACLE_UNQNAME=TESTDENEME; 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=TESTDENEME; export ORACLE_SID
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/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Deyishikliyi icra edib yadda saxlamasi uchun  ashagdaki komandani icra edirik:

$. .bash_profile

Belelikle sonda Xmanager ile database ni inistal etmeye bashlayirq (grafik ara uzunden).

Oracle grafik ara yuzunde inistall etmek addimlarini ise  https://anargodjaev.wordpress.com/2013/10/24/oracle-database-11gr2-installation/ linkden baxa bilersiniz.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: