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

678145
I would for first restart node1, and only after node1 is up and running restart node2.
247514
What's your Oracle version?

You should use directory object instead if on 10g and above.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5007.htm#SQLRF01207
Achyot
you want me to do the below steps

1. at node 1
sql>alter system set utl_file_dir='/home/oracle' scope=spfile;
sql>shutdown immediate;
#reboot
sql>startup

2.after starting the node 1 at node 2
sql>shutdown immediate;
#reboot
sql>startup
678145
Achyot wrote:
you want me to do the below steps

1. at node 1
sql>alter system set utl_file_dir='/home/oracle' scope=spfile;
sql>shutdown immediate;
#reboot
sql>startup
No, no, with restart I was meaning oracle restart, not the whole node.
if system is 24x7, then both nodes down is something not allowed. So for first restart instance on node1, and then on node2.
Achyot
ok got it..

Thanks


final steps are:

1. at node 1
sql>alter system set utl_file_dir='/home/oracle' scope=spfile;
sql>shutdown immediate;
sql>startup

2. at node 2
sql>shutdown immediate;
sql>startup

Edited by: Achyot on May 5, 2009 1:14 PM
1 - 5
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,567 views