Operating System

Installation Guide on AIX for All Releases of Oracle Database

by Ed Chen
March 23, 2023February 16, 2023

In this post, we collect installation guides on AIX for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »

Installation Guide on Solaris for All Releases of Oracle Database

by Ed Chen
March 22, 2023February 16, 2023

In this post, we collect installation guides on Solaris for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »

Installation Guide on Windows for All Releases of Oracle Database

by Ed Chen
March 21, 2023February 15, 2023

In this post, we collect installation guides on Windows for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »

Installation Guide on Linux for All Releases of Oracle Database

by Ed Chen
March 20, 2023February 15, 2023

In this post, we collect installation guides on Linux for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »

How to Resolve ORA-27302: failure occurred at: skgpspawn3

by Ed Chen
March 13, 2023March 14, 2023

ORA-27302 skgpspawn3 One of RAC instances crashed in the night and we saw ORA-27300, ORA-27301 and ORA-27302 in the alert log before crashing. 2022-11-21T22:28:01.339829-08:00 Process… Read More »

How to Setup Oracle Linux 8 Yum Repository

by Ed Chen
February 23, 2023February 23, 2023

Here are steps to install Oracle Linux 8 yum repository into Red Hat Enterprise Linux (RHEL) derivative or Fedora, in this case, it's AlmaLinux 8.… Read More »

How to Install Oracle Linux 8 Boot ISO

by Ed Chen
February 22, 2023March 2, 2023

First of all, we download Boot ISO image from Oracle Linux repository. In this case, what we downloaded is OL8U7 x86_64-boot.iso. Be noted, the Boot… Read More »

How to Resolve rtld: 0712-001 Symbol CreateIoCompletionPort was referenced

by Ed Chen
January 30, 2023March 13, 2023

After restoring the operating system of an Oracle database server from tape, we saw something wrong. Could not load program sqlplus [oracle@test oracle]$ sqlplus /… Read More »

How to Check DB Status by Script

by Ed Chen
January 27, 2023January 5, 2023

To check if a databae is alive or not, we already have a way to do it. However, such script can't tell NOMOUNT, MOUNT or… Read More »

How to Check if Oracle Database is Running

by Ed Chen
January 26, 2023March 13, 2023

To make sure that an Oracle database is alive, we can use a piece of shell script to check it. [oracle@test ~]$ vi check_database_alive.sh #!/bin/bash… Read More »