Manual upgrading Oracle database 11gR2 to 18c

Manual upgrading Oracle database 11gR2 to 18c If you want to know how we upgrade an database to using DBUA, click here. This article explains how to upgrade and above, and, to manually. Manually upgrading to 18c There are many DBAs who don’t want to follow the recommended way of an upgrade […]

Read More

Tablespaces Info for upgrading to 18c

To help you keep track of your tablespace allocations, the following AUTOEXTEND tablespaces are expected to successfully EXTEND during the upgrade process.

Minimum tablespace sizes for upgrade are estimates. Only Solution is to extend the tablespace.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the […]

Read More


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

Fast Application Notification[FAN] Benefits :

For DBA, if a database is up and running, everything seems beautiful..!! But once a state change happens in a database, we don’t know will it take 2 min to overcome it or it will eat our infinite time. When we talk about Oracle RAC, we know there are multiple resources are available to give […]

Read More

Converting an Administrator-Managed Database to a Policy-Managed Database

In this article, We can convert Administrator managed database to Policy managed database : First of all, let’s check the configuration of the database :

In above output, we can see the last line shows us my demo database is an administrator-managed database. Now next we need to create a server pool.

In […]

Read More

Relocating Service in Oracle RAC

In this article, we will see Relocation of Service from One Instance to another Instance. I have service called myservice already running at orcl1 instance. Let us check status of myservice

Now relocate service from orcl1 to orcl2

-i represents an old instance -t represents a new instance Now check the status of […]

Read More

Creating Deleting and Modifying Services in Oracle RAC

1.Creating Service in Oracle RAC : Step 1: To create a service in Oracle RAC

Here I have created service named myservice with preferred instance orcl1 and available instance orcl2. To check all available parameters of service creation :

Step 2: Check the status of service :

We can see here service […]

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

Apply Patch on Oracle 18c Database

In this post, we are going to apply bug fix patch for testing in Oracle 18c Database. First of all, we can download latest opatch utility from support. Doc ID 274526.1 -> How To Download And Install The Latest OPatch (6880880) Version. Check the version from new OPatch utility.

Now we are going to […]

Read More