3 Replies Latest reply: May 23, 2013 3:18 AM by 974366 RSS

    Oracle 11g database Listening Port

    974366
      Hi,

      It can allow only 127.0.0.1 through this port that is localhost.
      "TCP 127.0.0.1:1521 0.0.0.0:0 LISTENING" how can i create one more IP LISTENING port. I want to access my db using ip address without(localhost) Kindly help.

      The below format:
      TCP 0.0.0.0:1521 0.0.0.0:0 LISTENING


      Thanks.
        • 1. Re: Oracle 11g database Listening Port
          EdStevens
          971363 wrote:
          Hi,

          It can allow only 127.0.0.1 through this port that is localhost.
          What is the "it" that you are referring to?
          "TCP 127.0.0.1:1521 0.0.0.0:0 LISTENING" how can i create one more IP LISTENING port. I want to access my db using ip address without(localhost) Kindly help.

          The below format:
          TCP 0.0.0.0:1521 0.0.0.0:0 LISTENING


          Thanks.
          Assuming linux, on the databse server, show us:
          cat /etc/hosts
          • 2. Re: Oracle 11g database Listening Port
            Billy~Verreynne
            971363 wrote:

            It can allow only 127.0.0.1 through this port that is localhost.
            "TCP 127.0.0.1:1521 0.0.0.0:0 LISTENING" how can i create one more IP LISTENING port. I want to access my db using ip address without(localhost) Kindly help.

            The below format:
            TCP 0.0.0.0:1521 0.0.0.0:0 LISTENING
            This endpoint, +0.0.0.0+, listens on port 1521 on all IP addresses of that platform. Including any new dynamically created IPs. Including localhost. The socket parameter is called INADDR_ANY - lots of info available on it (use your favourite search engine).

            To bind an Oracle listener to a specific IP, use that specific IP address (dotted format). Do not use the hostname, as the listener by default interprets it as an INADDR_ANY option.

            As for not wanting to use localhost.. why not? What are the reasons for this? It cannot be a network security issue.
            • 3. Re: Oracle 11g database Listening Port
              974366
              Hi Billy Verreynne,

              I can figure it out the issue. Thanks for your support.