OSDBA Group In the previous post, we have talked about how to enable an user other than administrator (Windows) or oracle (Linux) to use SQL*Plus… Read More »How to Add User to OSDBA Group
OSDBA or OSOPER OSDBA and OSOPER are just a symbol name defined by Oracle database, users belonged to either group are natively granted to use… Read More »How to Check Group of OSDBA
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 dd: invalid number
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 "No ADR base is set"
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 to Resolve PRVG-11250 Error Message
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 XFS Grow File System
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 »Where is Oracle SPFILE Location