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?
Srini Chavali wrote: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.
One option you have is to create a separate ORACLE_HOME for this one instance - use the clone capabilities in OUI
As Ed noted, better and more robust alternatives exist