Listener error not connecting

Posted by Sham on Stack Overflow See other posts from Stack Overflow or by Sham
Published on 2012-12-14T09:29:02Z Indexed on 2012/12/14 11:04 UTC
Read the original article Hit count: 389

Filed under:
|

I have two database running on Port No : 1521.

When i m connecting to ORCL db it get's connected, but when i try to connect to another DB it gives me following error.


    ORA-12514: TNS:listener does not currently know of service requested in connect
    descriptor.

My Listener:


     # listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0   \dbhome_1\network\admin\listener.ora
     # Generated by Oracle configuration tools.

    ADMIN_RESTRICTIONS_LISTENER = ON

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.1.1.1)(PORT = 1521))
    )
   )


    ADR_BASE_LISTENER = C:\app\Administrator

TNSNAMES.ora


     ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.1.1.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
    )

    PARIVARTAN =
    (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.1.1.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = Parivartan)
    )
    )

Lsnrctl Result


     STATUS of the LISTENER
     ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Start Date                14-DEC-2012 14:22:51
    Uptime                    0 days 0 hr. 19 min. 31 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_1\network\a
    dmin\listener.ora
    Listener Log File         c:\app\administrator\diag\tnslsnr\127.1.1.1\listener\al
    ert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.1.1.1)(PORT=1521)))
    Services Summary...
    Service "orcl" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Service "orclXDB" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    The command completed successfully

Reply me soon....

© Stack Overflow or respective owner

Related posts about oracle11g

Related posts about listener