Re: ORA-12560

  • From: "fahd mirza" <fahd-m@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 24 Aug 2004 13:32:00 +0500

The oracle_sid is set. and also the database in running and its service is
also running.

moreover, I am including the trace file of listener, please see this. and
when I tnsping my database from client side. I get error.
ORA-12535 TNS OPERATION TIMED OUT.

*******
Listener Trace File:
24-AUG-2004 12:07:53 *
(CONNECT_DATA=(SID=AWCdev)(CID=(PROGRAM=C:\orant\BIN\ifbld60.EXE)(HOST=NADEE
M-MIS)(USER=nadeem-k))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=172.0.0.64)(PORT=1556)) * establish * AWCdev *
12500
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error
   32-bit Windows Error: 2: No such file or directory
24-AUG-2004 12:09:03 *
(CONNECT_DATA=(SERVICE_NAME=AWCDEV.AWC.COM)(CID=(PROGRAM=C:\orant\BIN\PLUS80
W.EXE)(HOST=NADEEM-MIS)(USER=nadeem-k))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=172.0.0.64)(PORT=1557)) * establish *
AWCDEV.AWC.COM * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error
   32-bit Windows Error: 2: No such file or directory
24-AUG-2004 12:09:10 *
(CONNECT_DATA=(SERVICE_NAME=AWCDEV.AWC.COM)(CID=(PROGRAM=C:\orant\BIN\PLUS80
W.EXE)(HOST=NADEEM-MIS)(USER=nadeem-k))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=172.0.0.64)(PORT=1558)) * establish *
AWCDEV.AWC.COM * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error
   32-bit Windows Error: 2: No such file or directory
24-AUG-2004 12:11:31 * service_register * AWCDEV * 0
************
regards,
Fahd





----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: