0 Comments

Oracle Database Appliance Odacli & Odaadmcli Command reference 0 (0)

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 […]

 58 Total Views,  10 Views Today

0 Comments

Solution for Oracle Appliance Manager Console Access Issue in ODA 0 (0)

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 […]

 122 Total Views,  2 Views Today

0 Comments

Solution for ORA-01516: nonexistent log file, data file, or temporary file in Oracle 0 (0)

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 […]

 158 Total Views,  5 Views Today

0 Comments

Oracle Critical Database Patch ID for July 2022 5 (3)

Oracle Critical Database Patch ID for July 2022 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch Update informative. […]

 561 Total Views,  14 Views Today

0 Comments

Steps to create Self Signed Server and Client SSL Certificates in Oracle 0 (0)

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 […]

 270 Total Views,  5 Views Today

0 Comments

Steps to create a Database Link from Oracle to MSSQL Server 0 (0)

Steps to create a Database Link from Oracle to MSSQL Server Nowadays many companies are using a mix of RDBMS systems, for example, some instances are running on Oracle and other instances are running on MSSQL Server, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow us to query data from non-Oracle databases using SQL. In the previous two […]

 351 Total Views,  9 Views Today

0 Comments

Steps to Clone Oracle Database from Windows to Oracle Linux 0 (0)

Steps to Clone Oracle Database from Windows to Oracle Linux In the previous blog, we saw Steps to create a Heterogeneous Dataguard between Windows and Linux Click here to read more. In this blog, we are going to perform a clone of Windows Oracle DB by taking RMAN backup and restoring it to Oracle Linux Server. […]

 324 Total Views,  5 Views Today

0 Comments

How to Find Database Properties in Oracle 0 (0)

How to Find Database Properties in Oracle In this article, we will prepare a script for How to Find Database Properties in Oracle. Using the view DATABASE_PROPERTIES, we can fetch the default values of the database like the default permanent & temporary tablespace, dictionary endian type, character set, global database name, etc. Execute the below […]

 282 Total Views,  1 Views Today

0 Comments

Oracle Critical Database Patch ID for April 2022 5 (3)

Oracle Critical Database Patch ID for April 2022 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch Update informative. […]

 574 Total Views,  1 Views Today

0 Comments

Steps to create a Heterogeneous Dataguard between Windows and Linux 0 (0)

Steps to create a Heterogeneous Dataguard between Windows and Linux Heterogenous Dataguard is a best use case, when we need to perform DB migration from Windows to Linux with minimum downtime as the actual downtime comprises only DB switch. As both Windows and Linux are Little Endian so no conversion is required at the target […]

 372 Total Views,  7 Views Today