Warning message inbound connection timed out (ORA-3136) can be seen in the alert log file if a client was failed to authenticate itself within a specified period of time, since connection was initiated first time. sqlne.ora parameter called "SQLNET.INBOUND_CONNECT_TIMEOUT" is used to specify a value in number of seconds, database would
Tuesday, August 19, 2014
Wednesday, August 13, 2014
ORA-01113 when Tablespace is in Backup Mode
On a 9.2.0.4 database, while logging in to the database, it was throwing error "ORA-01033: ORACLE initialization or shutdown in progress". This error means that database is either no-mount or mount state. So I logged in as SYSDBA and tried to open the database.
Thursday, August 7, 2014
Excessive PGA Memory Usage by Sessions and System Hang
In this article I will explain how to handle memory leak by an oracle session process or if because of a bug in a code if an oracle processes consumes all available memory because of growth of PGA. Starting 12c, we can limit the amount of memory to which PGA of an Oracle session can grow. Click here to find out how.
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 ...
-
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...
-
ORA-01653: unable to extend table <SCHEMA_NAME>.<SEGMENT_NAME> by 8192 in tablespace <TABLESPACE_NAME> This error is q...
-
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 document explains how to start and stop an Oracle cluster. To start and stop Grid Infrastructure services for a standalone insta...
-
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... -
In this post I will be demonstrating the steps to upgrade Oracle Grid Infrastructure (GI) 11g (11.2.0.4) to Grid Infrastructure 12c (12.1.... -
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 ...