Specifying session creates a new session for the client, but
this does not preserve the position in a cursor when you are running a SELECT statement.
Specifying select preserves the state of the cursor during a SELECT, but it involves extra
overhead on the client side. The default, none, disables failover functionality.
method How fast failover occurs. Using a value of basic establishes connections when
the failover occurs, and this incurs no overhead on the backup server(s). A value of
preconnect provides faster failover, but as the name implies, it uses resources on the
backup server(s) even when no failover scenario is active.
retries The number of times to attempt to connection after a failover.
delay The amount of time, in seconds, to wait between connection attempts when a
failover scenario is active.
Later in this chapter, I will show you how connecting to the racsvc service ensures high
availability for client connections when the client connects to a node and the node fails.
The next few screens are the same as for a single-instance database installation; see the
appendix for the options available on these screens. Figure 10-18 summarizes the cluster database
installation, which includes the location of the database??™s SPFILE on the DATA1 disk group.
?–
?–
?–
?–
FIGURE 10-18 DBCA RAC database creation complete
378 Oracle Database 11g DBA Handbook
Once the installation is complete, EM Database Control is automatically configured and started,
just as it is with a single-instance installation; however, you can manage the entire cluster and not
just individual nodes.
Pages:
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595