Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ORA-3136 error and Other errors

Posted on 2009-04-19
3
Medium Priority
?
3,307 Views
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?
0
Comment
Question by:umesh4exp
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
mganesh earned 1500 total points
ID: 24179022
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.



0
 

Author Comment

by:umesh4exp
ID: 24185375
what about this ORA-3136?
0
 
LVL 3

Assisted Solution

by:mganesh
mganesh earned 1500 total points
ID: 24190667
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?
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

577 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