sqlplus / as sysasm
grant sysasm to sys;
Q1. Run the Cluster Verify Utility before and post database installation, and check connectivity, user, permission, ASM, OCR and Votedisk verifications (10min)
cluvfy stage -pre crsinst -n all -verbose
cluvfy stage -post crsinst -n all -verbose
Q2. Install a RAC database on 2 node cluster using DBCA (15min)
https://yooliberalhouse.tistory.com/128
7-1 Grid Infrastructure and ASM - Install Oracle Grid Infrastructure (7) Install Oracle Database 19c
1. [노드1] https://www.oracle.com/kr/database/technologies/oracle19c-linux-downloads.html 에서 LINUX.X64_193000_db_home.zip 설치 후, VMmachine에 파일 이동 [root@srv1 ~]# mkdir -p /u01/app/oracle/product/19c/db_1 [root@srv1 ~]# chown -R oracle:o
yooliberalhouse.tistory.com
https://yooliberalhouse.tistory.com/129
7-1 Grid Infrastructure and ASM - Install Oracle Grid Infrastructure (8) Create RAC Database
1. OUI를 실행한다 dbca 2. 실행 결과, RAC가 원활히 작동하고 있는지 확인한다. crsctl check cluster -all crsctl stat res -t ## node1 sqlplus create user c##ryu identified by asdf0930k; grant dba to c##ryu; exit; ssh srv2 sqlplus c##ryu
yooliberalhouse.tistory.com
Q3. Create and configure new diskgroup using asmca utility in a silent mode (10min)
$ asmca -silent -createDiskGroup
-diskGroupName NANO
-disk '/dev/oracleasm/NANO*'
-redundancy external
-au_size 64
-compatible.asm '19.0.0.0.0'
-compatible.rdbms '19.0.0.0.0'
-compatible.advm '19.0.0.0.0'
References
Q4. Install a RAC database in a silent mode (10min)
dbca -silent -createDatabase
-templateName General_Purpose.dbc
-sid database_system_identifier
-sysPassword SYS_user_password
-systemPassword SYSTEM_user_password
-emConfiguration {DBEXPRESS | CENTRAL | BOTH | NONE}
-storageType ASM
-diskGroupName DATA
-nodelist node1,node2
-databaseConfigType RAC
-databaseType {MULTIPURPOSE | DATA_WAREHOUSING | OLTP}
srvctl status database -d RACDB
sqlplus / as sysdba
SHOW PARAMETER cluster_database;
