Thursday, February 25, 2010

Listener: Amazing Issue

A part of the Oracle DBMS that "listens" for users connecting to the database. It directs the queries to a function that either creates a dedicated server process for each user or to a shared multithreaded function that handles many users.
File located at ORACLE_HOME\network\admin

If there is 'N' of database at server, but the listener would be common for all the database.At a time there is only listener would be active.

The issue that i face, after creation of database listener.ora file exist with required parameter.
- I am able to connect SQLPLUS,but when I try to connect my client application its unable to connect, how rediculous is it.

start-->cmd-->lsnrctl
lsnrctl> services
LSNRCTL> services


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
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
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MohammadKhub)(PORT=1521)
))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error


it shows the parameter of listener including port, machine,etc and shows error.

and the important this is that i am able to connect with my database:
cmd-->sqlplus sys/sys as sysdba
SQL>


hey......... its an amazing.....

Problem is that i m not able to Oracle Client application that is ODMr.

C:\Users\Mohammad Khubeb>ping MohammadKhub

Pinging MohammadKhub [fe80::cad:1010:a3cf:f945%10] from fe80::cad:1010:a3cf:f945
%10 with 32 bytes of data:
Reply from fe80::cad:1010:a3cf:f945%10: time<1ms
Reply from fe80::cad:1010:a3cf:f945%10: time<1ms
Reply from fe80::cad:1010:a3cf:f945%10: time<1ms
Reply from fe80::cad:1010:a3cf:f945%10: time<1ms
Ping statistics for fe80::cad:1010:a3cf:f945%10:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Mohammad Khubeb>tnsping HD_MohammadKhub
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 24-FEB-2
010 18:38:00
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
C:\oracle_DB\product\10.2.0\db_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name

that an issue to my listener.

then i prepare fresh listener with NCA utility and disabled previous one.

and I check through lsnrctl utility.

start-->cmd-->lsnrctl
LSNRCTL> services

now my Client application is connected to Database server.