- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle TNS listener
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
тАО10-05-2004 11:10 PM
тАО10-05-2004 11:10 PM
Oracle TNS listener
(CONNECT_DATA=(SERVICE_NAME=speks)(CID=(PROGRAM=)(HOST=appspek1)(USER=as9i))
) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.32.31.4)(PORT=53742)) * establish * speks * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNSrotocol adapter error
TNS-00510: Internal limit restriction exceeded
HPUX Error: 11: Resource temporarily unavailable
16-SEP-2004 11:01:45 *
(CONNECT_DATA=(SERVICE_NAME=speks)(CID=(PROGRAM=)(HOST=appspek1)(USER=as9i))
) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.32.31.4)(PORT=53789)) * establish * speks * 0
What seems to be the problem? Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2004 11:16 PM
тАО10-05-2004 11:16 PM
Re: Oracle TNS listener
Listerner is not started,
login as oracle user
oracle> lsnrctl
lsnrctl> status
shows the error which you have posted
lsnrctl> start
will start listener
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2004 11:43 PM
тАО10-05-2004 11:43 PM
Re: Oracle TNS listener
Maybe there is a problem with the kernel parameters. Put the ones recommended by Oracle, and if this it's already done try to increase the NPROC above the Oracle's recommnedation of 4096.
Regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2004 12:43 AM
тАО10-06-2004 12:43 AM
Re: Oracle TNS listener
"Check the processes parameter in the init
set to the number of background processes plus one for each connection to the
database.
If the init
increase the Unix kernel parameters for the maximum number of processes or
users.
Check the manual for the Unix operating system that you are using for the
correct parameters. Care should be taken when modifying these parameters.
Save a copy of the original file version before making changes. "
Also check the NFILES kernel parameter as well as the number of available semaphores (with ipcs -ca).
mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2004 01:18 PM
тАО10-06-2004 01:18 PM
Re: Oracle TNS listener
Users are trying to connect to the database but are failing with the following errors listed in the listener log:
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
OS Error: 11: Resource temporarily unavailable
The following might help to fix the problem.
OS kernel parameters reaching their limits can be a cause of this error. In HP UX, increae the OS limit of maximum files that can be opened at a time. It is down to the number of file descriptors allowed in the Oracle user.
Another solution could be to setup your MTS so you can increase the amount of concurrent connections using shared server processes.
May be increasing the max user processes.
Other possible areas to check is MEMORY, SWAP, PROCESSES
Check the UNIX system for available swap space. Verify swap space has not filled up. Also verify any other filesystems are not close to full capacity.
Attached is a document which briefly describes the above errror codes and their reasons / meaning.
I hope this helps.
Indira A