How to Add User to OSDBA Group
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
Enterprise Linux
How to Check Group of OSDBA
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
How to Resolve ORA-27040: file create error, unable to create file
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 ORA-27040: file create error, unable to create file
How to Resolve dd: invalid number
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
How to Resolve "No ADR base is set"
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"
How to Resolve PRVG-1017 : NTP configuration file
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-1017 : NTP configuration file
How to Resolve PRVG-11250 Error Message
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
How XFS Grow File System
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
How to Delete Old Audit Files in Oracle
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 »How to Delete Old Audit Files in Oracle
Where is Oracle SPFILE Location
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