7 Replies Latest reply: Mar 23, 2013 5:52 AM by Billy~Verreynne RSS

    UTL_TCP port range

    998630
      Database 11.2.0.3
      LINUX 6.4 64BIT

      When we use UTL_TCP to connect to a remote host from server_abc or server_xyz, do you know what local port(s) on the server_abc/server_xyz server is used to make the connection?

      Thanks
        • 1. Re: UTL_TCP port range
          sb92075
          995627 wrote:
          Database 11.2.0.3
          LINUX 6.4 64BIT

          When we use UTL_TCP to connect to a remote host from server_abc or server_xyz, do you know what local port(s) on the server_abc/server_xyz server is used to make the connection?

          Thanks
          which ever port you specify
          TYPE connection IS RECORD (
              remote_host    VARCHAR2(255),
              remote_port    PLS_INTEGER,
              local_host     VARCHAR2(255),
              local_port     PLS_INTEGER,
              charset        VARCHAR2(30), 
              newline        VARCHAR2(2),
              tx_timeout     PLS_INTEGER,
              private_sd     PLS_INTEGER);
          • 2. Re: UTL_TCP port range
            998630
            how can i find port which UTL_TCP using?.
            • 3. Re: UTL_TCP port range
              Catch_22
              Check the "netstat" command or try (as root) "lsof -i TCP:port", where port is the destination port number. It will show you the dynamic local (outgoing) port used to establish the connection.
              • 4. Re: UTL_TCP port range
                998630
                i got that error

                ORA-29260: network error: not connected
                ORA-06512: at "SYS.UTL_TCP", line 231
                ORA-06512: at "SYS.UTL_TCP", line 460
                ORA-06512: at "TGPLDBA.UTIL_HTTP", line 411
                ORA-29260: network error: TNS:no listener
                • 5. Re: UTL_TCP port range
                  998630
                  Can anyboddy reply to this post...
                  • 6. Re: UTL_TCP port range
                    sb92075
                    my car won't go.
                    tell me how to make my car go.

                    since we don't know exactly what you do, we can't say what you do wrong.
                    Do you have error of commission or error of omission?


                    How do I ask a question on the forums?
                    SQL and PL/SQL FAQ


                    what problem are you REALLY trying to solve?
                    • 7. Re: UTL_TCP port range
                      Billy~Verreynne
                      995627 wrote:
                      i got that error

                      ORA-29260: network error: not connected
                      ORA-06512: at "SYS.UTL_TCP", line 231
                      ORA-06512: at "SYS.UTL_TCP", line 460
                      ORA-06512: at "TGPLDBA.UTIL_HTTP", line 411
                      ORA-29260: network error: TNS:no listener
                      The last message in the error stack (typically the root cause) says that your TCP client connection attempted to connect to a target (IP address and TCP port) that is not accepting TCP client requests.

                      This can be because the remote server is not running the service on the server port your code attempts to connect to. This can be because of a firewall issue.