?
Solved

maxuprc, nproc and maxusers

Posted on 2003-03-07
7
Medium Priority
?
1,715 Views
Last Modified: 2013-12-06
I have an Oracle 9.0.1 database in a unix 4.3 server.
The database had a ORA-12500 error.  Looking on support pages there is a mention to look for the numbers of the maxuprc, maxuses and nproc.
There is no /etc/system file.
Where should I look to find those numbers?

0
Comment
Question by:LindaC
[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
7 Comments
 
LVL 8

Author Comment

by:LindaC
ID: 8090482
Yong, when you don't have a tracing on what you see on the listner.log is not meaningful at all.

What about my question...  Where can I find the numbers of maxuprd, maxusers and netproc?
0
 
LVL 8

Author Comment

by:LindaC
ID: 8090805
Ok, I found it, you have to execute the following command:
lsattr -E -l sys0

Compare this to your init.ora process parameter.

Thank you, Me!!!!!!
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Expert Comment

by:bedot
ID: 8098738
it seem a kernel problem being to be recompiled with new parameters maxuprc, maxuses and nproc.
take a look at kernel parameters;
often to read active kernel parameters you can use the sysdef command.
0
 

Expert Comment

by:suprakoma
ID: 8145784
LindaC,

What flavour of UNIX do you use? Solaris, HP-UX, AIX?
(1) For Solaris, edit /etc/system, and reboot mechine.
(2) For HP-UX, use (root) $ sam
(3) For AIX, use (root) $ smit

Does it help?

Regards,
suprakoma
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 10768087
PAQed, with points refunded (20)

CetusMOD
Community Support Moderator
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
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.
Suggested Courses
Course of the Month8 days, 23 hours left to enroll

765 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