192.168.10.149로 로키리눅스 서버 설치
Linux
Memory : 4GB
Processors : 4개(2*2)
Disk : 60 GB
SWAP : 8G
오라클 다운로드
wget 192.168.10.11/data/down/db/LINUX.X64_193000_db_home.zip
groupadd -g 1900 dba
useradd -g dba -u 1900 ora19c
passwd ora19c
mkdir -p /app/ora19c/19c
mkdir -p /app/oraInventory
chown -R ora19c.dba /app/ora19c
chown -R ora19c.dba /app/oraInventory
chgrp -R dba /app
chmod -R 775 /app
ls -al /app
dnf -y install ksh libaio-devel glibc-devel libstdc++-devel gcc-c++ libnsl wget
dnf install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libcap1-1.10-7.el7.x86_64.rpm
dnf install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
dnf install -y https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
mv LINUX.X64_193000_db_home.zip app/ora19c/19c/
chown -R ora19c.dba /app/ora19c/19c/
vi ~/.bash_profile
===============================
# oracle setup
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_OWNER=ora19c
export ORACLE_BASE=/app/ora19c
export ORACLE_HOME=/app/ora19c/19c
export ORACLE_SID=DB19
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME:/usr/bin:.
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export CV_ASSUME_DISTID=RHEL7.6
================================
env | grep ORACLE
cd /app/ora19c/19c
unzip LINUX.X64_193000_db_home.zip
그 다음 gui로 접속한다.
unset LANG
cd $ORACLE_HOME
./runInstaller
------------------------------------
linux : root
oracle : sys(sysdba)
system(sysoper)
sysdba는 sys만
sysoper는 system만 사용가능
sqlplus / as sysdba
ㄴ sysdba라는 권한으로 dba에 접속할래요 하는뜻 (sys만 사용가능하기 때문에 sys로 접속하는거임.)
ㄴ 테이크 브랜트 보안모델이다.
shutdown immediate;
ㄴ 데이터베이스 죽일때 사
startup
ㄴ 데이터베이스 살릴때 사용