Searching by file timestamp Unix/Linux filesystems have three types of timestamp on each file. They are as follows: Access time (-atime): The timestamp when the file was last accessed. Modification time (-mtime): The timestamp when the file was last modified. Change time (-ctime): The timestamp when the metadata for a file (such as permissions or […]
Archives for March 2019
“-bash: firewall: command not found” – How to resolve in CentOS/RHEL 7
The Problem Why is the below error observed when the firewall-cmd –state command is executed: -bash: firewall: command not found The Solution If there is a syntax error while executing the command, one may get the error of the following sorts :- # firewall-cmd -state usage: see firewall-cmd man page firewall-cmd: error: unrecognized arguments: -state […]
Which SPFILE Parameter File is Impacted when Issuing an ALTER SYSTEM Command
Question: You maintain several SPFILE files: $ ls -l spfile* -rw-r—– 1 sme dba 2560 Mar 20 08:20 spfile.ora -rw-r—– 1 sme dba 2560 Mar 20 08:20 spfileRel14.ora Which one is modified when you run the “ALTER SYSTEM” SQL command to permanently change parameter values in the spfile? The DBAs must be cautious when using […]
How to Modify spfile in Oracle Database
SPFILE: The Server Parameter File Beginning with Oracle9i, Oracle introduced the concept of the server parameter file. This file, known as SPFILE , differs from the standard INIT.ORA file in a number of ways: It is a binary file, rather than a text-based file. It is stored on the server, rather than on a client […]
Beginners Guide to Monitoring Oracle Database Restore/Recovery Progress
In an production environment, it is a common task to take backup and restore it using RMAN. So it is important to know the Tips and techniques for monitoring a restore/recovery operation and determine whether it is indeed working, slow or hung. In general, a restore should take approximately the same time as a backup, […]
Auditd Messages Are Filling Up /var/log/messages
The Problem On the server audit messages are filling-up /var/log/messages file with debug information: type=1101 audit(1431535584.561:3): user pid=2428 uid=0 auid=4294967295 ses=4294967295 subj=kernel msg=’PAM: accounting acct=”root” : exe=”/bin/su” (hostname=?, addr=?, terminal=console res=success)’ type=1105 audit(1431535584.634:4): user pid=2428 uid=0 auid=4294967295 ses=4294967295 subj=kernel msg=’PAM: session open acct=”root” : exe=”/bin/su” (hostname=?, addr=?, terminal=console res=success)’ type=1103 audit(1431535584.646:5): user pid=2428 uid=0 auid=4294967295 […]
How to Ignore/Disable Specific auditd Logging Entries
When you enable auditd logging on a Linux system, the generation of logs can be overwhelming. Some customer may want to disable an auditd entries related a specific command/SYSCALL. For example, below entries are being logged by auditd ( /var/log/messages ) type=CWD msg=audit(1464664627.639:1858714): cwd=”/u01/app/oracle/emagent/12.1.0.3/agent_inst/sysman/emd” type=PATH msg=audit(1464664627.639:1858714): item=0 name=”/u01/app/oracle/emagent/12.1.0.3/agent_inst/sysman/emd/upload/upload/stream0/” inode=17910851 dev=fc:03 mode=040740 ouid=1000 ogid=1001 rdev=00:00 type=PATH […]
How to find Which Process Is Killing mysqld With SIGKILL or SIGTERM on Linux
To determine which process is sending the signal to mysqld, it is necessary to trace the signals through the Linux kernel. Two options to do this are: the audit log (auditd) systemtap Each of these methods will be discussed in the following sections. Audit Log The audit log is simple to set up, but does […]
12c ASM: PRCR-1001 : Resource ora.proxy_advm Does Not Exist (Flex ASM with Cardinality = ALL)
The Problem This a RAC cluster configuration composed of 2 nodes. Clusterware was upgrade from 11.2.0.4 to 12.1.0.2 release. And ASM was converted to “Flex ASM” with “Cardinality = ALL”. Validating the “ora.proxy_advm” resource state reports the below error: $ srvctl status asm -proxy -n asmcloud2 -verbose PRCR-1001 : Resource ora.proxy_advm does not exist The […]
How to Convert STANDARD ASM to FLEX ASM in 12C
You can convert an Oracle ASM configuration to an Oracle Flex ASM using ASMCA. This functionality is only available in an Oracle Grid Infrastructure 12c configuration. Before you convert an Oracle ASM configuration to an Oracle Flex ASM, you must ensure the following: Oracle Cluster Registry (OCR) is stored in a disk group. The server […]