Apply Patch without shutting the Database

Most of the time, we can shut down the database and listener for patching the database home. But there is a method to apply the patch without shutting down the database and listener. Checking the database and listener running

Checking the lsinventory

Now, we can apply the patch

Again, check the lsinventory […]

Read More

Installing Oracle 18c Data Guard on Cloud

This article shows how to create Oracle 18c Data Guard in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Data Guard 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 DG18. – […]

Read More

Relink Oracle 12c Grid Infrastructure and RDBMS binaries.

In order to relink the Oracle Grid Infrastructure RAC/Cluster Installation, please follow the next steps after stopping all the services running: 1) As root OS user, please unlock the Grid Infrastructure Oracle Home (on every node) as follows:

2) As the Oracle Grid Infrastructure owner (on every node) relink the Grid Infrastructure Oracle Home […]

Read More

OPatch failed with error code 135 – Argument(s) Error… Given ‘ocmrf’ file does not exists

Issue Using opatch auto to apply patch 18706472, it failed with error code 135: opatchauto2017-09-23_04-21-57.log shows:


Solution Either open the permission of /home/grid path to be 755, eg:

The permission looks like:

Or create a response file under a directory accessible by both grid user and oracle user, for example: […]

Read More

CRS-2101:The OLR was formatted using version 3

Got this while trying to install RAC on Redhat Linux 7.3. fails with a message like

This is bug 18370031. Need to apply the patch before running Install of Clusterware fails while running on OL7 – ohasd fails to start (Doc ID 1959008.1)

Execute the script once you applied the patch.

Thank […]

Read More

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

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

Background Processes and Listener in Oracle 18c

In this post we can see that how many background processes will come after starting the Oracle 18c Database on virtual box. Also we can create listener in Read Only Home to connect the database remotely with the help of tns entry. Let me start the newly created 18c Database. Configured the Listener Manually or […]

Read More

SQLT in Oracle

SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise – ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, […]

Read More