Home » RDBMS Server » Server Utilities » Listener problem
Listener problem [message #70190] Sat, 27 April 2002 04:33 Go to next message
Manas
Messages: 5
Registered: March 2002
Junior Member
dear friends
I am having a proble with oracle listener .I am abl eto connect to oracle in server but not from any cleint machine nor can i connect my VB application to oracle database.

it says following error

Test Connection failed beacause of an error in intializing provider[[Microsoft]][[ODBC driver for oracle]][[oracle]] ORA-12154:TNS: could not resolve service name

when the listener is started the following erros are comming:
lsnrctl>start
Failed to start services, error2
TNS-12547: TNS: lost contact
TNS-12560: TNS: protocol adapter error
TNS-00517: TNS: lost contact
32 bit windows error : 2: No such file or directory.
lsnrctl>staus
Connecting to <ADDRESS=<PROTOCOL=IPC><KEY=PNPKEY>>
TNS-12224: TNS: no listener
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: TNS: no listener
32 bit windows error : 2: No such file or directory.
Re: Listener problem [message #70246 is a reply to message #70190] Fri, 10 May 2002 23:23 Go to previous messageGo to next message
Sreedhar
Messages: 30
Registered: March 2000
Member
Hi Manas..

Give you're Oracle spec is it Personal or Entp..

did you configured the Listener file..
did you'r clients have tnsnames.ora file..

tell me if you don't know the path.. check doc for more details...

Thanks
-Sreedhar
Listener problem [message #72973 is a reply to message #70190] Fri, 02 January 2004 05:26 Go to previous message
S Jeyabalaji
Messages: 1
Registered: January 2004
Junior Member
Hi,
We have the following problem with TNS Listener. Whenever we try to connect to the DB, the TNSLSNR.EXE fails, giving the foll. error message:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=iflexserver-FRA)(PORT=15
21)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory

The database is installed on Windows 2000, Oracle 9.2.0.1

Thanks,

Regards,
Jeyabalaji.
Previous Topic: will hourly export affect the system performance?
Next Topic: Transfer of Data from Informix to Oracle
Goto Forum:
  


Current Time: Tue Dec 24 20:00:59 CST 2024