- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Listener problems on Oracle 9.0.2 on HP ux 11i
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2003 12:06 AM
тАО09-18-2003 12:06 AM
Listener problems on Oracle 9.0.2 on HP ux 11i
I've got a problem on a database, when I launch too many network sessions, I've got this error message:
ORA-12500:
How can I increase the number of network simultaneous connectionsn permitted ?
Thanks in advance for your help
Regards
J??r??me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2003 12:18 AM
тАО09-18-2003 12:18 AM
Re: Listener problems on Oracle 9.0.2 on HP ux 11i
Just check this document attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2003 12:29 AM
тАО09-18-2003 12:29 AM
Re: Listener problems on Oracle 9.0.2 on HP ux 11i
===============================================
oerr ora 12500
12500, 00000, "TNS:listener failed to start a dedicated server process"
// *Cause: The process of starting up a dedicated server process failed.
// The executable could not be found or the environment may be set up
// incorrectly.
// *Action: Turn on tracing at the ADMIN level and reexecute the operation.
// Verify that the ORACLE Server executable is present and has execute
// permissions enabled. Ensure that the ORACLE environment is specified
// correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being
// called may not be installed on the local hard drive. Please check that
// the correct Protocol Adapter are successfully linked.
// If error persists, contact Oracle Customer Support.
===============================================
Odds are -- if you are GETTING an ora-12500 it means your system is way over taxed.
The ORA-12500 -- could be caused by hitting the listener too fast, faster then the OPERATING system itself can deal with. If you are using dedicated server configurations for example, each connection is a unix fork/exec.
If you overload the OS, it won't be able to spawn any new processes. Its not really that you hit the LISTENER too fast in this case, more that the OS is physically out of resources or is taking so long to get these resources in place that we time out. How fast is too fast -- thats a function of your OS, the amount of ram, how many cpu's you have, how fast they are, what else is going on
on the box, etc etc etc...
Do you have processes set correctly? Have you poked about in the logs to see what the underlying issue is exactly?
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2003 12:40 AM
тАО09-18-2003 12:40 AM
Re: Listener problems on Oracle 9.0.2 on HP ux 11i
The server is a 2x650MHz, 4 GB of RAM, I've increased the swap to 4GB, but it is still using a lot of RAM:
swapinfo
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4194304 29360 4164944 1% 0 - 1 /dev/vg00/lvol2
dev 4194304 0 4194304 0% 0 - 1 /dev/vg00/lswap2
reserve - 2553408 -2553408
memory 3165420 2495728 669692 79%
I certainly need to change kernel + orainit parameters ...
Could you help
Thanks in advance
Regards
J??r??me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2003 12:57 AM
тАО09-18-2003 12:57 AM
Re: Listener problems on Oracle 9.0.2 on HP ux 11i
As it seems that there could be many reasons for the error you are getting, have you checked syslog.log to see if there is any more specific information. You don't really want to increase things unless you really need to.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2003 01:22 AM
тАО09-18-2003 01:22 AM
Re: Listener problems on Oracle 9.0.2 on HP ux 11i
processes parameter in the init.ora file.
If that parameter is high enough then I would look into the kernel parameters
maxuprc-->maximum number of user processes
Please revert on the same
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2003 11:55 PM
тАО09-18-2003 11:55 PM
Re: Listener problems on Oracle 9.0.2 on HP ux 11i
Here is the init.ora file, and the maxuprc is 75, then the shmmax 1073741824 ..
Thanks for your help
Regards
Jerome
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2003 04:23 AM
тАО09-19-2003 04:23 AM
Re: Listener problems on Oracle 9.0.2 on HP ux 11i
nproc should be 4096
maxuprc should be ((NPROC*9)/10)
I recommend that you scour the release notes for kernel parameters. They are _very_ important.
-good luck