install-OracleDatabase12.2

install-OracleDatabase12.2

Simple installation scripts for Oracle Database 12c Release 2 (12.2.0.1) 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 12c Release 2 (12.2.0.1) software from Oracle Software Delivery Cloud. Then place the downloaded file in the $MEDIA folder. (You can set the environment variable $MEDIA to any value you like.)

• V839960-01.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/12.2.0.1/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

./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 * FROM hr.employees WHERE rownum <= 10;

Author

Shinichi Akiyama

License

MIT License