Skip to content
Common Oracle Environment for Linux
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE
README.md
aliases.conf
functions.conf
init_script.conf
profile.sh
skel
variables.conf

README.md

COE

Common Oracle Environment for Linux

Installation instructions for the Oracle Cloud Infrastructure

# Connect as oracle
sudo su - oracle

# Clone this repository
git clone https://github.com/ludovicocaldara/COE.git

# Enable the profile scripts
echo ". ~/COE/profile.sh" >> $HOME/.bash_profile

# Load the new profile
. ~/.bash_profile

(optional) Installing git and rlwrap

# Install rlwrap (used extensively, although optional)
sudo yum install rlwrap

# Enable the Public Yum repository (optional, for git install)
cd /etc/yum.repos.d
sudo wget http://yum.oracle.com/public-yum-ol6.repo

# Install git (needed just to download the repo, you might want to find another way to copy it)
sudo yum install git

Depending on your VM version, you might encounter problems installing rlwrap. Please let me know if you find a one-command-fits all.

Some examples of the environment:

# [ oracle@ludodb01:/home/oracle/COE [21:28:15] [18.4.0.0.0 [DBMS EE] SID=CDB] 130 ] #
# u
DB_Unique_Name           DB_Name  ludodb01       Oracle_Home
------------------------ -------- -------------- --------------------------------------------------
CDB_fra1cw               CDB      CDB            /u01/app/oracle/product/18.0.0.0/dbhome_1

# [ oracle@ludodb01:/home/oracle/COE [21:28:18] [18.4.0.0.0 [DBMS EE] SID=CDB] 0 ] #
# sid CDB
DB_UNIQUE_NAME  = CDB_fra1cw
ORACLE_SID      = CDB
ROLE            = PRIMARY
VERSION         = 18.4.0.0.0
ORACLE_HOME     = /u01/app/oracle/product/18.0.0.0/dbhome_1
NLS_LANG        = AMERICAN_AMERICA.AL32UTF8

# [ oracle@ludodb01:/home/oracle/COE [21:28:22] [18.4.0.0.0 [DBMS EE] SID=CDB] 0 ] #
# lsoh

HOME                        LOCATION                                                VERSION      EDITION
--------------------------- ------------------------------------------------------- ------------ ---------
OraGrid180                  /u01/app/18.0.0.0/grid                                  18.4.0.0.0   GRID
OraDB18000_home1            /u01/app/oracle/product/18.0.0.0/dbhome_1               18.4.0.0.0   DBMS EE


# [ oracle@ludodb01:/home/oracle/COE [21:28:28] [18.4.0.0.0 [DBMS EE] SID=CDB] 0 ] #
# s_

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Apr 15 21:28:41 2019
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

# [ oracle@ludodb01:/home/oracle/COE [21:32:05] [18.4.0.0.0 [DBMS EE] SID=CDB] 0 ] #
# svcstat
DB_Unique_Name           Service_Name                   PDB                            ludodb01
------------------------ ------------------------------ ------------------------------ --------------
cdb_fra1cw               pdb_service_test               PDB1                           ONLINE

# [ oracle@ludodb01:/home/oracle/COE [21:32:18] [18.4.0.0.0 [DBMS EE] SID=CDB] 0 ] #
#
You can’t perform that action at this time.