Re: Oracle RAC newbie

soalvajavab1_at_yahoo.com wrote:
> I am newbie to RAC. some very basic questions
>
> let's say we have a two nodes RAC, does it means
>
> - Two system tablespaces
> -Two Temp tablespaces
> - Redo logs for each instance in its own disk
> - The only thing is shared are User Datafiles and they must be in SAN
>
> - What has to be in both init.ora minimun?
> - Database create command is difference or not? Can you send me the
> script as sample?
> - When I connect from sqlplus from another PC what exactly happen?
>
> _ what is differenne in listenetr.ora and =tnsnames?
>
> - AS soon as one node crash what happens?
>
> - Who do the load balance?
>
> - How do you value RAC to Hot Standby honestly?
>
> Sorry too much questions but shed a brief light give me idea. Thanks
> millions

You obviously have spent no time reading the Oracle documentation on RAC and I urge you to do so. RAC means one database and multiple instances. By definition that is 1 system tablespace, 1 sysaux tablespace, 1 temp tablespace, 1 set of control files. And for the things you didn't mention one undo tablespace and one log thread per instance.

listener.ora and tnsnames? You need to read the docs.

When a node crashes different things can happen depending on the reason it crashed, the version of Oracle, and the types of transactions involved.

Load balancing takes place at multiple levels.

RAC and hot standby are two different technologies addressing two entirely different issues. RAC (except extended RAC) does not solve the problem of site failure. A hot standby will never do what RAC does.

If you want to take a class and learn concepts, architecture, and how to build a cluster contact me off-line. The PSOUG has a working RAC lab and students can build up to 8 node clusters pretty much any day of the week.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org