Oracle - How do we setup SQL*Net for RAC? posted by
Babu Kunwar
How do we setup SQL*Net for RAC?
You should really be on Oracle 7.0.15.4 or higher to use SQL*Net
Steps:
-
Set up TNS_ADMIN in the environment to specify a directory where the
configuration files will be kept. Ensure all users have this environment
variable set.
-
Set up the listener.ora and tnsnames.ora files and configure the init.ora file to include the MTS parameters.
-
Start the listener as lsnrctl start
-
Shutdown and startup the database to pick up the init<SID>.ora changes.
-
Check the server of the running database: lsnrctl services.
-
After this check the shared and dedicated connections.
The TNSNAMES.ORA file identifies services available from the machine. On our
instance here we will describe all databases that the server has mounted. The
listener.ora file contains the descriptions of the services that other machines
are allowed to connect to and any configuration that is required for the server
listener. It contains sections for the listener name, listener address,
databases served by the listener and configuration parameters.
|
