操作环境:linux6.5
所需介质
软件包安装
1.oracleasm-support的安装,在操作系统Packages下安装oracle-support
2.oracleasmlib-2.0.4-1.el6.x86_64.rpm,在官网下载
3.GI软件p13390677_112040_linux_x86-64_3of7.zip,在官网下载
[root@PROD1 mnt]# ls
hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[root@PROD1 mnt]# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda3 36822724 6315312 28630268 19% /
tmpfs 1018232 224 1018008 1% /dev/shm
/dev/sda1 194241 55714 128287 31% /boot
.host:/ 367000572 232994896 134005676 64% /mnt/hgfs
/dev/sr0 3794060 3794060 0 100% /media/OL6.5 x86_64 Disc 1 20131125
[root@PROD1 mnt]# cd /media/OL6.5\ x86_64\ Disc\ 1\ 20131125/Packages/
[root@PROD1 Packages]# rpm -ivh oracleasm-support-2.1.8-1.el6.x86_64.rpm
warning: oracleasm-support-2.1.8-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:oracleasm-support ########################################### [100%]
[root@PROD1 Packages]# cd /mnt
[root@PROD1 mnt]# ls
hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[root@PROD1 mnt]# rpm -ivh oracleasmlib-2.0.4-1.el6.x86_64.rpm
warning: oracleasmlib-2.0.4-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:oracleasmlib ########################################### [100%]
所需介质
软件包安装
1.oracleasm-support的安装,在操作系统Packages下安装oracle-support
2.oracleasmlib-2.0.4-1.el6.x86_64.rpm,在官网下载
3.GI软件p13390677_112040_linux_x86-64_3of7.zip,在官网下载
[root@PROD1 mnt]# ls
hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[root@PROD1 mnt]# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda3 36822724 6315312 28630268 19% /
tmpfs 1018232 224 1018008 1% /dev/shm
/dev/sda1 194241 55714 128287 31% /boot
.host:/ 367000572 232994896 134005676 64% /mnt/hgfs
/dev/sr0 3794060 3794060 0 100% /media/OL6.5 x86_64 Disc 1 20131125
[root@PROD1 mnt]# cd /media/OL6.5\ x86_64\ Disc\ 1\ 20131125/Packages/
[root@PROD1 Packages]# rpm -ivh oracleasm-support-2.1.8-1.el6.x86_64.rpm
warning: oracleasm-support-2.1.8-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:oracleasm-support ########################################### [100%]
[root@PROD1 Packages]# cd /mnt
[root@PROD1 mnt]# ls
hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[root@PROD1 mnt]# rpm -ivh oracleasmlib-2.0.4-1.el6.x86_64.rpm
warning: oracleasmlib-2.0.4-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:oracleasmlib ########################################### [100%]
配置用户及组,在root用户下
[root@PROD1 mnt]# groupadd asmadmin
[root@PROD1 mnt]# groupadd asmdba
[root@PROD1 mnt]# groupadd asmoper
[root@PROD1 mnt]# groupadd dba
[root@PROD1 mnt]# groupadd oinstall
[root@PROD1 mnt]# useradd -g oinstall -G asmdba,asmadmin,asmoper,dba grid
[root@PROD1 mnt]# groupadd asmadmin
[root@PROD1 mnt]# groupadd asmdba
[root@PROD1 mnt]# groupadd asmoper
[root@PROD1 mnt]# groupadd dba
[root@PROD1 mnt]# groupadd oinstall
[root@PROD1 mnt]# useradd -g oinstall -G asmdba,asmadmin,asmoper,dba grid
[root@PROD1 mnt]# useradd -g oinstall -G asmdba,asmadmin,dba oracle
[root@PROD1 mnt]# echo grid | passwd --stdin grid
Changing password for user grid.
passwd: all authentication tokens updated successfully.
Changing password for user grid.
passwd: all authentication tokens updated successfully.
[root@PROD1 mnt]# echo oracle | passwd --stdin oracle
Changing password for user oracle.
passwd: all authentication tokens updated successfully.
Changing password for user oracle.
passwd: all authentication tokens updated successfully.
配置目录,在root用户下
[root@PROD1 mnt]# mkdir -p /u01/app/grid
[root@PROD1 mnt]# mkdir -p /u01/app/11.2.0/grid
[root@PROD1 mnt]# chown -R grid:oinstall /u01/app/grid /u01/app/11.2.0/grid
[root@PROD1 mnt]# mkdir -p /u01/app/grid
[root@PROD1 mnt]# mkdir -p /u01/app/11.2.0/grid
[root@PROD1 mnt]# chown -R grid:oinstall /u01/app/grid /u01/app/11.2.0/grid
在root用户下,分配用户内存等内核参数资源
[root@PROD1 mnt]# vi /etc/security/limits.conf
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
配置grid用户的配置文件,在.bash_profile配置文件中添加
[root@PROD1 mnt]# su - grid
[grid@PROD1 ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_SID=+ASM
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_OWNER=oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
[grid@PROD1 ~]$ source .bash_profile
创建ASM磁盘及配置ASMlib驱动
分区(分区之前先在虚拟机上新建4个大小为3G的磁盘)
[grid@PROD1 ~]$ su -
Password:
[root@PROD1 ~]# fdisk -l
Disk /dev/sda: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000d40af
Device Boot Start End Blocks Id System
/dev/sda1 * 1 26 204800 83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 26 548 4194304 82 Linux swap / Solaris
Partition 2 does not end on cylinder boundary.
/dev/sda3 548 5222 37542912 83 Linux
Disk /dev/sdb: 3221 MB, 3221225472 bytes
255 heads, 63 sectors/track, 391 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000f1e5f
Device Boot Start End Blocks Id System
Disk /dev/sdc: 3221 MB, 3221225472 bytes
255 heads, 63 sectors/track, 391 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x0001aeb7
Device Boot Start End Blocks Id System
Disk /dev/sde: 3221 MB, 3221225472 bytes
255 heads, 63 sectors/track, 391 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000c3532
Device Boot Start End Blocks Id System
Disk /dev/sdd: 3221 MB, 3221225472 bytes
255 heads, 63 sectors/track, 391 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000b360e
Device Boot Start End Blocks Id System
[root@PROD1 ~]# fdisk /dev/sdb
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-391, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-391, default 391):
Using default value 391
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@PROD1 ~]# mkdir -p /u01/app/oraInventory
[root@PROD1 ~]# chown grid:oinstall -R /u01/app/oraInventory
[root@PROD1 ~]# /tmp/CVU_11.2.0.4.0_grid/runfixup.sh
Response file being used is :/tmp/CVU_11.2.0.4.0_grid/fixup.response
Enable file being used is :/tmp/CVU_11.2.0.4.0_grid/fixup.enable
Log file location: /tmp/CVU_11.2.0.4.0_grid/orarun.log
Setting Kernel Parameters...
The value for shmmni in response file is not greater than value of shmmni for current session. Hence not changing it.
The value for semmsl in response file is not greater than value of semmsl for current session. Hence not changing it.
The value for semmns in response file is not greater than value of semmns for current session. Hence not changing it.
The value for semmni in response file is not greater than value of semmni for current session. Hence not changing it.
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
The value for aio-max-nr in response file is not greater than value of aio-max-nr for current session. Hence not changing it.
[root@PROD1 ~]# cd /media/OL6.5\ x86_64\ Disc\ 1\ 20131125/Packages/
[root@PROD1 Packages]# rpm -ivh ksh-20120801-10.el6.x86_64.rpm
warning: ksh-20120801-10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:ksh ########################################### [100%]
[root@PROD1 Packages]# rpm -ivh libaio-devel-0.3.107-10.el6.x86_64.rpm
warning: libaio-devel-0.3.107-10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:libaio-devel ########################################### [100%]
[root@PROD1 Packages]# /u01/app/oraInventory/orainstRoot.sh
[root@PROD1 Packages]# /u01/app/11.2.0/grid/root.sh
点击OK;SKip跳过继续安装
[grid@PROD1 grid]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE prod1
ora....ER.lsnr ora....er.type ONLINE ONLINE prod1
ora.asm ora.asm.type ONLINE ONLINE prod1
ora.cssd ora.cssd.type ONLINE ONLINE prod1
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE prod1
ora.ons ora.ons.type OFFLINE OFFLINE
[grid@PROD1 grid]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 4 18:32:24 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Automatic Storage Management option
[root@PROD1 mnt]# vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
配置grid用户的配置文件,在.bash_profile配置文件中添加
[root@PROD1 mnt]# su - grid
[grid@PROD1 ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_SID=+ASM
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_OWNER=oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
[grid@PROD1 ~]$ source .bash_profile
创建ASM磁盘及配置ASMlib驱动
分区(分区之前先在虚拟机上新建4个大小为3G的磁盘)
[grid@PROD1 ~]$ su -
Password:
[root@PROD1 ~]# fdisk -l
Disk /dev/sda: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000d40af
Device Boot Start End Blocks Id System
/dev/sda1 * 1 26 204800 83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 26 548 4194304 82 Linux swap / Solaris
Partition 2 does not end on cylinder boundary.
/dev/sda3 548 5222 37542912 83 Linux
Disk /dev/sdb: 3221 MB, 3221225472 bytes
255 heads, 63 sectors/track, 391 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000f1e5f
Device Boot Start End Blocks Id System
Disk /dev/sdc: 3221 MB, 3221225472 bytes
255 heads, 63 sectors/track, 391 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x0001aeb7
Device Boot Start End Blocks Id System
Disk /dev/sde: 3221 MB, 3221225472 bytes
255 heads, 63 sectors/track, 391 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000c3532
Device Boot Start End Blocks Id System
Disk /dev/sdd: 3221 MB, 3221225472 bytes
255 heads, 63 sectors/track, 391 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000b360e
Device Boot Start End Blocks Id System
[root@PROD1 ~]# fdisk /dev/sdb
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-391, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-391, default 391):
Using default value 391
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@PROD1 ~]# fdisk /dev/sdc
..............
[root@PROD1 ~]# fdisk /dev/sdd
..............
[root@PROD1 ~]# fdisk /dev/sdd
..............
[root@PROD1 ~]# fdisk /dev/sde
..............
配置ASMlib驱动(root用户)
[root@PROD1 ~]# /etc/init.d/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 without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
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 ]
..............
配置ASMlib驱动(root用户)
[root@PROD1 ~]# /etc/init.d/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 without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
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 ]
创建ASM磁盘(root用户)
[root@PROD1 ~]# oracleasm createdisk VOL1 /dev/sdb1
Writing disk header: done
Instantiating disk: done
Instantiating disk: done
[root@PROD1 ~]# oracleasm createdisk VOL3 /dev/sdd1
Writing disk header: done
Instantiating disk: done
[root@PROD1 ~]# oracleasm createdisk VOL4 /dev/sde1
Writing disk header: done
Instantiating disk: done
[root@PROD1 ~]# oracleasm createdisk VOL1 /dev/sdb1
Writing disk header: done
Instantiating disk: done
[root@PROD1 ~]# oracleasm createdisk VOL2 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@PROD1 ~]# oracleasm createdisk VOL3 /dev/sdd1
Writing disk header: done
Instantiating disk: done
[root@PROD1 ~]# oracleasm createdisk VOL4 /dev/sde1
Writing disk header: done
Instantiating disk: done
[root@PROD1 ~]# oracleasm listdisks
VOL1
VOL2
VOL3
VOL4
VOL1
VOL2
VOL3
VOL4
安装GI
[root@PROD1 ~]# cd /mnt
[root@PROD1 mnt]# ls
grid hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[grid@PROD1 mnt]$ ls
hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[root@PROD1 ~]# cd /mnt
[root@PROD1 mnt]# ls
grid hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[root@PROD1 mnt]# chown grid p13390677_112040_Linux-x86-64_3of7.zip
[root@PROD1 ~]# su - grid
[grid@PROD1 ~]$ cd /mnt
[grid@PROD1 mnt]$ ls
hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[grid@PROD1 mnt]$ unzip p13390677_112040_Linux-x86-64_3of7.zip
[grid@PROD1 mnt]$ ls
grid hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[grid@PROD1 mnt]$ cd grid
[grid@PROD1 grid]$ ls
install readme.html response rpm runcluvfy.sh runInstaller sshsetup stage welcome.html
grid hgfs oracleasmlib-2.0.4-1.el6.x86_64.rpm p13390677_112040_Linux-x86-64_3of7.zip
[grid@PROD1 mnt]$ cd grid
[grid@PROD1 grid]$ ls
install readme.html response rpm runcluvfy.sh runInstaller sshsetup stage welcome.html
[grid@PROD1 grid]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 26464 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-01-04_05-57-08PM. Please wait ...[grid@PROD1 grid]$
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 26464 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-01-04_05-57-08PM. Please wait ...[grid@PROD1 grid]$
[root@PROD1 ~]# chown grid:oinstall -R /u01/app/oraInventory
Response file being used is :/tmp/CVU_11.2.0.4.0_grid/fixup.response
Enable file being used is :/tmp/CVU_11.2.0.4.0_grid/fixup.enable
Log file location: /tmp/CVU_11.2.0.4.0_grid/orarun.log
Setting Kernel Parameters...
The value for shmmni in response file is not greater than value of shmmni for current session. Hence not changing it.
The value for semmsl in response file is not greater than value of semmsl for current session. Hence not changing it.
The value for semmns in response file is not greater than value of semmns for current session. Hence not changing it.
The value for semmni in response file is not greater than value of semmni for current session. Hence not changing it.
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
The value for aio-max-nr in response file is not greater than value of aio-max-nr for current session. Hence not changing it.
[root@PROD1 Packages]# rpm -ivh ksh-20120801-10.el6.x86_64.rpm
warning: ksh-20120801-10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:ksh ########################################### [100%]
[root@PROD1 Packages]# rpm -ivh libaio-devel-0.3.107-10.el6.x86_64.rpm
warning: libaio-devel-0.3.107-10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:libaio-devel ########################################### [100%]
[root@PROD1 Packages]# /u01/app/11.2.0/grid/root.sh
点击OK;SKip跳过继续安装
[grid@PROD1 grid]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE prod1
ora....ER.lsnr ora....er.type ONLINE ONLINE prod1
ora.asm ora.asm.type ONLINE ONLINE prod1
ora.cssd ora.cssd.type ONLINE ONLINE prod1
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE prod1
ora.ons ora.ons.type OFFLINE OFFLINE
[grid@PROD1 grid]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 4 18:32:24 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Automatic Storage Management option
SQL> select name from v$asm_disk;
NAME
------------------------------
VOL1
VOL2
VOL3
VOL4
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
NAME
------------------------------
VOL1
VOL2
VOL3
VOL4
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606744/viewspace-1970934/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30606744/viewspace-1970934/