์ฝ˜ํ…์ธ ๋กœ ๊ฑด๋„ˆ๋›ฐ๊ธฐ

Install Oracle DB 12 ON Radhat Linux 7.7 ๐Ÿ”ฎ

1. ํ™ˆํŽ˜์ด์ง€ ์ ‘์† ํ›„ ์›ํ•˜๋Š” ๋ฒ„์ „์˜ Oracle DB ๋‹ค์šด๋กœ๋“œ

Oracle DB Download link

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html

RedHat release ๋ฒ„์ „ ํ™•์ธ

cat /etc/redhat-release
uname -r

์„ค์น˜๋œ ๋ฒ„์ „๊ณผ ์ง€์›๋˜๋Š” DB ํ™•์ธ ํ›„ ์ง„ํ–‰ํ•˜์—ฌ์•ผ ํ•œ๋‹ค.

Linux update ์ง„ํ–‰

yum update -y

๊ธฐ๋ณธ ์„ค์น˜ ํ”„๋กœ๊ทธ๋žจ

Oracle DB ์„ค์น˜ ์ „ ํ•„์ˆ˜๋กœ ์„ค์น˜๋˜์–ด์žˆ์–ด์•ผ ํ•˜๋Š” ํ”„๋กœ๊ทธ๋žจ์„ ์„ค์น˜ํ•ด์ค€๋‹ค.

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 libaio-devel.i686 libaio-devel.x86_64 libgcc.i686 libgcc.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 libXtst.i686 libXst.x86_64 make.x86_64 sysstat.x86_64 zip unzip

์ •์ƒ ์„ค์น˜ ํ™•์ธ

Oracle ์‚ฌ์šฉ์ž, ๊ทธ๋ฃน ์ƒ์„ฑ

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle && passwd oracle

oracle ๊ณ„์ • ํ™˜๊ฒฝ ๋ณ€์ˆ˜ ์„ค์ •

cd /home/oracle
mkdir db
chown -R oracle:oinstall db
chmod -R 775 db
chmod g+s db

Oracle .bash_profile ์„ธํŒ…

vi /home/oracle/.bash_profile

๋ณ€๊ฒฝ ์ „

.bash_profile
Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
...

๋ณ€๊ฒฝ ํ›„

.bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export TMP=/tmp
export TMPDIR=/tmp
export ORACLE_BASE=/home/oracle/db
export ORACLE_SID=orcl
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1
export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH=$ORACLE_HOME/bin:$PATH
...

์ปค๋„ ์„ค์ • ์ˆ˜์ •

vi /etc/sysctl.conf

๋ณ€๊ฒฝ ์ „

sysctl.conf

์ฝ”๋“œ ์ถ”๊ฐ€

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1987162112
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

๋ณ€๊ฒฝ ํ›„

sysctl.conf

Kernel update

sysctl -p

์—…๋ฐ์ดํŠธ ๋‚ด์šฉ ํ™•์ธ

๊ณ„์ • limit ์„ค์ •

vi /etc/security/limits.conf

๋ณ€๊ฒฝ ์ „

limits.conf

limit ์„ค์ •

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

๋ณ€๊ฒฝ ํ›„

limits.conf

Oracle Install

๋‹ค์šด๋กœ๋“œ ๋ฐ›์€ Oracle DB ์„ค์น˜ํŒŒ์ผ ์••์ถ• ํ•ด์ œ

unzip Oracle Database 12.2.0.1.0 for Linux x86-64.zip
su - oracle
cd /home/oracle/database

Oracle ์‹คํ–‰

unzip Oracle DB

error

Xwindow๊ฐ€ ์—†์–ด ์—๋Ÿฌ๊ฐ€ ์‹คํŒจ๊ฐ€ ๋‚˜์ง€๋งŒ ์„ค์น˜๋ฅผ ๊ณ„์† ์ง„ํ–‰ํ•˜์˜€๋‹ค.

[oracle@localhost database] ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB.   Actual 4093 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1639 MB    Passed
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY                                                                           variable is set.    Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Continue? (y/n) [n] y
>>> Ignoring required pre-requisite failures. Continuing...
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-10-13_05-12-18AM. Please wait ...
DISPLAY not set. Please set the DISPLAY and try again.
Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
- For csh:                      % setenv DISPLAY 192.168.1.128:0.0
- For sh, ksh and bash:         $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
        echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
        echo $DISPLAY
- Make sure that client users are authorized to connect to the X Server.
To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as 'xclock':
        % <full path to xclock.. see below>
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for xclock: /usr/X11R6/bin/xclock

์ดํ›„ ์„ค์น˜

xhost +
xclock
xterm

GUI Interface install (GNOME) for RHEL 7

yum groupinstall "Server with GUI"
ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target
reboot

install Server with GUI

์ดํ›„ ๋‹ค์‹œ oracle ๊ณ„์ •์˜ database ํด๋” ๋‚ด ์„ค์น˜ ํŒŒ์ผ์„ ์‹คํ–‰ํ•˜์—ฌ ์ง„ํ–‰ํ•œ๋‹ค.

Oracle DB Install

๋ณด์•ˆ ๋ฉ”์ผ ์ˆ˜์‹  ๊ฑฐ๋ถ€ ํ›„ next

2. DB ์ƒ์„ฑํ•˜๊ธฐ -> next

3. Server class -> next

4. Single instance database installation -> next

5. Advanced install -> next

6. Enterprise Edition -> next

7. Oracle install path ์„ค์ • -> next

8. Oracle ์ธ๋ฒคํ† ๋ฆฌ ์„ค์ • -> next

9. DB type ์„ค์ • -> next

10. ๊ธ€๋กœ๋ฒŒ ์ด๋ฆ„, SID, Pluggable ์„ค์ • -> next

11. ๋ฉ”๋ชจ๋ฆฌ ์„ค์ • -> character sets

12. character sets ์„ค์ •(AL32UTF8) -> next

12. ์˜ค๋ผํด ํŒŒ์ผ ์‹œ์Šคํ…œ ์„ค์ • -> next

12. EM(Enterprise Manager) ์„ค์ • -> next

13. ๋ณต๊ตฌ ๊ด€๋ จ ์„ค์ • -> next

14. ๋น„๋ฐ€๋ฒˆํ˜ธ ์„ค์ • -> next

15. ๊ทธ๋ฃน ์„ค์ • -> next -> install

16. ์Šคํƒ ์‚ฌ์ด์ฆˆ ์„ค์ •

17. oracle ์„ค์น˜์— ๊ด€ํ•œ ์ •๋ณด ํ™•์ธ

18. ์„ค์น˜ ์ง„ํ–‰

19. ์„ค์น˜ ์ค‘ ๋ช…๋ น์–ด ์ž…๋ ฅ ์ฐฝ์ด ๋œจ๋ฉด ์ž…๋ ฅ ํ›„ ์„ค์น˜ ์ฐฝ์—์„œ ok ํด๋ฆญ ํ›„ ์ง„ํ–‰

20. ์„ค์น˜ ์™„๋ฃŒ

21. oracle ํ™˜๊ฒฝ๋ณ€์ˆ˜ ์žฌ์„ค์ •

์šฉ๋Ÿ‰๋•Œ๋ฌธ์— ๋ณ€๊ฒฝํ•œ oracle path ์žฌ ์ง€์ •, ์‹คํ–‰

.bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PAT
export TMP=/tmp
#export TMPDIR=/tmp
#export ORACLE_BASE=/home/oracle/db
#export ORACLE_SID=orcl
#export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1
#export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
#PATH=$PATH:$HOME/.local/bin:$HOME/bin
#export PATH=$ORACLE_HOME/bin:$PATHH
export ORACLE_BASE=/oracle12.2
export ORACLE_HOME=$ORACLE_BASE/lnventory
#ORACLE_BASE = /oracle12.2; export ORACLE_BASE
#ORACLE_HOME= /$ORACLE_BASE/lnventory; export ORACLE_HOME
ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl; export ORACLE_HOME_LISTNER
ORACLE_SID=orcl; export ORACLE_SID
LD_LIBRATY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; export LD_LIBRAY=PATH
LCASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
export NLS_LANG=KOREAN_KOREA.AL32UTF8
PATH=$ORACLE_HOME/bin:$PATH:$HOME/.local/bin:$HOME/bin; export PATH

Oracle Database ์„ค์น˜ ์™„๋ฃŒ

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
๋ชจ๋“  ๋Œ“๊ธ€๋ณด๊ธฐ