This discussion is archived
1 2 3 Previous Next 34 Replies Latest reply: Feb 15, 2013 9:37 AM by sb92075 Go to original post RSS
  • 30. Re: ORA-12154:TNS:could not resolve the connect identifier specified
    adf009 Explorer
    Currently Being Moderated
    On which machine are you executing 'lsnrctl'=client machine,I've never seen an instance named SID=its an example i remove for security
  • 31. Re: ORA-12154:TNS:could not resolve the connect identifier specified
    EdStevens Guru
    Currently Being Moderated
    ADF112 wrote:
    On which machine are you executing 'lsnrctl'=client machine,
    As stated earlier, the listener is a server process. It has no meaning on the client machine.

    I've never seen an instance named SID=its an example i remove for security
    Yet you posted the output of lsnrctl, showing a fully qualified host name and supported service names.

    If I have to post output from my system, I first put it all in Notepad, then do a global replace on the sensitive bits, but I do it in such a way that it is obvious what I've done and is consistent. For example, if an IP address is present, I will mask the first 3 octets, so it looks like '***.***.***.123' Server names get changed to 'mydbserver' or 'mydbserver.mydomin' Everyone then understand exactly what I've done and doesn't get side tracked thinking I've blindly copied an example into my system without replacing 'example' values with real/correct values.
  • 32. Re: ORA-12154:TNS:could not resolve the connect identifier specified
    adf009 Explorer
    Currently Being Moderated
    Hi i have insatll oracle developer suite 10gr2 in my machine ,am windown 7 64 bit, my problem is when i connect through my IDE am geting this error TNS-12514: TNS:listener does not currently know of service requested in connect descriptor, but am able to connect with sql*plus without a problem,

    Edited by: adf009 on 2013/02/15 7:25 PM

    Edited by: adf009 on 2013/02/15 7:36 PM
  • 33. Re: ORA-12154:TNS:could not resolve the connect identifier specified
    EdStevens Guru
    Currently Being Moderated
    adf009 wrote:
    Hi i have insatll oracle developer suite 10gr2 in my machine ,am windown 7 64 bit, my problem is when i connect through my IDE am geting this error TNS-12514: TNS:listener does not currently know of service requested in connect descriptor, but am able to connect with sql*plus without a problem,

    Edited by: adf009 on 2013/02/15 7:25 PM

    Edited by: adf009 on 2013/02/15 7:36 PM
    see: [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
    see: [url http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/] Help! I can’t connect to my database (part duex)
    see: [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154 TNS:could not resolve the connect identifier specified
    see: [url http://edstevensdba.wordpress.com/2011/02/27/tnsping-101/] tnsping-101
    see: [url http://edstevensdba.wordpress.com/2011/03/19/ora-12514/] ora-12514
    see: [url http://edstevensdba.wordpress.com/2011/03/05/ora-12545/] ora-12545
    see: [url http://edstevensdba.wordpress.com/2011/07/30/exploring-the-local_listener-parameter/] exploring-the-local_listener-parameter 
  • 34. Re: ORA-12154:TNS:could not resolve the connect identifier specified
    sb92075 Guru
    Currently Being Moderated
    adf009 wrote:
    Hi i have insatll oracle developer suite 10gr2 in my machine ,am windown 7 64 bit, my problem is when i connect through my IDE am geting this error TNS-12514: TNS:listener does not currently know of service requested in connect descriptor, but am able to connect with sql*plus without a problem,

    Edited by: adf009 on 2013/02/15 7:25 PM

    Edited by: adf009 on 2013/02/15 7:36 PM
    ORA-12514 ALWAYS only occurs due to a problem on DB Server system.
    One cause of this problem is when the Oracle database is down & needs to be started.
    A remote client send a request to the Listener asking to be connected to a specific service.
    If/when the listener does not know anything about that service, the listener responds with ORA-12514

    post results from the following two OS commands:
    lsnrctl status
    lsnrctl service

    Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.

    This line contains valuable debugging details. So post this line & surrounding lines.

    for additional debugging suggestions read the URL below:
    http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
1 2 3 Previous Next

Legend

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