ASM 설치
ASM 설치
1.Creating the Fake Hard Disks
-- 1GB 파일 20개 생성
OS] cd c:\
md c:\asmdisks
asmtool -create c:\asmdisks\disk1 200
asmtool -create c:\asmdisks\disk2 200
asmtool -create c:\asmdisks\disk3 200
asmtool -create c:\asmdisks\disk4 200
asmtool -create c:\asmdisks\disk5 200
asmtool -create c:\asmdisks\disk6 200
asmtool -create c:\asmdisks\disk7 200
asmtool -create c:\asmdisks\disk8 200
asmtool -create c:\asmdisks\disk9 200
asmtool -create c:\asmdisks\disk10 200
asmtool -create c:\asmdisks\disk11 200
asmtool -create c:\asmdisks\disk12 200
asmtool -create c:\asmdisks\disk13 200
asmtool -create c:\asmdisks\disk14 200
asmtool -create c:\asmdisks\disk15 200
asmtool -create c:\asmdisks\disk16 200
asmtool -create c:\asmdisks\disk17 200
asmtool -create c:\asmdisks\disk18 200
asmtool -create c:\asmdisks\disk19 200
asmtool -create c:\asmdisks\disk20 200
2.Creating the ASM Instance
C:\> C:\oracle\product\10.2.0\db_1\bin\localconfig add
-- 파라미터 파일을 생성하고 내용을 입력하자.
C:\> cd \oracle\product\10.2.0\db_1\database
C:\> notepad init+ASM.ora
INSTANCE_TYPE=ASM
DB_UNIQUE_NAME=+ASM
LARGE_POOL_SIZE=8M
ASM_DISKSTRING='c:\asmdisks\*'
_ASM_ALLOW_ONLY_RAW_DISKS=FALSE
-- 서비스 추가
C:\> oradim -NEW -ASMSID +ASM -STARTMODE auto
-- +ASM 인스턴스에 접속
C:\> set ORACLE_SID=+ASM
C:\> sqlplus / as sysdba
SQL> show user
SQL> select status from v$instance;
STATUS
------------
STARTED
set pagesize 3000
set linesize 132
column path format a55
select path, mount_status from v$asm_disk;
PATH MOUNT_S
------------------------------------------------------- -------
C:\ASMDISKS\DISK1 CLOSED
C:\ASMDISKS\DISK2 CLOSED
C:\ASMDISKS\DISK4 CLOSED
C:\ASMDISKS\DISK3 CLOSED
-- Diskgroup 생성 및 확인
create diskgroup DGROUP1 normal redundancy disk
'c:\asmdisks\disk1',
'c:\asmdisks\disk2',
'c:\asmdisks\disk3',
'c:\asmdisks\disk4';
select path, mount_status from v$asm_disk;
PATH MOUNT_S
------------------------------------------------------- -------
C:\ASMDISKS\DISK1 CACHED
C:\ASMDISKS\DISK2 CACHED
C:\ASMDISKS\DISK3 CACHED
C:\ASMDISKS\DISK4 CACHED
create spfile from pfile;
startup force; --ORA-15110: ???? ??? ?? ??
alter system set asm_diskgroups=DGROUP1 scope=spfile;
startup force; --성공
C:\> hostname
pc
C:\> notepad addasm.txt
-- MachineName 및 password을 주의해서 값을 입력하도록 하자.
<Target TYPE="osm_instance" NAME="+ASM" DISPLAY_NAME="+ASM">
<Property NAME="SID" VALUE="+ASM"/>
<Property NAME="MachineName" VALUE="pc"/>
<Property NAME="OracleHome" VALUE="C:\oracle\product\10.2.0\db_1"/>
<Property NAME="UserName" VALUE="sys"/>
<Property NAME="password" VALUE="oracle" ENCRYPTED="FALSE"/>
<Property NAME="Role" VALUE="sysdba"/>
<Property NAME="Port" VALUE="1521"/>
</Target>
C:\> set ORACLE_SID=orcl
C:\> emctl config agent addtarget c:\addasm.txt
C:\> emctl stop agent
-y
C:\> emctl start dbconsole
orapwd file=c:\oracle\product\10.2.0\db_1\database\PWD+ASM.ora password=oracle
Host -> Target