Installing Oracle Database 12c on the ubuntu linux

오라클 데이터베이스 설치

(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;