1 2 Previous Next 22 Replies Latest reply on Jul 6, 2007 1:43 PM by 586345

    TNS-12560: TNS:protocol adapter error

    586345
      Hello,


      I'm new to linux platform. I have installed oracle xe server in Fedora core 4. The installation is gone smoothly and it is working in that machine.

      I want to connect oracle client(9i) which is running in the windows xp.
      I have added a oracle service using the net manager to the database(XE) running in the linux server.

      But when i trying to connect to that DB it shows TNS-12560: TNS:protocol adapter error.

      I give the ping command to that linux server, It gone smoothly

      C:\>ping 192.168.1.124

      Pinging 192.168.1.124 with 32 bytes of data:

      Reply from 192.168.1.124: bytes=32 time<1ms TTL=64
      Reply from 192.168.1.124: bytes=32 time<1ms TTL=64
      Reply from 192.168.1.124: bytes=32 time<1ms TTL=64
      Reply from 192.168.1.124: bytes=32 time<1ms TTL=64

      Ping statistics for 192.168.1.124:
      Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
      Approximate round trip times in milli-seconds:
      Minimum = 0ms, Maximum = 0ms, Average = 0ms

      When i give the tnsping to that database it shows the same error message:

      C:\>tnsping xe

      TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JUL-20
      07 11:39:59

      Copyright (c) 1997 Oracle Corporation. All rights reserved.

      Used parameter files:
      e:\oracle\ora92\network\admin\sqlnet.ora


      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
      (HOST = 192.168.1.124)(PORT = 1521))) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_
      NAME = xe)))
      TNS-12560: TNS:protocol adapter error

      Could u pls help me to solve this problem?
      Suggestions are Welcome.
        • 1. Re: TNS-12560: TNS:protocol adapter error
          504435
          Not entirely sure, but I believe you need the XE client to connect to an XE database.
          • 2. Re: TNS-12560: TNS:protocol adapter error
            557426
            Check whether the listner of XE database is working properly.

            lsnrctl status
            • 3. Re: TNS-12560: TNS:protocol adapter error
              586345
              How i should check it?
              any command in linux or oracle xe?

              If any Pls tell me
              • 4. Re: TNS-12560: TNS:protocol adapter error
                557426
                Try the bellow command in command line....

                [Oracle@DBTEST ]$ lsnrctl status

                and check for the status ......

                if it's not up , u can use the following command to start the listner.

                [Oracle@DBTEST ]$ lsnrctl start

                Message was edited by:
                Prasad De Alwis
                • 5. Re: TNS-12560: TNS:protocol adapter error
                  586345
                  Hi to all,
                  This is the output when i checked my listener control status.
                  Could u please, tell me what is the problem? and solution for this problem.

                  [root@oracle-xe server]# lsnrctl status

                  LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-JUL-2007 09:17:50

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

                  Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 n ot found; No message file for product=network, facility=TNSMessage 1022 not foun d; No message file for product=network, facility=TNSMessage 1023 not found; No m essage file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file fo r product=network, facility=TNSMessage 1024 not found; No message file for produ ct=network, facility=TNSMessage 1025 not found; No message file for product=netw ork, facility=TNSMessage 1040 not found; No message file for product=network, fa cility=TNSMessage 1422 not found; No message file for product=network, facility= TNSMessage 1033 not found; No message file for product=network, facility=TNSMess age 1028 not found; No message file for product=network, facility=TNSMessage 141 5 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
                  Message 1050 not found; No message file for product=network, facility=TNS
                  Message 1050 not found; No message file for product=network, facility=TNS
                  Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
                  Message 1408 not found; No message file for product=network, facility=TNS
                  Message 1411 not found; No message file for product=network, facility=TNS
                  Message 1408 not found; No message file for product=network, facility=TNS
                  Message 1411 not found; No message file for product=network, facility=TNS
                  Message 1408 not found; No message file for product=network, facility=TNS
                  Message 1411 not found; No message file for product=network, facility=TNS
                  Message 1408 not found; No message file for product=network, facility=TNS
                  Message 1052 not found; No message file for product=network, facility=TNS[root@o                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                  • 6. Re: TNS-12560: TNS:protocol adapter error
                    557426
                    Think your Listner is not up. try the following command.

                    oracle@DBTEST]$ lsnrctl start

                    check what is the output from the comand...


                    Then Check the status by giving the bellow comand.

                    oracle@DBTEST]$ lsnrctl status
                    • 7. Re: TNS-12560: TNS:protocol adapter error
                      586345
                      i checked the status of the oracle listener by issuing the command lsnrctl status

                      But its output is the below:

                      [root@oracle-xe ~]# lsnrctl status

                      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-JUL-2007 12:09:40
                      Copyright (c) 1991, 2005, Oracle. All rights reserved.

                      Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1422 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
                      Message 1050 not found; No message file for product=network, facility=TNS
                      Message 1050 not found; No message file for product=network, facility=TNS
                      Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
                      Message 1408 not found; No message file for product=network, facility=TNS
                      Message 1411 not found; No message file for product=network, facility=TNS
                      Message 1408 not found; No message file for product=network, facility=TNS
                      Message 1411 not found; No message file for product=network, facility=TNS
                      Message 1408 not found; No message file for product=network, facility=TNS
                      Message 1411 not found; No message file for product=network, facility=TNS
                      Message 1408 not found; No message file for product=network, facility=TNS
                      Message 1052 not found; No message file for product=network, facility=TNS[root@oracle-xe ~]#

                      Could u help me for this problem?
                      Please.............
                      Suggestions are always welcome...................
                      • 8. Re: TNS-12560: TNS:protocol adapter error
                        557426
                        Hari,

                        Try to Start the listner.....by giving the following comand.

                        oracle@DBTEST]$ lsnrctl start


                        And check the output ...

                        What u have done is again have checked the status ...
                        • 9. Re: TNS-12560: TNS:protocol adapter error
                          561093
                          if you are unable to start the listener then delete and recreate the listener.
                          • 10. Re: TNS-12560: TNS:protocol adapter error
                            586345
                            Hi,
                            When i start the listener, i got the e following output:

                            [root@oracle-xe ~]# lsnrctl start
                            LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-JUL-2007 14:21:12
                            Copyright (c) 1991, 2005, Oracle. All rights reserved.
                            TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS [LISTENER]


                            After that i checking the status of the listener, the output is:

                            [root@oracle-xe ~]# lsnrctl status

                            LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-JUL-2007 14:25:44

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

                            Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1422 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
                            Message 1050 not found; No message file for product=network, facility=TNS
                            Message 1050 not found; No message file for product=network, facility=TNS
                            Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
                            Message 1408 not found; No message file for product=network, facility=TNS
                            Message 1411 not found; No message file for product=network, facility=TNS
                            Message 1408 not found; No message file for product=network, facility=TNS
                            Message 1411 not found; No message file for product=network, facility=TNS
                            Message 1408 not found; No message file for product=network, facility=TNS
                            Message 1411 not found; No message file for product=network, facility=TNS
                            Message 1408 not found; No message file for product=network, facility=TNS
                            Message 1052 not found; No message file for product=network, facility=TNS[root@oracle-xe ~]#



                            So what i do for this ouput, it tells error during execution of that command for giving message to user.
                            • 11. Re: TNS-12560: TNS:protocol adapter error
                              586345
                              Hi,
                              When i start the listener, i got the e following output:

                              [root@oracle-xe ~]# lsnrctl start
                              LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-JUL-2007 14:21:12
                              Copyright (c) 1991, 2005, Oracle. All rights reserved.
                              TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS [LISTENER]
                              • 12. Re: TNS-12560: TNS:protocol adapter error
                                557426
                                I think It's better if u can delete the listner and try to recreate it ..
                                • 13. Re: TNS-12560: TNS:protocol adapter error
                                  586345
                                  Thanks,

                                  But its not working even after i recreated the listener.ora

                                  Please tell me the step to solve it.............................
                                  • 14. Re: TNS-12560: TNS:protocol adapter error
                                    Ian M
                                    Connect as Oracle on your Linux Box.

                                    Then type lsnrctl status

                                    Then type ps -ef | grep lsnr

                                    Show the output of the above and also show us the contents of your listener.ora
                                    1 2 Previous Next