ORA-3136 error and Other errors

Posted on 2009-04-19
Last Modified: 2013-12-18
WARNING: inbound connection timed out (ORA-3136)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum

How to resolve this and what is the resolution?
Question by:umesh4exp
    LVL 3

    Accepted Solution

    First, if you are using Oracle 10g, this parameter is for backward compatibility. DB_CACHE_SIZE is the one which you may have to set.

    But, if you want to continue using DB_BLOCK_BUFFERS, then the minimum value is 50.

    You may need to set this parameter either in the pfile or the spfile and do a database bounce.

    For example, ALTER SYSTEM SET DB_BLOCK_BUFFERS=2048 scope spfile;  and then a database restart.


    Author Comment

    what about this ORA-3136?
    LVL 3

    Assisted Solution

    I can suggest the following:
    1. Recreate the listener and try connecting again
    2. See if there is a network delay
    3. Provide the contents of sqlnet.ora, sqlnet.log file and alert.log file (specific to the time of error) so that more analysis could be done

    Could you let us know when exactly do you get this error?

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to recover a database from a user managed backup

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now