Network access to the Compute Node associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. By default SSH port 22 is opened to allow access to the tools, utilities and other resources on the Compute Node associated with the Oracle Database Cloud Services. You can use SSH client software such as PuTTY on Windows to establish a secure connection and log in as “opc” or “oracle” user. To access network protocols and services on a compute node by using a port other than portSEE DETAILS

Starting with Oracle ESS version 18c and OEDA August 2017 release Oracle introduced a new feature OEDA command-line (oedacli). The new OEDA command line interface allows you to update an existing es.xml file. These updates are called Actions and an action is a single atomic task.  OEDA command-line interface (oedacli) can help you with various Exadata life cycle management tasks, such as: Add node to or remove node from a Virtual Cluster on Exadata Add database home to or remove database home from physical cluster Add or remove Storage cellSEE DETAILS

Oracle Database Appliance consists of two physical servers (Node 0 and Node 1), a storage shelf and optionally an additional storage shelf. The two independent physical servers are interconnected and direct attached to SAS and SSD storage. ODA is basically a 2-node RAC cluster database system running Oracle Linux operating (OEL), Oracle Database Enterprise Edition, Oracle Grid Infrastructure (Clusterware and ASM). All these together provides the Oracle Database high availability running on ODA. In 2016, Oracle added 3 new models to expand Oracle Database Appliance portfolio. These 3 new modelsSEE DETAILS

In the previous article we have demonstrated how to connect to Oracle Database in Oracle Cloud using Oracle SQL Developer when the Oracle Net Listener port 1521 was enabled.Let’s assume that you DO NOT want to enable the Oracle Net Listener port 1521 for security reasons. In that case you can create an SSH tunnel to port 1521 on the compute node associated with Oracle Database Cloud Service. Then you can use SSH client software that supports tunneling. Oracle SQL Developer supports SSH and it can used to create anSEE DETAILS

You can connect to the Oracle database in Oracle Cloud using Oracle SQL Developer or similar tool to perform the database operations as you would similar to an on-premises databases. When you create a Database Cloud Service database deployment on Oracle Cloud, by default the Oracle Net Listener port 1521 is Disabled to ensure network security. Use the Oracle Database Cloud Service console to enable access to port 1521 on a compute node to make a SQL Developer connection to the Oracle Database. Note: If you DO NOT want toSEE DETAILS

Oracle Database Cloud Service uses access rules to provide secure network access to database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling and disabling access rules and creating new access rules.  Network access to the compute nodes associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. When you access a compute node using SSH, you must provide the private key that matches the public key associated with database deployment. To access other network protocolsSEE DETAILS

When you create a database deployment in Oracle Database Cloud Service, the following tasks are completed for you: Compute Node Allocated Storage Allocated Virtual Machine Image Installed Set Keys and Privileges Install and Configure Database Configure Backup Configure Tools Configure Access Network access to the Compute Node associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. By default SSH port 22 is opened to allow access to the tools, utilities and other resources on the Compute Node associated with the Oracle Database Cloud Services.SEE DETAILS

In our previous article we have learned how to Create a Database Deployment using Create Service Wizard. Let’s assume that you have created multiple services on Oracle Cloud and want to manage the services on the Dashboard so you just display services you want. You can use “Customize Dashboard” option on the “Oracle Cloud My Services” page to specify which services appear on the dashboard. In this article we will demonstrate how to Customize Dashboard on Oracle Cloud My Services page. Open a web browser and enter the URL youSEE DETAILS

There are several ways in which you can create a Database Deployment in Oracle Database Cloud Service. Some of the methods that you can use to create a Database Deployment are: QuickStart Template Create Service Wizard Using Snapshot Hybrid Disaster Recovery (DR) Deployment In this article we will demonstrate how to Create A Database Deployment using Create Service Wizard. Prerequisites: Oracle Account Oracle Cloud Subscription SSH Public/Private Key pair Steps to Create a Database Deployment Open a web browser and enter the URL you received in the Welcome email toSEE DETAILS

Oracle Database Cloud Service or simply DBCS or DBaaS is built on top of Infrastructure that is provided by Oracle Compute Cloud Service. When you create a service instance (Database Deployment for Example), all the Oracle Compute virtual machines (VMs) required to support the Database Services are provisioned and configured for you. You can use SSH (Secure Shell) to access the service Instance (Database VM or Database Compute node) provided by Oracle Compute Virtual Machines (VMs). Before you can access the VM, you need an SSH public/private key pair forSEE DETAILS

Before you create service instance (Database Deployment for example) on Oracle Cloud, you must subscribe to Oracle Cloud Services. Once you subscribe to an entitlement to create instance of an Oracle Cloud Service, then you can create multiple service instances based on your Business requirement. Subscribing to an Oracle Cloud Service consists of following 3 steps: Order One of the subscription type A free trail subscription to an Oracle Cloud Service A paid subscription Activate the Service Verify the Service is running Note: Free Oracle Cloud Promotion Applicable to only: OracleSEE DETAILS

To start using Oracle Database Cloud Service, follow the guidelines as below: Sign up for a free credit promotion or purchase a subscription Fill in your information, and sign up for a free credit promotion or purchase a subscription to Oracle Database Cloud Service. Add and manage users and roles Create user accounts and assign them appropriate privileges and assign the necessary Database Cloud Service roles. Create a database deployment Use create service wizard (GUI interface) to create a new database deployment. Enable network access Allow access to network servicesSEE DETAILS

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 followingSEE DETAILS

Oracle Database Cloud Service (DBCS) provides you the ability to deploy Oracle databases in the Oracle Cloud. Each database deployment contains a single Oracle database in a Virtual machine image. You can’t create multiple databases in one database deployment if you want to create multiple databases then you create a 12c Container database with multiple Pluggable databases. Oracle DBCS or also known as DBaaS is part of Platform as a Service (PaaS) offering. The compute, virtual machine, storage, network, optionally tools to simplify routine database maintenance and management operations areSEE DETAILS

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 ofSEE DETAILS

Introduction Exadata Compute nodes and storage cells come with an Integrated Lights Out Manager or simply ILOM. ILOM is an adapter card in each compute node and storage cell that operates independently of the operating system. The ILOM boots up as soon as power is applied to the server and provides web and SSH access through the management network. Using ILOM you can perform several tasks remotely that would otherwise require physical access to the servers, this includes access to the remote console, attach diag.iso image, power server on andSEE DETAILS

Introduction: Oracle Database Console that existed in Oracle Database 10g and 11g is now dead in Oracle Database 12c. Oracle Database 12cR1 gave birth to a completely new GUI interface known as Oracle Enterprise Manager Database Express or simply EM Express. EM Express replaces the Database Console that existed in Oracle 10g and 11g. Enterprise Manager Database Express is a lightweight browser-based tool for managing Oracle Database 12c is well suitable for common DBA tasks such as Tablespace Management, User Management and comprehensive performance diagnostics and tuning. You can’t performSEE DETAILS <...

Introduction In 2011, Oracle Introduced an entry level Engineered system known as Oracle Database Appliance (ODA). ODA is a pre-configured, highly available Oracle Database Engineered system. ODA system consists of hardware, software, storage and networking. The hardware configuration is designed to provide redundancy and protection against single points of failures in the system. The Oracle Database Appliance saves time and money by simplifying deployment, maintenance, and support of high availability Database solutions. ODA consists of two physical servers (Node 0 and Node 1), a storage shelf and optionally an additionalSEE DETAILS <span class="more-link-hover-...

Introduction Exadata Database Machine or simply known as Exadata is: An Engineered System A pre-configured combination of balanced Hardware and unique software A unique platform for running Oracle Databases Consists of Compute Grid, Storage Grid and Network Grid A fully integrated platform for Oracle Database Ideal for Database Consolidation platform It provides High Availability and High Performance for all types of Workloads Exadata Database Machine consists of a storage grid, compute grid, and network grid. Each grid, or hardware layer, is built with multiple high-performing, industry-standard Oracle servers to provideSEE DETAILS <span class="more-link-hover-...

In this article, I would like to demonstrate how to create a shell script to perform an RMAN SCN based backup and execute in background.  Tip: Scripting is a powerful tool to automate and execute jobs in background. Below example shows how to perform an SCN based RMAN Incremental backup using 4 Channels when we perform Roll-forward of Physical Standby. Step 1. Make a RMAN command file with RMAN Commands. Create a cmd script and include RMAN backup command. Get current SCN of Physical Standby and select a location toSEE DETAILS