Ibi ipamọ data Oracle 11g Tujade 2 Fifi sori RHEL/CentOS 6.x/5.x/4.x

Gẹgẹ bi gbogbo wa ṣe mọ Ibi ipamọ data Oracle jẹ olokiki julọ ati lilo ni ibigbogbo Eto Isakoso data ti ibatan (RDBMS) ni agbaye. Ifiweranṣẹ yii ṣe apejuwe igbesẹ nipasẹ igbesẹ fifi sori ẹrọ ti Oracle Database 11g Tujade 2 32bit lori CentOS 6.4 32bit . Awọn igbesẹ fifi sori ko yẹ ki o yatọ lori pupọ julọ awọn kaakiri Linux ti Red Hat.

Fifi aaye data Ebora 11g Tu 2

A lo package “oracle-rdbms-server-11gR2-preinstall” ti a funni nipasẹ ibi ipamọ “Oracle Public Yum”. Ibi ipamọ yum gbangba ti Oracle pese ọna ọfẹ ati irọrun lati fi sori ẹrọ gbogbo awọn igbẹkẹle Oracle Linux tuntun laifọwọyi. Lati ṣeto ibi ipamọ yum, tẹle awọn itọnisọna ti a pese ni isalẹ.

Lo pipaṣẹ “wget” lati Gba faili atunto yum ti o yẹ labẹ itọsọna /etc/yum.repos.d/ gẹgẹbi olumulo root.

# 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

Bayi ṣe pipaṣẹ\"yum" atẹle lati fi sori ẹrọ gbogbo awọn ohun pataki ti o ṣe pataki laifọwọyi.

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

Lakoko ti o n gbe bọtini GPG wọle, o le gba aṣiṣe “igbapada bọtini GPG kuna” bi a ṣe han ni isalẹ. Nibi, o nilo lati gbe bọtini GPG to dara fun idasilẹ OS rẹ.

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

Gbaa lati ayelujara ki o ṣayẹwo daju Oracle Linux GPG Key ti o baamu pẹlu RHEL/CentOS ibaramu idasilẹ OS rẹ.

# 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

Ṣii faili “/ ati be be/sysconfig/nẹtiwọọki” ki o ṣe atunṣe HOSTNAME lati baamu pẹlu FQDN rẹ (Orukọ Aṣẹ Pipe Ni kikun) orukọ agbalejo.

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

Ṣii faili “/ ati be be/awọn ogun” ki o ṣafikun orukọ agbalejo ti o kun fun olupin.

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

Bayi o nilo lati tun netiwọki bẹrẹ lori olupin lati rii daju pe awọn ayipada yoo jẹ jubẹẹlo lori atunbere.

 /etc/init.d/network restart

Ṣeto ọrọ igbaniwọle fun olumulo “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.

Ṣafikun titẹsi si faili “/etc/security/limits.d/90-nproc.conf” bi a ti ṣalaye ni isalẹ.

 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

Ṣeto SELinux si ipo “iyọọda” nipa ṣiṣatunkọ faili “/ ati be be/selinux/config“.

 vi /etc/selinux/config
SELINUX=permissive

Lọgan ti o ti ṣe ayipada, maṣe forger lati tun bẹrẹ olupin naa lati ṣe afihan awọn ayipada tuntun.

 reboot

Wọle bi olumulo Oracle ati ṣiṣi ṣiṣi ".bash_profile", eyiti o wa lori itọsọna ile olumulo olumulo, ṣe awọn titẹ sii bi a ti salaye rẹ ni isalẹ. Rii daju pe o ṣeto orukọ ogun ti o tọ si “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

Yipada si olumulo gbongbo ki o fun ni aṣẹ atẹle lati gba olumulo Oracle laaye lati wọle si olupin X.

 xhost +

Ṣẹda awọn ilana naa ki o ṣeto awọn igbanilaaye ti o yẹ ninu eyiti yoo fi software Oracle sori ẹrọ.

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

Forukọsilẹ ati Gba sọfitiwia Ebora ni lilo ọna asopọ atẹle.

  1. Ibi ipamọ data Ebora 11g Tujade 2

Apakan Oracle ni awọn faili pelu 2 sii eyiti o gbọdọ kọkọ gba adehun iwe-aṣẹ ṣaaju gbigba lati ayelujara. Mo ti fun awọn orukọ awọn faili fun itọkasi rẹ, jọwọ ṣe igbasilẹ awọn faili wọnyi fun ọna ẹrọ eto rẹ nibikan labẹ “/ ile/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

Bayi jẹ ki a bẹrẹ fifi sori Ebora. Ni akọkọ nilo lati yipada bi olumulo ‘oracle’ lati fi sori ẹrọ ibi ipamọ data.

[[email  ~]$ su oracle

Jade awọn faili orisun orisun data Ebora Oracle si itọsọna kanna “/ ile/oracle /“.

[[email  ~]$ unzip linux_11gR2_database_1of2.zip

[[email  ~]$ unzip linux_11gR2_database_2of2.zip

Firanṣẹ faili orisun unzip, itọsọna ti a pe ni ibi ipamọ data ni yoo ṣẹda, lọ si inu itọsọna naa ki o ṣe iwe afọwọkọ isalẹ lati bẹrẹ ilana fifi sori ẹrọ data 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

Lakoko fifi sori ẹrọ pdksh package o le ba pade aṣiṣe rogbodiyan ti ksh package. Yọ package ksh kuro ni agbara ki o fi sori ẹrọ pdksh package pẹlu aṣẹ ti a fun ni isalẹ: -

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

11. Ṣiṣe awọn sọwedowo Ibeere: O jẹ idanwo boya o to aaye SWAP lapapọ to wa lori eto naa.

12. Lakotan Fifi sori ẹrọ: Tẹ lori Fipamọ Faili Idahun . Faili yii wulo fun Fifi sori Ipo Ipo ipalọlọ Oracle

13. Fipamọ Faili Idahun ibikan ninu eto rẹ.

14. Ilọsiwaju Fifi sori Ọja

15. Didaakọ awọn faili data data

16. Tẹ lori “Iṣakoso Ọrọigbaniwọle“.

17. Ṣeto ọrọ igbaniwọle fun olumulo “SYS” ki o tẹ O DARA lati tẹsiwaju.

18. Awọn iwe afọwọkọ iṣeto ni nilo lati ṣe bi olumulo “gbongbo”. Lọ si ọna ti a fun ni iboju ki o ṣe awọn iwe afọwọkọ naa lọkọọkan. Tẹ lori 'O DARA' ni kete ti awọn iwe afọwọkọ ti ṣiṣẹ.

 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. Fifi sori ẹrọ ti aaye data Ebora jẹ aṣeyọri.

20. Lati ṣe idanwo fifi sori Oracle rẹ lilö kiri si wiwo iṣakoso oju-iwe wẹẹbu fun eto rẹ ni\"localhost" pẹlu orukọ olumulo\"SYS" n ṣopọ bi\"SYSDBA" ati lilo ọrọ igbaniwọle ti o ṣeto lakoko fifi sori Oracle. Ranti lati ṣii ibudo 1158 lori ogiriina rẹ ki o tun bẹrẹ iṣẹ iptables.

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

21. Oluṣakoso Iṣakoso data Ibaramu Idawọle Idawọle

Bayi o le bẹrẹ lilo Oracle. Mo ṣeduro pupọ fun ọ lati tẹle eto UI Olùgbéejáde Oracle SQL.

Eyi ni ipari ti Fifi sori ẹrọ sọfitiwia aaye data data Ebora. Ninu nkan wa ti n bọ a yoo ṣe ibo bo bii o ṣe le ṣẹda ibi ipamọ data nipa lilo DBCA ati bii o ṣe le Bẹrẹ ati Database Iboju Ibura. Jọwọ duro si aifwy… !!!