ORA-3136 error and Other errors

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?
umesh4expAsked:
Who is Participating?
 
mganeshCommented:
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
 
umesh4expAuthor Commented:
what about this ORA-3136?
0
 
mganeshCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.