Netsoftmate

Tag: Cloud

  • Steps to Deploy Exadata Database Machine on Oracle Cloud Infrastructure

    Steps to Deploy Exadata Database Machine on Oracle Cloud Infrastructure

    In this article we will demonstrate quick steps to deploy Exadata Database Machine in Oracle Cloud Infrastructure (OCI). 

     Prerequisites:

    • Exadata Cloud Subscription
    • Credentials to Login Oracle Cloud
    • Access to Deploy Exadata in OCI
    • Compartment
    • VCN & Subnet


     Steps to Deploy Exadata on OCI

    • Open a browser and enter the URL you have received from Oracle to connect to the Oracle Cloud
    •  

    • Enter your Oracle Cloud credentials
    •  

    • Click on “Create Instance”
    •  

    • Click on “All Services” and search for Exadata keyword. Click on Create.
    •  

    • Select your “Compartment” on left and Click on “Launch DB System”
    •  

    • Enter the details as per your requirement and the Exadata subscription procured
    •  

    • Browse and upload the public key
    •  

    • Choose your desired storage allocation and timezone
    •  

    • Fill in the required VCN and Subnet details. Work with your network engineer to gather the correct details on VCN and Subnet created for your environment
    •  

    • Fill the database details, name, version, CDB and Password
    •  

    • Select the Workload type and database character set for your database
    •  

    • Optionally specify the TAG Key and click “Launch DB System” to deploy Exadata DBM
    •  

    Conclusion

     In this article we have learned how to deploy an Exadata Database Machine in Oracle Cloud Infrastructure (OCI).

    Expert Support for Oracle Exadata | Netsoftmate

  • How to find Hostname from AWS console

    Overview

    All AWS RDS Instances has DNS name and port number which is also known as endpoint, to establish connection to your AWS DB Instance you require DNS names and port number, we can find endpoint details of AWS RDS Instance through AWS console.

    In this article we will demonstrate, how to find endpoint details from AWS console.

    Steps to find endpoint of AWS RDS Instance


    • Login to AWS console
    please check previous article on how to login AWS console by click on following link


    • From console got to services then RDS


    • Click on RDS


    • Click on Instances


    • Choose oracle database instance and see database properties from Instance action tab.



    • Click on see details to display database instance properties.
    Conclusion
    In preceding article we have learned that how to find endpoint details from AWS console.




    Next, How to establish connection between on-premises and AWS Cloud…







    By
    Name : Omer
    Designation : Senior Database Engineer
    Organization: Netsoftmate IT Solutions    . 

  • How to Create AWS RDS Instance

    Amazon Web Services (AWS) is a secure cloud services platform, It offers compute power, database storage, evolving cloud computing platform provided by Amazon, content delivery and other functionality to help businesses scale up and grow.

    Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.
    To know more about Amazon RDS please visit https://aws.amazon.com/rds/

    In this article we will demonstrate how to create an AWS RDS Instance.

    Steps to create AWS RDS Instance (Oracle EE)


    • Login to AWS console, click here to know more about how to login to console
    • On AWS console click on RDS dashboard


    • Click on Get started now,  then on next page select engine
    • Click on Oracle Engine to create Oracle Database Instance


    • Select edition, here we are selecting enterprise edition,then another window appear where we have to provide more details, here choose license model as bring your own license

    • Now choose DB version, we have selected latest version


    • Now choose db instance class, we have choose DB instance class as db.r4.xlarge – this class has 4 cpu, 30 GB memory, to know more about Db instance class check this

    • Provide storage type, we have selected IOPS to learn more about AWS storage type please check following link.


    • Provide database settings, like DB name, master username credentials this master username we will use for connecting to database through back end.


    • After specifying DB details now move next window to provide advance configuration settings, like VPC details, security group


    To learn more about VPC(virtual private cloud) check this link

    To Learn about RDS Security group, please follow this link

    • Provide VPC, security group, database name and port details


    • Under Database options, provide database details character set, option group and parameter group

    • After provide all details click on Launch DB instance


    • Check progress, instance creation is in progress


    • Instance created and backup is in progress


    • Now Database is available for use



    Conclusion
    In this article  we have learned how to Create AWS RDS Instance. We have touch base about virtual private cloud(VPC), RDS security group, DB Instance class and storage types.




    Next, How to find Host name of AWS RDS Instance….


    By
    Name : Omer
    Designation : Senior Database Engineer
    Organization: Netsoftmate IT Solutions    . 

  • Oracle DBCS Storage Volumes and File System Layout

    Oracle uses simple and most efficient Storage Volumes and
    File System Layout in Oracle Database Cloud Service (DBCS) for the ease of use
    and management.


    Let’s take a look at the
    Oracle Database Cloud Services Storage Volume and File System Layout in more
    details.

    When you create a database deployment, Oracle Database Cloud
    Services (DBCS) creates the following Storage Layout and File Systems for you.

    Storage Volumes

    Storage Volume
    Description
    bits
    60
    GB volume completely allocated to /u01 on the
    virtual machine.
    boot
    32 GB volume allocated to the
    following file system mounts on the virtual machine:
    • / (root)
    • /boot
    • swap space
    data
    GB size equal to the value
    provided in the Usable
    Data Storage     field
    during the database deployment creation process, with a minimum of 15 GB.
    This volume is completely allocated to /u02 on the
    virtual machine.
    fra
    GB size depends on the choice of Backup Destination during the database deployment
    creation process:



    • Both Cloud Storage and Local Storage: GB size equal to 1.7 times the
      size of the       data
      volume.
    • Cloud Storage Only or None: GB size equal to 0.1 times the
      size of the       data
      volume, with a
      minimum of 7 GB



    This volume is completely
    allocated to /u03 on the virtual machine.
    redo
    10
    GB volume completely allocated to /u04 on the
    virtual machine.

    Storage Volumes of an Oracle Database Deployment



    File System Layout

    File System mount point
    Description
    swap
    Swap
    space:     4 GB
    allocated from the boot
    Compute Cloud
    storage volume.
    / (root)
    Operating
    system files:
    25.5 GB allocated from the boot
    Compute Cloud
    storage volume.
    /boot
    Operating
    system kernel:
    500 MB allocated from the boot
    Compute Cloud
    storage volume.
    /u01
    Oracle
    product software:
    the entire bits
    Compute Cloud
    storage volume.
    /u02
    Oracle
    Database data storage:
    the entire data
    Compute Cloud
    storage volume.
    /u03
    Database
    backup storage:
    the entire fra
    Compute Cloud
    storage volume.
    /u04
    Database redo logs: the entire redo Compute Cloud storage volume.


    File System Layout of an Oracle Database Deployment




    Conclusion

    In this article we have learned about Oracle Database Cloud Services
    Storage Volumes and File System Layout. When you create a database deployment, Oracle
    Database Cloud Services (DBCS) creates the Storage Layout and File Systems for
    you.

  • Oracle Cloud Quick Overview

    Oracle Cloud Overview

    • Oracle Cloud is one of the few cloud providers that can offer a complete set of cloud services to meet all your enterprise computing needs.
    • Oracle Cloud provides deployment options ranging from the public cloud to your data center.
    • Oracle Cloud offers best-in-class services across:
    • Software as a Service (SaaS),
    • Platform as a Service (PaaS),
    • Infrastructure as a Service (IaaS)


    Infrastructure As a Service (IaaS):


     Using Oracle IaaS services you can set up the virtual machines, storage, and networking capabilities you need to run any kind of workload. The entire infrastructure is managed, hosted, and supported by Oracle. You are responsible for patching and maintenance of the operating system and any other application software that you may run.


    Platform As a Service (PaaS)


     Using Oracle PaaS services you can quickly provision ready-to-use environments for your enterprise IT and development teams, so they can build and deploy applications, based on proven Oracle databases and application servers. Oracle Database as a service (DBaaS) is part of PaaS offering. You are not responsible for managing and administering the infrastructure and Operating System.


    Software As a Service (SaaS)


     Oracle SaaS allows users to subscribe and use application software in the cloud. Oracle offers cloud-based solutions for Human Capital Management (HCM), Cloud Managed Services, Enterprise Resource Planning (ERP), Supply Chain Management (SCM), HR, CX and many other applications, all managed, hosted, and supported by Oracle. You are not responsible for managing and administering the infrastructure and Operating System.


    Oracle Cloud Platform

    Oracle Cloud Platform
    Courtesy: Oracle

    Oracle IaaS and PaaS

    Oracle IaaS and PaaS
    Courtesy: Oracle

     

    Conclusion


     In this article we have learned what is Oracle Cloud and what are the different Oracle Cloud offerings currently available. Oracle Cloud offers best-in-class services across Software as a Service (SaaS), Platform as a Service (PaaS) and Infrastructure as a Service (IaaS)