Skip to Main Content

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

fetchdesigns

Perhaps there is a better solution, but what worked for me is (if you are using Windows)...

  1. Click the start button (the windows icon at the lower left of your screen)
  2. Start typing "java" and select "Configure Java" when it appears
  3. Open the "Security" tab
  4. Drag the security setting down to "Medium"

I believe the issue is with the Pitney Bowes certificate conflicting with newer versions of Java.  You may also be able to downgrade your version of Java to get it working, but that may be less secure.  Your call.

fetchdesigns

I was able to resolve this by doing the following (on Windows 7)...

  1. Click the Windows button at the bottom left on your screen
  2. Type "java" and select "Configure Java" when it appears
  3. Open the "Security" tab
  4. Drag the setting down to "medium"

From what I understand the issue is with the Pitney Bowes certificate conflicting with newer versions of Java.  You may also be able to downgrade your version of Java to get it working, but that may be less secure.  Your call.

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

Post Details

Locked on Jun 2 2009
Added on May 5 2009
5 comments
1,690 views