Search this site
Embedded Files
Skip to main content
Skip to navigation
MyShare
Home
Handy Links
Metalink Notes
Metalink Notes Posts
11gR2 Key facts
Changing Miscount for voting disk
FAQ for Products in Extended Support
FAQ- Statspack Complete Reference
How to collect the full path name of the files in ASM diskgroups
How to get full sql text statement from v$sql
How to Recover from OCR corruption without having any backups
How to work out how many of the parse count are hard/soft?
Manually register backuppiece when information about this backuppiece is not in controlfile.
Metalink Notes Updates
OCR Backup Filling Up $ORA_CRS_HOME/CDATA/ Directory
Oracle Service request escalation
RAC and Sequences
RAC/AIX important informations
Untitled Post
Untitled Post
Miscellaneous
Miscellaneous Posts
12c optimizer hidden parameters and fix controls
A quick LogMiner exercise
Archive Logs In 11gR1 Are Written To DB_RECOVERY_FILE_DEST And LOG_ARCHIVE_DEST_1
Autostart Oracle Databases on Linux.
Blocking Sessions
Case Sensitive Passwords in Oracle Database 11g Release 1
Create NON RAC DB in RAC environment using DBCA
CURSOR SHARING similar, force, exact explained
CYGWIN usage to connect via proxy server
Database Growth Month Wise
Database Statistics
Datafile created with Hidden characters
Delete files older than x days in Unix
Example of Standby Site Setup
Export Import Performance Enhancement Tips
Export Import via Pipe
Find Out Latest Patch applied to the Database
Flash Recovery Area Usage
Hexadecimal to Decimal and vice versa conversion
How to analyze Table Fragmentation
How to analyze Tablespace Fragmentation
How to calculate Subnet/Network ID for using while changing Public/Interconnect IP configuration for RAC systems.
How To Convert Your Putty .ppk Private Key To A Normal SSH Key
How to determine no. of CPUs on AIX and LINUX systems
How to determine Oracle Home Name
How to determine platform supporting cross-platform data transport
How to determining the Endian Format of a platform
How to identify Granule Size in Oracle
How to recreate Corrupt Undo Tablespace
How to recreate OraInventory
How to select non-corrupted data from segment with corrupted blocks
Listing Privileges Recursively
Manual Upgrade 10 11gR2 checklist
Match OS process with Oracle Session
MISCELLANEOUS Updates
Monitor Import process
Open Database when Redo log is corrupted
Oracle 10g Flashback versions query
Processes using ports
relative data block address mapping to file_id and object_id
tail -f for windows
To find the most frequently executed SQL
Tracking DDL changes in 11g
Using memory_target parameter in 11g
X11 forwarding and su/sudo
Online Sessions
Friday March 9
March 13 2018, Practical Session
March 16 Chapter Files
Sunday Feb 24 10:00 AM
Sunday March 04
Oracle Events
Oracle Events Posts
Database Internals (Events, Blockdumps)
ORACLE METRICS
PEARLS FOR WISDOM
Q & A
Q & A POSTS
Explain following output in red (DGNEW group# was 3 and now it is 0)
How many OCR and voting disks should one have?
How to check the Properties of CRS resources
How to stop and start RAC DB?
How we can check if asm instance is being used by which db instance.
Is it possible to create failure groups for one diskgroup in some other diskgroup
Is Rebalance operation is invoked at some regular intervals by ASM automatically ?
Q & A Updates
RAC FAQs
RACGMAIN orphan processes accumulating and eating server resources
RAC & ROLL (Readymade Solutions for DBAs)
RAC & ROLL POSTS
ASMCMD connection
Clean Failed CRS installation
Cluster Verify Stages
CRS not started automatically
crs_stat improved output
How to check OCR integrity
How to copy files into and from ASM
How to get TNS entries if you create "services" using srvctl
How to quickly check the member nodes in your RAC cluster system.
How to verify and check Cluster Components
IMPORTANT INFORMATION TO KNOW ABOUT VIPs AND INTERCONNECTs
Mapping ASM Disks with Storage
Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node
RAC & ROLL (Updates)
RAC TIPS RECENT POSTS
RECOMMENDED RAC FILE PERMISSIONS
Relocating VIP address manually
Sequences and Oracle RAC
Set up Bonding for RAC interfaces (For Public and Private network) for Red Hat Enterprise Linux
Untitled Post
Untitled Post
Untitled Post
Untitled Post
RAC for Rookies
RAC for Rookies Posts
11gR2 Deinstall
clean up failed Grid infrastructure installation
Duplication RAC database to Non RAC database
How to check CRS version
How to check health of Oracle Clusterware, or to see if Clusterware is running fine.
How to check if you have a Cluster Database (RAC database)
How to check integrity of Diskgroups
How to find cluster name
How to identify the nodes which are part of cluster
How to monitor free space in ASM Diskgroups
How to restart CRS after node reboot (in case if it is not automatically restarted)
kfed
Log Files in RAC Environment
OCR File and Voting Disk Administration by Example - (Oracle 10g)
RAC for Rookies Updates
RAC Permissions
Recover Corrupt/Missing OCR with No Backup - (Oracle 10g)
Steps to make Oracle Cluster UP after node reboot or after some maintainance
What is the status of ASM instance
RAC TUNING
RAC TUNING POSTS
Idle Wait Events
Instance Recovery and RAC
Query Tuning
RAC Tuning Updates
Scripts
Scripts Posts
Asynchrous I/O determination on AIX
Column Formatting
Display all Long Operations
Five biggest Files in Linux directory
Formated crs_stat -t output
Free memory in AIX
Hidden Undocumented Parameters
How to find SID of your connected session
Index Usage or Nousage
Library cache Locking
Roles and Privileges of User
SCRIPT - to Tune the 'SESSION_CACHED_CURSORS' and 'OPEN_CURSORS'
Scripts Updates
Sessions their current sqls and time since they are executing
Shrink Datafiles
SQL Plan Changes
Undo Tablespace Usage
Windows OS Information
Test Cases
TEST CASES POSTS
Check logical Corruption in Indexes
DISKGROUP BEHAVIOUR
How to disable autostart for some particular CRS resource
How to move database from one diskgroup to another
How to rename directories within the ASM
TEST CASES Updates
Untitled Post
Troubleshooting with Scenarios
Troubleshooting Posts
Detection of Nologging Operations On the Primary or Standby Site
Disk group creation and deletion thereafter
listener process going down as VIP failed to start on primary node. (default gateway being changed or not found)
Memory Target is not supported on this system
Missing Disk in Diskgroup
ORA-00845: MEMORY_TARGET not supported on this system
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
RMAN cloning slow in 10g
TROUBLESHOOTING Updates
Tuning
Tuning Posts
How to monitor parallel query execution ?
Tuning Updates
About Me
MyShare
Scripts Updates
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse