Facts about Instance

Today we are going to have look at some more interesting facts about  “Oracle Technology”.  This post about is the  “ASM Instance and Database Instance”. Being an Oracle DBA our  Oracle journey starts with Database Instance. As we go into the deep knowledge of Oracle we get new terms of Oracle technology. We are going to learn about ASM instance and […]

Read More

Updating dbaascli in Oracle Cloud

Normally, you use the dbaascli utility to update the cloud tooling on Database Cloud Service database deployments hosting a single-instance database or Oracle Data Guard configuration. However, older deployments don’t support the two dbaascli subcommands you use:

Connect as the opc user to the compute node. Start a root-user command shell:

Navigate to […]

Read More

RESTful API in Oracle Cloud

A RESTful API is an application program interface (API) that uses HTTP requests to GET, PUT, POST and DELETE data. A RESTful API — also referred to as a RESTful web service — is based on representational state transfer (REST) technology, an architectural style and approach to communications often used in web services development. Oracle […]

Read More

Converting Normal Disk Groups to Flex Disk Groups in Oracle 18c

In this post, You can convert a conventional disk group ie created before Oracle ASM 18c to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option. Migrating (converting) to a flex disk group can be performed for a NORMAL or HIGH redundancy disk group with the CONVERT REDUNDANCY TO FLEX […]

Read More

New look of ASMCA in Oracle 18c

Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring Oracle ASM instances, disk groups, volumes, and Oracle Automatic Storage Management Cluster File System (Oracle ACFS). In addition, you can use the ASMCA command-line interface as a non-GUI utility. In Oracle 18c database, ASMCA comes up with new GUI interface which looks cool and easy to […]

Read More

Upgrading Oracle Grid Infrastructure 11gR2 to 18c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 18c (18.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 18.0.0.0 to 11.2.0.4 later one. If you want […]

Read More

Patch 27107360 – Oracle Grid Infrastructure PSU 11.2.0.4.180116

Patch Information GI PSUs are cumulative and include the Database PSU and associated CPU program security content. This is Jan 2018 PSU having Patch number 27107360 for 11gR2. OPatch Utility Information You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2 […]

Read More

MONITORING ALERT LOG

Today we are going to have look at the “MONITORING ALERT LOG ORA-ERRORS”. With help of this script DBA can monitor all the ORA-Errors from the alert log and used to send to our mailboxes, he schedules this through a cronjob. Being DBA we all are aware of the importance of Alert Log. For managing the backup […]

Read More

First Look of OEM 18c

In this article, we will try to find the new things with Oracle OEM 18c. I already installed Oracle OEM18c. After deploying the agent, we log in with sys user. First thing, we can able to see Forward Listener in Oracle 18c, which can explain in later posts. After that, we can see more parameter […]

Read More

Installing Oracle 18c Database on Cloud in 3-clicks

This article shows how to create Oracle 18c database in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Database Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter Cloud18c. – From the Software Release list, […]

Read More