Cause The flash_recovery_area is full. SQL>  archive log list; Database log mode Archive Mode Automatic archival Enabled Archive...

Step 1. Is listener version compatible to the database Check if you are using compatible listener version for your database version. If...

Prepare the disks For OCR or voting disk addition or replacement, new disks need to be prepared. Please refer to Clusteware/Gird...

Oracle Error: ORA-1157 An ORA-01157 is issued whenever Oracle attempts to access a file but cannot find or lock the file. Error...

To show system-wide shared memory allocations, use the following command: # ipcs -ma T        ID    KEY    MODE      OWNER  GROUP CREATOR...

Troubleshooting Steps What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area...

# chedition -l <– Shows what you have # chedition -x <– Sets to Express # chedition -s <– Set to Standard

Actually, you can fix it without un-mounting /usr or rebooting. Here’s how: mkdir /temproot mount / /temproot chmod a+rx /temproot/usr...

Symptoms When attempting to connect to a RAC service name, the connection intermittently fails with an ORA-12545 error:  TNS: Host or...

PURPOSE This note lists what to collect for different type of Oracle Clusterware and Real Application Cluster issues, it’s not mandatory...

Scope This document is intended for Clusterware/RAC Database Administrators and Oracle support engineers. Details Start up sequence: In a...