How to update CRS with TNS_Admin location
There needs to be 2 TNS admin locations on our server. One location u02 for one database X and another u01, a default location set on server level, for the remaining databases. My servers .profile automatically sets the location to u01(default locn) when I login. Now the requirement is such that we need to setup a unique TNS_ADMIN location for X database i.e., if I set the env for the database X it should automatically consider tns-admin location as u02 and not the u01 given in .profile. I believe this can be done by CRS. If yes then which file do I need to udpate the tns admin location for database X? How can we update the CRS to set TNS_ADMIN different for X database? Using Srvctl command ? Appreciate your help and thanks in advance !