Do RAC instances share same spfile and control files?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Do RAC instances share same spfile and control files?

  1. #1
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322

    Do RAC instances share same spfile and control files?

    I am new to RAC. While configuring local and remote listeners, I realized that our 2 node RAC has same spfile and control files on ASM storage. Though same control files for all instances might be understandable, the same spfile for both instances is not understandable. If both instances have to share same spfiles, how can I then configure local and remote listeners of both instances?

    If I set local and remote listeners in our current configuration, then the local listener of both instances will be 172.16.91.22 (assumed IP) and remote listener of both instances will be 172.16.91.23 (again assumed IP).
    lucky

  2. #2
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Just found:

    alter system set local_listener= '.....................' sid='inst1'

    My mistake indeed.
    lucky

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width