Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle TNS listener

Edward Tan Jr.
Occasional Contributor

Oracle TNS listener

We are using HP server rp7410 with O/S HP-UX version 11i and our database is running Oracle 9i. The oracle has unlimited users. We found out that only 70 users can access to the Oracle application. Beyond the 70 users, errors appeared as shown below:

(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
4 REPLIES
Ravi_8
Honored Contributor

Re: Oracle TNS listener

Hi,

Listerner is not started,

login as oracle user
oracle> lsnrctl
lsnrctl> status

shows the error which you have posted
lsnrctl> start
will start listener
never give up
Pedro Cosmen
Valued Contributor

Re: Oracle TNS listener

Hello Edward,

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 Greene_1
Honored Contributor

Re: Oracle TNS listener

From Oracle's web site:

"Check the processes parameter in the init.ora file. Processes should be
set to the number of background processes plus one for each connection to the
database.

If the init.ora processes parameter seems fine, it might be necessary to
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
the future will be a lot like now, only later
Indira Aramandla
Honored Contributor

Re: Oracle TNS listener

Hi Edward,

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
Never give up, Keep Trying