Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Oct 6, 2010

Moving to Oracle RAC One Node - Page 7

By Vincent Chan

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:

a.   Configuration Type: Admin-Managed.

b.  Global Database Name: appsdb.

c.   SID Prefix: appsdb.

d.  Select the nodes: gurnard1. Make sure you select just one node.

Database Configuration Assistant - Database Identification

5.  Management Options:

a.   On the Enterprise Manager tab, select

  • Configure Enterprise Manager.

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

a.  Password: **********

b.  Confirm Password: **********

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

a.  Database Area: +DATA

8.  ASM Credentials:

a.   Specify ASMSNMP password specific to ASM: **********

9.  Recovery Configuration: Select Specify Flash Recovery Area.

a.   Flash Recovery Area: +FRA

b.  Flash Recovery Area Size: 5000

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:

a.   Select Create Database.

14.  Summary: Click on OK.

15.  Database Configuration Assistant: Click on Exit.

Database Configuration Assistant - Database Creation Complete

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
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: appsdb
Database instances: appsdb1
Disk Groups: DATA,FRA
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 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 - 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  /
---------- ---------------- -------------- ------------
         1 appsdb1          gurnard1       OPEN  
SQL> select inst_id,thread#,bytes/1024/1024 "Size(MB)",members,status
  2  from gv$log
  3  /
---------- ---------- ---------- ---------- ----------------
         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,
  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
      1 remote_listener      gurnard-cluster-scan.gurnard.vccons
      1 undo_tablespace      UNDOTBS1
7 rows selected.

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM