Load balancing will need to be disabled on both the client side (in tnsnames.ora) and the server side.
One example of how to do this is below:
- Use the ALTER SYSTEM statement to dynamically alter your Oracle Database instance. For example:
SQL> show user
USER is "SYS"
SQL> alter system set remote_listener ='';
After you do this, you will need to restart the Applications Manager processes with stopso and startso commands so that connections will go to only one RAC node.
BEWARE: While this is an example of one way to disable load balancing, an Oracle Database Administrator should always be consulted to make sure it is done correctly.
- Back up and edit the init.ora file for each instance in the RAC setup and remove only the REMOTE_LISTENER lines. Do not remove any other lines. This will require a restart of Oracle instances and Applications Manager processes.
Fix Status: No Fix