OLE7.5 Oracle 19c Single ASM-1

구성 환경

VMWARE	VIRTUALBOX 6.1.22
OS	Oracle Linux 7.5
HostName	ole7ora19casm
DB	19.3.0.0
SID	ORCL
LISTENER	1521
FILESYSTEM	ASM

 

Oracle Pre Installation

#cat /etec/redhat-release

[root@ole7ora19casm ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.5 (Maipo)

 

# ifconfig -a

enp0s8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500         inet 192.168.56.103  netmask 255.255.255.0  broadcast 192.168.56.255         inet6 fe80::7ed2:41c9:8919:7eab  prefixlen 64  scopeid 0x20<link>         ether 08:00:27:ab:dd:32  txqueuelen 1000  (Ethernet)         RX packets 590  bytes 54803 (53.5 KiB)         RX errors 0  dropped 0  overruns 0  frame 0         TX packets 277  bytes 40271 (39.3 KiB)         TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

 

#Hostname

[root@ole7ora19casm ~]# cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 192.168.56.103          ole7ora19casm           ole7ora19casm

 

#Oracle RPM Package

[root@ole7ora19casm ~]# rpm -qa | grep oracle oracleasm-support-2.1.11-2.el7.x86_64 oracle-logos-70.0.3-4.0.7.el7.noarch oraclelinux-release-7.5-1.0.3.el7.x86_64 oracleasmlib-2.0.12-1.el7.x86_64 oracle-database-server-12cR2-preinstall-1.0-3.el7.x86_64

 

#RPM Installation

#yum install -y oracle-database-preinstall-19c

rpm 설치시 의존성 패키지 필요합니다.

 

#Directory Create Grant

mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 mkdir -p /u01/app/19.0.0/grid chown -R oracle:oinstall /u01 chmod -R 775 /u01

 

#Oracle User Password

# passwd oracle oracle 사용자의 비밀 번호 변경 중 새  암호: 잘못된 암호: 암호에 어떤 형식으로 사용자 이름이 포함되어 있습니다 새  암호 재입력: passwd: 모든 인증 토큰이 성공적으로 업데이트 되었습니다.

[root@ole7ora19casm ~]# su - oracle [oracle@ole7ora19casm ~]$ id uid=54321(oracle) gid=54321(oinstall)

 

#SELINUX

[root@ole7ora19casm ~]# cat /etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: #     enforcing - SELinux security policy is enforced. #     permissive - SELinux prints warnings instead of enforcing. #     disabled - No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three two values: #     targeted - Targeted processes are protected, #     minimum - Modification of targeted policy. Only selected processes are protected. #     mls - Multi Level Security protection. SELINUXTYPE=targeted

 

#Linux firewall

[root@ole7ora19casm ~]# # systemctl stop firewalld [root@ole7ora19casm ~]# # systemctl disable firewalld

 

[root@ole7ora19casm ~]# su - oracle [oracle@ole7ora19casm ~]$ 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/.local/bin:$HOME/bin export PATH # Oracle Settings export TMP=/tmp export TMPDIR=/$TMP export ORACLE_HOSTNAME=ole7ora19casm export ORACLE_UNQNAME=orcl export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/$ORACLE_BASE/product/19.0.0/dbhome_1 export ORA_INVENTORY=/u01/app/oraInventory export ORACLE_SID=orcl export PDB_NAME=pdb1 export PATH=/usr/sbin:/usr/local/bin:/$PATH export PATH=/$ORACLE_HOME/bin:/$PATH export LD_LIBRARY_PATH=/$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=/$ORACLE_HOME/jlib:/$ORACLE_HOME/rdbms/jlib

 

Oracle File WINSCP

/u01/app/19.0.0/grid/LINUX.X64_193000_grid_home.zip

/u01/app/oracle/product/19.0.0/dbhome_1/LINUX.X64_193000_db_home.zip

 

OLE7.5 Oracle ASM DISK Configuration 따라하기

Grid Infrastructure Installation

GRID Infrastructure

[oracle@ole7ora19casm grid]$ pwd /u01/app/19.0.0/grid [oracle@ole7ora19casm grid]$ mv /u01/app/oracle/product/19.0.0/dbhome_1/LINUX.X64_193000_grid_home.zip ./ [oracle@ole7ora19casm grid]$ ls -alrt 합계 2821472 -rw-r--r--. 1 oracle oinstall 2889184573  9월 30  2019 LINUX.X64_193000_grid_home.zip drwxr-xr-x. 3 oracle oinstall         18 11월  8 12:46 .. drwxr-xr-x. 2 oracle oinstall         44 11월  8 13:11 . [oracle@ole7ora19casm grid]$ chown -R oracle:oinstall LINUX.X64_193000_grid_home.zip [oracle@ole7ora19casm grid]$ chmod -R 755 LINUX.X64_193000_grid_home.zip [oracle@ole7ora19casm grid]$ unzip LINUX.X64_193000_grid_home.zip

 

GRID Infrastructure

[oracle@ole7ora19casm grid]$ ./gridSetup.sh

[root@ole7ora19casm install]# cd /u01/app/19.0.0/grid/cv/rpm/ [root@ole7ora19casm rpm]# ls -alrt 합계 12 -rw-r--r--. 1 oracle oinstall 11412  3월 13  2019 cvuqdisk-1.0.10-1.rpm drwxr-xr-x. 7 oracle oinstall    71  4월 17  2019 .. drwxr-xr-x. 2 oracle oinstall    35  4월 17  2019 . [root@ole7ora19casm rpm]# [root@ole7ora19casm rpm]# rpm -Uvh cvuqdisk-1.0.10-1.rpm 준비 중...                         ################################# [100%] Using default group oinstall to install package Updating / installing...    1:cvuqdisk-1.0.10-1                ################################# [100%]

[root@ole7ora19casm ~]# /u01/app/oraInventory/orainstRoot.sh 다음 권한 변경 중/u01/app/oraInventory. 그룹에 대한 읽기, 쓰기 권한을 추가하는 중입니다. 월드에 대한 읽기, 쓰기, 실행 권한을 제거하는 중입니다. 그룹 이름 변경 중 /u01/app/oraInventory 대상 oinstall. 스크립트 실행이 완료되었습니다. [root@ole7ora19casm ~]# /u01/app/19.0.0/grid/root.sh Performing root user operation. The following environment variables are set as:     ORACLE_OWNER= oracle     ORACLE_HOME=  /u01/app/19.0.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]:    Copying dbhome to /usr/local/bin ...    Copying oraenv to /usr/local/bin ...    Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params The log of current session can be found at:   /u01/app/oracle/crsdata/ole7ora19casm/crsconfig/roothas_2021-11-08_02-49-16PM.logCreating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_p                                                                              arams The log of current session can be found at:   /u01/app/oracle/crsdata/ole7ora19casm/crsconfig/roothas_2021-11-08_02-49-16PM.                                                                              log 2021/11/08 14:49:29 CLSRSC-363: User ignored prerequisites during installation LOCAL ADD MODE Creating OCR keys for user 'oracle', privgrp 'oinstall'.. Operation successful. LOCAL ONLY MODE Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-4664: ole7ora19casm 노드가 성공적으로 고정되었습니다. 2021/11/08 14:49:44 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd                                                                              .service' ole7ora19casm     2021/11/08 14:52:41     /u01/app/oracle/crsdata/ole7ora19casm/olr/backup_20211108_145241.olr     724960844 2021/11/08 14:52:43 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

 

GRID Infrastructure 설치완료

[root@ole7ora19casm bin]# ./crsctl status res -t -------------------------------------------------------------------------------- Name           Target  State        Server                   State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr                ONLINE  ONLINE       ole7ora19casm            STABLE ora.OCR.dg                ONLINE  ONLINE       ole7ora19casm            STABLE ora.asm                ONLINE  ONLINE       ole7ora19casm            Started,STABLE ora.ons                OFFLINE OFFLINE      ole7ora19casm            STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd       1        ONLINE  ONLINE       ole7ora19casm            STABLE ora.diskmon       1        OFFLINE OFFLINE                               STABLE ora.evmd       1        ONLINE  ONLINE       ole7ora19casm            STABLE --------------------------------------------------------------------------------