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 processCan you tell me in detail what I have to do to overcome this problem?
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 OracleTNSListenerYou 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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.