Solved

Error: ORA-20 (There are a lot of connection inactive)

Posted on 2008-06-19
4
617 Views
Last Modified: 2013-12-19
Hello everybody,

I've Oracle 8.1.7. There are 155 connections but 100 are inactive. The program that uses the oracle is a 16 bits program.
The program fails because there is the error ORA-20.

Best regards,

Silvia
0
Comment
Question by:silviall
  • 2
4 Comments
 
LVL 6

Expert Comment

by:dragos_craciun
ID: 21823182
A session has an associated process even if it's not active. (In dedicated server mode)
Besides that, there are a lot of background processes.

You should increase sessions and processes initialization parameters on the server.
0
 

Author Comment

by:silviall
ID: 21823726
The oracle 8.1.7 is in archive mode. Is this a problem?
Every day I restart the oracle services. Is a good practice?
Please If i have to modify the parameter. Tell me step by step. I am beginner.

Best regards,

SilviaLl
0
 
LVL 6

Expert Comment

by:dragos_craciun
ID: 21823856
Archive mode it's not a problem.
Restarting the server every day it's not good as it will flush the SGA. Stop doing this unless you have a real solid reason, which I doubt.
As of version 8.1.7 ... I'm not familiar with it, I worked with 9 and 10 and used the new interfaces to do changes like this.

Maybe post another question on how to change the parameters.
Sorry.

0
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 21824011
create a profile with an idle timeout

here's an example.  This will end sessions that are idle for 15 minutes


CREATE PROFILE KICK_OUT_IDLE_USERS
 LIMIT IDLE_TIME 15;


then set your users to use that profile, or modify the profile they currently have
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

820 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