Oracle Database 11g Mwepụta 2 na RHEL/CentOS 6.x/5.x/4.x

Dị ka anyị niile si mara Oracle database bụ nke kacha ewu ewu na nke a na-ejikarị Relational Database Management System (RDBMS) n'ụwa niile. Nke a post na-akọwa nzọụkwụ site nzọụkwụ ntinye nke Oracle Database 11g Hapụ 2 32bit na CentOS 6.4 32bit. Usoro nrụnye ekwesịghị ịdị iche n'ọtụtụ nkesa Linux Red Hat dabere.

Ịwụnye Oracle Database 11g Mwepụta 2

Anyị na-eji ngwungwu “oracle-rdbms-server-11gR2-preinstall” nke “Oracle Public Yum” na-eweta. Ebe nchekwa yum ọha Oracle na-enye ụzọ efu na nke kachasị mfe iji wụnye ihe ndabere Linux Oracle kacha ọhụrụ na-akpaghị aka. Iji hazie ebe nchekwa yum, soro ntuziaka enyere n'okpuru.

Jiri iwu “wget” budata faịlụ nhazi yum kwesịrị ekwesị n'okpuru /etc/yum.repos.d/ directory dị ka onye ọrụ mgbọrọgwụ.

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

Ugbu a, mee iwu na-esonụ \yum ka ịwụnye ihe niile dị mkpa na-akpaghị aka.

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

Mgbe ị na-ebubata igodo GPG, ị nwere ike nweta mperi iweghachite igodo GPG dara dịka egosiri n'okpuru. N'ebe a, ịkwesịrị ibubata igodo GPG kwesịrị ekwesị maka mwepụta OS gị.

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Budata wee nyochaa igodo Oracle Linux GPG dabara nke ọma dabara na ntọhapụ OS RHEL/CentOS gị dakọtara.

# wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
# wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
# wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-el4 -O /usr/share/rhn/RPM-GPG-KEY-oracle

Mepee faịlụ ''/etc/sysconfig/network'' wee gbanwee HOSTNAME ka ọ dabara aha nnabata FQDN (Fully Qualified Domain Name) gị.

 vi /etc/sysconfig/network
HOSTNAME=oracle.linux-console.net

Mepee faịlụ “/etc/hosts” ma tinye aha nnabata tozuru oke maka sava ahụ.

 vi /etc/hosts
192.168.246.128		oracle.linux-console.net		oracle

Ugbu a ịkwesịrị ịmalitegharịa ịkparịta ụka n'Ịntanet na ihe nkesa ahụ iji jide n'aka na mgbanwe ga-adịgide adịgide na reboot.

 /etc/init.d/network restart

Tọọ paswọọdụ maka onye ọrụ oracle.

 passwd oracle

Changing password for user oracle.
New password:
BAD PASSWORD: it is based on a dictionary word
Retype new password:
passwd: all authentication tokens updated successfully.

Tinye ntinye na faịlụ /etc/security/limit.d/90-nproc.conf dị ka akọwara n'okpuru.

 vi /etc/security/limits.d/90-nproc.conf
# Default limit for number of user's processes to prevent
# accidental fork bombs.
# See rhbz #432903 for reasoning.

*          soft    nproc     1024
# To this
* - nproc 16384

Tọọ SELinux ka ọ bụrụ ọnọdụ “nwere ikike” site na dezie faịlụ “/etc/selinux/config“.

 vi /etc/selinux/config
SELINUX=permissive

Ozugbo ịmechara mgbanwe, emela ka ịmalitegharịa ihe nkesa ahụ iji gosipụta mgbanwe ọhụrụ.

 reboot

Banye dị ka onye ọrụ Oracle wee mepee faịlụ .bash_profile, nke dị na ndekọ ụlọ onye ọrụ oracle, tinye ndenye dịka akọwara n'okpuru. Gbaa mbọ hụ na ịtọọ aha nnabata ziri ezi na ORACLE_HOSTNAME=oracle.linux-console.net.

 su oracle
[[email  ~]$ vi .bash_profile
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=oracle.linux-console.net; 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/dbhome_1; export ORACLE_HOME
ORACLE_SID=DB11G; 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 export PATH

Gbanwee na onye ọrụ mgbọrọgwụ wee nye iwu na-esonụ ka onye ọrụ Oracle nweta X Server.

 xhost +

Mepụta akwụkwọ ndekọ aha ma tọọ ikike kwesịrị ekwesị nke a ga-etinye ngwanrọ Oracle.

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

Debanye aha wee budata ngwanrọ Oracle site na iji njikọ a.

  1. Oracle Database 11g Mwepụta 2

Ngwungwu Oracle nwere faịlụ zip 2 nke ị ga-ebu ụzọ nabata nkwekọrịta ikike tupu nbudata. Enyere m aha faịlụ ndị ahụ maka ntụnyere gị, biko budata faịlụ ndị a maka nhazi sistemụ gị ebe n'okpuru /home/oracle/.

http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip

Ugbu a ka anyị bido nwụnye Oracle. Nke mbụ ịkwesịrị ịgbanwe dị ka onye ọrụ 'oracle' iji wụnye nchekwa data.

[[email  ~]$ su oracle

Wepụ faịlụ isi iyi nchekwa data Oracle abịakọrọ n'otu akwụkwọ ndekọ aha /home/oracle/.

[[email  ~]$ unzip linux_11gR2_database_1of2.zip

[[email  ~]$ unzip linux_11gR2_database_2of2.zip

Bipute faịlụ isi mmalite, akwụkwọ ndekọ aha a na-akpọ nchekwa data ga-emepụta, banye n'ime ndekọ ma mebie n'okpuru edemede ka ịmalite usoro ntinye data Oracle.

[[email  database]$ cd database

 wget ftp://rpmfind.net/linux/redhat-archive/6.2/en/os/i386/RedHat/RPMS/pdksh-5.2.14-2.i386.rpm

N'oge nrụnye ngwungwu pdksh ị nwere ike ịhụ njehie esemokwu nke ngwugwu ksh. Wepu ngwugwu ksh ike wee wụnye ngwugwu pdksh nke enyere iwu n'okpuru: -

 rpm -e ksh-20100621-19.el6_4.4.i686 --nodeps
 rpm -ivh pdksh-5.2.14-2.i386.rpm

11. Na-eme ndenye ego achọrọ: Ọ na-anwale ma ohere SWAP zuru oke dị na sistemụ.

12. Nchịkọta nwụnye: Pịa na Chekwa faịlụ nzaghachi. Faịlụ a bara uru maka Nwụnye ọnọdụ Silent Oracle

13. Chekwa faịlụ nzaghachi ebe na sistemụ gị.

14. Ọganihu nwụnye ngwaahịa

15. Iṅomi faịlụ nchekwa data

16. Pịa na Password Management.

17. Tọọ paswọọdụ maka onye ọrụ SYS wee pịa OK ka ịga n'ihu.

18. Ekwesịrị igbu ederede nhazi dịka onye ọrụ mgbọrọgwụ. Gaa na ụzọ enyere na ihuenyo wee mebie scripts otu otu. Pịa 'OK' ozugbo emechara scripts.

 cd /u01/app/oraInventory
 ./orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
 cd /u01/app/oracle/product/11.2.0/dbhome_2/
 ./root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/dbhome_2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

19. Ntinye nke Oracle Database na-aga nke ọma.

20. Iji nwalee gị Oracle nrụnye gaa na web based management interface maka sistemụ gị na \localhost na aha njirimara \SYS na-ejikọta dị ka \SYSDBA na iji paswọọdụ ị debere n'oge ịwụnye Oracle. Cheta imeghe. ọdụ ụgbọ mmiri 1158 na firewall gị wee malitegharịa ọrụ iptables.

 iptables -A INPUT -p tcp --dport 1158 -j ACCEPT
 service iptables restart
https://localhost:1158/em/

21. Oracle Enterprise Database Control Manager

Ugbu a ị nwere ike ịmalite iji Oracle. Ana m akwado gị ka ị soro mmemme Oracle SQL Developer UI.

Nke a bụ njedebe nke Nwụnye Software Database Oracle. N'ime edemede anyị na-abịa, anyị ga-ekpuchi otu esi emepụta nchekwa data site na iji DBCA yana otu esi amalite na mechie Oracle database. Biko nọrọ na nche…!!!