?
Solved

maxuprc, nproc and maxusers

Posted on 2003-03-07
7
Medium Priority
?
1,762 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
6 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
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.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
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, 16 hours left to enroll

621 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