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!

How to modify Oracle Initialization Parameters in Oracle RAC db

user10427867Apr 16 2009 — edited Apr 17 2009
I would like to modify the AUDIT_SYS_OPERATIONS and SQL92_SECURITY parameters to TRUE. I have a two node Oracle RAC db.

Should I stop the clustering services, modify the parameters on both nodes and restart them? Or modify the parameter on one node (node1), restart node1, restart node 1 (no modification)?

ALTER SYSTEM SET AUDIT_SYS_OPERATIONS = TRUE scope=SPFILE;

Thanks.
This post has been answered by 26741 on Apr 17 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2009
Added on Apr 16 2009
#general-database-discussions
7 comments
3,472 views