1 Reply Latest reply on Sep 27, 2011 5:22 PM by JustinCave

    Restrict Users To Connect Database

    890126
      Dear All,
      Actually I am working in oracle ERP R12 and I want to control users to connect database only invited nodes are connected to database through sqlnet.ora file. I set parameter in sqlnet.ora file below:
      SQLNET.AUTHENTICATION_SERVICES = (NTS)
      TCP.VALIDNODE_CHECKING = YES
      #tcp.excluded_nodes = {list of IP addresses}
      TCP.INVITED_NODES = {172.16.72.63}

      this is working in database but in erp environment this is not working any one please help me!!!

      Regards,
      Muhammad Zubair
      DBA Warid Telecom Pakistan
      00923244509956
        • 1. Re: Restrict Users To Connect Database
          JustinCave
          Can you elaborate a bit on "not working"? What, exactly, is the behavior you're seeing? What is the behavior you expect? Are you getting errors? If so, what errors?

          In the "ERP environment", are users connecting via a client/ server application? Or via a three-tier application? Assuming a three-tier application, are you trying to invite the nodes of the application servers? Or of the end clients (or, potentially, the web servers)?

          Justin