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