What are the restrictions on the SID with a RAC database? Is it limited to 5 characters?
The SID prefix in 10g Release 1 and prior versions was restricted to five characters by install/config tools so that an ORACLE_SID of upto max of 5+3=8 characters can be supported in a RAC environment. The SID prefix is relaxed upto 8 characters in 10g Release 2, see bug4024251 for more information.
Related Questions
- I have an existing RAC database on a hardware cluster. Can I install the Infrastructure using CFC on the same hardware cluster?
- What are the restrictions on the SID with an Oracle RAC database? Is it limited to 5 characters?
- How does the ISWN database and search handle languages and special characters?