Skip to content

Root Fan

Oracle & Postgresql DBA Blog

  • Home
  • Contact
  • About
  • Index
  • Services

Category: Oracle

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 14 Page 15 Page 16 … Page 18 Next page

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • Oracle Exadata vs ExaCC vs ExaCS
  • How to Read an AWR Report in Oracle
  • Oracle 19c Data Guard Configuration Step by Step

Recent Posts

  • How to Install ora2pg on Ubuntu and Run a Migration Assessment Report
  • Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples
  • Oracle to Postgres Migration: CO Schema Issues and Fixes
  • Oracle to Postgres Migration Step by Step: The SH Schema (Partitions, Materialized Views, Bitmap Indexes)
  • ora2pg Migration Example: Oracle HR Schema to PostgreSQL

Categories

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

EN
EN
ES FR

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