3 Replies Latest reply: Jan 2, 2013 9:34 AM by EdStevens RSS

    Configuring sqlnet.ora per instance when instances share the same host

    982513
      Hi,

      After upgrading some of our databases to 11.2 which used to be on different machines onto the same new host we realised that one of them had had valid node checking setting with invited nodes list in sqlnet.ora.

      Is it possible that we keep this setting for the instance and keep others outside this configuration?

      Regards,
      Altan
        • 1. Re: Configuring sqlnet.ora per instance when instances share the same host
          EdStevens
          ak1980 wrote:
          Hi,

          After upgrading some of our databases to 11.2 which used to be on different machines onto the same new host we realised that one of them had had valid node checking setting with invited nodes list in sqlnet.ora.

          Is it possible that we keep this setting for the instance and keep others outside this configuration?

          Regards,
          Altan
          No.

          And the use of valid_node and invited_node is pretty lame to begin with. I've always wondered why oracle implemented that in their sqlnet layer at all, since the proper place to do ip filtering is at the router.

          So now you have to ask yourself why one instance -- and not the others -- was using it in the first place. The solution to your dilemma will hinge on the answer to that question. It could be that doing IP filtering for a particular instance was valid. However, the decision to do it at the tns layer was wrong-headed, and then moving that instance to a host with other instances who have different requirements only compounded the original error.
          • 2. Re: Configuring sqlnet.ora per instance when instances share the same host
            Srini Chavali-Oracle
            One option you have is to create a separate ORACLE_HOME for this one instance - use the clone capabilities in OUI

            http://docs.oracle.com/cd/E11882_01/em.112/e12255/oui6_cloning.htm

            As Ed noted, better and more robust alternatives exist

            HTH
            Srini
            • 3. Re: Configuring sqlnet.ora per instance when instances share the same host
              EdStevens
              Srini Chavali wrote:
              One option you have is to create a separate ORACLE_HOME for this one instance - use the clone capabilities in OUI
              I'm afraid that solution will just did the hole even deeper. He'd then have to run two listeners, which brings another load of problems and complexity to the table. Yes, it could be made to work, but is really just compounding a fundamental error.

              http://docs.oracle.com/cd/E11882_01/em.112/e12255/oui6_cloning.htm

              As Ed noted, better and more robust alternatives exist

              HTH
              Srini