I have installed Oracle 10g on Windows XP SP2. I have also disabled Windows Firewall, which is part of SP2, because I have heard that Oracle doesn't run with Windows Firewall.

I have Mcafee Personal Firewall 2005 running, but I disabled it, too; however, I'm having the same problem. 

This is the tnsnames.ora file:
SNOOPY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = neptune)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Snoopy)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

This is the listener.ora file:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:oracleproduct10.1.0Db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = snoopy)
      (ORACLE_HOME = C:oracleproduct10.1.0Db_1)
      (SID_NAME = snoopy)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = neptune)(PORT = 1521))
  )

This is the problem: 
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:Documents and SettingsBashar Fakhry>cd C:oracleproduct10.1.0Db_1BIN

C:oracleproduct10.1.0Db_1BIN>lsnrctl start LISTENER

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 09-MAR-2005 11:02
:54

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

Failed to start service, error 3.
TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error
  32-bit Windows Error: 3: No such process
Can you tell me in detail what I have to do to overcome this problem?

    Requires Free Membership to View

    Login

Which version of Windows XP are you running? Oracle is only supported on Windows XP Pro. There have been many reported network problems on Windows XP Home.

I've received the same TNS-12560 error starting the listener when I've been connected to the database server through Remote Desktop. The solution is to either connect to the database server directly or to start the Listener service with the following command: 

net start OracleTNSListener
You will have to look up the exact name of your Listener's service in Control Panel. My example uses the service name "OracleTNSListener."

This was first published in May 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top