Gnu Screen is a helpful Linux utility which functions as a virtual terminal manager. With it you can manage multiple terminal sessions and detach/reconnect to sessions as needed in your workflow. The virtual terminals will continue to run and insulate you from unexpected disconnections and logouts.

Why?

I need to create a RAC cluster at a client site where they only have a NFS file server device.

To ASM or not ASM?

Options

direct NFS

Option 2 : ASM on NFS

You can make use of ASM with NFS by creating shared files on NFS that will act as Raw devices to ASM.

Note that if you are wanting to schedule a script to run with Cron and execute SQLPLUS, you may have to make the script aware of the user environment variables like this:

#!/bin/sh
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
sqlplus -S perfstat/perfstat @query.sql > outfile.txt

To run a script with Cron automatically: 1) Log in to the OS as the user you want to execute the job. 2) Run "crontab -e" to edit the crontab configuration file 3) Add a line to the configuration file to specify the info about the job. The crontab file is organized like this:

Create new Virtualbox VM

• Adaptor 1 - Nat, ipv4 DHCP, ipv6 disabled, Connected checkbox
• Set Optical drive to Linux 6.7 ISO
• Create 30gb IDE drive, sparsely populated

Start VM for Initial Install

The ISO image will be used for boot up and installation will begin.

• Skip Media check
• Select language, click next.
• Select keyboard, click next.
• Select Basic Storage Devices, click next.

"Master Data versus Reference Data" by Malcolm Chisholm

Reference Data Topics

Wikipedia: Reference Data

RefData Portal

Whitemarsh Approach to Ref Data Management

Why use a Metric Extension?

The Metric Extension is the evolution of the User Defined Metric. Regular UDMs can be used to gather and store data from targets. Repository-side Metric Extensions let you define new metrics/alerts based on information that is in the EM SYSMAN repository schema.

Creating a Metric Extension

In this example we will create a Metric Extension for Data Guard Lag time.

Enable Auditing

-- Run as SYSDBA

-- Enable Auditing
ALTER SYSTEM SET AUDIT_TRAIL=DB SCOPE=SPFILE;
SHUTDOWN IMMEDIATE
STARTUP

Set Auditing Configuration

-- Reset auditing
-- Statements
NOAUDIT ALL; 
-- Privileges
NOAUDIT ALL PRIVILEGES; 
 -- Objects
NOAUDIT ALL ON DEFAULT;
-- Network
NOAUDIT NETWORK;



-- Turn on session auditing LOGON / LOGOFF
AUDIT SESSION;


-- User changes
AUDIT USER;


-- Audit role creation/grants
AUDIT ROLE;
AUDIT GRANT ANY ROLE BY ACCESS;
AUDIT ALTER, GRANT ON DEFAULT;
AUDIT SYSTEM GRANT;

--