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.
- 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…!!!