Useful Commands and Information

ASM

• Check Space Usage in ASM
• Extending and Adding ASM Datafiles
• How to Manage the Local Cluster Registry

RAC and CRS

• Stopping and Start the RAC Stack
• SRVCTL Commands
• RAC Interconnect Port Configurations for Switches

UNIX

• Useful Find Commands
• How to Generate a Random Number
• Conditional Operators
• Number Manipulation on Linux
• Dtrace Guide From http://www.brendangregg.com (opens in a new window)
• Unix Monitoring
• How to Encrypt and Password Protect a Linux File
• How to Add a Swap File to Redhat v7
• How to set up a service on Redhat v7
• How to Colour Echo Commands
• How to Clear the Screen if a Script is being Run Interactively

SQL and SQLPLUS

• Using Autotrace
• Useful Sysdate Formats
• Connecting to a Pluggable DB as SYSDBA
• Using GV$ Cursor

General Database

• Shrinking Lobs
• Useful RunInstaller Flags
• Proxy Access
• Useful Diagnostics Commands