My Blog

Oracle Database 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 DB

  • 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.

After doing db startup in sqlplus you can check the status using 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

Configure custom inbound and outbound rules using this link

Remote Connections to Oracle EC2 instance:

  1. Configure the firewall – Either allow 1521 port in iptables or disable the firewall
    • To allow use the command iptables -I INPUT -s 192.168.1.0/24 -p tcp –dport 1521 -j ACCEPT (192.168.1.0/24 will be your VPC ip ranges)
    • To disable use service iptables status
      service iptables stop
      chkconfig iptables off
      service iptables status

      With either of the above methods access to the 1521 port from VLAN / same vpc subnet is allowed unless any other security group is blocking the access

  2. For allowing public/remote internet access you need to create entry in listener.ora file. When opening 1521 port on on inbound rule for security please ensure that the port is allowed only to restricted IP ranges.
  3. An example is as given below
============== contents of listener.ora =================
LISTENER =

  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ec2-3-6-36-190.ap-south-1.compute.amazonaws.com)(PORT = 1521))
    )

)

==================================================
Check env command to get the ORACLE_HOME value
For your version the file needs to be created in $ORACLE_HOME/network/admin/listener.ora
Change “ec2-3-6-36-190.ap-south-1.compute.amazonaws.com” to your ec2 instance details.
After the change restart the listener
lsnrctl stop

lsnrctl start

lsnrctl status

Telnet to ip and port from remote location and check the access
Oracle Database 12.c  Enterprise Edition

Videos

Oracle DataBase

Oracle Database on Cloud