How do I fix my ORA 12520?
Mia Phillips
Updated on May 02, 2026
The immediate solution was to stop/restart Aleph and Oracle. This # processes needs to be increased to 400 or 800: 200 for (recommended value for a ‘small’ system), 400 for (recommended value for a ‘medium’ system).
Could not find available handler for requested type of server?
This error is related with out of available Oracle processes. If processes parameters are insufficient, then you should increase the PROCESSES parameter as follows. Restart database after this operation.
What is the difference between process and session in Oracle?
So a process is a process and a session is a session. A session eventually needs a process, is not tied to a single process. A process can have zero one or more sessions using it.
Why is Oracle session inactive?
It just means that someone is logged in but not executing SQL right at that instant. Your very own session is “INACTIVE” everytime you are in the process of typing in a query via sqlplus. It is a normal state to be in.
What is difference between session and process in Oracle?
How can I tell if Oracle is running?
On Windows systems, go to Control Panel→Administrative Tools→Services to see whether the Oracle service has started. You can also look under Windows Task Manager to find similar information. On Linux/UNIX systems, simply check for the PMON process. Without PMON, there’s no Oracle database instance running.
What is Oracle inactive session?
It just means that someone is logged in but not executing SQL right at that instant. Your very own session is “INACTIVE” everytime you are in the process of typing in a query via sqlplus.
How do I stop an inactive session in Oracle?
Open the SQLNET ORA file and set the parameter. it is client file so set it in client side. IDLE Connection is set at USER PROFILES, define profile with IDLE_TIME limit so that INACTIVE SESSION killed after the time limit reached. — Need to enable resource limit so it automatic terminate the session.
How do I know if Oracle is installed on Windows?
Follow these steps:
- From the Start menu, select All Programs, then Oracle – HOMENAME, then Oracle Installation Products, then Universal Installer.
- In the Welcome window, click Installed Products to display the Inventory dialog box.
- To check the installed contents, find the Oracle Database product in the list.
What happens to inactive sessions in Oracle?
Inactive sessions will have a low impact unless you exceed the maximum session number. In simple words, an INACTIVE status in v$session means no SQL statement is being executed at the time you check in v$session. You might see such INACTIVE sessions for quite a long time.
