亚洲激情专区-91九色丨porny丨老师-久久久久久久女国产乱让韩-国产精品午夜小视频观看

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

Oracle DataBase單實例使用ASM案例(3)--Oracle 10g應用

發布時間:2020-07-25 01:52:36 來源:網絡 閱讀:866 作者:客居天涯 欄目:關系型數據庫

Oracle DataBase單實例使用ASM案例(3)--Oracle 10g應用

系統環境:

操作系統:RedHat EL5(64)

Oracle 軟件:Oracle 10gR2


   在Oracle 10g單實例環境下使用ASM比較容易實現:

1、建立磁盤分區

[root@rh65 ~]# fdisk -l

Disk /dev/sdb: 21.4 GB, 21474836480 bytes

255 heads, 63 sectors/track, 2610 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System

/dev/sdb1               1         487     3911796   83  Linux

/dev/sdb2             488         974     3911827+  83  Linux

/dev/sdb3             975        2610    13141170    5  Extended

/dev/sdb5             975        1461     3911796   83  Linux

/dev/sdb6            1462        1948     3911796   83  Linux

/dev/sdb7            1949        2192     1959898+  83  Linux

/dev/sdb8            2193        2436     1959898+  83  Linux

/dev/sdb9            2437        2610     1397623+  83  Linux

2、安裝ASM LIB軟件

系統內核版本:

[root@rh65 rh6_xen_asm]# uname -a

Linux rh65 2.6.18-194.el5xen #1 SMP Tue Mar 16 22:08:06 EDT 2010 i686 i686 i386 GNU/Linux

安裝ASM軟件包:

[root@rh65 rh6_xen_asm]# ls -l

total 236

-rwxr--r-- 1 oracle oinstall 128392 May 27 12:15 oracleasm-2.6.18-194.el5xen-2.0.5-1.el5.i686.rpm

-rwxr--r-- 1 oracle oinstall  13929 May 27 12:14 oracleasmlib-2.0.4-1.el5.i386.rpm

-rwxr--r-- 1 oracle oinstall  85303 May 27 12:14 oracleasm-support-2.1.8-1.el5.i386.rpm

[root@rh65 rh6_xen_asm]# rpm -ivh *

warning: oracleasm-2.6.18-194.el5xen-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

error: failed to stat /media/RHEL_5.5 i386 DVD: No such file or directory

Preparing...                ########################################### [100%]

   1:oracleasm-support      ########################################### [ 33%]

   2:oracleasm-2.6.18-194.el########################################### [ 67%]

   3:oracleasmlib           ########################################### [100%]

3、配置ASM并建立ASM磁盤

[root@rh65 rh6_xen_asm]# service oracleasm configure

Configuring 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 an

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]: 

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver: [  OK  ]

Scanning the system for Oracle ASMLib disks: [  OK  ]

[root@rh65 rh6_xen_asm]# 

建立ASM磁盤:

[root@rh65 rh6_xen_asm]# service oracleasm createdisk ASM_DSK1 /dev/sdb1

Marking disk "ASM_DSK1" as an ASM disk: [  OK  ]

[root@rh65 rh6_xen_asm]# service oracleasm createdisk ASM_DSK2 /dev/sdb2

Marking disk "ASM_DSK2" as an ASM disk: [  OK  ]

[root@rh65 rh6_xen_asm]# service oracleasm createdisk ASM_DSK3 /dev/sdb5

Marking disk "ASM_DSK3" as an ASM disk: [  OK  ]

[root@rh65 rh6_xen_asm]# service oracleasm createdisk ASM_DSK4 /dev/sdb6

Marking disk "ASM_DSK4" as an ASM disk: [  OK  ]

查看ASM磁盤信息:

[root@rh65 ~]# service oracleasm listdisks;

ASM_DSK1

ASM_DSK2

ASM_DSK3

ASM_DSK4

4、配置ASM實例

[oracle@rh65 dbs]$ cat init+ASM.ora 

instance_type='asm'

asm_diskstring='ORCL:ASM_*'

large_pool_size=12m

asm_diskgroups='DG1','RCY1'

background_dump_dest=/u01/app/oracle/admin/+ASM/bdump

core_dump_dest=/u01/app/oracle/admin/+ASM/cdump

user_dump_dest=/u01/app/oracle/admin/+ASM/udump

建立相應目錄:

[oracle@rh65 dbs]$ mkdir -p /u01/app/oracle/admin/+ASM/bdump

[oracle@rh65 dbs]$ mkdir -p /u01/app/oracle/admin/+ASM/cdump

[oracle@rh65 dbs]$ mkdir -p /u01/app/oracle/admin/+ASM/udump

建立口令文件:

[oracle@rh65 dbs]$ orapwd file='orapw+ASM' password=oracle entries=3

啟動CSS服務:

[root@rh65 ~]# cd /u01/app/oracle/product/10.2.0/db_1/bin

[root@rh65 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.

        rh65

CSS is active on all nodes.

Oracle CSS service is installed and running under init(1M)

5、啟動ASM Instance

[oracle@rh65 ~]$ export ORACLE_SID=+ASM

[oracle@rh65 ~]$ sqlplus '/as sysdba'

12:44:31 SYS@ +ASM>startup force nomount;

ASM instance started

Total System Global Area   83886080 bytes

Fixed Size                  1217836 bytes

Variable Size              57502420 bytes

ASM Cache                  25165824 bytes

12:44:46 SYS@ +ASM>show parameter name

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_file_name_convert                 string

db_name                              string

db_unique_name                       string      +ASM

global_names                         boolean     FALSE

instance_name                        string      +ASM

lock_name_space                      string

log_file_name_convert                string

service_names                        string      +ASM

12:45:10 SYS@ +ASM>

6、手工建立ASM diskgroup

12:50:33 SYS@ +ASM>create diskgroup dg1 

12:53:57   2  normal redundancy

12:54:01   3  failgroup fg1 disk 'ORCL:ASM_DSK1'

12:54:06   4  failgroup fg2 disk 'ORCL:ASM_DSK2';

Diskgroup created.

Elapsed: 00:00:12.22

12:54:23 SYS@ +ASM>create diskgroup rcy1

12:54:37   2  normal redundancy

12:54:40   3  failgroup fg1 disk 'ORCL:ASM_DSK3'

12:54:50   4  failgroup fg2 disk 'ORCL:ASM_DSK4';

Diskgroup created.

7、查看ASM磁盤組和磁盤信息

12:55:09 SYS@ +ASM>select name ,state from v$asm_diskgroup;

NAME                           STATE

------------------------------ -----------

DG1                            MOUNTED

RCY1                           MOUNTED

Elapsed: 00:00:00.18

12:56:02 SYS@ +ASM>

12:57:09 SYS@ +ASM>select GROUP_NUMBER ,DISK_NUMBER,STATE,NAME,PATH from v$asm_disk;

GROUP_NUMBER DISK_NUMBER STATE    NAME                           PATH

------------ ----------- -------- ------------------------------ ----------------------------------------

           1           0 NORMAL   ASM_DSK1                       ORCL:ASM_DSK1

           1           1 NORMAL   ASM_DSK2                       ORCL:ASM_DSK2

           2           0 NORMAL   ASM_DSK3                       ORCL:ASM_DSK3

           2           1 NORMAL   ASM_DSK4                       ORCL:ASM_DSK4

Elapsed: 00:00:00.03

8、通過DBCA管理ASM

Oracle DataBase單實例使用ASM案例(3)--Oracle 10g應用


  @至此,Oracle 10g在單實例下ASM磁盤亦可以使用了








向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

武隆县| 辉县市| 宁都县| 龙口市| 浦江县| 普定县| 乐清市| 林芝县| 湘潭市| 定兴县| 九龙坡区| 澎湖县| 凤台县| 久治县| 英吉沙县| 惠州市| 西藏| 东光县| 黄梅县| 扶绥县| 萍乡市| 揭西县| 揭阳市| 旅游| 凤庆县| 兴宁市| 梅河口市| 托克托县| 天水市| 广元市| 盐亭县| 新沂市| 师宗县| 文登市| 屯门区| 那坡县| 石屏县| 孝义市| 芦山县| 馆陶县| 杂多县|