OraFAQ Forum: Server Administration » number of connection is exceeded.

Home » RDBMS Server » Server Administration » number of connection is exceeded.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

number of connection is exceeded. [message #63954]

Mon, 29 November 2004 23:58

JoinNepal
Messages: 33
Registered: October 2003

Member

Hi,
I have more than 80 connection in my database and sometimes it displays message like 'number of connection is exceeded....'

what can I do to solve that problem??? and the data execution is slower as I increased the workstations for the Data entry and report retrive...

Well, hope to hear from you soon.

Regards,

Roshan

Report message to a moderator

Re: number of connection is exceeded. [message #63956 is a reply to message #63954]

Tue, 30 November 2004 00:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please post the exact error message.
if it is ORA-00018: maximum number of sessions exceeded
then
Increase the value of the SESSIONS initialization parameter.

Report message to a moderator

Re: number of connection is exceeded. [message #63957 is a reply to message #63956]

Tue, 30 November 2004 00:32

JoinNepal
Messages: 33
Registered: October 2003

Member

well, the message is the same as u sent.
which parameter file I should access and increase the session?
is that init.ora?
Regards,
Roshan

Report message to a moderator

Re: number of connection is exceeded. [message #63958 is a reply to message #63957]

Tue, 30 November 2004 00:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yes.
In initsid.ora

Report message to a moderator

Re: number of connection is exceeded. [message #63959 is a reply to message #63958]

Tue, 30 November 2004 00:59

JoinNepal
Messages: 33
Registered: October 2003

Member

which statement should I access in init.ora

Regards,
Roshan

Report message to a moderator

Re: number of connection is exceeded. [message #63960 is a reply to message #63959]

Tue, 30 November 2004 02:58

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if there are no entries,add an entry.
sessions=YOURVALUE
like
sessions=500

do a clean database shutdown.
start the database using this init< sid >.ora.
if everything works then it is all set.
(if you are in 9i , create an spfile from this pfile,
becuase by default only spfile is used in 9i).

Report message to a moderator

Re: number of connection is exceeded. [message #63967 is a reply to message #63960]

Tue, 30 November 2004 18:17

JoinNepal
Messages: 33
Registered: October 2003

Member

H,
Thanks and I added the value sessions=500 since my sessions are increasing day by day cause of the increase in workstations.
I hope it will work properly.
Thank you.
Regards,
Roshan

Report message to a moderator

Re: number of connection is exceeded. [message #63969 is a reply to message #63960]

Tue, 30 November 2004 20:59

JoinNepal
Messages: 33
Registered: October 2003

Member

Hi,
Why Inactive session is still on the Database??
Is it creating session exceed message?
Regards,
Roshan

Report message to a moderator

Previous Topic:	Selection of Db & Programming Language
Next Topic:	Manual database creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 22:27:06 CST 2025