• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archives for February 2019

How to audit all Commands run on OEL 5,6 using auditd

by admin

Question: How to log every user command executed with or without sudo and forwarding this logs to a central log file? To configure the auditd for logging all user commands please follow the below action plan. 1. Use yum to install the audit package: # yum install audit 2. To start automatically the auditd service […]

Filed Under: Linux, OEL 6

How to change the default permissions on /var/log/audit/audit.log file in CentOS/RHEL

by admin

Question: How to configure auditd to change the default permissions on the /var/log/audit/audit.log from 0600 to 0640 and also changing the group ownership of the file? By default it’s not possible to change permissions on the /var/log/audit/audit.log file using ACLs, instead “log_group” parameter can be set under the file /etc/audit/audit.conf. The Steps In this example, […]

Filed Under: CentOS/RHEL 5, CentOS/RHEL 6, Fedora, Linux

A File Is Claimed to Be Disappearing – How to monitor a file for deletion in Linux

by admin

Question: A file seems to be disappearing and no direct reason for its disappearance can be found. How can we monitor the file access, especially the deletion of a particular file in CentOS/RHEL system? A file can be monitored through its lifecycle by using the Linux auditd service. The Steps 1. To install it on […]

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Fedora, Linux

How to Stop Audit Log Entries Written to System Logs in CentOS/RHEL 6

by admin

This post explains how to stop audit log entries written to system logs. 1. Check the file /etc/audisp/plugins.d/syslog.conf. By default, the file “/etc/audisp/plugins.d/syslog.conf will have the below line. args = LOG_INFO This will allow syslog to log audit logs into /var/log/messages. In addition audit.d will log all the audit events to /var/log/audit/audit.log too and this […]

Filed Under: CentOS/RHEL 6, Fedora, Linux

GUDS – A Script for Gathering Solaris Performance Data

by admin

Whats is GUDS? The GUDS script is a ksh script designed to collect the data needed to analyze performance issues. The script collects a specific set of files and runs a series of operating system utilities, the selection of which are based on the specified level. The duration, number of iterations, and other variables are […]

Filed Under: Solaris

TSPITR fails With RMAN-06553

by admin

The Problem TSPITR fails With RMAN-06553 when the tablespace (using OMF files) is dropped including contents and datafiles: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/22/2015 16:43:08 RMAN-03015: error occurred in stored script Memory Script RMAN-06553: DB_CREATE_FILE_DEST must be set for SET NEWNAME … TO […]

Filed Under: oracle, Oracle 11g, oracle 12c, RMAN

How to Recover A Dropped Tablespace Using TSPITR

by admin

The Basics RMAN automatic Tablespace Point-In-Time Recovery ( TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database. Prior to the 11.2 version, the TSPITR had a restriction of not being […]

Filed Under: oracle, Oracle 11g, oracle 12c

Oracle Tablespace Transport for a Single Partition

by admin

Prior to 11g, there is a restriction on transporting tablespaces for a single partition. Starting in RDBMS version 11g, transport of a tablespace for a single partition and plugging it into another database is now supported. This note shows the process to follow in order to achieve this. Steps 1. Create the partitioned table: SQL> […]

Filed Under: oracle, Oracle 11g, oracle 12c

How To Convert A Partitioned Table To A Non-Partitioned Table Using DataPump In Oracle 11g and 12c

by admin

The Basics A new import DataPump parameter PARTITION_OPTIONS has been introduced with 11g. The allowed values are: NONE – Creates tables as they existed on the system from which the export operation was performed. This is the default value. DEPARTITION – Promotes each partition or subpartition to a new individual table. The default name of […]

Filed Under: oracle, Oracle 11g, oracle 12c

Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN

by admin

This post covers the detailed steps for creating a physical standby database on a normal file system using RMAN for a primary database in ASM. Overview Here the Standby database can be created using the following 2 methods: Normal Restore and Recovery using RMAN. Creating a Duplicate database for Standby using RMAN. Method 1 Perform […]

Filed Under: ASM, oracle, Oracle 10g, Oracle 11g, oracle 12c, RMAN

Next Page »

Primary Sidebar

Recent Posts

  • ncat Command Examples in Linux
  • ncat: command not found
  • nautilus Command Examples in Linux
  • namei: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright