Skip to content

Root Fan

Oracle & Postgresql DBA Blog

  • Home
  • Contact
  • About
  • Index
  • Services

Author: Fernando

Posted on October 2, 2020April 4, 2022

How to Fix Oracle RAC Resource Unknown State

white clouds

Quite often you can get Oracle RAC resources in an unknown state and this is quite annoying because you won't be able to use srvctl to manage that resource, to start and stop them.

There is a way to fix it and I'm going to show you how I solved that in a 2 node Exadata RAC.

Let's first check a resource that is in an unknow state:

Continue reading “How to Fix Oracle RAC Resource Unknown State”
Posted on September 22, 2020April 4, 2022

How to Check PDB Status in Oracle

black and teal mountain

Sometimes a PDB is in a wrong status, like the MIGRATE status if you have just made an upgrade.

The best way to check the status is to execute this query from the CDB

Continue reading “How to Check PDB Status in Oracle”

Posts pagination

Previous page Page 1 … Page 25 Page 26 Page 27 … Page 38 Next page

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle Exadata vs ExaCC vs ExaCS
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • Oracle 19c Data Guard Configuration Step by Step
  • Top 7 Oracle Wait Events Explained

Recent Posts

  • The Complete Oracle-to-PostgreSQL Data Type Mapping Guide
  • PostgreSQL Tools List: The Essential Stack for Production DBAs
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • 5 Oracle to PostgreSQL Migration Projects That Failed (And Why)
  • Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

Unmissable posts

  • The Complete Oracle-to-PostgreSQL Data Type Mapping Guide
  • PostgreSQL Tools List: The Essential Stack for Production DBAs
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle Exadata vs ExaCC vs ExaCS
  • The Complete Oracle-to-PostgreSQL Data Type Mapping Guide
  • PostgreSQL Tools List: The Essential Stack for Production DBAs
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • 5 Oracle to PostgreSQL Migration Projects That Failed (And Why)
  • Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

EN
EN
ES FR

  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress