On Linux machine, there could be several reasons for this error message appearing in some log file, or on the command line output while executing some command. Most of the time we immediately start checking if our file system has still sufficient space left, but file system space is not the problem most of the time. Following are a few of them I will be discussing.
Tuesday, September 20, 2016
Monday, September 12, 2016
Enable Asynchronous IO for file System using FILESYSTEMIO_OPTIONS
We noticed that on one of our standby database, the log apply was quite
slow. I stopped managed recovery process which showed ORA-16037 in the alert
log file along with trace file name.
ALTER DATABASE RECOVER
managed standby database cancel Fri Nov 20 16:13:12 2015 RFS[2]: Selected log 12 for thread 1 sequence 504809 dbid -1228626264 branch 748801133 Fri Nov 20 16:13:13 2015 |
Subscribe to:
Posts (Atom)
Popular Posts - All Times
-
This error means that you are trying to perform some operation in the database which requires encryption wallet to be open, but wallet is ...
-
Finding space usage of tablespaces and database is what many DBAs want to find. In this article I will explain how to find out space usage ...
-
ORA-01653: unable to extend table <SCHEMA_NAME>.<SEGMENT_NAME> by 8192 in tablespace <TABLESPACE_NAME> This error is q...
-
You may also want to see this article about the ORA-12899 which is returned if a value larger than column’s width is inserted in the col...
-
This document explains how to start and stop an Oracle cluster. To start and stop Grid Infrastructure services for a standalone installatio...
-
If database server CPU usage is showing 100%, or high 90%, DBA needs to find out which session is hogging the CPU(s) and take appropriate ...
-
If you want to know how we upgrade an 11g database to 12c using DBUA, click here . For upgrading 12.1.0.1 to 12.1.0.2 using DBUA, ...
-
By default AWR snapshot interval is set to 60 minutes and retention of snapshots is set to 8 days. For better and precise investigation of...
-
SWAP space recommendation from Oracle corp. for Oracle 11g Release 2 If RAM is between 1 GB and 2 GB, SAWP should be 1.5 times the s...
-
This article explains how to install a 2 nodes Oracle 12cR1 Real Application Cluster (RAC) on Oracle Linux 7. I did this installation on O...