课程第2次

botang

2019-05-08
做oracleasm绑定：

1. [root@station80 ~]# oracleasm-discover
   
2. Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so
   
3. [ASM Library - Generic Linux, version 2.0.4 (KABI_V2)]
   
4. Discovered disk: ORCL:ASMDISK01 [14336000 blocks (7340032000 bytes), maxio 512]
   
5. Discovered disk: ORCL:ASMDISK02 [14336000 blocks (7340032000 bytes), maxio 512]
   
6. Discovered disk: ORCL:ASMDISK03 [14336000 blocks (7340032000 bytes), maxio 512]
   
7. Discovered disk: ORCL:ASMDISK04 [14336000 blocks (7340032000 bytes), maxio 512]
   
8. Discovered disk: ORCL:ASMDISK05 [20480000 blocks (10485760000 bytes), maxio 512]
   
9. [root@station80 ~]# oracleasm listdisks
   
10. ASMDISK01
    
11. ASMDISK02
    
12. ASMDISK03
    
13. ASMDISK04
    
14. ASMDISK05
    
15. [root@station80 ~]# oracleasm deletedisk  ASMDISK01
    
16. Clearing disk header: done
    
17. Dropping disk: done
    
18. [root@station80 ~]# oracleasm deletedisk  ASMDISK02
    
19. Clearing disk header: done
    
20. Dropping disk: done
    
21. [root@station80 ~]# oracleasm deletedisk  ASMDISK03
    
22. Clearing disk header: done
    
23. Dropping disk: done
    
24. [root@station80 ~]# oracleasm deletedisk  ASMDISK04
    
25. Clearing disk header: done
    
26. Dropping disk: done
    
27. [root@station80 ~]# oracleasm deletedisk  ASMDISK05
    
28. Clearing disk header: done
    
29. Dropping disk: done
    
30. [root@station80 ~]# oracleasm-discover
    
31. Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so
    
32. [ASM Library - Generic Linux, version 2.0.4 (KABI_V2)]
    
33. [root@station80 ~]# oracleasm configure -i
    
34. Configuring the Oracle ASM library driver.
    
35. 
    
36. This will configure the on-boot properties of the Oracle ASM library
    
37. driver.  The following questions will determine whether the driver is
    
38. loaded on boot and what permissions it will have.  The current values
    
39. will be shown in brackets ('[]').  Hitting <ENTER> without typing an
    
40. answer will keep that current value.  Ctrl-C will abort.
    
41. 
    
42. Default user to own the driver interface [oracle]: oracle
    
43. Default group to own the driver interface [asmadmin]: asmadmin
    
44. Start Oracle ASM library driver on boot (y/n) [y]: y
    
45. Scan for Oracle ASM disks on boot (y/n) [y]: y
    
46. Writing Oracle ASM library driver configuration: done
    
47. [root@station80 ~]# service oracleasm start
    
48. Initializing the Oracle ASMLib driver:                     [  OK  ]
    
49. Scanning the system for Oracle ASMLib disks:               [  OK  ]
    
50. [root@station80 ~]# chkconfig oracleasm on
    
51. [root@station80 ~]# cat /proc/partitions
    
52. major minor  #blocks  name
    
53. 
    
54.    1        0      16384 ram0
    
55.    1        1      16384 ram1
    
56.    1        2      16384 ram2
    
57.    1        3      16384 ram3
    
58.    1        4      16384 ram4
    
59.    1        5      16384 ram5
    
60.    1        6      16384 ram6
    
61.    1        7      16384 ram7
    
62.    1        8      16384 ram8
    
63.    1        9      16384 ram9
    
64.    1       10      16384 ram10
    
65.    1       11      16384 ram11
    
66.    1       12      16384 ram12
    
67.    1       13      16384 ram13
    
68.    1       14      16384 ram14
    
69.    1       15      16384 ram15
    
70.    8        0   94371840 sda
    
71.    8        1     307200 sda1
    
72.    8        2   46899200 sda2
    
73.    8        3   10240000 sda3
    
74.    8        4          1 sda4
    
75.    8        5    7168000 sda5
    
76.    8        6    7168000 sda6
    
77.    8        7    7168000 sda7
    
78.    8        8    7168000 sda8
    
79.    8        9    4194304 sda9
    
80.   11        0      56730 sr0
    
81. 251        0   46825472 dm-0
    
82. [root@station80 ~]# oracleasm createdisk ASMDISK01 /dev/sda5
    
83. Writing disk header: done
    
84. Instantiating disk: done
    
85. [root@station80 ~]# oracleasm createdisk ASMDISK02 /dev/sda6
    
86. Writing disk header: done
    
87. Instantiating disk: done
    
88. [root@station80 ~]# oracleasm createdisk ASMDISK03 /dev/sda7
    
89. Writing disk header: done
    
90. Instantiating disk: done
    
91. [root@station80 ~]# oracleasm createdisk ASMDISK04 /dev/sda8
    
92. Writing disk header: done
    
93. Instantiating disk: done
    
94. [root@station80 ~]# oracleasm createdisk ASMDISK05 /dev/sda3
    
95. Writing disk header: done
    
96. Instantiating disk: done
    
97. [root@station80 ~]#
    

复制代码

win10上11.2.0.1 32bit出错：删除文件：
C:\oracle\product\11.2.0\dbhome_1\database\SPFILEWINORCL.ORA
新建参数文件：
C:\oracle\product\11.2.0\dbhome_1\database\initwinorcl.ora
内容如下：

1. db_name=winorcl
   
2. memory_target=800M
   
3. control_files='C:\oracle\oradata\winorcl\CONTROL01.CTL'
   
4. db_recovery_file_dest_size=5G
   
5. db_recovery_file_dest='C:\oracle\flash_recovery_area'

复制代码