¿ìºÐÅõ Oracle 11g ¼³Ä¡ |
* ¿ìºÐÅõ ¿À¶óŬ ¼³Ä¡
=> ¿ìºÐÅõ µ¥½ºÅ©Å¾ ȯ°æ¿¡¼ ¼³Ä¡ ÇÔ
* ¼³Ä¡ ÆÄÀÏ ´Ù¿î
http://www.oracle.com/technetwork/indexes/downloads/index.html#database
-> Database -> Database 11g Standard / Enterprise Edition -> ·Î±×ÀÎ -> ÆÄÀÏÀúÀå
================================================================================
1. ¿ìºÐÅõ ¼³Á¤ º¯°æ
================================================================================
* ¿ìºÐÅõ 16.04 64bit
sudo addgroup oinstall
sudo addgroup dba
sudo addgroup nobody
sudo usermod -g nobody nobody
sudo useradd -g oinstall -G dba -m -d /home/oracle -s /bin/bash oracle
sudo chown -R oracle:dba /home/oracle
sudo passwd oracle
=>ºñ¹ø : oracle
* ½ÃÀÛ ½ºÅ©¸³Æ® ¹× ¼³Ä¡ µð·ºÅ丮 Áغñ
sudo mkdir /etc/rc.d
for i in 0 1 2 3 4 5 6 S
do sudo ln -s /etc/rc$i.d /etc/rc.d/rc$i.d
done
sudo mkdir -p /u01/app/oracle
sudo chown -R oracle:dba /u01
* Ä¿³Î ÆĶó¹ÌÅÍ º¯°æ
* ¿ìºÐÅõ 13.04
sudo sh -c 'cat >> /etc/sysctl.conf << EOF
# Settings for Oracle Database Installation
fs.aio-max-nr=1048576
fs.file-max=6815744
kernel.shmall=2097152
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
kernel.shmmax=1073741824
EOF'
* Àû¿ë ½ÇÇà
sudo sysctl -p
* ¿ìºÐÅõ 13.04
root °èÁ¤¿¡¼ ´ÙÀ½ Shell limit ¼³Á¤À» µÚ¿¡ Ãß°¡ÇÕ´Ï´Ù.
sudo sh -c 'cat >> /etc/security/limits.conf << EOF
# Settings for Oracle Database Installation
oracle soft nproc 2048
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF'
===============================================================================
3. ÇÊ¿ä ÆÐÅ°Áö Ãß°¡
================================================================================
* ¿ìºÐÅõ 16.04
sudo apt-get update
sudo apt-get install gcc make binutils gawk x11-utils rpm build-essential libaio1 libaio-dev libtool expat alien ksh sysstat elfutils libelf-dev binutils libstdc++5
# ¼ºñ½º Á¾·á ÆÐÅ°Áö
# libmotif4 pdksh unixODBC unixODBC-dev lesstif2 lsb-cxx
================================================================================
4. ¼³Ä¡½Ã ¿À·ù¿¡ ´ëÇÑ ´ëºñ
================================================================================
* ¿ìºÐÅõ 16.04
sudo ln -s /usr/bin/awk /bin/awk
sudo ln -s /usr/bin/rpm /bin/rpm
sudo ln -s /usr/bin/basename /bin/basename
#lib µð·ºÅ丮 Àüü ¸µÅ©¸¦ »ç¿ëÇؼ (¹Ì»ç¿ë)
#sudo ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a #/usr/lib/libpthread_nonshared.a
#sudo ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib/libc_nonshared.a
#sudo ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /lib/libgcc_s.so.1
#sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib/libstdc++.so.6
#sudo ln -s /usr/lib /usr/lib64
#64bit
sudo mkdir -p /usr/lib64
sudo ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/libgcc_s.so.1
sudo ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/libc_nonshared.a
sudo ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/libpthread_nonshared.a
sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/libstdc++.so.6
* oracle °èÁ¤ ȯ°æº¯¼ö
su - oracle
touch .bashrc
ln -s .bashrc .bash_profile
/home/oracle/.bashrc ÆÄÀÏ¿¡ ´ÙÀ½°ú °°Àº ³»¿ëÀ» ³Ö¾îÁØ´Ù.(*ORACLE_SID´ë¼Ò¹®ÀÚ ÁÖÀÇ listener.ora ¿Í ´ë¼Ò¹®ÀÚ µ¿ÀÏ ÇØ¾ß ÇÔ)
# set file creation mask
umask 022
# setting up oracle environment variables
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=${ORACLE_BASE}/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export ORACLE_UNQNAME=orcl
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin
¾Æ·¡ ¸í·ÉÀ» ½ÇÇàÇØ oracle ȯ°æº¯¼ö Àû¿ë
. .bashrc
================================================================================
6. Oracle ¼³Ä¡
================================================================================
* ¿ìºÐÅõ 16.04
cd /home/oracle
sudo mv /home/somewhere/linux*database*.zip .
sudo chown oracle:dba linux*database*.zip
su oracle
unzip linux*database_1of2.zip
unzip linux*database_2of2.zip
cd database
LANG=C ./runInstaller -ignoreSysPrereqs
* ¿À·ù ½Ã ȸéÁ¶Á¤
owthit@owthit-desktop:~$ sudo xhost +
[sudo] password for owthit:
access control disabled, clients can connect from any host
owthit@owthit-desktop:~$ su oracle
¾ÏÈ£:
oracle@owthit-desktop:/home/owthit$ xhost +
access control disabled, clients can connect from any host
* Àç½ÇÇà
LANG=C ./runInstaller -ignoreSysPrereqs
* ¼³Ä¡ ¿À·ù ½Ã ½ÇÇà
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
sed -i 's/^\(\s*\$(MK_EMAGENT_NMECTL)\)\s*$/\1 -lnnz11/g' ${ORACLE_HOME}/sysman/lib/ins_emagent.mk
sed -i 's/^\(\$LD \$LD_RUNTIME\) \(\$LD_OPT\)/\1 -Wl,--no-as-needed \2/g' ${ORACLE_HOME}/bin/genorasdksh
sed -i 's/^\(\s*\)\(\$(OCRLIBS_DEFAULT)\)/\1 -Wl,--no-as-needed \2/g' ${ORACLE_HOME}/srvm/lib/ins_srvm.mk
sed -i 's/^\(TNSLSNR_LINKLINE.*\$(TNSLSNR_OFILES)\) \(\$(LINKTTLIBS)\)/\1 -Wl,--no-as-needed \2/g' ${ORACLE_HOME}/network/lib/env_network.mk
sed -i 's/^\(ORACLE_LINKLINE.*\$(ORACLE_LINKER)\) \(\$(PL_FLAGS)\)/\1 -Wl,--no-as-needed \2/g' ${ORACLE_HOME}/rdbms/lib/env_rdbms.mk
* ¼³Ä¡ Áß ½ÇÇà ÈÄ Àç½Ãµµ
su root
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/11.2.0/dbhome_1/root.sh
* Web Manager Á¢¼Ó URL
https://owthit-desktop:1158/em
* listener.ora ¼³Á¤
HOST´Â /etc/hosts IP µî·Ï ÈÄ µµ¸ÞÀÎ ÀÛ¼º
SID_NAME´Â ORACLE_SID¿Í ´ë¼Ò¹®ÀÚ È®ÀÎ ÈÄ µ¿ÀÏÇÏ°Ô ÀÛ¼º
listener.ora--------------------------------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = owthit.oracle)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
--------------------------------------------------------
lsnrctl stop
lsnrctl start
* Connect TEST
sqlplus system/oracle@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.17)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
<< Linux¿¡¼ ¿À¶óŬ »èÁ¦Çϱâ >>
1. $ORACLE_HOME µð·ºÅ丮¿¡ ÀÖ´Â ¼³Ä¡ ÈÀÏÀ» ÀüºÎ »èÁ¦
sudo rm -rf $ORACLE_HOME
2. /etc µð·ºÅ丮¿¡ ÀÖ´Â oraInst.loc, oratab ÆÄÀÏ »èÁ¦
sudo rm -r /etc/ora*
3. /usr/local/bin/oraenv ÆÄÀÏ »èÁ¦
sudo rm -fr /usr/local/bin/oraenv
4. /tmp µð·ºÅ丮¿¡¼ Ora °ü·Ã ÆÄÀÏ ¹× µð·ºÅ丮 »èÁ¦
sudo rm -fr /tmp/Ora*
4.5 /oraInventory µð·ºÅ丮 »èÁ¦
sudo rm -rf /u01/app/oracle/oraInventory/
5. oracle °èÁ¤ÀÇ È¯°æ¼³Á¤ ÆÄÀÏ ¹é¾÷
.bashrc or .bashrc_profile or .profile ... backup
6. oracle °èÁ¤À» »èÁ¦
sudo deluser oracle
7. oracle °èÁ¤ÀÇ HOME µð·ºÅ丮¸¦ »èÁ¦
sudo deluser --remove-home oracle
<oracle service start/shutdown>
su - oracle
sqlplus /nolog [sqlplus "/as sysdba"]
connect /as sysdba
shutdown immediate
startup
<¸®½º³Ê>
lsnrctl stop, start, reload, status
1. °èÁ¤ÀÇ Å×ÀÌºí ½ºÆäÀ̽º »ý¼º
sqlplus /nolog
conn sys as sysdba
create tablespace [tablespace_name]
datafile '/oradata/DANBEE/[file_name].dbf' size 500m;
¿¹)
CREATE TABLESPACE ADMIN DATAFILE '/oradata/xe/admin.dbf' SIZE 500M ;
SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM DBA_TABLESPACES;
2. ¿À¶óŬ À¯Àú ¸¸µé±â
sqlplus /nolog
conn sys as sysdba
CREATE USER [user_name]
IDENTIFIED BY [password]
DEFAULT TABLESPACE [tablespace_name]
TEMPORARY TABLESPACE TEMP;
¿¹)
CREATE USER ugis IDENTIFIED BY tprPchlrkd DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
3. »ý¼ºÇÑ USER¿¡ ±ÇÇÑÁÖ±â
GRANT connect, resource, dba TO [user_name];
¿¹)
grant connect, dba, resource to ugis; (¸ðµç ±ÇÇÑ ÁÖ±â)
GRANT CREATE SESSION TO À¯Àú¸í // µ¥ÀÌÅͺ£À̽º¿¡ Á¢±ÙÇÒ ¼ö ÀÖ´Â ±ÇÇÑ
GRANT CREATE DATABASE LINK TO À¯Àú¸í
GRANT CREATE MATERIALIZED VIEW TO À¯Àú¸í
GRANT CREATE PROCEDURE TO À¯Àú¸í
GRANT CREATE PUBLIC SYNONYM TO À¯Àú¸í
GRANT CREATE ROLE TO À¯Àú¸í
GRANT CREATE SEQUENCE TO À¯Àú¸í
GRANT CREATE SYNONYM TO À¯Àú¸í
GRANT CREATE TABLE TO À¯Àú¸í // Å×À̺íÀ» »ý¼ºÇÒ ¼ö ÀÖ´Â ±ÇÇÑ
GRANT DROP ANY TABLE TO À¯Àú¸í // Å×À̺íÀ» Á¦°ÅÇÒ ¼ö ÀÖ´Â ±ÇÇÑ
GRANT CREATE TRIGGER TO À¯Àú¸í
GRANT CREATE TYPE TO À¯Àú¸í
GRANT CREATE VIEW TO À¯Àú¸í
GRANT
CREATE SESSION
,CREATE TABLE
,CREATE SEQUENCE
,CREATE VIEW
TO À¯Àú¸í;
4. »ý¼ºÇÑ USER·Î ORACLE¿¡ Á¢¼ÓÇϱâ
sqlplus nextree/nextree[@db_sid]
5. °èÁ¤ »èÁ¦Çϱâ
drop user »ç¿ëÀÚ°èÁ¤ cascade;