Skip to content

Latest commit

 

History

History

install-OracleDatabase21

README.md

install-OracleDatabase21

Simple installation scripts for Oracle Database 21c (21.3) single instance database.

Requirements

Oracle Linux Server 7

Internet access is required to install the software from GitHub and Oracle Linux Yum Server.

Please refer to Installation Guide for Linux x86-64 for the required memory and storage space.

Oracle Database software

Download Oracle Database 21c (21.3) software from Oracle Database Software Downloads. Then place the downloaded file in the $MEDIA folder. (You can set the environment variable $MEDIA to any value you like.)

  • LINUX.X64_213000_db_home.zip

Configuration

Copy the file dotenv.sample to a new file named .env and modify the contents as needed.

MEDIA=/mnt
ORACLE_BASE=/u01/app/oracle
ORACLE_CHARACTERSET=AL32UTF8
ORACLE_EDITION=EE
ORACLE_HOME=/u01/app/oracle/product/21.3.0/dbhome_1
ORACLE_PASSWORD=oracle
ORACLE_PDB=pdb1
ORACLE_SAMPLESCHEMA=TRUE
ORACLE_SID=orcl

Provision

When you run provision.sh, the following will be performed internally.

  • Install Oracle Preinstallation RPM
  • Create directories
  • Set environment variables
  • Set password for oracle user
  • Unzip downloaded Oracle Database software
  • Install Oracle Database
  • Create a listener
  • Create a database
  • Install sample schemas
./provision.sh

Examples of Use

Connect to CDB root and confirm the connection.

sudo su - oracle
sqlplus system/oracle
SHOW CON_NAME

Connect to PDB and confirm the connection. If you have sample schemas installed, browse to the sample table.

sqlplus system/oracle@localhost/pdb1
SHOW CON_NAME
-- If you have sample schemas installed
SELECT JSON_OBJECT(*) FROM hr.employees WHERE rownum <= 3;

Author

Shinichi Akiyama

License

MIT License