Question: When trying to connect to Oracle, I
get these errors?
limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit
DEC OSF/1 AXP Error: 28: No space left on
What is the TNS-00510 error?
Answer: : The
oerr utility shows this for the TNS-00510 error:
Internal limit restriction exceeded
Cause Too many files or
sockets open simultaneously or some other resource has been depleted
Action For further details, trace the
operation for protocol details.
As we see, the AXP Error: 28 No space left
on device is a clue, probably a shortage of "swap" disk.
See here, how to
add swap disk for Oracle.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.