오라클 데이터베이스 설치
(reference from: https://gemsofprogramming.wordpress.com/2013/09/19/installing-oracle-12c-on-ubuntu-12-04-64-bit-a-hard-journey-but-its-worth-it/)
호스트 환경 - Windows 8.1 Pro K 64bit
설치 환경
VMware - Ubuntu linux 14.04
Oracle Database 12c
4096 MB RAM
2 Processors
데이터베이스 설치 전 리눅스 필요 패키지 설치
root# apt-get install elfutils libaio1 libaio-dev libstdc++6-4.4-dev numactl pdksh sysstat unixODBC-dev unixODBC build-essential libaio1 gawk ksh libmotif3 alien libtool
오라클 유저 준비
root# addgroup oinstall
root# addgroup dba
root# useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle
root# mkdir /home/oracle
root# chown -R oracle:dba /home/oracle
오라클 바이너리 설치 경로
root# mkdir -p /oracle
root# chown -R oracle:dba /oracle
sysctl.conf 수정
root# vi /etc/sysctl.conf
# Oracle 12c entries
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
root# sysctl -p
limits.conf 수정
root# vi /etc/security/limits.conf
#Oracle 12c
oracle soft nproc 2048
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
Oracle Database 12c 압축 해제(/tmp/Oracle12c) 후 인스톨 실행(oracle 계정으로 로그인)
[복사: cp source destination, 압축풀기: unzip]
oracle:/tmp/Oracle12c/database$ ./runInstaller
몇가지 경고 메시지가 뜨는데 일단은 무시한다.
oracle binary 경로를 설정해 주는데 디폴트로 놔두어도 되지만 접근하기 쉽게 /oracle/base와 /oracle/base/dbhome_1로 변경
설치가 진행되다가 경고창이 뜬다. 새 터미널을 열고 로그파일을 열어 본다.
(tail -f 와 함께 사용하여 추가되는 로그를 계속 모니터링 가능)
$ tail -f /oracle/oraInventory/logs/installActions2013-09-19_08-51-51AM.log
라이브러리 위치 확인 및 심볼릭 링크 후 Retry
root# locate libpthread_nonshared
root# ln -s /usr/lib /usr/lib64
root# ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/libpthread_nonshared.a
root# locate libc_nonshared.a
root# ln -s [locate] /usr/lib64
Link binaries
root# ldd /oracle/base/dbhome_1/lib/libnnz12.so
root# ln -s /oracle/base/dbhome_1/lib/libclntshcore.so.12.1 /usr/lib
root# gedit /oracle/base/dbhome_1/rdbms/lib/ins_rdbms.mk
$(ORAPWD) : $(ALWAYS) $(ORAPWD_DEPS)
$(SILENT)$(ECHO)
$(SILENT)$(ECHO) " - Linking password utility (orapwd)"
$(RMF) $@
$(ORAPWD_LINKLINE) -lnnz12
root# ldd /oracle/base/dbhome_1/lib//libagtsh.so
root# ln -s /oracle/base/dbhome_1/lib/libagtsh.so /usr/lib
root# gedit /oracle/base/dbhome_1/rdbms/lib/ins_rdbms.mk
$(HSOTS) : $(ALWAYS) $(HSOTS_DEPS)
$(SILENT)$(ECHO)
$(SILENT)$(ECHO) " - Linking HS OTS agent"
$(RMF) $@
$(HSOTS_LINKLINE) -lagtsh
root# gedit /oracle/base/dbhome)1/rdbms/lib/env_rdbms.mk
HSOTS_LINKLINE=$(LINK) $(OPT) -Wl,--no-as-needed $(HSOTSMAI) $(HSALIB_SUBSET1) \
$(HS_OTS_DRIVER) $(HS_XASWITCH_ORA) $(RDBMSLIB)$(XAD_OFF) \
$(HSALIB_SUBSET2)
- after Retry -
HSDEPXA_LINKLINE=$(LINK) $(OPT) -Wl,--no-as-needed $(HSDEPMAI) $(HSALIB_SUBSET1) \
$(HS_DEP_DRIVER) $(RDBMSLIB)$(XAD_OFF) \
$(HSALIB_SUBSET2)
AMDU_LINKLINE=$(LINK) $(S0MAIN) -Wl,--no-as-needed $(SSKFMUED) $(SKFMUPT) \
$(LLIBDBTOOLS) $(LLIBCORE) $(LLIBGENERIC) $(LLIBUNLSRTL) \
$(LLIBNLSRTL) $(LLIBCORE) $(LLIBSAGE) $(LLIBSKGXP) \
$(LLIBNLSRTL) $(CSSCLNTLIBS_SERVER) $(LLIBASMCLNT) $(LINKTTLIBS)
KFED_LINKLINE=$(LINK) $(S0MAIN) -Wl,--no-as-needed $(SSKFEDED) $(SKFEDPT) \
$(LLIBDBTOOLS) $(LLIBSAGE) \
$(LLIBSKGXP) $(CSSCLNTLIBS_SERVER) $(LLIBASMCLNT) $(LINKTTLIBS)
KFNDG_LINKLINE=$(LINK) $(S0MAIN) -Wl,--no-as-needed $(SSKFNDGED) $(SKFNDGPT) $(KFNDGOBJ) \
$(LLIBCLNTSH) $(LIBGENERIC) $(DEF_OPT) $(LLIBDBTOOLS) $(LIBGENERIC) \
$(LIBCORE) $(CSSCLNTLIBS) $(ASMCLNT_LIBS) $(LINKTTLIBS)
root# gedit /oracle/base/dbhome)1/rdbms/lib/ins_rdbms.mk
$(EXTPROC): $(ALWAYS) $(EXTPROC_DEPS)
$(SILENT)$(ECHO)
$(SILENT)$(ECHO) "Linking external procedure agent ($@)"
$(RMF) $@
$(EXTPROC_LINKLINE) -lagtsh
root# gedit /oracle/base/dbhome)1/rdbms/lib/env_rdbms.mk
EXTPROC_LINKLINE=$(LINK) $(OPT) -Wl,--no-as-needed $(EXTPMAI) $(PROD_EXTPROC_OPT) \
$(HSALIB_SUBSET1) $(HSALIB_SUBSET2)
root# gedit /oracle/base/dbhome_1/network/lib/ins_net_server.mk
tnslsnr: $(S0NSGL) $(SNSGLP) $(NSGLPNP)
$(SILENT)$(ECHO) " - Linking $(TNSLSNR)"
$(RMF) $@
$(TNSLSNR_LINKLINE) -lnnz12 -lons
root# ldd /oracle/base/dbhome_1/lib/libocrb12.so
root# ln -s /oracle/base/dbhome_1/lib//libocrutl12.so /usr/lib
root# gedit /oracle/base/dbhome_1/rdbms/lib/env_rdbms.mk
ORACLE_LINKLINE=$(ORACLE_LINKER) -Wl,--no-as-needed $(PL_FLAGS) $(ORAMAI) $(SSORED) $(TTCSOI) \
$(ORACLE_KERNEL_LIBS) $(LINKLDLIBS)
스크립트 실행
실행 후 OK 버튼 누르면
나머지 설치 진행 후 완료
터미널로 돌아와
~$ export ORACLE_HOME=/oracle/base/dbhome_1
oracle:~$ export PATH=$PATH:$ORACLE_HOME/bin
oracle:~$ dbca
완료
테스트
oracle$ export ORACLE_SID=packarddb
oracle$ sqlplus / as sysdba
SQL> select instance_name from gv$instance;
rman target /
RMAN> show all;
