1 2 3 Previous Next 34 Replies Latest reply: Feb 15, 2013 11:37 AM by sb92075 Go to original post RSS
      • 30. Re: ORA-12154:TNS:could not resolve the connect identifier specified
        Tshifhiwa
        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
          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
            Tshifhiwa
            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
              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
                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