I am an Oracle DBA and I have a question regarding Oracle 9i RAC database. We have two nodes that are concurrently accessing the same database in a RAC environment on Sun boxes, and we have a total of 300 users. 100 users out of 300 are connected to node1 and the rest of the users are connected to node2. Here we want to use the RAC feature to call (availability) Transparent Application Failover (TAF). Our primary node is node1 and the secondary node is node2. In case node1 fails, then those users who were accessing the database through node1 can access the database through node 2 by using the TAF feature. So please tell me, should I configure the TAF parameters in tnsnames.ora on each client workstation so they can access the database without any interruption? Or is there any other efficient way to do that?
As far as I know, the TAF parameters must be defined in all tnsnames.ora files that are required to access the database and instances. This means that any clients accessing your system will require these parameters defined in their tnsnames.ora files. If there is a more efficient way of doing this, I am not aware of it.
Dig Deeper on Oracle database installation, upgrades and patches
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
I'm getting errors while installing the Database Configuration Assistant.
Can I use /var/opt/oracle/oratab to specify listener information?