12 Replies Latest reply: Dec 28, 2011 11:27 AM by 612857 RSS

    Database connectivity issue from LAN

    612857
      Hi all,
      I have installed Oracle 11g R2, on LAPTOP1(Windows 7 Professional). I have created a database manually. I am able to login to the database and do all my work.
      Now i am trying to connect to the same database from LAPTOP2(Windows 7 professional). in LAPTOP2 i have installed the Oracle Client. LAPTOP1 and LAPTOP2 are in network. in LAPTOP1, i have added exception to the port 1521 in the firewall. from LAPTOP2 i am able to ping LAPTOP1. but i am not able to TNSPING to the Database, which is in LAPTOP1.

      Please kindly help me solve this problem.

      Thank you.
        • 1. Re: Database connectivity issue from LAN
          damorgan
          Try to understand what you have posted from the perspective of someone trying to help you. You wrote:
          but i am not able to TNSPING to the Database, which is in LAPTOP1
          How are we to know what specific error message you are seeing or if your fingers are broken?

          Post the full and complete error message after making sure the TNSNAMES.ORA on the second laptop has an entry for the database.
          • 2. Re: Database connectivity issue from LAN
            NikolayIvankin
            give us errors you recieve
            • 3. Re: Database connectivity issue from LAN
              612857
              I am sorry that i forgot to copy the error message. Here is the error message.

              C:\Users\Name>tnsping FSDMO

              TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 27-DEC-2
              +011 00:33:59+

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

              Used parameter files:
              C:\app\Name\product\11.2.0\client_1\network\admin\sqlnet.ora


              Used TNSNAMES adapter to resolve the alias
              Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCP
              +)(PROTOCOL = TCP)(HOST = 5.23.143.174)(PORT = 1521))) (CONNECT_DATA = (SERVER =+
              DEDICATED) (SERVICE_NAME = FSDMO)))
              TNS-12535: TNS:operation timed out

              C:\Users\Name>
              • 4. Re: Database connectivity issue from LAN
                NikolayIvankin
                disable a firewall for a few minutes and retry, if you'll success - then config firewall.
                • 5. Re: Database connectivity issue from LAN
                  612857
                  Hi Nikolay Ivankin
                  Thanks for the quick response.

                  I have disabled the Firewall in both the laptops and tried again. Here is what i have got.


                  C:\Users\Name>tnsping FSDMO

                  TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 27-DEC-2
                  +011 01:39:30+

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

                  Used parameter files:
                  C:\app\Name\product\11.2.0\client_1\network\admin\sqlnet.ora


                  Used TNSNAMES adapter to resolve the alias
                  Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
                  +(HOST = 5.23.143.174)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVI+
                  CE_NAME = FSDMO)))
                  TNS-12541: TNS:no listener

                  C:\Users\Name>

                  Here are the contents of my sqlnet.ora

                  SQLNET.AUTHENTICATION_SERVICES= (NTS)

                  NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
                  • 6. Re: Database connectivity issue from LAN
                    NikolayIvankin
                    user609854 wrote:
                    TNS-12541: TNS:no listener
                    Then start it :-)
                    • 7. Re: Database connectivity issue from LAN
                      612857
                      Hi Nikolay Ivankin,

                      The listener in server(LAPTOP1) is already started. when i am LAPTOP1 i am able to login to database successfully.
                      Did you mean the Listener in client(LAPTOP2)?

                      Thank you.
                      • 8. Re: Database connectivity issue from LAN
                        NikolayIvankin
                        user609854 wrote:
                        The listener in server(LAPTOP1) is already started. when i am LAPTOP1 i am able to login to database successfully.
                        Show connection string for LAPTOP1, results of:
                        ipconfig /all
                        lsnrctl status
                        Did you mean the Listener in client(LAPTOP2)?
                        no
                        • 9. Re: Database connectivity issue from LAN
                          orafad
                          Note that this forum is about Instant Client - your issue seem to be more of a database connectivity problem, not related or not specific to Instant Client.

                          user609854 wrote:
                          The listener in server(LAPTOP1) is already started. when i am LAPTOP1 i am able to login to database successfully.
                          Sadly that does not prove that listener is started.

                          Please try to show more of what you do and see i.e. copy-paste of command session when you login both successfully and not.

                          Did you mean the Listener in client(LAPTOP2)?
                          Why do you have a listener in the client ?

                          Edited by: orafad on Dec 27, 2011 10:26 AM

                          Edited by: orafad on Dec 27, 2011 10:27 AM
                          • 10. Re: Database connectivity issue from LAN
                            612857
                            Hi Nikolay Ivankin,

                            Here is the ipconfig results.
                            Ethernet adapter Hamachi:

                            Connection-specific DNS Suffix . :
                            Description . . . . . . . . . . . : Hamachi Network Interface
                            Physical Address. . . . . . . . . : 7A-79-05-17-8F-AE
                            DHCP Enabled. . . . . . . . . . . : Yes
                            Autoconfiguration Enabled . . . . : Yes
                            IPv6 Address. . . . . . . . . . . : 2620:9b::517:8fae(Preferred)
                            Link-local IPv6 Address . . . . . : fe80::40f5:7f7e:233e:e37e%18(Preferred)
                            IPv4 Address. . . . . . . . . . . : 5.23.143.174(Preferred)
                            Subnet Mask . . . . . . . . . . . : 255.0.0.0
                            Lease Obtained. . . . . . . . . . : Monday, December 26, 2011 10:27:02 PM
                            Lease Expires . . . . . . . . . . : Wednesday, December 26, 2012 5:43:17 AM
                            Default Gateway . . . . . . . . . : 5.0.0.1
                            DHCP Server . . . . . . . . . . . : 5.0.0.1
                            DHCPv6 IAID . . . . . . . . . . . : 393902393
                            DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-16-75-FC-78-00-0C-29-A9-7A-52

                            DNS Servers . . . . . . . . . . . : fec0:0:0:ffff::1%1
                            fec0:0:0:ffff::2%1
                            fec0:0:0:ffff::3%1
                            NetBIOS over Tcpip. . . . . . . . : Enabled
                            I have Hamachi software to put two laptops in LAN though.


                            Here is the result of lsnrctl status
                            C:\Users\windows7>lsnrctl status

                            LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 27-DEC-2011 09:24
                            :34

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

                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                            STATUS of the LISTENER
                            ------------------------
                            Alias LISTENER
                            Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                            ction
                            Start Date 26-DEC-2011 22:27:14
                            Uptime 0 days 10 hr. 57 min. 21 sec
                            Trace Level off
                            Security ON: Local OS Authentication
                            SNMP OFF
                            Listener Parameter File C:\app\windows7\product\11.2.0\dbhome_1\network\admin\
                            listener.ora
                            Listener Log File c:\app\windows7\diag\tnslsnr\WIN-NJC6G5LOQAN\listener\
                            alert\log.xml
                            Listening Endpoints Summary...
                            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                            Services Summary...
                            Service "CLRExtProc" has 1 instance(s).
                            Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                            Service "FSDMO" has 1 instance(s).
                            Instance "FSDMO", status UNKNOWN, has 1 handler(s) for this service...
                            The command completed successfully

                            C:\Users\windows7>
                            Thank you for all help you are doing.
                            • 11. Re: Database connectivity issue from LAN
                              orafad
                              user609854 wrote:
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                              No remote connectivity possible with localhost.

                              It needs to listen on a routable address.

                              Best options is likely to remove listener.ora and bounce the listener, giving it default workable parameters.
                              • 12. Re: Database connectivity issue from LAN
                                612857
                                Hi Orafad,

                                I have added to the listener.ora as the bolded part.

                                LISTENER =
                                (DESCRIPTION_LIST =
                                (DESCRIPTION =
                                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                                (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
                                *(ADDRESS = (PROTOCOL = TCP)(HOST = 5.23.143.174)(PORT = 1521))*
                                )
                                )


                                I stopped and started the Listener by using the following commands in Command prompt.
                                LSNRCTL STOP
                                LSNRCTL START
                                It is working now. Thank you.

                                Thank you all for your time.

                                Edited by: user609854 on Dec 28, 2011 11:26 AM