Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to set utl_file_dir in RAC

AchyotMay 5 2009 — edited May 5 2009
hello 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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 2 2009
Added on May 5 2009
#general-database-discussions
5 comments
1,593 views