Mir Sayeed Hassan – Oracle Blog

How to Configure TNSNAMES.ORA in Oracle on Linux, Windows, and using SQL Developer

The TNSNAMES.ORA file is a key Oracle configuration file that maps service names to connection details, allowing clients to connect to database servers. Proper configuration is essential for DBAs, developers, and administrators.

Here are some alternative...
Read more..

Configuring Disks for Oracle ASM Storage Setup in Oracle database 19C

Overview: 

The disk configuration is a major step when setting up Oracle ASM (Automatic Storage Management) in Oracle Database 19c. ASM provides an efficient way to manage database storage by organizing disks into disk groups, improving...
Read more..

Oracle 19c Standalone Database Patching high level steps: Upgrade from 19.3 to 19.20.

Steps to Perform Before Patch Implementation

Here demonstrates the complete patching process across three phases:

• Pre-Patch

• Patching 

• Post-Patch

Let...
Read more..

Database Switchover was successful but the temporary tablespace got failures, why this issue happen

Before proceeding to this process, create the database outage for both the primary and standby databases.

Disable all the database jobs in both primary and standby database., check if the database jobs are running or schedules by crontab jobs or any other...
Read more..

How to use the flashback operation in Oracle database 19c

Check the status of database

SYS> select name, open_mode, version from V$instance, v$database;

NAME        OPEN_MODE     VERSION
------------------------------------
ORA19CDB   READ WRITE    19.0.0.0.0

Check flashback is enable or not.

SYS> select flashback_on from...

How to export the data of Physical standby database (DataGuard) using the network link.

Note: Consider your production database has primary and standby database, during the business hours it is not recommend to take the export of data from the primary database due to the performance issue might occur., Therefore we can perform the export of data from the Physical...
Read more..