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.