Error: Failed to download metadata for repo ‘ol8_baseos_latest’ Linux Rhel8 and Oracle linux 8

Oracle linux 8 Error

19 February 2020   0 Comment

I encountered a problem with yum repository problem on Oracle linux 8, you can produce a solution by doing the following operations. It can also cause the following issues. Incorrect date and time settings Old dnf cache available or expired Proxy address not defined or proxy address specified in /etc/dnf/dnf.conf file is incorrect cd /etc/yum.repos.d […]

Read More

How to use the Oracle Data Guard Switchover Operations

oracle dataguard

16 February 2020   0 Comment

Dataguard Switchover is a planned role change. In other words, it is the transition of the live database to the standby role and the standby database to the live role. We may be doing Dataguard switchover for testing the functionality of our backup database, doing maintenance work in our live database, etc.Dataguard Switchover operation can […]

Read More

Cloning an Oracle Real Application Cluster(RAC) Database Software Home

Oracle Software

6 February 2020   0 Comment

In this post we will demonstrate how to create the Oracle RAC Database Software Clone manually, add them to the respective clone.pl script on Oracle Full Rack Exadata Compute Node. Create a tarball of the source home Node1 cd /u01/app/ orcl /product/orcl_12201tar zcvf /u01/app/ orcl /orcl .tar Node2 cd /u01/app/ orcl /product/orcl_12201tar zcvf /u01/app/ orcl […]

Read More

Exadata and Exalogic Elastic Cloud IB Ports State Shown as Down Along with Infiniband Switch Ports Status Showing AutomaticHighErrorRate Message

Oracle Exadata Troubleshooting

5 February 2020   0 Comment

In the Exadata and Exalogic Elastic Cloud racks, you may see issue of IB ports showing status as “Down” when running “ibstat” command. This issue can of happen on Compute Nodes,İnifiniband Switch or Storage heads. IB port being down on Compute Node can be confirmed by running below command [root@xc000xc-ibb01 ~] # listlinkup Connector 0A […]

Read More

How to fix ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’

How to fix Oracle

28 January 2020   0 Comment

While working on an Oracle ASM instance, we may encounter a spfile creation error like the one below. SQL> create pfile=’/u01/ora/inittkitest3.ora’ from spfile; create pfile=’/u01/ora/inittkitest3.ora’ from spfile * ERROR at line 1: ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’ ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 […]

Read More

Oracle Exadata Storage Cell Rescue Using the internal Flash Drive

Oracle Exadata Troubleshooting

17 December 2019   0 Comment

While working on the Exadata Storage cell insert, the attachment failed due to the internal USB drive in the storage cell. Oracle uses the internal USB drive to automatically back up the Exadata Storage cell. We do not have to back up the storage cell manually. In this article, I will show you how to […]

Read More

Celldisk and Griddisk are Not Created Automatically on Oracle Full Rack Exadata Cell Node

Oracle Exadata Troubleshooting

9 December 2019   0 Comment

In this post we will demonstrate how to create the Cell Disk and Grid disks manually, add them to the respective ASM Disk Group on Oracle Full Rack Exadata Cell Node. The Exadata Machine is expected to be up and running and the storage cell containing the failed drive to boot and be available. If […]

Read More

Big DBA as one of the Top 100 Oracle Blogs on the web.

BigDBA is on the Top 100 Oracle Blogs list.

8 December 2019   0 Comment

Today I received an email from Anuj Agarwal, founder of Feedspot .Thank you for your attention. I will try to be worthy. BigDBA is on the Top 100 list. For detailed list; https://blog.feedspot.com/oracle_blogs/

Read More

How to configure yum server in Oracle linux 5,6,7

redhat-oracle-linux

6 December 2019   0 Comment

In this article, we will learn how to congure yum server in dierent Oracle Linux versions. YUM repository is a software package manager which allows you to easily install, update or delete RPMs. Most of the required RPM packages come along with the Linux installer CD. But! if you have internet connection, you can congure […]

Read More

ORA-01565: ERROR IN IDENTIFYING FILE – ORA-01031: insufficient privileges startup

How to fix Oracle

5 December 2019   0 Comment

The solution for Oracle Database insufficient privileges generic error is as follows. [grid@testdb1 ~]$ srvctl start asm; [grid@testdb1 ~]$ crsctl stat res -t SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file ‘+DATA/ORCL/PARAMETERFILE/spfileORCL.ora’ ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora […]

Read More