database | Vinicius DBA

ORA-12514 when using TNS entry for SCAN_LISTENER

Hi everyone, Hope you all are doing great! It’s been a while since my last post. Well, today I’m going to share about an issue you all can get it when using RAC. This issue happened on September 2024, client was running on 19.24 version….

Vinicius, 3 months ago 0 3 min read

Administration, Database

How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views

Hi everyone, Hope you’re doing good! Ensuring high availability of your Oracle databases is crucial for maintaining optimal performance and meeting Service Level Agreements (SLAs). Oracle Enterprise Manager (OEM) provides a comprehensive way for monitoring and managing database uptime. With that said, I received a…

Vinicius, 10 months ago 0 4 min read

Administration, Database

How to Efficiently Export a Large List of Tables with DataPump

Hi everyone, hope you’re doing good! I’m a member of a WhatsApp Group in Brazil for DBAs (not only Oracle), and one of the members asked about how to export a large list of tables with DataPump. This question may sound a little bit basic,…

Vinicius, 10 months ago 0 3 min read

RAC

Oracle RAC Database Backup: Backup Scheduling on All Nodes

Hey all, Hope you are safe and healthy during pandemic. This post can be very simple for some people, but, it will be useful to another ones. Some weeks ago a client had asked for our support. Their issue was with a cluster node that…

Vinicius, 5 years ago 0 3 min read

Tag: database

ORA-12514 when using TNS entry for SCAN_LISTENER

How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views

How to Efficiently Export a Large List of Tables with DataPump

Oracle RAC Database Backup: Backup Scheduling on All Nodes

About

Blog recognized by:

Disclaimer

Find

Archive

Blogs I Follow

Links

Visitors