1 2 3 Previous Next 34 Replies Latest reply: Jan 28, 2013 4:54 AM by Udo RSS

    Remote Connection Help

    985865
      I can connect to the XE database from the same computer (Fedora) but I can't get to it from a remote computer on the same network. What settings am I missing on either the server or client side? What should I check first?
        • 1. Re: Remote Connection Help
          asahide
          Hi,

          Could you show us what error occured?
          What should I check first?
          tnsping from remote node.

          Regards,
          • 2. Re: Remote Connection Help
            985865
            http://s13.postimage.org/q2tdd5w87/Capture.png

            This is what happens in SQL developer when i try to connect.
            • 3. Re: Remote Connection Help
              985865
              asahideO wrote:
              Hi,

              Could you show us what error occured?
              What should I check first?
              tnsping from remote node.

              Regards,
              I got TNS-12535, timed out. The command I issued was tnsping 192.168.1.135, the IP where xe is.
              • 4. Re: Remote Connection Help
                asahide
                HI,

                Could you put client's "tnsnames.ora", And server's output of "lsnrctl services" and listener.ora file?

                tnsping use netservice name, not IP address.
                tnsping "netservice name"
                Regards,
                • 5. Re: Remote Connection Help
                  985865
                  Client tnsnames.ora

                  dbconnection =
                  (DESCRIPTION =
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(Host = 192.168.1.135)(Port = 1521))
                  )
                  (CONNECT_DATA =
                  (SERVICE_NAME = XE)
                  )
                  )


                  Server lsnrctl services

                  [brandon@brandon-Linux ~]$ lsnrctl services


                  LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 21-JAN-2013 18:06:28


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


                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))

                  Services Summary...

                  Service "PLSExtProc" has 1 instance(s).

                  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

                  Handler(s):

                  "DEDICATED" established:0 refused:0

                  LOCAL SERVER

                  Service "XE" has 1 instance(s).

                  Instance "XE", status READY, has 1 handler(s) for this service...

                  Handler(s):

                  "DEDICATED" established:6 refused:0 state:ready

                  LOCAL SERVER

                  Service "XEXDB" has 1 instance(s).

                  Instance "XE", status READY, has 1 handler(s) for this service...

                  Handler(s):

                  "D000" established:0 refused:0 current:0 max:1022 state:ready

                       DISPATCHER <machine: brandon-Linux, pid: 3157>

                  (ADDRESS=(PROTOCOL=tcp)(HOST=brandon-Linux)(PORT=56812))

                  The command completed successfully


                  listener.ora

                  # listener.ora Network Configuration File:


                  SID_LIST_LISTENER =

                  (SID_LIST =

                  (SID_DESC =

                  (SID_NAME = PLSExtProc)

                  (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)

                  (PROGRAM = extproc)

                  )

                  )


                  LISTENER =

                  (DESCRIPTION_LIST =

                  (DESCRIPTION =

                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))

                  )

                  )



                  DEFAULT_SERVICE_LISTENER = (XE)
                  • 6. Re: Remote Connection Help
                    985865
                    issued tnsping dbconnection

                    still timed out
                    • 7. Re: Remote Connection Help
                      asahide
                      Hi,
                      Pls use
                       tag.
                      
                      Regards,                                                                                                                                                                                                                            
                      • 8. Re: Remote Connection Help
                        asahide
                        Is normal ping to 192.168.1.135 OK?
                        No firewall?(no port filtering?)

                        On local node, how did you connect to database? sqlplus user/pass@dbconnect, right?

                        regards,
                        • 9. Re: Remote Connection Help
                          985865
                          reg ping works, no firewall.
                          i used sql developer to connect when I was on the server (Fedora) computer and that works

                          http://s8.postimage.org/avubw4k7p/Capture2.png
                          • 10. Re: Remote Connection Help
                            asahide
                            On local host, Could you try to connect db via TNS?
                            And not sysdba user.

                            Regards,
                            • 11. Re: Remote Connection Help
                              985865
                              There aren't any other users other than sys and system on the database.

                              the tns file doesn't show up in the dropdown in sql develper for Network Alias on the server.

                              Edited by: crench92 on Jan 21, 2013 4:08 PM
                              • 12. Re: Remote Connection Help
                                asahide
                                Try via sql*plus, pls.
                                Or check [ID 119706.1]...


                                Regards,
                                • 13. Re: Remote Connection Help
                                  985865
                                  used sql plus and worked just fine on local computer
                                  • 14. Re: Remote Connection Help
                                    asahide
                                    Hi,

                                    "sqlplus sys/*****@dbconnect as sysdba" OK?
                                    regards,
                                    1 2 3 Previous Next