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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

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
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.


Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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











×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.