I'm getting a very strange problem. All of aa sudden i'm encoutered with this error both on the server and on the client sides also.and i'm still getting this. The strange part is we are having two machines with same OS and DB and the same setup, very thing quite similar. But we facing this error on only one machine, other is working fine, both are production machines.
Please look into the errors.
Our OS is linux 7.1 , Oracle 9.0.1.
All of a sudden i'm getting
ORA-12500: TNS:listener failed to start a dedicated server process" and kicked out of oracle. " This is on client side, either sqlplus session or TOAD.
and also, On server side, i'm getting this error.
[oracle@cmsprod1 41dbexport]$ sqlplus
SQL*Plus: Release 188.8.131.52.0 - Production on Mon Sep 2 00:47:32 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: devlcms
ORA-12547: TNS:lost contact
At this point of time, i'm also getting,
"[oracle@cmsprod1 41dbexport]$ exp help=y
Segmentation fault (core dumped)"
Any one can help me please. Our LD_LIBRARY_PATH is not set on both the machines. But one is working fine and the other is not.
Originally posted by pnrdba Hi,
Ours is a dedicated server. We already did a re-installation of oracle S/W. But again getting the same problem. The other machine is working fine.
Waiting for your reply
Thanks in advance
Pls do post the following details. sort_area_size, sort_area_retained_size, no. of sessions connected to Oracle at the time of error, your sga statistics, paging space, no. of processes connected to server at the tome of error. Pls check for the msgs in "errpt" (aix version, don't know about Linux) and post the details. This looks like more of OS level problem.