Moving to Oracle RAC One Node - Page 7

5. Create Oracle Database 11g (appsdb)

As the oracle user on gurnard1, execute dbca.

oracle@gurnard1-> dbca

1.  Welcome: Select Oracle Real Application Clusters database.

2.  Operations: Select Create a Database.

3.  Database Templates: Select General Purpose or Transaction Processing.

4.  Database Identification:

5.  Management Options:

6.  Database Credentials: For simplicity, we selected Use the Same Administrative Password for All Accounts.

7.  Database File Locations: Select Use Oracle-Managed Files.

8.  ASM Credentials:

9.  Recovery Configuration: Select Specify Flash Recovery Area.

10.  Database Content: Leave Sample Schemas unchecked.

11.  Initialization Parameters: Accept the default values.

12.  Database Storage: Click on Next.

13.  Creation Options: Select the database creation options:

14.  Summary: Click on OK.

15.  Database Configuration Assistant: Click on Exit.

5.1 Oracle Database Post-Installation checks

At this stage, we have a single database instance, appsdb1 running on gurnard1. The database is not yet a RAC One Node on the cluster until we initialize it using the raconeinit utility in the next section.

oracle@gurnard1-> srvctl config database -d appsdb -a
Database unique name: appsdb
Database name: appsdb
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/appsdb/spfileappsdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: appsdb
Database instances: appsdb1
Disk Groups: DATA,FRA
Services:
Database is enabled
Database is administrator managed
 
oracle@gurnard1-> srvctl status database -d appsdb
Instance appsdb1 is running on node gurnard1
 
 
oracle@gurnard1-> sqlplus system@appsdb
 
SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 27 05:31:56 2010
 
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
 
Enter password:
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management and Real Application Testing options
 
SQL> select instance_number instance#,instance_name,host_name,status
  2  from gv$instance
  3  /
 
 INSTANCE# INSTANCE_NAME    HOST_NAME      STATUS
---------- ---------------- -------------- ------------
         1 appsdb1          gurnard1       OPEN  
 
 
SQL> select inst_id,thread#,bytes/1024/1024 "Size(MB)",members,status
  2  from gv$log
  3  /
 
   INST_ID    THREAD#   Size(MB)    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
         1          1         50          2 INACTIVE
         1          1         50          2 INACTIVE
         1          1         50          2 CURRENT
 
 
SQL> select inst_id,group#,member,is_recovery_dest_file
  2  from gv$logfile
  3  order by 1,2
  4  /
 
INST_ID GROUP# MEMBER                                       IS_
------- ------ -------------------------------------------- ---
      1      1 +DATA/appsdb/onlinelog/group_1.261.713575025 NO
      1      1 +FRA/appsdb/onlinelog/group_1.257.713575033  YES
      1      2 +DATA/appsdb/onlinelog/group_2.262.713575037 NO
      1      2 +FRA/appsdb/onlinelog/group_2.258.713575043  YES
      1      3 +DATA/appsdb/onlinelog/group_3.263.713575045 NO
      1      3 +FRA/appsdb/onlinelog/group_3.259.713575049  YES
 
6 rows selected.
 
 
SQL> select  inst_id,
  2           name,
value
  3  from    gv$parameter
  4  where   name in ('cluster_database',
  5                    'db_name',
  6                    'instance_name',
  7                    'instance_number',
  8                    'local_listener',
  9                    'remote_listener',
 10                    'undo_tablespace')
 11  order by 2
 12  /
 
INST_ID NAME                 VALUE
------- -------------------- -----------------------------------
      1 cluster_database     TRUE
      1 db_name              appsdb
      1 instance_name        appsdb1
      1 instance_number      1
      1 local_listener       (DESCRIPTION=(ADDRESS_LIST=(ADDRESS
                             =(PROTOCOL=TCP)(HOST=192.168.1.222)
                             (PORT=1521))))
 
      1 remote_listener      gurnard-cluster-scan.gurnard.vccons
                             ult.com:1521
 
      1 undo_tablespace      UNDOTBS1
 
7 rows selected.