Q
Problem solve Get help with specific problems with your technologies, process and projects.

Getting error when trying to connect to listener

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?
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."

Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close