Solved

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

Posted on 2008-06-19
4
610 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 73

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

Suggested Solutions

Title # Comments Views Activity
Oracle - Query Insert and Update multiple tables 5 58
Raid 6 or Raid 10? 19 138
ORA-01008: not all variables bound. 6 38
Oracle SQL syntax check  without executing 6 38
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…
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
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…
Via a live example, show how to take different types of Oracle backups using RMAN.

864 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

25 Experts available now in Live!

Get 1:1 Help Now