| Oracle® Real Application Clusters Installation and Configuration Guide 10g Release 1 (10.1) for AIX-Based Systems, hp HP-UX PA-RISC (64-bit), hp Tru64 UNIX, Linux, Solaris Operating System (SPARC 64-bit) Part No. B10766-01 |
|
 |
 |
| Oracle® Real Application Clusters Installation and Configuration Guide 10g Release 1 (10.1) for AIX-Based Systems, hp HP-UX PA-RISC (64-bit), hp Tru64 UNIX, Linux, Solaris Operating System (SPARC 64-bit) Part No. B10766-01 |
|
|
|
This chapter describes the steps required to create an Oracle Real Application Clusters (RAC) database from scripts. The topic in this appendix is:
To generate a script to create a Real Application Clusters database, create a database from the script, and prepare the database for use, execute the following steps:
Invoke the Database Configuration Assistant (DBCA) and select your preferred options to build the RAC database. However, you must select the Custom Database template on the Database Templates page for the DBCA to provide the script generation option.
On the Creation Options page of your DBCA session, deselect Create Database and select Generate Database Creation Scripts before you click Finish. You can accept the default destination directory for the script file or browse for a different location. In either case, you should note the path name for use in the next step.
|
See Also: " Creating RAC Databases with the Database Configuration Assistant " for details on executing a DBCA session. |
Navigate to the directory where the DBCA stored your script and review the SQL scripts that are there to ensure that they contain the statements to build a database with the characteristics you require. If they do not, Oracle recommends that you rerun the DBCA to create scripts with the desired configuration rather than editing the scripts yourself.
Execute the db_name.sql script, where db_name is the database name that you assigned in your earlier DBCA session, using a SQL*Plus session with the operating system SID set to the value you provided in your DBCA session. This script executes the CreateDB.sql, postDBCreation.sql, CreateDBCatalog.sql, and CreateDBFiles.sql scripts followed by the scripts to configure the optional products that you selected.
Run SVRCTL to configure instance characteristics and node applications as described in the Oracle Real Application Clusters Administrator's Guide.
Configure Net Services to support your new database and instances as described in Chapter 12, " Understanding the Real Application Clusters Installed Configuration ".
