During Startup you may see that error message on your standby database. I faced with that error message on 12.2 on linux os.

The above error is caused because of the following parameter set to NONE in standby whereas it has been set to TYPICAL in primary database.
So we have altered the below parameter to TYPICAL in standby and the above warning cleared.

Read the rest of this entry »

I faced with that issue while trying to install CentOS 8 on WMware.

I am using VMware Workstation 15.5 pro and trying to install CentOS 8. When I boot and it starts the installer it gives me a message on the
bottom

“Pane is dead”. I tried to set “install operating system later”,
Unfortunately VMware does not pick up the boot device as ISO and goes right to DHCP boot.

Read the rest of this entry »

I faced with that error during restoring container database to non-container database.

RMAN Backup has been taken from container database. It was my 2 Node RAC database.

Target database is standalone(non-asm) database. While I run recover command I hit this error message:

RMAN-06067: RECOVER DATABASE required with a backup or created control file

Read the rest of this entry »

This article is about Oracle Statspack. We are going to learn How We can Install and what is Oracle Statspack?

Statspack is a performance tuning tool provided by Oracle with the Oracle9i database distribution. With minimal effort, it can be installed on any Oracle9i database to rapidly gather detailed analysis of the performance of that database instance.

So What is Oracle Statspack?

The Statspack package is a set of SQL, PL/SQL, and SQL*Plus scripts that allow the collection, automation, storage, and viewing of performance data. Statspack stores the performance statistics perennially in Oracle tables, which can later be used for reporting and analysis. The data collected can be analyzed using Statspack reports, which includes an instance health and load summary page, high resource SQL statements, and the traditional wait events and initialization parameters.

Read the rest of this entry »

How We Are Adding new disk to ACFS disk group or extending/increasing the size of ACFS file system diskgroup

Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to support all customer files. The Oracle ASM Dynamic Volume Manager (Oracle ADVM) provides volume management services and a standard disk device driver interface to clients.

In this scenario We assume that disks have been formated by udev utulity.

So here We go

Read the rest of this entry »

One of our customer want to check their rman backup can be restore or not. As you know Oracle RMAN utility which you can try Verification whole backup, controlfile and so on.

While I am making this scenario I faced with below error message:

Starting restore at 19-AUG-20
using channel ORA_DISK_1
RMAN-00571: ================
RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================
RMAN-03002: failure of restore command at 08/19/2020 23:13:41
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 2 with sequence 26302 and starting SCN of 24674954085 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 26301 and starting SCN of 24674835189 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 26300 and starting SCN of 24674673364 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 26299 and starting SCN of 24674438135 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 26298 and starting SCN of 24674341864 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 26297 and starting SCN of 24674135281 found to restore
Read the rest of this entry »

As you know Oracle has new naming convention. Before start Let us check current Release and Support Timelines.

Now here is the details

Read the rest of this entry »

You may face with that error while you are working with dblink. Sometimes, after a remote operation a user wants to close the connection to the remote site to conserve resources.

Formal details lets look at the oerr:

ORA-02080, 00000, "database link is in use"
Cause: a transaction is active or a cursor is open on the database link given in the alter session close database link  command.
Action: commit or rollback, and close all cursors




 Read the rest of this entry »		

One of our customer need to decreased server RAM from 128Gb to 32 Gb.

After closing database, We rebooted server. While server trying to open it gave below error message:

Read the rest of this entry »

As you know there many oracle process are running as background process.

You may now some of them or you may not. So You can find related process from oracle documentation or you can follow below steps:

Some of Oracle Process:

Read the rest of this entry »