-
RDBMS Version:: Oracle 8161
Operating System and Version:: WinNT 4.0 EE
Error Number (if applicable):: TNS-12540
Hi,
I have configured my oracle backups thru Legato.
Yesterday while taking Online backup, I got the subject error.
Detail of error from sqlnet.log is as below :
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
Time: 23-APR-2002 21:20:42
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12540
TNS-12540: TNS:internal limit restriction exceeded
ns secondary err code: 12560
nt main err code: 510
TNS-00510: Internal limit restriction exceeded
nt secondary err code: 8
nt OS err code: 0
init.ora parameter
processes = 160.
sessions = 190
Please advise.
Regards
Vijay
--------------------------
The Time has come ....
-
U got problem with # of open file descriptors per 1 application (process).
Probably this is internal OS (NT) problem with size of the table of file descriptors.
I know, how i can solve this situation in unix, but not in NT.
-
The error implies that you have hit a limit of some form. This is usually an OS limit that has been reached.
Typical problems are:
- Out of system memory / swap
- Out of process slots in the process table
- Streams resources depleted
- Out of File Handles
Here is info from Oracle :-
Problem Description
-------------------
You are receiving an ora TNS-12540 error intermitently
when trying to make connections to the database. OPS
and MTS are not being used in this configuration.
The error might be:
TNS-12540: TNS:internal limit restriction exceeded
The alert log has an entry that looks like:
skgpspawn failed category 27143
The skgpspawn failed message refers to a failure to spawn
a new session.
Solution Description
--------------------
Performance monitor shows that the instance that that has
the TNS-12540 error occurring is using right around 2gb of
memory. The SGA for the instance is about 1.8gb of memory.
Reconfiguring the SGA to take less memory allows for connections
to be made sucessfully.
The most significant init.ora settings that are a candidate to
to reduce the size of the SGA are:
db_block_buffers
shared_pool_size
java_pool_size
sort_area_size
sort_area_retained_size
Explanation
-----------
Because non Enterprise Windows NT Server limits the amount of memory
used per process to 2gb, the process for the instance could not
allocate more memory for new connections.
References
----------
A Microsoft document that explains what is termed 4GT RAM Tuning can
be found at:
http://support.microsoft.com/support.../Q171/7/93.ASP
Originally posted by vijay8282
RDBMS Version:: Oracle 8161
Operating System and Version:: WinNT 4.0 EE
Error Number (if applicable):: TNS-12540
Hi,
I have configured my oracle backups thru Legato.
Yesterday while taking Online backup, I got the subject error.
Detail of error from sqlnet.log is as below :
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
Time: 23-APR-2002 21:20:42
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12540
TNS-12540: TNS:internal limit restriction exceeded
ns secondary err code: 12560
nt main err code: 510
TNS-00510: Internal limit restriction exceeded
nt secondary err code: 8
nt OS err code: 0
init.ora parameter
processes = 160.
sessions = 190
Please advise.
Regards
Vijay
OCP 8i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|