[Инсталляция 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



Grid installation

Grid installation

Grid installation

Grid installation

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.



Grid installation

Grid installation

Grid installation

Grid installation

Grid installation

Grid installation

Grid installation

Grid installation

Grid installation

Grid installation

Grid installation

Grid installation


Проверка работы служб 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;