Enterprise Linux

How to Resolve ORA-27040: file create error, unable to create file

by Ed Chen
May 18, 2022December 17, 2022

ORA-27040 Tried to add a data file to a tablespace, but it failed with ORA-01119 and ORA-27040. SQL> ALTER TABLESPACE EXAMPLE ADD DATAFILE '/u01/app/oracle/oradata/ORCLCDB/ORCLPDBX/example02.dbf' SIZE… Read More »

How to Resolve dd: invalid number

by Ed Chen
September 6, 2021March 25, 2022

dd: invalid number: ‘1m’ Tried to replicate a partition to another with dd, but it failed with dd: invalid number. Here I initially use 1g… Read More »

How to Resolve "No ADR base is set"

by Ed Chen
August 25, 2021December 21, 2022

No ADR base is set To manage Automatic Diagnostic Repository (ADR), we used to use ADRCI command line to interact with server. Node 1 [oracle@primary01… Read More »

How to Resolve PRVG-1017 : NTP configuration file

by Ed Chen
April 7, 2021January 7, 2023

There're 2 error types of PRVG-1017 in this post. NTP Configuration in Linux NTP Configuration in AIX PRVG-1017 in Linux Found PRVG-1017 which is related… Read More »

How to Resolve PRVG-11250 Error Message

by Ed Chen
October 16, 2020September 25, 2021

PRVG-11250 : The check "RPM Package Manager database" was not performed because it needs 'root' user privileges Saw error PRVG-10467 during the validation check before… Read More »

How XFS Grow File System

by Ed Chen
October 7, 2018November 22, 2022
2 Comments

XFS Grow Initially, I allocated root mount point as 30 GB during OS installation, but now it seems a little small for future growth. So… Read More »

How to Delete Old Audit Files in Oracle

by Ed Chen
May 17, 2018October 8, 2022

ADUMP Cleanup Audit files cannot be deleted like trace files deletion by ADR Command Interpreter (ADRCI), so we need to delete them at OS-level by… Read More »

Where is Oracle SPFILE Location

by Ed Chen
March 29, 2018December 11, 2022

Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora PFILE… Read More »

How Oracle Auto Start Database in Linux

by Ed Chen
March 24, 2018December 11, 2022
4 Comments

For Solaris OS, you should check this post: How to Auto Start Oracle Database on Solaris. Assuming that you already have some knowledge about how… Read More »

Golden Gate Installation and Configuration

by Ed Chen
May 6, 2017March 21, 2023

Suppose that you have two Oracle database 12c installed on the servers. One is for the source database (ora12c1), the other is the target database… Read More »