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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 624
  • Last Modified:

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

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
silviall
Asked:
silviall
  • 2
1 Solution
 
dragos_craciunCommented:
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
 
silviallAuthor Commented:
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
 
dragos_craciunCommented:
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
 
sdstuberCommented:
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now