Hello and welcome to DBsGuru,I’m Jamsher Khan working as Senior Oracle DBA based in KSA-Jeddah, I have working experience in Oracle DBA, SQL Server, MySql, PostgreSQL, Linux, Golden Gate, ODA.Thanks for the visits!Share Learn Grow!
Solution for ORA-00600: Internal Error Code, Arguments:  [2206} in Oracle In this post we will see How to solve ORA-00600: Internal Error Code, Arguments:  , You can encounter this error in Multitenant Environment (CDB) if your Oracle Database machine was suddenly stopped without proper shutdown command due to some unavoidable problem like Power […]
Oracle Database Appliance Odacli & Odaadmcli Command reference In this blog, we will demonstrate several different usages of odacli, odaadmcli & virsh commands along with some commands output that can be used to administer and manage your Oracle Database Appliance (ODA) with KVM residing in your ODA. ODACLI: It is used for everyday tasks on […]
Solution for Oracle Appliance Manager Console Access Issue in ODA Oracle Appliance Manager Web Console provides a user-friendly interface to monitor ODA hardware and create databases and view job activity. We started to receive the below error while accessing the ODA web console. Follow the below steps to fix the Oracle Appliance Manager Console Access […]
Steps to Install & Configure SNMP in Oracle Linux 7 SNMP (Simple Network Management Protocol) is an internet standard protocol used to remotely retrieve the operational statistics of the servers and infrastructure components. SNMP protocol is implemented on the application layer of the networking stack. It is one of the widely accepted protocols to manage […]
Solution for ORA-01516: nonexistent log file, data file, or temporary file in Oracle In the previous blog, we saw steps to restore RMAN consistent backup using duplicate database command Click here to read more. In this blog, we are going to restore the same consistent RMAN backup using the manual method. With this method we […]
Solution for RMAN-05541: no archived logs found in target database in Oracle In the previous blog, we performed Steps to Clone Oracle Database from Windows to Oracle Linux Click here to read more. The only difference, in this case, we are taking a cold RMAN backup, and since this is a cold rman backup we […]
MySQL major version upgrade from 5.7 to 8.0.30 In the previous blog, we saw MySQL minor version upgrade from 8.0.22 to 8.0.30 Click here to read more In this blog, we are going to perform Major Version upgrade from 5.7 to 8.0.30 using Yum Repository method. MySQL 8.0 have many important performance and security improvements and […]
Access the MSSQL database from PostgreSQL using TDS Foreign Data Wrapper (TDS_FDW) The Tabular Data Source (TDS) Foreign Data Wrapper (TDS_FDW) is a Postgres extension that allows you to access data that resides on an MSSQL database from Postgres Server. TDS_FDW depends on a database access library called FreeTDS. FreeTDS is a set of libraries […]
MySQL minor version upgrade from 8.0.22 to 8.0.29 A minor upgrade is easy to perform just install the new version using the package manager like yum of your distribution. Installing the new version of a package requires the MySQL service to be stopped. In a recent blog, we have installed MySQL Server 8.0.22 using Yum […]
Steps to create Self Signed Server and Client SSL Certificates in Oracle In the previous blog, we discuss in detail about Oracle Wallet Click here to read more. In this blog, we will discuss the steps required to create Self Signed Server and Client SSL Certificates in Oracle. Below are the high-level steps we […]
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.