반응형
[기존 ASM Disk Mount]
-기존 ASM Disk 상태 확인
[grid@rac1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ASMNET2LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.OCRVOTE.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.36.171 192.1
68.200.20 192.168.10
0.20,STABLE
ora.asm
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
[grid@rac1 ~]$
[grid@rac1 ~]$ sqlplus "/as sysasm"
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +OCRVOTE/rac-cluster/ASMPARAME
TERFILE/registry.253.107265750
3
SQL> create pfile='/home/grid/DATASYNCXML/init+ASM1.ora_20210523' from spfile;
SQL> set linesize 150
SQL> col name for a20
col state for a10
col path for a40
select name, group_number "g_no", disk_number "d_no", state, redundancy, path from v$asm_disk order by 2;SQL> SQL> SQL>
NAME g_no d_no STATE REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
0 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk5
0 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk3
0 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk4
0 3 NORMAL UNKNOWN /dev/oracleasm/asm-disk2
0 4 NORMAL UNKNOWN /dev/oracleasm/asm-disk1
OCRVOTE_0000 1 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk6
6 rows selected.
SQL> col name for a15
col state for a10
col ALLOCATION_UNIT_SIZE for a25
select NAME, GROUP_NUMBER "g_no", ALLOCATION_UNIT_SIZE "a_size", STATE,TOTAL_MB, FREE_MB from v$asm_diskgroup;SQL> SQL> SQL>
NAME g_no a_size STATE TOTAL_MB FREE_MB
--------------- ---------- ---------- ---------- ---------- ----------
DG1 0 0 DISMOUNTED 0 0
DG2 0 0 DISMOUNTED 0 0
OCRVOTE 1 4194304 MOUNTED 102396 68388
SQL> col disk_name for a20
col state for a10
SELECT b.name as group_name, a.name as disk_name, a.header_status, a.state, a.free_mb FROM v$asm_disk a, v$asm_diskgroup b WHERE a.group_number = b.group_number ;SQL> SQL>
GROUP_NAME DISK_NAME HEADER_STATU STATE FREE_MB
------------------------------ -------------------- ------------ ---------- ----------
DG1 MEMBER NORMAL 0
DG1 CANDIDATE NORMAL 0
DG1 MEMBER NORMAL 0
DG1 CANDIDATE NORMAL 0
DG1 CANDIDATE NORMAL 0
DG2 MEMBER NORMAL 0
DG2 CANDIDATE NORMAL 0
DG2 MEMBER NORMAL 0
DG2 CANDIDATE NORMAL 0
DG2 CANDIDATE NORMAL 0
OCRVOTE OCRVOTE_0000 MEMBER NORMAL 68388
11 rows selected.
SQL>-기존 ASM Diskgroup Mount
--RAC 전체 노드에서 각각 수행 해야 함
[grid@rac1 ~]$ sqlplus "/as sysasm"
SQL> alter diskgroup DG1 mount;
Diskgroup altered.
SQL> alter diskgroup DG2 mount;
Diskgroup altered.
SQL>
SQL> show parameter asm_diskgroups
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DG1, DG2
[grid@rac2 ~]$ sqlplus "/as sysasm"
SQL> alter diskgroup DG1 mount;
Diskgroup altered.
SQL> alter diskgroup DG2 mount;
Diskgroup altered.
SQL>
SQL> show parameter asm_diskgroups
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DG1, DG2--기존 ASM Disk Group Mount 후 확인
[grid@rac1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ASMNET2LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DG1.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DG2.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.OCRVOTE.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.36.171 192.1
68.200.20 192.168.10
0.20,STABLE
ora.asm
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
[grid@rac1 ~]$ asmcmd -p
ASMCMD [+] > lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 10236 6776 0 6776 0 N DG1/
MOUNTED EXTERN N 512 512 4096 4194304 10236 9456 0 9456 0 N DG2/
MOUNTED EXTERN N 512 512 4096 4194304 102396 68388 0 68388 0 Y OCRVOTE/
ASMCMD [+] > cd DG1
ASMCMD [+DG1] > ls
ASM/
TEST/
orapwasm
ASMCMD [+DG1] > cd TEST
ASMCMD [+DG1/TEST] > ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
ASMCMD [+DG1/TEST] > cd DATAFILE
ASMCMD [+DG1/TEST/DATAFILE] > ls
SYSAUX.262.1072566651
SYSTEM.261.1072566647
UNDOTBS1.263.1072566653
USERS.265.1072566663
ASMCMD [+DG1/TEST/DATAFILE] > exit
[grid@rac1 ~]$[Oracle Database RAC 전환]
-기존 Single DB 형태로 Open Test
---audit traile 경로 생성(양쪽 Node 각각)
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ ls
cr_con.sql_20210515 initTEST.ora_20210515 orapwTEST tnsnames.ora
[oracle@rac1 DATASYNCXML]$
---DB 기동 Test
[oracle@rac1 DATASYNCXML]$ export ORACLE_SID=TEST
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysdba"
SQL*Plus: Release 12.2.0.1.0 Production on Sun May 16 12:31:13 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile='/home/oracle/DATASYNCXML/initTEST.ora_20210515';
ORACLE instance started.
Total System Global Area 2499805184 bytes
Fixed Size 8623784 bytes
Variable Size 687868248 bytes
Database Buffers 1795162112 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@rac1 DATASYNCXML]$ ps -ef | grep pmon
oracle 1176 23292 0 12:31 pts/0 00:00:00 grep --color=auto pmon
grid 3428 1 0 12:12 ? 00:00:00 asm_pmon_+ASM1
grid 4710 1 0 12:13 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 32407 1 0 12:31 ? 00:00:00 ora_pmon_TEST
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysdba"
SQL> shutdown immediate-DB Single to RAC 전환
---inti Parameter 변경
[oracle@rac1 DATASYNCXML]$ cp initTEST.ora_20210515 initTEST.ora.rac
[oracle@rac1 DATASYNCXML]$ vi initTEST.ora.rac
*.audit_file_dest='/oracle/base/admin/TEST/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_files='+DG1/TEST/CONTROLFILE/current.257.1072566643','+DG2/TEST/CONTROLFILE/current.256.1072566643'
*.db_block_size=8192
*.db_create_file_dest='+DG1'
*.db_create_online_log_dest_1='+DG1'
*.db_create_online_log_dest_2='+DG2'
*.db_name='TEST'
*.diagnostic_dest='/oracle/base'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'
#*.local_listener='LISTENER_TEST'
*.local_listener=''
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=793m
*.processes=320
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=2378m
#*.undo_tablespace='UNDOTBS1'
TEST1.undo_tablespace='UNDOTBS1'
TEST2.undo_tablespace='UNDOTBS2'
*.cluster_database_instances=2
TEST1.instance_number=1
TEST2.instance_number=2
TEST1.thread=1
TEST2.thread=2
*.cluster_database=false
#*.cluster_database=true --최종 시 변경 해야 함'
[oracle@rac1 DATASYNCXML]$ ls
cr_con.sql_20210515 initTEST.ora_20210515 initTEST.ora.rac orapwTEST tnsnames.ora
[oracle@rac1 DATASYNCXML]$ vi initTEST.ora.rac
[oracle@rac1 DATASYNCXML]$ echo $ORACLE_SID
TEST
[oracle@rac1 DATASYNCXML]$ export ORACLE_SID=TEST1
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysdba"
SQL> startup pfile='/home/oracle/DATASYNCXML/initTEST.ora.rac';
ORACLE instance started.
Total System Global Area 2516582400 bytes
Fixed Size 8623832 bytes
Variable Size 671090984 bytes
Database Buffers 1828716544 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.
SQL> select COMP_ID,COMP_NAME from dba_registry where COMP_ID='RAC';
no rows selected
SQL>@?/rdbms/admin/catclust.sql
SQL> select COMP_ID,COMP_NAME from dba_registry where COMP_ID='RAC';
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
RAC
Oracle Real Application Clusters
SQL>
SQL> alter database add logfile thread 2 group 4 ('+DG1','+DG2') size 200m;
Database altered.
SQL> alter database add logfile thread 2 group 5 ('+DG1','+DG2') size 200m;
Database altered.
SQL> alter database add logfile thread 2 group 6 ('+DG1','+DG2') size 200m;
Database altered.
SQL> alter database enable public thread 2;
Database altered.
SQL> create undo tablespace UNDOTBS2 datafile '+DG1' size 500M;
Tablespace created.
SQL>
SQL> shutdown immediate---inti Parameter 변경
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ ls
cr_con.sql_20210515 initTEST.ora_20210515 initTEST.ora.rac orapwTEST tnsnames.ora
[oracle@rac1 DATASYNCXML]$ vi initTEST.ora.rac
*.audit_file_dest='/oracle/base/admin/TEST/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_files='+DG1/TEST/CONTROLFILE/current.257.1072566643','+DG2/TEST/CONTROLFILE/current.256.1072566643'
*.db_block_size=8192
*.db_create_file_dest='+DG1'
*.db_create_online_log_dest_1='+DG1'
*.db_create_online_log_dest_2='+DG2'
*.db_name='TEST'
*.diagnostic_dest='/oracle/base'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'
#*.local_listener='LISTENER_TEST'
*.local_listener=''
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=793m
*.processes=320
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=2378m
#*.undo_tablespace='UNDOTBS1'
TEST1.undo_tablespace='UNDOTBS1'
TEST2.undo_tablespace='UNDOTBS2'
*.cluster_database_instances=2
TEST1.instance_number=1
TEST2.instance_number=2
TEST1.thread=1
TEST2.thread=2
#*.cluster_database=false
*.cluster_database=true
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysdba"
SQL> startup pfile='/home/oracle/DATASYNCXML/initTEST.ora.rac';
SQL> create spfile='+DG1' from pfile='/home/oracle/DATASYNCXML/initTEST.ora.rac';
File created.
SQL> shutdown immediate
[grid@rac2 ~]$ asmcmd -p
ASMCMD [+] > lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 10236 5652 0 5652 0 N DG1/
MOUNTED EXTERN N 512 512 4096 4194304 10236 8844 0 8844 0 N DG2/
MOUNTED EXTERN N 512 512 4096 4194304 102396 68388 0 68388 0 Y OCRVOTE/
ASMCMD [+] > cd DG1
ASMCMD [+DG1] > ls
ASM/
TEST/
orapwasm
ASMCMD [+DG1] > cd TEST
ASMCMD [+DG1/TEST] > ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
ASMCMD [+DG1/TEST] > cd P*
ASMCMD [+DG1/TEST/PARAMETERFILE] > ls
spfile.266.1072569847
spfile.271.1072702275
ASMCMD [+DG1/TEST/PARAMETERFILE] > ls -l
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE MAY 15 23:00:00 Y spfile.266.1072569847
PARAMETERFILE UNPROT COARSE MAY 16 12:00:00 Y spfile.271.1073316629
ASMCMD [+DG1/TEST/PARAMETERFILE] >
---각각 Node passwd 파일 및 기타 설정 파일 원복
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ ls
cr_con.sql_20210515 initTEST.ora_20210515 initTEST.ora.rac orapwTEST tnsnames.ora
[oracle@rac1 DATASYNCXML]$ cp orapwTEST $ORACLE_HOME/dbs
[oracle@rac1 DATASYNCXML]$ cp tnsnames.ora $ORACLE_HOME/network/admin
[oracle@rac1 DATASYNCXML]$ scp orapwTEST oracle@rac2:/oracle/product/12.2.0.1/db_1/dbs
orapwTEST 100% 3584 2.2MB/s 00:00
[oracle@rac1 DATASYNCXML]$ scp tnsnames.ora oracle@rac2:/oracle/product/12.2.0.1/db_1/network/admin
tnsnames.ora 100% 412 241.5KB/s 00:00
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ cd $ORACLE_HOME/dbs
[oracle@rac1 dbs]$ ls
hc_TEST1.dat hc_TEST.dat init.ora orapwTEST
[oracle@rac1 dbs]$ cp orapwTEST orapwTEST1
[oracle@rac1 dbs]$ cd $ORACLE_HOME/network/admin
[oracle@rac1 admin]$ ls
samples shrept.lst tnsnames.ora
[oracle@rac1 admin]$ vi tnsnames.ora
LISTENER_TEST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)
[oracle@rac2 admin]$ cd $ORACLE_HOME
[oracle@rac2 db_1]$ cd dbs
[oracle@rac2 dbs]$ ls
init.ora orapwTEST
[oracle@rac2 dbs]$ cp orapwTEST orapwTEST2
[oracle@rac2 dbs]$ cd $ORACLE_HOME/network/admin
[oracle@rac2 admin]$ ls
samples shrept.lst tnsnames.ora
[oracle@rac2 admin]$ vi tnsnames.ora
LISTENER_TEST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)-Oracle CRS에 Database Resource 등록
[grid@rac1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ASMNET2LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DG1.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DG2.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.OCRVOTE.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.36.171 192.1
68.200.20 192.168.10
0.20,STABLE
ora.asm
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
[grid@rac1 ~]$
[oracle@rac1 ~]$ srvctl add database -d TEST -o /oracle/product/12.2.0.1/db_1/ -spfile +DG1/TEST/PARAMETERFILE/spfile.271.1073316629
[oracle@rac1 ~]$ srvctl add instance -d TEST -i TEST1 -n rac1
[oracle@rac1 ~]$ srvctl add instance -d TEST -i TEST2 -n rac2
[grid@rac2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ASMNET2LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DG1.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DG2.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.OCRVOTE.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.36.171 192.1
68.200.20 192.168.10
0.20,STABLE
ora.asm
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.test.db
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------------
[grid@rac2 ~]$
[oracle@rac1 ~]$ srvctl start database -d TEST
[grid@rac2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ASMNET2LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DG1.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DG2.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.OCRVOTE.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.36.171 192.1
68.200.20 192.168.10
0.20,STABLE
ora.asm
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.test.db
1 ONLINE ONLINE rac1 Open,HOME=/oracle/pr
oduct/12.2.0.1/db_1/
,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/oracle/pr
oduct/12.2.0.1/db_1/
,STABLE
--------------------------------------------------------------------------------
[grid@rac2 ~]$[기타 작업]
---현 삳태 확인
[grid@rac1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 16-MAY-2021 13:13:02
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 16-MAY-2021 12:13:21
Uptime 0 days 0 hr. 59 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid/12.2.0.1/grid/network/admin/listener.ora
Listener Log File /grid/base/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.101)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.103)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DG1" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DG2" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCRVOTE" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "TEST" has 1 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Service "TESTXDB" has 1 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$
--리스너 Port 변경
[grid@rac1 ~]$ srvctl modify listener -l listener -o /grid/12.2.0.1/grid -p "TCP:1621"
[grid@rac1 ~]$ srvctl stop listener
[grid@rac1 ~]$ srvctl start listener
[grid@rac1 ~]$ su - oracle
[oracle@rac1 ~]$ srvctl stop database -d TEST
[oracle@rac1 ~]$ cd $ORACLE_HOME/network/admin
[oracle@rac1 admin]$ vi tnsnames.ora
[oracle@rac1 admin]$ srvctl start database -d TEST
[oracle@rac1 admin]$ su - grid
[grid@rac1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 16-MAY-2021 13:20:57
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 16-MAY-2021 13:15:58
Uptime 0 days 0 hr. 4 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid/12.2.0.1/grid/network/admin/listener.ora
Listener Log File /grid/base/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.101)(PORT=1621)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.103)(PORT=1621)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DG1" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DG2" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCRVOTE" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "TEST" has 1 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Service "TESTXDB" has 1 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$반응형