My Blog

Secured Oracle 18c on Cloud

1-click AWS Deployment 1-click Azure Deployment 1-click Google Deployment

Overview

Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.

An Oracle database server consists of a database and at least one database instance, commonly referred to as simply an instance. Because an instance and a database are so closely connected, the term Oracle database is sometimes used to refer to both instance and database. In the strictest sense the terms have the following meanings:

  • Database: A database is a set of files, located on disk, that store data. These files can exist independently of a database instance.
  • Database instance

Cognosys provides hardened images of Oracle  DB on all public cloud  AWS , Azure and Google Marketplace.

Features

Major Features of Oracle 18c

  • Oracle Move is cost effective. The same flexibility that lets you directly migrate your Oracle Database to the Oracle Cloud is applied to finding the most cost effective solution for the purpose and duration of the migration.
  • Oracle Move is highly available and scalable. The tight integration of all migration tools with the Oracle Database lets you maintain control and gain better efficiency when moving your databases into the Oracle Cloud.
  • Oracle Move offers simplicity and efficiency. Oracle automated tools make it seamless to move your database to the Oracle Cloud with virtually no downtime. Using the same technology and standards on-premises and in the Oracle Cloud, you can facilitate the same products and skills to manage your cloud-based Oracle Databases as you would on any other platform.
  • Oracle Move is flexible. You can directly migrate your Oracle Database to the Oracle Cloud from various source databases into different target cloud deployments depending on your requirements and business needs. Oracle Move provides a well-defined set of tools, giving you the flexibility to choose the method that best applies to your needs

AWS

Installation Instructions For Linux

Installation Instructions 

Note: How to find PublicDNS in AWS

Step 1) SSH Connection: To connect to the deployed instance, Please follow Instructions to Connect to Linux instance on AWS Cloud

1) Download Putty.

2) Connect to the virtual machine using SSH key Refer this link:

  • Hostname: PublicDNS  / IP of machine
  • Port : 22

Step 2) Database Details:

Sample Database: Database cdb1 and pdb pdb1 has been created.
Credentials: The below passwords for oracle access have been set to Passw@rd123

  1. sysPassword
  2. systemPassword
  3. pdbAdminPassword
    Note : Please change the password after first login.

To use the oracle system user

  1. SSH to the instance please
  2. Switch context to root with “sudo -i”
  3. Then do su – oracle

Please set oracle user password as required.

Login with the command “sqlplus / as sysdba” as oracle user.

On the oracle sqlplus prompt “startup” the sample db configured in /etc/oratab.

After doing db startup in sqlplus you can check the status on ssh using the “lsnrctl status” command.
​Please use service dbora stop or start and start_all.sh or stop_all.sh script in /home/oracle/scripts to manage the listener.

Step 3) Other Information:

Default ports: For Linux SSH Port – 22

Oracle Database 18c Enterprise Edition

Videos

Oracle 18c DataBase

Secured Oracle 18c on Cloud