[Инсталляция Oracle DataBase Server 12.1 в Centos 6.7 с использованием ASM и GRID]: Инсталляция GRID
Войдите в систему пользователем, от имени которого будет будет происходить инсталляция базы данных.
# su - oracle12
$ . asm.sh
Проверка:
$ echo $ORACLE_SID
+ASM
$ cd /tmp/oracle/12.1/grid
Определите системную переменную DISPLAY следующим образом.
$ export DISPLAY=192.168.1.5:0.0
В данном случае 192.168.1.5 - ip адрес компьютера, с которого происходит процесс управления установкой.
$ ./runInstaller
INS-30011: The string password entered does not conform to the Oracle recommended standards.
Cause: Oracle recommends that the password entered should be at least string characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
Action: Provide a password that conforms to the Oracle recommended standards.
Проверка работы служб crsctl
$ crsctl check has
CRS-4638: Oracle High Availability Services is online
$ crsctl check css
CRS-4529: Cluster Synchronization Services is online
$ crsctl stat res
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on localhost
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on localhost
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on localhost
NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on localhost
NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on localhost
NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.ora121.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=ONLINE on localhost
$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE localhost STABLE
ora.LISTENER.lsnr
ONLINE ONLINE localhost STABLE
ora.asm
ONLINE ONLINE localhost Started,STABLE
ora.ons
OFFLINE OFFLINE localhost STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE localhost STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE localhost STABLE
ora.orcl.db
1 ONLINE ONLINE localhost Open,STABLE
-------------------------------------------------------------------------------
$ ps -fea | grep asm_
oracle12 1914 1 0 10:17 ? 00:00:00 asm_pmon_+ASM
oracle12 1916 1 0 10:17 ? 00:00:00 asm_psp0_+ASM
oracle12 1918 1 10 10:17 ? 00:04:16 asm_vktm_+ASM
oracle12 1922 1 0 10:17 ? 00:00:02 asm_gen0_+ASM
oracle12 1924 1 0 10:17 ? 00:00:00 asm_mman_+ASM
oracle12 1928 1 0 10:17 ? 00:00:00 asm_diag_+ASM
oracle12 1930 1 0 10:17 ? 00:00:00 asm_dia0_+ASM
oracle12 1932 1 0 10:17 ? 00:00:00 asm_dbw0_+ASM
oracle12 1934 1 0 10:17 ? 00:00:00 asm_lgwr_+ASM
oracle12 1936 1 0 10:17 ? 00:00:00 asm_ckpt_+ASM
oracle12 1938 1 0 10:17 ? 00:00:00 asm_smon_+ASM
oracle12 1940 1 0 10:17 ? 00:00:00 asm_lreg_+ASM
oracle12 1942 1 0 10:17 ? 00:00:00 asm_pxmn_+ASM
oracle12 1944 1 0 10:17 ? 00:00:00 asm_rbal_+ASM
oracle12 1946 1 0 10:17 ? 00:00:00 asm_gmon_+ASM
oracle12 1948 1 0 10:17 ? 00:00:00 asm_mmon_+ASM
oracle12 1950 1 0 10:17 ? 00:00:00 asm_mmnl_+ASM
oracle12 7312 1 0 10:50 ? 00:00:00 asm_asmb_+ASM
oracle12 7765 29253 0 10:57 pts/0 00:00:00 grep asm_
$ sqlplus / as sysdba
SQL> set linesize 200;
SQL> set pagesize 0;
SQL> col name format a20;
SQL> col name state a20;
SQL> select name, state from v$asm_diskgroup;
column path format a30
SQL> select name, path from v$asm_disk;