How can one connect to an Exadata? In our example we will assume a half rack Exadata, which means that at the database layer we have a 4-node database RAC.
At the server side, we need to install a local listener on each database node. So we have 4 listeners "listening" for Exadata connections.
At the client side we assume the so-called "Local Naming Method" for name resolving, which simply means that we have at the client side a tnsnames.ora file with an appropriate tns entry. But what should be an appropriate tns entry for connecting to our Exadata?
At the server side, we need to install a local listener on each database node. So we have 4 listeners "listening" for Exadata connections.
At the client side we assume the so-called "Local Naming Method" for name resolving, which simply means that we have at the client side a tnsnames.ora file with an appropriate tns entry. But what should be an appropriate tns entry for connecting to our Exadata?