Oracle Database 11g Sakin 2 Shigarwa akan RHEL/CentOS 6.x/5.x/4.x

Kamar yadda muka sani Oracle Database shine mafi shahara kuma ana amfani dashi sosai Relational Database Management System (RDBMS) a duniya. Wannan sakon yana bayyana mataki-mataki shigarwa na Oracle Database 11g Sakin 2 32bit akan CentOS 6.4 32bit. Matakan shigarwa bai kamata su bambanta akan yawancin rarrabawar Linux na Red Hat ba.

Sanya Oracle Database 11g Sakin 2

Muna amfani da fakitin “oracle-rdbms-server-11gR2-preinstall” wanda maajiyar “Oracle Public Yum” ke bayarwa. Ma'ajiyar yum ta jama'a ta Oracle tana ba da hanya mafi sauƙi kuma mafi sauƙi don shigar da duk sabbin abubuwan dogaro na Oracle Linux ta atomatik. Don saita ma'ajiyar yum, bi umarnin da aka bayar a ƙasa.

Yi amfani da umarnin wget don Zazzage fayil ɗin sanyin yum mai dacewa a ƙarƙashin /etc/yum.repos.d/ directory azaman mai amfani.

# 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

Yanzu yi umarnin \yum mai zuwa don shigar da duk abubuwan da ake buƙata ta atomatik.

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

Yayin shigo da maɓallin GPG, zaku iya samun kuskuren dawo da maɓalli na GPG kamar yadda aka nuna a ƙasa. Anan, kuna buƙatar shigo da maɓallin GPG mai dacewa don sakin OS ɗin ku.

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

Zazzage kuma tabbatar da Maɓallin GPG na Oracle Linux mai dacewa wanda ya dace da sakin OS ɗin ku na RHEL/CentOS.

# 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

Bude fayil ɗin /etc/sysconfig/network kuma canza HOSTNAME don dacewa da sunan mai masaukin ku FQDN (Cikakken Sunan Domain Name).

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

Bude fayil/sauransu/hosts kuma ƙara cikakken sunan mai masauki don uwar garken.

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

Yanzu kana buƙatar sake farawa sadarwar kan uwar garke don tabbatar da cewa canje-canje za su dawwama a sake yi.

 /etc/init.d/network restart

Saita kalmar sirri don mai amfani da 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.

Ƙara shigarwar zuwa fayil /etc/security/limits.d/90-nproc.conf kamar yadda aka bayyana a ƙasa.

 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

Saita SELinux zuwa yanayin mai izini ta hanyar gyara fayil ɗin /etc/selinux/config.

 vi /etc/selinux/config
SELINUX=permissive

Da zarar kun yi canji, kar a ƙirƙira don sake kunna sabar don nuna sabbin canje-canje.

 reboot

Shiga azaman mai amfani da Oracle kuma buɗe fayil .bash_profile, wanda ke samuwa akan kundin adireshin gidan mai amfani na Oracle, yi shigarwa kamar yadda aka bayyana a ƙasa. Tabbatar kun saita daidai sunan mai masauki zuwa 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

Canja zuwa tushen mai amfani kuma ba da umarni mai zuwa don bawa mai amfani Oracle damar samun dama ga uwar garken X.

 xhost +

Ƙirƙiri kundayen adireshi kuma saita izini masu dacewa waɗanda za a shigar da software na Oracle a ciki.

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

Yi rajista kuma zazzage software na Oracle ta amfani da hanyar haɗi mai zuwa.

  1. Oracle Database 11g Sakin 2

Kunshin Oracle ya ƙunshi fayilolin zip guda 2 waɗanda dole ne ku fara karɓar yarjejeniyar lasisi kafin zazzagewa. Na ba ku sunayen fayilolin da kuke tunani, da fatan za a sauke waɗannan fayilolin don tsarin gine-ginen ku a wani wuri a ƙarƙashin /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

Yanzu bari mu fara shigarwa na Oracle. Da farko kuna buƙatar canzawa azaman mai amfani da 'oracle' don shigar da bayanai.

[[email  ~]$ su oracle

Cire fayilolin tushen tushen bayanan Oracle da aka matsa zuwa wannan kundin adireshi /gida/oracle/.

[[email  ~]$ unzip linux_11gR2_database_1of2.zip

[[email  ~]$ unzip linux_11gR2_database_2of2.zip

Buga fayil ɗin tushen buɗewa, za a ƙirƙiri kundin adireshi da ake kira bayanan bayanai, je zuwa cikin kundin adireshi kuma aiwatar da rubutun ƙasa don fara aikin shigar da bayanai na 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

Yayin shigar da kunshin pdksh kuna iya fuskantar kuskuren rikici na kunshin ksh. Cire fakitin ksh da ƙarfi kuma shigar da kunshin pdksh tare da umarnin da ke ƙasa: -

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

11. Yin rajistan abubuwan da ake buƙata: Yana gwada ko isassun sararin SWAP yana samuwa akan tsarin.

12. Ƙimar Shigarwa: Danna Ajiye Fayil na Amsa. Wannan fayil ɗin yana da amfani ga Shirya Yanayin Silent Oracle

13. Ajiye Fayil na Amsa wani wuri a cikin tsarin ku.

14. Ci gaban Shigar Samfur

15. Kwafi fayilolin bayanai

16. Danna kan Password Management.

17. Saita kalmar sirri don mai amfani SYS kuma danna Ok don ci gaba.

18. Ana buƙatar aiwatar da rubutun tsarin aiki azaman mai amfani da “tushen”. Jeka hanyar da aka bayar a allon kuma aiwatar da rubutun daya bayan daya. Danna 'Ok' da zarar an aiwatar da rubutun.

 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. An yi nasarar shigar da Oracle Database.

20. Don gwada shigarwar Oracle ɗin ku kewaya zuwa tsarin gudanarwar gidan yanar gizo don tsarin ku a \localhost tare da sunan mai amfani \SYS yana haɗawa azaman \SYSDBA da amfani da kalmar sirri da kuka saita yayin shigar da Oracle. Ka tuna budewa. tashar jiragen ruwa 1158 akan Tacewar zaɓi kuma sake kunna sabis na iptables.

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

21. Oracle Enterprise Database Control Manager

Yanzu zaku iya fara amfani da Oracle. Ina ba ku shawara sosai da ku bi shirin Oracle SQL Developer UI.

Wannan shine ƙarshen shigarwar Software na Database na Oracle. A cikin labarinmu mai zuwa za mu rufe yadda ake ƙirƙira ma'ajin bayanai ta amfani da DBCA da yadda ake Farawa da Rufe Bayanan Oracle. Da fatan za a kasance tare…!!!