Yadda ake Sanya Oracle Database 12c akan RHEL/CentOS 7
Bayanan bayanan Oracle shine ɗayan mafi yawan amfani da tsarin sarrafa bayanan bayanai (RDBMS) a cikin mahallin kasuwanci. Haɓaka, kiyayewa, da tallafi daga Oracle Corporation, ana shigar da wannan RDBMS akan ɗanɗano na Linux Enterprise (RHEL, CentOS, ko Linux Scientific). Wannan yana haifar da tsarin aiki mai ƙarfi sosai - zaɓin bayanai.
A cikin wannan labarin, zamuyi bayanin yadda ake shigar da Oracle 12c Sakin 2 akan sabar RHEL/CentOS 7 GUI.
Hankali: Masu amfani da RHEL/CentOS 6 na iya bin wannan jagorar don Sanya Oracle Database 12c akan RHEL/CentOS 6.x
Bari mu fara.
Bayan shigar da Oracle 12c, za a aiwatar da tsarin ta hanyar dubawar hoto. Wannan shine dalilin da ya sa muke buƙatar uwar garken CentOS 7 tare da shigar da rukunin software na Window System.
Ƙari ga haka, lura cewa ana buƙatar asusun Oracle don zazzage fayil ɗin shigarwa na Oracle Database 12c (3.2 GB). Kada ku damu da wannan, kodayake, saboda kuna iya ƙirƙirar asusun kyauta.
A ƙarshe, tabbatar da cewa uwar garken yana da aƙalla 2 GB na RAM da 30 GB na sararin diski. Waɗannan buƙatun kayan masarufi suna da aminci don yanayin gwaji kamar namu, amma za su buƙaci haɓaka idan kun yi la'akari da amfani da Oracle wajen samarwa.
Ana shirin Shigar Oracle 12c
1. Don farawa, tabbatar da cewa duk fakitin da aka shigar a halin yanzu akan tsarin RHEL/CentOS 7 an sabunta su zuwa sabbin nau'ikan su.
# yum update -y
2. Na gaba, shigar da duk abubuwan da ake buƙata don RDBMS, tare da fakitin zip da unzip.
# yum install -y binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64 glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64 libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64 zip unzip
3. Ƙirƙiri asusun mai amfani da ƙungiyoyi don Oracle.
# groupadd oinstall # groupadd dba # useradd -g oinstall -G dba oracle
A ƙarshe, saita kalmar sirri don sabon asusun Oracle da aka ƙirƙira.
# passwd oracle
4. Ƙara sigogin kwaya masu zuwa zuwa /etc/sysctl.conf fayil.
fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 8329226240 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586
kuma a yi amfani da su:
# sysctl -p # sysctl -a
5. Sanya iyakoki don oracle a cikin /etc/security/limits.conf file.
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
6. Ƙirƙiri kundin adireshi mai suna/mataki kuma cire fayil ɗin shigarwa na zipped.
# unzip linuxx64_12201_database.zip -d /stage/
Kafin a ci gaba, ƙirƙiri wasu kundayen adireshi waɗanda za a yi amfani da su yayin ainihin shigarwa, kuma sanya izini masu dacewa.
# mkdir /u01 # mkdir /u02 # chown -R oracle:oinstall /u01 # chown -R oracle:oinstall /u02 # chmod -R 775 /u01 # chmod -R 775 /u02 # chmod g+s /u01 # chmod g+s /u02
Yanzu muna shirye don gudanar da rubutun shigarwa.
7. Bude zaman GUI a cikin uwar garken RHEL/CentOS 7 kuma kaddamar da rubutun shigarwa.
/stage/database/runInstaller
kuma bi matakan da mai sakawa ya gabatar.
Shigar da Oracle 12c akan CentOS 7
8. Shigar da adireshin imel mai alaƙa da asusun Oracle (na zaɓi).
9. Zaɓi Ƙirƙiri kuma saita bayanan bayanai.
10. Zaɓi ajin Desktop tunda muna saita ƙaramin tsari da bayanan farawa.
11. Zaɓi waɗannan zaɓuɓɓuka don daidaitawa na asali.
- Oracle tushe: /u01/app/oracle
- Wurin software: /u01/app/oracle/product/12.2.0/dbhome_1
- Wurin fayil ɗin bayanai: /u01
- Kungiyar OSDBA: dba
- Sunan bayanai na duniya: zaɓinku. Mun zaɓi tecmint a nan.
- A lura da kalmar sirri, kamar yadda za ku yi amfani da shi lokacin da kuka fara haɗawa da ma'ajin bayanai.
- Cire alamar Ƙirƙiri azaman bayanan kwantena.
12. Bar tsoho na Inventory Directory as /u01/app/oraInventory.
13. Tabbatar cewa an kammala shigarwar pre-check ba tare da kurakurai ba.
Mai sakawa ba zai bar ku ku wuce wannan batu idan an sami wasu kurakurai.
14. Jira har sai Oracle 12c shigarwa ya kammala.
Yana yiwuwa a wani lokaci yayin shigarwa za a umarce ku da ku gudanar da rubutun biyu don saita ƙarin izini ko gyara batutuwa. An kwatanta wannan a nan:
Kuma a nan:
# cd /u01/app/oraInventory # ./orainstRoot.sh # cd /u01/app/oracle/product/12.2.0/dbhome_1 # ./root.sh
15. Bayan haka, kuna buƙatar komawa zuwa allon baya a cikin zaman GUI kuma danna Ok don ci gaba da shigarwa.
Lokacin da aka gama, za a gabatar muku da saƙo mai zuwa wanda ke nuna URL na Manajan Kasuwancin Oracle:
https://localhost:5500/em
Oracle 12c Ƙarshen Ƙarshe
16. Don ba da damar haɗi daga wajen uwar garken, kuna buƙatar buɗe tashoshin jiragen ruwa masu zuwa:
1521/TCP 5500/TCP 5520/TCP 3938/TCP
Mai bi:
# firewall-cmd --zone=public --add-port=1521/tcp --add-port=5500/tcp --add-port=5520/tcp --add-port=3938/tcp --permanent # firewall-cmd --reload
17. Bayan haka, shiga azaman oracle ta amfani da kalmar sirrin da aka zaɓa a baya sannan kuma ƙara layin da ke gaba zuwa .bash_profilefile.
TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1; export ORACLE_HOME ORACLE_SID=tecmint; export ORACLE_SID PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
18. A ƙarshe, maye gurbin localhost tare da 0.0.0.0 akan.
# vi $ORACLE_HOME/network/admin/listener.ora
19. Mataki na ƙarshe ya ƙunshi reloading .bash_profile don amfani da sabbin saitunan.
# source .bash_profile
20. Sannan ku shiga rumbun adana bayanai ta amfani da tsarin asusun da kalmar sirri da aka zaba a mataki na 11 na sashin da ya gabata.
# sqlplus [email
Da zaɓin, bari mu ƙirƙiri tebur a cikin bayanan tecmint inda za mu saka wasu bayanan samfurin kamar haka.
SQL> CREATE TABLE NamesTBL (id NUMBER GENERATED AS IDENTITY, name VARCHAR2(20));
Lura cewa an fara gabatar da ginshiƙan Identity a cikin Oracle 12c.
SQL> INSERT INTO NamesTBL (name) VALUES ('Gabriel'); SQL> INSERT INTO NamesTBL (name) VALUES ('Admin'); SQL> SELECT * FROM NamesTBL;
Bayar da Oracle don Farawa akan Tsarin Boot
21. Don ba da damar sabis na bayanai don farawa ta atomatik akan taya, ƙara waɗannan layin zuwa /etc/systemd/system/oracle-rdbms.service fayil.
# /etc/systemd/system/oracle-rdbms.service # Invoking Oracle scripts to start/shutdown Instances defined in /etc/oratab # and starts Listener [Unit] Description=Oracle Database(s) and Listener Requires=network.target [Service] Type=forking Restart=no ExecStart=/u01/app/oracle/product/12.2.0/dbhome_1/bin/dbstart /u01/app/oracle/product/12.2.0/dbhome_1 ExecStop=/u01/app/oracle/product/12.2.0/dbhome_1/bin/dbshut /u01/app/oracle/product/12.2.0/dbhome_1 User=oracle [Install] WantedBy=multi-user.target
22. A ƙarshe, muna buƙatar nuna cewa ya kamata a kawo bayanan tecmint a lokacin boot in /etc/oratab (Y: Ee).
A cikin wannan labarin, mun bayyana yadda ake shigar da Oracle 12c akan RHEL/CentOS 7, yadda ake ƙirƙira da daidaita ma'ajin bayanai, da yadda ake ƙirƙirar teburi da saka layuka na bayanai.
Bugu da ƙari, yana da mahimmanci a lura cewa uwar garken bayanan ya kamata ya tashi kuma yana aiki lokacin da tsarin ya fara aiki, kuma ya kamata a sami tsoffin bayanan mu a wannan lokacin.
Idan kuna da wasu tambayoyi ko sharhi game da wannan labarin, jin daɗin sauke mana layi ta amfani da fom ɗin da ke ƙasa.