<mohammadrony>

Database Server Setup

Install Latest Database Server

Download Installer file.

Oracle OS

Archive Installation

version=19.0.0 # 21.0.0 23.0.0

# Update ~/.bashrc and ~/.zshrc
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/$version/dbhome_1
export ORACLE_SID=orcl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export PATH=$PATH:$ORACLE_HOME/bin

Extract Zip file

cd $ORACLE_HOME
unzip -qo LINUX...db_home.zip

./runInstaller

Start listener

lsnrctl start

Stop listener

lsnrctl stop

RPM-based Installation

Installation

version=19 #21 23

sudo yum install -y oracle-database-preinstall-${version}c

sudo yum install -y bc binutils compat-libcap1 compat-libstdc++-33 dtrace-utils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libdtrace-ctf-devel libXrender libXrender-devel libX11 libXau libXi libXtst libgcc librdmacm-devel libstdc++ libstdc++-devel libxcb make net-tools nfs-utils python python-configshell python-rtslib python-six targetcli smartmontools sysstat

wget https://download.oracle.com/otn/linux/oracle19c/190000/oracle-database-ee-...x86_64.rpm?AuthParam=xxx -O oracle-database-ee-...x86_64.rpm

# Update ~/.bashrc and ~/.zshrc
export ORACLE_HOME=/opt/oracle/product/${version}c/dbhome_1

sudo yum -y localinstall oracle-database-ee-...x86_64.rpm

Create Database

sudo /etc/init.d/oracledb_ORCLCDB-${version}c configure

Remove Installation

sudo yum -y remove oracle-database-preinstall-${version}c

cd $ORACLE_HOME/bin
./dbca
./netca

sudo yum -y remove oracle-database-ee-${version}c

sudo /etc/init.d/oracledb_ORCLCDB-${version}c delete

Auto Start in System boot

sudo vi /etc/oratab

Update

version=19 # 21 23
ORACLE_SID=orcl
ORACLE_HOME=/u01/app/oracle/product/$version.0.0/dbhome_1
sudo sed -i "s#$ORACLE_SID:$ORACLE_HOME:N#$ORACLE_SID:$ORACLE_HOME:Y#" /etc/oratab

# Update ~/.bashrc and ~/.zshrc
export TMP=/tmp
export TMPDIR=$TMP

version=19 # 21 23
export ORACLE_HOSTNAME=crvsdb
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/$version.0.0/dbhome_1
export ORACLE_SID=orcl

export PATH=/usr/sbin:/usr/local/bin:$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

Save database state

sqlplus / as sysdba

ALTER PLUGGABLE DATABASE PDB_NAME OPEN;
ALTER PLUGGABLE DATABASE PDB_NAME SAVE STATE;

ALTER PLUGGABLE DATABASE ALL OPEN;

ALTER PLUGGABLE DATABASE PDB_NAME CLOSE IMMEDIATE;

ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE;

ALTER PLUGGABLE DATABASE ALL SAVE STATE;

Windows

Download Installer file

Extract Downloaded file.

Run ..._db_home/setup.exe as Administrator with these steps:

  1. Configuration Option
  2. System Class
  3. Oracle Home User
  4. Typical Installation
  5. Prerequisite Checks
  6. Summary
  7. Install Product
  8. Finish

Test Connection

SQL Plus commands

sqlplus /nolog

CONNECT / AS SYSDBA

STARTUP

SHUTDOWN

Uninstall Database

Run the deinstall script

ORACLE_HOME=..._db_home
cd $ORACLE_HOME/deinstall
./deinstall