Login as oracle and start Database Configuration Assistant to create the database.
$ cd $ORACLE_HOME/bin
$ dbca
On the Welcome screen, select Oracle Real Application Clusters (RAC)
database.
On Operations screen, select Create a Database.
On Database Templates screen, select General Purpose or Transaction
Processing.
On Database Identification screen, Admin-Managed is selected by default
for Configuration Type. When you enter Global Database Name, Database
Configuration Assistant automatically populates SID field with database name.
Click on Select All to select all the nodes in the cluster for the cluster
database creation.
On Management Options - Enterprise manager screen, uncheck Configure
Enterprise Manager. You can register this database with Cloud Control 12c later
for centralized management.
On Management Options - Automatic Maintenance Tasks screen, enable
automatic maintenance tasks is checked by default. Click Next to continue.
Enter the same Administrative password for SYS and SYSTEM.
On Database File Locations screen, Cluster File System is selected
as Storage Type by default. Select Use Common Location for All Database Files
and specify Database Files Location.
Click on File Location Variables to display the variables used for
the database.
On Recovery Configuration screen, check Specify Fast Recovery Area and
enter path for Fast Recovery Area and size for Fast Recovery Area Size. Check
Enable Archiving.
Click on Edit Archive Mode Parameters to see or modify the Archive Log Format.
On Database Content – Sample Schemas screen, Sample Schemas are
not needed.
On Database Content - Custom Scripts screen, no need to run any
custom scripts.
On Initialization Parameters - Memory screen, Automatic Memory
Management in enabled by default. Enter Memory Size.
Click on All Initialization Parameters to display the values.
On Initialization Parameters - Sizing screen, enter processes.
On Initialization Parameters - Character Sets screen, select Use
Unicode (AL32UTF8) which is Oracle recommended characterset.
On Initialization Parameters - Connection Mode screen, Dedicated Server
Mode is selected by default. Click Next.
On Database Storage screen, enter controlfile, Datafiles, Redo Log
Groups locations.
Enter Data file locations are under /u02 and Temp file location is
under /u04 to improve the performance.
Enter two redo log members for redundancy.
Change thread # to 2 for Redo Log Group 4. Add redo log groups 5 and 6
for thread 2.
On creation Options, click Finish for Summary page.
On Summary page, Click OK to start database creation.
The Database Configuration Assistant screen provides status so that you
can monitor the progress for database creation as DBCA continues.
Click on Exit to exit from DBCA.
$ srvctl config database -d orac
Database unique name: ORAC
Database name: ORAC
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: /u02/oradata/ORAC/spfileORAC.ora
Domain: example.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ORAC
Database instances: ORAC1,ORAC2
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is administrator managed
$ srvctl status database -d orac
Instance ORAC1 is running on node orarac1
Instance ORAC2 is running on node orarac2
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 7 13:48:19 2014
Copyright (c) 1982, 2013, Oracle.
All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select * from v$active_instances;
INST_NUMBER
-----------
INST_NAME
--------------------------------------------------------------------------------
1
orarac1.localdomain:ORAC1
2
orarac2.localdomain:ORAC2
Check status of the resources on cluster.
$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE
SERVER
STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE
orarac1
ONLINE ONLINE
orarac2
ora.asm
OFFLINE
OFFLINE orarac1 Instance Shutdown
OFFLINE
OFFLINE orarac2
ora.gsd
OFFLINE
OFFLINE orarac1
OFFLINE
OFFLINE orarac2
ora.net1.network
ONLINE ONLINE
orarac1
ONLINE ONLINE
orarac2
ora.ons
ONLINE ONLINE
orarac1
ONLINE ONLINE
orarac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE
ONLINE orarac2
ora.LISTENER_SCAN2.lsnr
1 ONLINE
ONLINE orarac1
ora.LISTENER_SCAN3.lsnr
1 ONLINE
ONLINE orarac1
ora.cvu
1 ONLINE
ONLINE orarac1
ora.oc4j
1 ONLINE
ONLINE orarac1
ora.orac.db
1 ONLINE
ONLINE orarac1 Open
2 ONLINE
ONLINE orarac2 Open
ora.orarac1.vip
1 ONLINE
ONLINE orarac1
ora.orarac2.vip
1
ONLINE ONLINE orarac2
ora.scan1.vip
1 ONLINE
ONLINE orarac2
ora.scan2.vip
1 ONLINE
ONLINE orarac1
ora.scan3.vip
1
ONLINE ONLINE
No comments:
Post a Comment