Oracle 10g manual creation of the ASM Database

Oracle10g manually create a database stored in ASM
Project Process:
0. Add two SCSI hard disks to the computer.
1. Install ASM
2. Create two ASM disk groups: GROUP1 and GROUP2
3. Create a database. First, create a parameter file and save it as $ ORACLE_HOME/dbs/initnestling. ora.
4. Create a password file $ ORACLE_HOME/dbs/orapwdnestling
5. Create a path for tracking and log files
6. Start the database to the nomount status.
7. Create and run the database creation script
8. Create an erp tablespace
9. Create a data dictionary View
10. Create a spfile.
11. Create a database user
12. Configure Network Services
13. extend the application
A. Check the ASM groups group number, group name, total size, and free space.
B. Delete group2.
C. Add ORCL: DISK2 to GROUP1.
D. view the load information.
E. Re-Load Balancing

Steps:
Oracle 10 Gb manual database creation
Today, I tried another method except DBCA to create a database. I used Oracle 10g manual database creation experiment. The data version is 10g 10.2.0.1.0 with ASM.
0. Add two SCSI hard disks to the computer.
1. Install ASM
[Root @ kk ~] # Uname-rm
2.6.18-92. el5 i686
[Root @ kk ~] # Cd 32bit/
[Root @ kk 32bit] # rpm-ivh oracleasm-support-2.1.3-1.el5.i386.rpm
Warning: oracleasm-support-2.1.3-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ######################################## ### [100%]
1: oracleasm-support ##################################### ###### [100%]
[Root @ kk 32bit] # rpm-ivh oracleasm-2.6.18-92.el5
[Root @ kk 32bit] # rpm-ivh oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm
Warning: oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ######################################## ### [100%]
1: oracleasm-2.6.18-92.el5 ####################################### #### [100%]
[Root @ kk 32bit] # rpm-ivh oracleasmlib-2.0.4-1.el5.i386.rpm
Warning: oracleasmlib-2.0.4-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ######################################## ### [100%]
1: oracleasmlib ####################################### #### [100%]
 
[Root @ kk 32bit] # vi/etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX = can take one of these three values:
# Enforcing-SELinux security policy is enforced.
# Permissive-SELinux prints warnings instead of enforcing.
# Disabled-SELinux is fully disabled.
SELINUX = disabled
# SELINUXTYPE = type of policy in use. Possible values are:
# Targeted-Only targeted network daemons are protected.
# Strict-Full SELinux protection.
SELINUXTYPE = targeted
~
[Root @ kk 32bit] # setenforce 0
 
[Root @ kk 32bit] #/etc/init. d/oracleasm configure
Processing the Oracle ASM library driver.
 
This will configure the on-boot properties of the Oracle ASM library
Driver. The following questions will determine whether the driver is
Loaded on boot and what permissions it will have. The current values
Will be shown in brackets ('[]'). Hitting <ENTER> without typing
Answer will keep that current value. Ctrl-C will abort.
 
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [OK]
Scanning the system for Oracle ASMLib disks: [OK]
[Root @ kk 32bit] #/etc/init. d/oracleasm enable
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [OK]
Scanning the system for Oracle ASMLib disks: [OK]
[Root @ kk 32bit] # cd/opt/oracle/product/10.2.0/db_1/bin/
[Root @ kk bin] #./localconfig add
/Etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root '..
Operation successful.
Configuration for local CSS has been initialized
 
Adding to inittab
Startup will be queued to init within 90 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
Kk
CSS is active on all nodes.
Oracle CSS service is installed and running under init (1 M)
 
2. Create two ASM disk groups: GROUP1 and GROUP2
 
[Root @ kk bin] # fdisk-l
 
Disk/dev/sda: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065*512 = 8225280 bytes
 
Device Boot Start End Blocks Id System
/Dev/sda1*1 25 200781 83 Linux
/Dev/sda2 26 286 2096482 + 82 Linux swap/Solaris
/Dev/sda3 287 5221 39640387 + 83 Linux
 
Disk/dev/sdb: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065*512 = 8225280 bytes
 
Device Boot Start End Blocks Id System
/Dev/sdb1 1 1044 8385898 + 83 Linux
 
Disk/dev/sdc: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065*512 = 8225280 bytes
 
Device Boot Start End Blocks Id System
/Dev/sdc1 1 1044 8385898 + 83 Linux
 
[Root @ kk bin] #/etc/init. d/oracleasm createdisk DISK1/dev/sdb1
Marking disk "DISK1" as an ASM disk: [OK]
[Root @ kk bin] #/etc/init. d/oracleasm createdisk DISK2/dev/sdc1
Marking disk "DISK2" as an ASM disk: [OK]
[Root @ kk bin] #/etc/init. d/oracleasm listdisk
Usage:/etc/init. d/oracleasm {start | stop | restart | enable | disable | configure | createdisk | deletedisk | querydisk | listdisks | scandisks | status}
[Root @ kk bin] #/etc/init. d/oracleasm listdisks
DISK1
DISK2

1 2 3 4 5 Next Page