Solved

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

Posted on 2008-06-19
4
618 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

More or less everybody in the IT market understands the basics of Networking, however when we start talking about Storage Networks, things get a bit dizzier, and this is where I would like to help.
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

734 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