This discussion is archived
1 2 Previous Next 27 Replies Latest reply: Oct 13, 2012 4:16 PM by EdStevens Go to original post RSS
  • 15. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    database and listner up and running.
    Please post tnsnames.ora for database you try to connect
  • 16. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    922134 Newbie
    Currently Being Moderated
    hi
    tnsnames.ora on standby database server

    # tnsnames.ora Network Configuration File: D:\ORACLE\ORA1020\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    LISTENER_DBMON2.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))




    DBMON2.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = dbmon2.nam.dow.com)
    )
    )

    LISTENER_DBMON1.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))

    DBMON1.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = dbmon1.nam.dow.com)
    )
    )


    LISTENER_USFRPSDOWA080.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))

    LISTENER_DBAMON.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))



    DBAMON.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DBAMON.nam.dow.com)
    )
    )


    LISTENER_DBTmon.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))



    DBTMON.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DBTMON.nam.dow.com)
    )
    )

    LISTENER_PPT93P1.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))

    LISTENER_PPT93P.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    LISTENER_SPEL8D.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    SPEL8D.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT93P.nam.dow.com)
    )
    )

    PPT93P1.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PPT93P.nam.dow.com)
    )
    )

    PPT93P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PPT93P.nam.dow.com)
    )
    )

    RMN04P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa388.dow.com)(PORT = 1587))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = rmn04p.nam.dow.com)
    )


    )

    RPT03P_PRD.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = RPT03P.nam.dow.com)
    )
    )

    LISTENER_RPT03P.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    #RPT03P_STDBY.NAM.DOW.COM =
    # (DESCRIPTION =
    # (ADDRESS_LIST =
    # (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))
    #)
    # (CONNECT_DATA =
    # (SERVICE_NAME = RPT03P.NAM.DOW.COM)
    # )
    #)
    RPT03P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = RPT03P.NAM.DOW.COM)
    )
    )

    RMN02P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa388.dow.com)(PORT = 1587))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = rmn02p.nam.dow.com)
    )
    )

    LISTENER_PPT94P.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    LISTENER_PPT94P1.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))

    LISTENER_SPLNA.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    SPLNA.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT94P.nam.dow.com)
    )
    )

    PPT94P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT94P.nam.dow.com)
    )
    )

    PPT94P1.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PPT94P.nam.dow.com)
    )
    )

    LISTENER_PPT95P.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    LISTENER_PPT95P1.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))

    LISTENER_SPLEU1.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    SPLEU1.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT95P.nam.dow.com)
    )
    )

    PPT95P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT95P.nam.dow.com)
    )
    )


    PPT95P1.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PPT95P.nam.dow.com)
    )
    )

    LISTENER_PPT96P.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    LISTENER_PPT96P1.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))

    LISTENER_SPLPAC.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    SPLPAC.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT96P.nam.dow.com)
    )
    )

    PPT96P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT96P.nam.dow.com)
    )
    )


    PPT96P1.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PPT96P.nam.dow.com)
    )
    )

    LISTENER_PPT97P.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    LISTENER_PPT97P1.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))

    LISTENER_SPLRTIP.NAM.DOW.COM =
    (ADDRESS = (PROTOCOL = TCP)(HOST = eapfrprd01.dow.com)(PORT = 1593))

    SPLRTIP.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT97P.nam.dow.com)
    )
    )

    PPT97P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (CONNECT_DATA =
    (SERVICE_NAME = PPT97P.nam.dow.com)
    )
    )


    PPT97P1.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PPT97P.nam.dow.com)
    )
    )

    RPT03P_STDBY.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = RPT03P_STDBY.nam.dow.com)
    (INSTANCE_NAME = RPT03P_STDBY)
    )
    )

    =====================================================

    tnsnames.ora on primary db

    # tnsnames.ora Network Configuration File: D:\ORACLE\ORA1020\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    LPS05P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa299.dow.com)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = lps05p.nam.dow.com)
    )
    )

    #RMN02P.NAM.DOW.COM =
    # (DESCRIPTION =
    # (ADDRESS_LIST =
    # (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA903.DOW.COM)(PORT = 1587))
    # (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA903.DOW.COM)(PORT = 1588))
    # )
    # (CONNECT_DATA =
    # (SERVICE_NAME = RMN02P.nam.dow.com)
    # )
    # )

    PPT26P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa999)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa999)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ppt26p.nam.dow.com)
    )
    )

    MIS04P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = MIS04P.nam.dow.com)
    )
    )

    DAS13P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DAS13P.nam.dow.com)
    )
    )

    JVEHS01P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.dow.com)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = JVEHS01P.nam.dow.com)
    )
    )

    MDEUP.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 143.219.8.121)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = mdeup.nam.dow.com)
    )
    )

    EHS15P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = EHS15P.nam.dow.com)
    )
    )


    EHS18P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA385-VIP.DOW.COM)(PORT = 1594))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = EHS18P.NAM.DOW.COM)
    )
    )

    DAS12P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DAS12P.nam.dow.com)
    )
    )

    RPT03P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = RPT03P.nam.dow.com)
    )
    )

    MIS03P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = MIS03P.nam.dow.com)
    )
    )

    DBAMON.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.dow.com)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DBAMON.nam.dow.com)
    )
    )

    RMN08P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = downeaprd008-vip.dow.com)(PORT = 1594))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = RMN08P.nam.dow.com)
    )
    )

    RPT06P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = RPT06P.nam.dow.com)
    )
    )

    RPT03P_STDBY.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = RPT03P.nam.dow.com)
    (INSTANCE_NAME = RPT03P_STDBY)
    )
    )

    )

    DOWAUD.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (COMMUNITY = tcpip.dow.com)(PROTOCOL = TCP)(Host = glvt12.nam.dow.com)(Port = 1521))
    )
    (CONNECT_DATA =
    (SID = dowaud)
    (GLOBAL_NAME = dowaud.nam.dow.com)
    )
    )

    LPS06P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = LPS06P.nam.dow.com)
    )
    )

    PRT07P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA935.DOW.COM)(PORT = 1588))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PRT07P.nam.dow.com)
    )
    )

    JVA09P.NAM.DOW.COM =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(Host = jvgrp0.nam.dow.com)(Port = 1587))
    (ADDRESS = (PROTOCOL = TCP)(Host = jvgrp0.nam.dow.com)(Port = 1588))
    )
    (CONNECT_DATA =
    (SID = jva90p)
    (GLOBAL_NAME = jva09p.nam.dow.com)
    )
    )
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(Host = jvgrp1.nam.dow.com)(Port = 1587))
    (ADDRESS = (PROTOCOL = TCP)(Host = jvgrp1.nam.dow.com)(Port = 1588))
    )
    (CONNECT_DATA =
    (SID = jva91p)
    (GLOBAL_NAME = jva09p.nam.dow.com)
    )
    )
    )
    sdn09p.nam.dow.com =
    (DESCRIPTION_LIST =
    (FAILOVER=ON)
    (LOAD_BALANCE=OFF)
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(Host = magrp0.nam.dow.com)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = magrp0.nam.dow.com)(Port = 1526))
    )
    (CONNECT_DATA = (SID = sdn90p)(GLOBAL_NAME = sdn09p.nam.dow.com)
    )
    )
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(Host = magrp1.nam.dow.com)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = magrp1.nam.dow.com)(Port = 1526))
    )
    (CONNECT_DATA = (SID = sdn91p)(GLOBAL_NAME = sdn09p.nam.dow.com)
    )
    )
    )



    codesp.nam.dow.com =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = magrp1-vip.nam.dow.com)(PORT = 1587))
    (ADDRESS = (PROTOCOL = TCP)(HOST = magrp0-vip.nam.dow.com)(PORT = 1587))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = sdn09p.nam.dow.com)
    )
    )


    codesp_old.nam.dow.com =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = magrp0.nam.dow.com)
    (Port = 1521)
    )
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = magrp0.nam.dow.com)
    (Port = 1526)
    )
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = magrp1.nam.dow.com)
    (Port = 1521)
    )
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = magrp1.nam.dow.com)
    (Port = 1526)
    )
    )
    (CONNECT_DATA =
    (SID = sdn09p)
    (GLOBAL_NAME = sdn09p.nam.dow.com)
    )
    )
    DAS13T.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA393.dow.com)(PORT = 1589))
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA393.dow.com)(PORT = 1590))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DAS13T.NAM.DOW.COM)
    )
    )

    RMN02P.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa388.dow.com)(PORT = 1587))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = rmn02p.nam.dow.com)
    )
    )



    DAS12T.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa393.dow.com)(PORT = 1589))
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa393.dow.com)(PORT = 1590))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DAS12T.nam.dow.com)
    )
    )

    JVEHS01P_New.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USMDLSDOWA387-vip.dow.com)(PORT = 1596))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = JVEHS01P.NAM.DOW.COM)
    )
    )
    RPT03T.NAM.DOW.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa393.dow.com)(PORT = 1589))
    (ADDRESS = (PROTOCOL = TCP)(HOST = usmdlsdowa393.dow.com)(PORT = 1590))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = rpt03t.nam.dow.com)
    )
    )



    ===========================================================


    Thanks.
  • 17. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    you need Analyzer for this ... Format it please
  • 18. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    JohnWatson Guru
    Currently Being Moderated
    Come on, man, for the fourth time:
    What is the status of the listener?
  • 19. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    922134 Newbie
    Currently Being Moderated
    hi,

    Below is the lsnrctl status command output on primary database

    C:\Documents and Settings\fglseatora10>lsnrctl status

    LSNRCTL for 64-bit Windows: Version 10.2.0.5.0 - Production on 13-OCT-2012 11:09
    :34

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=USMDLSDOWA935.dow.com)(P
    ORT=1587)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 10.2.0.5.0 - Produ
    ction
    Start Date 13-OCT-2012 06:11:55
    Uptime 0 days 4 hr. 57 min. 39 sec
    Trace Level off
    Security ON: Password or Local OS Authentication
    SNMP OFF
    Listener Parameter File D:\ORACLE\ORA1020\network\admin\listener.ora
    Listener Log File D:\ORACLE\ORA1020\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=USMDLSDOWA935.dow.com)(PORT=1587)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=USMDLSDOWA935.dow.com)(PORT=1588)))
    Services Summary...
    Service "DAS12P.NAM.DOW.COM" has 1 instance(s).
    Instance "DAS12P", status UNKNOWN, has 1 handler(s) for this service...
    Service "DAS13P.NAM.DOW.COM" has 1 instance(s).
    Instance "DAS13P", status UNKNOWN, has 1 handler(s) for this service...
    Service "DBAMON.NAM.DOW.COM" has 1 instance(s).
    Instance "DBAMON", status UNKNOWN, has 1 handler(s) for this service...
    Service "EHS15P.NAM.DOW.COM" has 1 instance(s).
    Instance "EHS15P", status UNKNOWN, has 1 handler(s) for this service...
    Service "JVEHS01P.NAM.DOW.COM" has 1 instance(s).
    Instance "JVEHS01P", status UNKNOWN, has 1 handler(s) for this service...
    Service "LPS06P.NAM.DOW.COM" has 1 instance(s).
    Instance "LPS06P", status UNKNOWN, has 1 handler(s) for this service...
    Service "MIS03P.NAM.DOW.COM" has 1 instance(s).
    Instance "MIS03P", status UNKNOWN, has 1 handler(s) for this service...
    Service "MIS04P.NAM.DOW.COM" has 1 instance(s).
    Instance "MIS04P", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "PRT07P.NAM.DOW.COM" has 1 instance(s).
    Instance "PRT07P", status UNKNOWN, has 1 handler(s) for this service...
    Service "RMN03P.NAM.DOW.COM" has 1 instance(s).
    Instance "RMN03P", status UNKNOWN, has 1 handler(s) for this service...
    Service "RPT03P.NAM.DOW.COM" has 1 instance(s).
    Instance "RPT03P", status UNKNOWN, has 1 handler(s) for this service...
    Service "RPT06P.NAM.DOW.COM" has 1 instance(s).
    Instance "RPT06P", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully


    ==============================================

    lsnrctl status output on satndby database :

    D:\Oracle\ORA10205\BIN>lsnrctl status

    LSNRCTL for 64-bit Windows: Version 10.2.0.5.0 - Production on 13-OCT-2012 10:08:56

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=USFRPSDOWA080-vip.dow.com)(P
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 10.2.0.5.0 - Productio
    Start Date 11-OCT-2012 22:36:41
    Uptime 1 days 11 hr. 32 min. 15 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File D:\ORACLE\ORA10205\network\admin\listener.ora
    Listener Log File D:\ORACLE\ORA10205\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=140.170.125.32)(PORT=1593)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=140.170.125.30)(PORT=1587)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=140.170.125.30)(PORT=1588)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=140.170.125.30)(PORT=1593)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=USFRPSDOWA080.dow.com)(PORT=1593)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "PPT93P.nam.dow.com" has 1 instance(s).
    Instance "PPT93P1", status READY, has 1 handler(s) for this service...
    Service "PPT94P.nam.dow.com" has 1 instance(s).
    Instance "PPT94P1", status READY, has 1 handler(s) for this service...
    Service "PPT95P.nam.dow.com" has 1 instance(s).
    Instance "PPT95P1", status READY, has 1 handler(s) for this service...
    Service "PPT96P.nam.dow.com" has 1 instance(s).
    Instance "PPT96P1", status READY, has 1 handler(s) for this service...
    Service "PPT97P.nam.dow.com" has 1 instance(s).
    Instance "PPT97P1", status READY, has 1 handler(s) for this service...
    Service "RPT03P_STDBY" has 1 instance(s).
    Instance "RPT03P_STDBY", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully



    Thanks.
  • 20. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    sb92075 Guru
    Currently Being Moderated
    Listener Log File D:\ORACLE\ORA10205\network\log\listener.log
    post tail end of listener.log file from above that contains the status code value of 12514 & lines surrounding it.
  • 21. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    922134 Newbie
    Currently Being Moderated
    hi,

    Listner.log on primaryy

    3-OCT-2012 11:29:46 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1502)) * establish * RPT03P * 0
    13-OCT-2012 11:29:49 * (CONNECT_DATA=(SERVICE_NAME=rpt03p.nam.dow.com)(CID=(PROGRAM=D:\Progra?1\Synchro\Sfisc\sfiscm.exe)(HOST=USMDLTDOWS199)(USER=fmas001))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.219.97)(PORT=3763)) * establish * rpt03p.nam.dow.com * 0
    13-OCT-2012 11:29:50 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1505)) * establish * RPT03P * 0
    13-OCT-2012 11:29:51 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1507)) * establish * RPT03P * 0
    13-OCT-2012 11:29:55 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1508)) * establish * RPT03P * 0
    13-OCT-2012 11:30:00 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1516)) * establish * RPT03P * 0
    13-OCT-2012 11:30:05 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1518)) * establish * RPT03P * 0
    13-OCT-2012 11:30:06 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1519)) * establish * RPT03P * 0
    13-OCT-2012 11:30:10 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1521)) * establish * RPT03P * 0
    13-OCT-2012 11:30:12 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1523)) * establish * RPT03P * 0
    13-OCT-2012 11:30:13 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1524)) * establish * RPT03P * 0
    13-OCT-2012 11:30:15 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1527)) * establish * RPT03P * 0
    13-OCT-2012 11:30:20 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1528)) * establish * RPT03P * 0
    13-OCT-2012 11:30:25 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1530)) * establish * RPT03P * 0
    13-OCT-2012 11:30:26 * (CONNECT_DATA=(SID=RPT03P)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.218.200)(PORT=1531)) * establish * RPT03P * 0

    ===============================================================


    listener.log on standby

    (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=RPT03P.nam.dow.com)(INSTANCE_NAME=RPT03P_STDBY)(CID=(PROGRAM=d:\oracle\ora1020\bin\ORACLE.EXE)(HOST=USMDLSDOWA935)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.198.217.85)(PORT=2931)) * establish * RPT03P.nam.dow.com * 12514
    TNS-12514: TNS:listener does not currently know of service requested in connect descriptor



    Thanks
  • 22. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    JohnWatson Guru
    Currently Being Moderated
    At last we can see why it isn't working. Your log_archive_dest_2 is attempting to contact a standby through these details:

    (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = USFRPSDOWA080-VIP.dow.com)(PORT = 1593))) (CONNECT_DATA = (SERVER = DEDI
    CATED) (SERVICE_NAME = RPT03P.nam.dow.com) (INSTANCE_NAME = RPT03P_STDBY)))

    You have a listener on the standby machine listening on these addresses:

    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=140.170.125.32)(PORT=1593)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=140.170.125.30)(PORT=1587)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=140.170.125.30)(PORT=1588)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=140.170.125.30)(PORT=1593)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=USFRPSDOWA080.dow.com)(PORT=1593)))

    Is one of those addresses USFRPSDOWA080-VIP.dow.com ? I assume so, you need to check. But it won't do you any good, because your primary is asking for the service_name RPT03P.nam.dow.com, and your listener is not accepting requests for a service of that name. This could be because your standby is not in fact running. Or it could be a basic configuration error. Which is it?
  • 23. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    922134 Newbie
    Currently Being Moderated
    Hi,

    So what steps i need to follow to resolve it.

    Thanks
  • 25. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    JohnWatson Guru
    Currently Being Moderated
    How about checking whether the standby database is in fact running, either mounted or open read-only? If it isnt, start it. If it is, you have a configuration problem. Which is it?

    You have to work on your problem solving skills, man.

    Edited by: JohnWatson on Oct 13, 2012 6:21 PM
    And, of course, you have to confirm that IP address is correct for that hostname. As I said before.
  • 26. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    You have to work on your problem solving skills, man.
    This is error has been posted for more than 10000000000000000 Times in this forum , Oracle must create new section for this error . but no one use search mechanism
  • 27. Re: ORA-12514:TNS:listener does not currently know of service requested in conn
    EdStevens Guru
    Currently Being Moderated
    919131 wrote:
    Hi,

    So what steps i need to follow to resolve it.

    Thanks
    Not to blow my own horn, but a couple of people have directed you to my explanation and resolution of the reported tns error on my blog at edstevensdba.wordpress.com.

    Please read it. And as you are doing so, keep firmly in mind that in the matter of transporting archivelogs in a DG setup, the primary database is taking the role of the client, and the secondary/failover/dg database is taking the role of the server. Therefore, the only listener that matters is the one on the failiover system. The only tnsnames.ora that matters is the one on the primary system. If you show us the tnsnames from the failover, you are wasting your time and ours. If you show us the listener, either its status or the listener.ora file, from the primary system, you are wasting your time and ours.

    It has already been pointed out that the listener on the standby doesn't know anything about the service requested by the client (the primary server). So you have to ask yourself "why doesn't the listener know about the service being requested.

    Actually, I need to make that more general. On the one side, you specified the server via a host name, on the other side you specified it via the actual ip address. So let me rephrase my previous statement. "The listener at the destination specified in the primary database init parm log_archive_dest_2 doesn't know anything about the service name specified in that parm.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points