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