Monthly Archives: January 2024

Cloning Tables Between Databases in SQL Server Using Export and Import Functions

Overview: Cloning tables between databases in SQL Server can be efficiently achieved through the use of the built-in export and import functions. This process involves exporting data from the source…

Read More

INSTALLATION OF OEM 13.5 USING SILENT METHOD IN ORACLE DATABASE 19.3 ON LINUX.

OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used for integrated solution for managing your heterogeneous environment. It Includes, Graphical console, Agents, Common Services and Tools to provide…

Read More

Workspace login is not working

Issue: When user was trying to login Apex with workspace login, getting error like below. Solution:   Need to login Apex as Admin user. Click on Manage Workspaces>Manage Developers and…

Read More

Error while accessing Apex URL

Issue: Getting 503 Service Unavailable error while trying to access Apex front end URL. The username or password for the connection pool named |apex||, are invalid, expired, or the account…

Read More

BACKUP USING SQL SERVER AGENT 

In this blog post, we will explore the process of scheduling and taking a backup of a SQL Server database using the SQL Server Agent method.   Firstly, log in to…

Read More

BACKUP USING MAINTENANCE PLAN 

 In this blog post, we will explore the process of scheduling and taking a backup of a SQL Server database using the SQL maintenance plan method.  Firstly, log in to…

Read More

Smart Flash Log Write-Back in oracle exadata

Smart Flash Log Write-Back Let us go through what is Smart Flash Log Write-Back in oracle exadata. On High Capacity Oracle Exadata Storage Servers, all redo log entries must be…

Read More

Upgrading Oracle database from 12.1.0.2 to 19.20 using AutoUpgrade tool

This blog aims to support DBAs upgrading databases from 12.1.0.2 to 19.20 using the new AutoUpgrade tool. Oracle Database AutoUpgrade is the supported and recommended method for upgrading Oracle database.…

Read More

LPX-00202: could not open opmn.xml

Recently we faced the below issue in fsclone. I have given the solution for it to resolve it. Issue: cat FSCloneApplyAppsTier_12210307.log ERROR: RC-50410: Fatal: OUI Registration failed with an Abnormal…

Read More

Converting a Non-CDB to PDB using remote cloning method

This blog aims to support DBAs in converting a Non-CDB database to a PDB using remote cloning method. Note: Non-CDB and target CDB are on different hosts (both on-premises) Create…

Read More