ROY wrote:case 1
My Local database was runniing fine till last friday. from today itself its suddenly dead.!! Even from Windows services I am not able to start the TNS service of Oracle.
When I checked our Big TNS log then below error logs we are getting. Any help ?
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-APR-2012 15:44:11
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is C:\oracle\network\admin\listener.ora
Log messages written to C:\oracle\network\log\listener.log
Trace information written to C:\oracle\network\trace\listener.trc
Trace level is currently 0
Started with pid=3148
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=A1H-4F039-117Z.sarindia.com)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1004: Unknown error
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))