Yearly Archives: 2024

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

SETUPAWS CERTIFICATE TO SEND E-MAIL

SETUPAWS CERTIFICATE TO SEND E-MAIL    Download the certificates from the link provided by Amazon. Click on PEM Copy the text. Create five certificate file using notepad with extension .crt. Move…

Read More

Enabling Database management and Operation insights in OCI console

Enabling Database management and Operation insights in OCI console   Enabling Database Management: Navigate to the Observability & Management. In the Observability & Management, under Database Management section select the…

Read More

Create and Assigning the Bank Account to the Supplier in Oracle Apps 11i

This Document will explain the steps to create Supplier Bank account and assign the supplier to the Bank account in Oracle Apps 11i. In Payables, you can define external banks…

Read More