OracleDB製品のインストール

https://edelivery.oracle.com/osdc/faces/SoftwareDelivery;jsessionid=Z8KxnLfHl3BNIKwUy8obX5PTF_taN-ChPBySprfrPHwLlKcbXQ4i!1966040717
リンクから降格

Create SwapFile

# https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-centos-7
free -m

https://support.hpe.com/hpesc/public/docDisplay?docId=kc0101061ko_kr&docLocale=ko_KR


### count 1000 , blocksize=1M = 1G 파일생성 
### ADD
free -m
mkdir -p /var/swap
sudo dd if=/dev/zero of=/var/swap/swapfile count=10000 bs=1M
sudo chmod 600 /var/swap/swapfile
ls -lh /var/swap/swapfile
sudo mkswap /var/swap/swapfile
sudo swapon /var/swap/swapfile

### REMOVE
sudo swapoff -v /var/swap/swapfile

Next, remove the swap file entry /swapfile swap swap defaults 0 0 from the /etc/fstab file.
vi /etc/fstab

sudo rm /var/swap/swapfile

REQ XMING

XMING.exeを開く必要があります!
https://sourceforge.net/projects/xming/files/latest/download

Allow powertool if xclock does not work

dnf config-manager --enable PowerTools
sudo yum install xorg-x11-apps
yum --enablerepo=PowerTools list xorg-x11-apps
xclock

JDKをインストールする必要があります

yum list java*jdk-devel
yum install -y java-1.8.0-openjdk-devel.x86_64
java -version
vi /etc/profile
JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.151-1.b12.el6_9.x86_64

./runInstallerエラー

Check if some JDK is installed in your system:
$ java -version
Installing JDK 7 solved my problem:
$ sudo apt-get install openjdk-7-jre-headless
If the problem persists, log as root, then execute:
$ xhost +
Switch back to another user and run installation again.

LinuxにOracleをインストールする場合./runInstallerを実行しました
ディスプレイ変数が設定されていることを確認してください
エラーが発生した場合は、rootアカウントからsu-oracleに接続しないでください.
一般ユーザーアカウントからsu-oracleに接続し、実行します.

Install SQLPLUS

Navigate to Instant Client Downloads for Linux x86-64 (64-bit)
Download these zip files:
instantclient-basic-linux.x64-12.2.0.1.0.zip
instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
Make dir for instant client then unzip zips
mkdir -p/opt/oracle
unzip -d/opt/oracle instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip -d/opt/oracle instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
The file listing of that dir should now look like
$ cd/opt/oracle/instantclient_12_2 && find . -type f | sort
./adrci
./BASIC_README
./genezi
./glogin.sql
./libclntshcore.so.12.1
./libclntsh.so.12.1
./libipc1.so
./libmql1.so
./libnnz12.so
./libocci.so.12.1
./libociei.so
./libocijdbc12.so
./libons.so
./liboramysql12.so
./libsqlplusic.so
./libsqlplus.so
./ojdbc8.jar
./sqlplus
./SQLPLUS_README
./uidrvci
./xstreams.jar
Set the LD_LIBRARY_PATH and PATH env vars in your ~/.bashrc
export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_2:LDLIBRARYPATHexportPATH=LD_LIBRARY_PATH export PATH=LDL​IBRARYP​ATHexportPATH=LD_LIBRARY_PATH:$PATH
Source your ~/.bashrc
source ~/.bashrc
Run sqlplus -V to confirm it’s installed
https://zwbetz.com/install-sqlplus-on-linux/

TNS ERROR

ADD to ~/.bash_profile
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_SID=orcl
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=ORACLEHOMEexportPATH=ORACLE_HOME export PATH=ORACLEH​OMEexportPATH=ORACLE_HOME/bin
//Apply
source ~/.bash_profile

CONNECT

sqlplus/as sysdba
sqlplus/nolog