how to set utl_file_dir in RAC
AchyotMay 5 2009 — edited May 5 2009hello everybody,
I want to set utl_file_dir parameter in our 2 node RAC environment (24x7)and we are having commomn SPFILE for both these 2 node instances. Since utl_file_dir is a static parameter we need to shut down both the instances to take effect.
I am going to follow the below steps:
1. at node 1
sql>alter system set utl_file_dir='/home/oracle' scope=spfile;
sql>shutdown immediate;
2. at node 2
sql>shutdown immediate;
3.at node 1
sql>startup
4.at node 2
sql>startup
So I want to know whether I am doing right steps or wrong.
With regards
Achyot