Bii o ṣe le Fi sori ẹrọ Ibi ipamọ data 12c lori RHEL/CentOS 7
Ibi ipamọ data Oracle jẹ ọkan ninu awọn ọna ṣiṣe isọdọkan data ibatan ibatan ti o gbooro julọ ti a lo (RDBMS) ni awọn agbegbe ile-iṣẹ. Idagbasoke, muduro, ati atilẹyin nipasẹ Oracle Corporation, RDBMS yii ni igbagbogbo fi sori ẹrọ lori adun ti Idawọlẹ Idawọlẹ (RHEL, CentOS, tabi Linux Linux). Eyi ṣe fun ẹrọ ṣiṣe ti o lagbara pupọ - yiyan data.
Ninu àpilẹkọ yii, a yoo ṣalaye bi o ṣe le fi sori ẹrọ Oracle 12c Tu 2 lori olupin RHEL/CentOS 7 GUI.
Ifarabalẹ: Awọn olumulo RHEL/CentOS 6 le tẹle itọsọna yii lati Fi sori ẹrọ Oracle Database 12c lori RHEL/CentOS 6.x
Jẹ ki a bẹrẹ.
Lẹhin fifi Oracle 12c sori ẹrọ, iṣeto naa yoo ṣe nipasẹ wiwo ayaworan. Iyẹn ni idi ti a nilo olupin CentOS 7 pẹlu ẹgbẹ sọfitiwia X Window System ti fi sii.
Ni afikun, jọwọ ṣe akiyesi pe iroyin Oracle ni a nilo lati gba lati ayelujara faili fifi sori ẹrọ Oracle Database 12c (3.2 GB). Maṣe yọ ara rẹ lẹnu nipa eyi, botilẹjẹpe, bi o ṣe le ṣẹda iroyin fun ọfẹ.
Lakotan, rii daju pe olupin rẹ ni o kere ju 2 GB ti Ramu ati 30 GB ti aaye disk to wa. Awọn ibeere ohun elo wọnyi jẹ ailewu fun agbegbe idanwo bi tiwa, ṣugbọn yoo nilo lati pọ si ti o ba ronu lilo Iba-ọrọ ni iṣelọpọ.
Ngbaradi fun fifi sori 12c Ebora
1. Lati bẹrẹ, rii daju pe gbogbo awọn idii ti o fi sori ẹrọ lọwọlọwọ lori eto RHEL/CentOS 7 rẹ ti ni imudojuiwọn si awọn ẹya tuntun wọn.
# yum update -y
2. Itele, fi sori ẹrọ gbogbo awọn igbẹkẹle ti o nilo fun RDBMS, pẹlu zip ati ṣiṣi awọn idii.
# 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. Ṣẹda akọọlẹ olumulo ati awọn ẹgbẹ fun Oracle.
# groupadd oinstall # groupadd dba # useradd -g oinstall -G dba oracle
Lakotan, ṣeto ọrọ igbaniwọle kan fun akọọlẹ oracle tuntun ti a ṣẹda.
# passwd oracle
4. Ṣafikun awọn iṣiro ekuro wọnyi si faili /etc/sysctl.conf.
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
ki o lo wọn:
# sysctl -p # sysctl -a
5. Ṣeto awọn ifilelẹ lọ fun oracle ni faili /etc/security/limits.conf.
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
6. Ṣẹda itọsọna kan ti a npè ni/ipele ki o jade faili fifi sori ẹrọ zipped.
# unzip linuxx64_12201_database.zip -d /stage/
Ṣaaju ki o to tẹsiwaju, ṣẹda awọn ilana ilana miiran ti yoo ṣee lo lakoko fifi sori ẹrọ gangan, ati fi awọn igbanilaaye to ṣe pataki.
# 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
A ti ṣetan bayi lati ṣiṣe iwe fifi sori ẹrọ.
7. Ṣii igba GUI ninu olupin RHEL/CentOS 7 ki o ṣe ifilọlẹ iwe afọwọkọ sori ẹrọ.
/stage/database/runInstaller
ki o tẹle awọn igbesẹ ti o gbekalẹ nipasẹ oluṣeto.
Fifi Oracle 12c sori CentOS 7
8. Tẹ adirẹsi imeeli ti o ni nkan ṣe pẹlu iroyin Oracle rẹ (iyan).
9. Yan Ṣẹda ati tunto ibi ipamọ data kan.
10. Yan kilasi Ojú-iṣẹ niwon a ti n ṣeto iṣeto ti o kere ju ati ibi ipamọ data ibẹrẹ.
11. Yan awọn aṣayan atẹle fun iṣeto ipilẹ.
- Ipilẹ Oracle:/u01/app/oracle
- Ipo sọfitiwia: /u01/app/oracle/product/12.2.0/dbhome_1
- Ipo faili aaye data:/u01
- ẹgbẹ OSDBA: dba
- Orukọ ibi ipamọ data agbaye: yiyan rẹ. A yan tecmint nibi.
- Ṣe akiyesi ọrọ igbaniwọle, bi o ṣe le lo o nigbati o kọkọ sopọ si ibi ipamọ data.
- Ṣayẹwo Ṣẹda bi ibi ipamọ data apoti.
12. Fi Itọsọna Oja aiyipada silẹ bi/u01/app/oraInventory.
13. Daju pe awọn ayẹwo ṣaaju fifi sori ẹrọ ti pari laisi awọn aṣiṣe.
Olupese ko ni jẹ ki o kọja aaye yii ti o ba ri awọn aṣiṣe eyikeyi.
14. Duro titi ti fifi sori Oracle 12c pari.
O ṣee ṣe pe ni aaye kan lakoko fifi sori ẹrọ yoo beere lọwọ rẹ lati ṣiṣe awọn iwe afọwọkọ meji lati ṣeto awọn igbanilaaye siwaju sii tabi awọn ọran ti o tọ. Eyi jẹ apejuwe nibi:
Ati nihin:
# cd /u01/app/oraInventory # ./orainstRoot.sh # cd /u01/app/oracle/product/12.2.0/dbhome_1 # ./root.sh
15. Lẹhin eyi, iwọ yoo nilo lati pada si iboju ti tẹlẹ ni akoko GUI ki o tẹ O DARA ki fifi sori le tẹsiwaju.
Nigbati o ba pari, ao gbekalẹ rẹ pẹlu ifiranṣẹ atẹle ti o tọka URL ti Oluṣakoso Idawọlẹ Oracle:
https://localhost:5500/em
Awọn ifọwọkan Ipari Oracle 12c
16. Lati gba awọn asopọ laaye lati ita olupin, iwọ yoo nilo lati ṣii awọn ibudo wọnyi:
1521/TCP 5500/TCP 5520/TCP 3938/TCP
Ni atẹle:
# 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. Nigbamii, buwolu wọle bi oracle nipa lilo ọrọ igbaniwọle ti a yan tẹlẹ ki o ṣafikun awọn ila wọnyi si .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. Lakotan, rọpo localhost pẹlu 0.0.0.0 lori.
# vi $ORACLE_HOME/network/admin/listener.ora
19. Igbesẹ ikẹhin ni atunkọ .bash_profile lati gbe awọn eto tuntun wọle.
# source .bash_profile
20. Ati lẹhinna buwolu wọle si ibi ipamọ data nipa lilo akọọlẹ eto ati ọrọ igbaniwọle ti a yan ni Igbese 11 ti apakan ti tẹlẹ.
# sqlplus [email
Ni aṣayan, jẹ ki a ṣẹda tabili inu aaye data tecmint nibi ti a yoo fi sii diẹ ninu awọn igbasilẹ apẹẹrẹ bi atẹle.
SQL> CREATE TABLE NamesTBL (id NUMBER GENERATED AS IDENTITY, name VARCHAR2(20));
Jọwọ ṣe akiyesi pe awọn ọwọn IDANIMỌ ni akọkọ ṣafihan ni Oracle 12c.
SQL> INSERT INTO NamesTBL (name) VALUES ('Gabriel'); SQL> INSERT INTO NamesTBL (name) VALUES ('Admin'); SQL> SELECT * FROM NamesTBL;
Muu Ebora bẹrẹ lati Bata Eto
21. Lati mu ki iṣẹ data ipilẹ ṣiṣẹ lati bẹrẹ laifọwọyi ni bata, fi awọn ila wọnyi si /etc/systemd/system/oracle-rdbms.service file.
# /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. Lakotan, a nilo lati tọka pe aaye data tecmint yẹ ki o wa mu lakoko bata ni/ati be be lo/oratab (Y: Bẹẹni).
Ninu nkan yii, a ti ṣalaye bi o ṣe le fi sori ẹrọ Oracle 12c lori RHEL/CentOS 7, bii o ṣe le ṣẹda ati tunto ibi ipamọ data kan, ati bii o ṣe le ṣẹda awọn tabili ati fi sii awọn ori ila data.
Ni afikun, o ṣe pataki lati ṣe akiyesi pe olupin ibi ipamọ data yẹ ki o wa ni ṣiṣiṣẹ nigbati awọn bata bata eto, ati pe ipilẹ data aiyipada wa yẹ ki o wa ni aaye yẹn.
Ti o ba ni ibeere tabi awọn asọye nipa nkan yii, ni ọfẹ lati ju ila wa silẹ ni lilo fọọmu ni isalẹ.