Oracle TNS listener

[Edward Tan Jr.]

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

[Ravi_8]

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

[Pedro Cosmen]

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]

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

[Indira Aramandla]

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