BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡

±Û¾´ÀÌ: ¿À¶óŬ ¿À¶óŬ silent ¼³Ä¡ Á¶È¸¼ö: 2235


vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4056393728
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 -p

User Limit ¼³Á¤

vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240


ÀÇÁ¸ ÆÐÅ°Áö ¼³Ä¡
yum update -y
yum install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 gcc gcc-c++ glibc glibc.i686 glibc-devel glibc-devel.i686 ksh libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel libstdc++-devel.i686 libaio libaio.i686 libaio-devel libaio-devel.i686 libXext libXext.i686 libXtst libXtst.i686libX11 libX11.i686libXau libXau.i686 libxcb libxcb.i686 libXi libXi.i686 make sysstat unixODBC unixODBC-devel zip unzip libXrender


Oracle ½Ã½ºÅÛ »ç¿ëÀÚ ¼³Á¤

Oracle »ç¿ëÀÚ »ý¼º
groupadd dba
useradd oracle -g dba
passwd oracle


Oracle °æ·Î »ý¼º
mkdir -p /app/oracle /app/oraInventory
chown oracle:dba /app/oracle /app/oraInventory


ÇÁ·ÎÆÄÀÏ

vi ~/.bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=dsrc
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/12.2
export ORACLE_SID=orcl
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


Oracle Instance ¼³Ä¡

Installer Áغñ

´ÙÀ½ °æ·Î¿¡¼­ Oracle Database 12c Release 2 ¸¦ ´Ù¿î¹Þ¾Æ ¼³Ä¡ÇÒ ¼­¹ö¿¡ ¾÷·ÎµåÇÑ´Ù. (·Î±×ÀÎ ÇÊ¿ä)

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

¾ÐÃàÀ» Ç®°í,






unzip linuxx64_12201_database.zip

responseFile À» ¼öÁ¤ÇÑ ´ÙÀ½,

vi ./database/response/db_install.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/app/oraInventory
ORACLE_HOME=/app/oracle/12.2
ORACLE_BASE=/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=dba
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.characterSet=AL32UTF8
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true


Installer ¸¦ ½ÇÇàÇÑ´Ù.

./database/runInstaller -ignoreSysPrereqs -showProgress -silent -responseFile /home/oracle/database/response/db_install.rsp

Database »ý¼º

dbca ¸¦ silent ¸ðµå·Î ½ÇÇàÇϱâ À§Çؼ­ ¸ÕÀú responseFile À» ÀÛ¼ºÇÑ´Ù.

vi $ORACLE_HOME/assistants/dbca/dbca.rsp





responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
gdbName=orcl
templateName=General_Purpose.dbc
sysPassword=oracle
systemPassword=oracle
emExpressPort=5500
dbsnmpPassword=oracle
characterSet=AL32UTF8


À̾ ¾Æ·¡ ¸í·ÉÀ¸·Î dbca¸¦ ½ÇÇàÇÏ¸é µ¥ÀÌÅͺ£À̽º »ý¼º ³¡.

dbca -silent -createDatabase -responseFile /app/oracle/12.2/assistants/dbca/dbca.rsp

Listener »ý¼º

¾Æ·¡ ¸í·ÉÀ¸·Î netca¸¦ ½ÇÇàÇÏ¸é ±âº» ¸®½º³Ê°¡ »ý¼ºµÈ´Ù.

netca -silent -responseFile /app/oracle/12.2/assistants/netca/netca.rsp

°ü·Ã±Û : ¾øÀ½ ±Û¾´½Ã°£ : 2021/04/26 15:49 from 218.152.230.207

  ¿À¶óŬ ¹é¾÷½ºÅ©¸³Æ® ¸ñ·Ïº¸±â »õ±Û ¾²±â Áö¿ì±â ÀÀ´ä±Û ¾²±â ±Û ¼öÁ¤ ¿À¶óŬ ±ÇÇÑ  
BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡