반응형

[기본환경]
-OEL 8.2
-Oracle RAC 19 + RU 19.13

[Resize전 상황]

[oracle@rac1 ~]$ df -h
Filesystem        Size  Used Avail Use% Mounted on
devtmpfs          3.9G     0  3.9G   0% /dev
tmpfs             3.9G  853M  3.1G  22% /dev/shm
tmpfs             3.9G  9.2M  3.9G   1% /run
tmpfs             3.9G     0  3.9G   0% /sys/fs/cgroup
/dev/sda2         134G   47G   88G  35% /
tmpfs             796M     0  796M   0% /run/user/0
/dev/asm/ogg-232  9.0G  568M  8.5G   7% /OGG
tmpfs             796M     0  796M   0% /run/user/54321
[oracle@rac1 ~]$
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 ~]$ asmcmd lsdg -g OGG
Inst_ID  State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
      1  MOUNTED  EXTERN  N         512             512   4096  4194304     10236      872                0             872              0             N  OGG/
      2  MOUNTED  EXTERN  N         512             512   4096  4194304     10236      872                0             872              0             N  OGG/
[oracle@rac1 ~]$
[oracle@rac1 ~]$ asmcmd lsattr -l -G OGG
Name                        Value
access_control.enabled      FALSE
access_control.umask        066
appliance._partnering_type  GENERIC
ate_conversion_done         true
au_size                     4194304
cell.smart_scan_capable     FALSE
cell.sparse_dg              allnonsparse
compatible.advm             19.0.0.0.0
compatible.asm              19.0.0.0.0
compatible.rdbms            10.1.0.0.0
content.check               FALSE
content.type                data
content_hardcheck.enabled   FALSE
disk_repair_time            12.0h
failgroup_repair_time       24.0h
idp.boundary                auto
idp.type                    dynamic
logical_sector_size         512
maxblkdump_content.check    3
maxdump_content.check       32
maxerr_content.check        1048576
phys_meta_replicated        true
preferred_read.enabled      FALSE
scrub_async_limit           1
scrub_metadata.enabled      TRUE
sector_size                 512
thin_provisioned            FALSE
vam_migration_done          false
[oracle@rac1 ~]$

 

[ACFS Resize]

[oracle@rac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 ~]$
[oracle@rac1 ~]$ which acfsutil
/usr/sbin/acfsutil
[oracle@rac1 ~]$
[oracle@rac1 ~]$ ls -al /usr/sbin/acfsutil
-rwxr-xr-x. 1 root root 2862 Mar 19 16:38 /usr/sbin/acfsutil
[oracle@rac1 ~]$ acfsutil size 5G /OGG
acfsutil size: new file system size: 5368709120 (5120MB)
[oracle@rac1 ~]$
[oracle@rac1 ~]$ df -h
Filesystem        Size  Used Avail Use% Mounted on
devtmpfs          3.9G     0  3.9G   0% /dev
tmpfs             3.9G  853M  3.1G  22% /dev/shm
tmpfs             3.9G  9.2M  3.9G   1% /run
tmpfs             3.9G     0  3.9G   0% /sys/fs/cgroup
/dev/sda2         134G   47G   88G  35% /
tmpfs             796M     0  796M   0% /run/user/0
/dev/asm/ogg-232  5.0G  376M  4.7G   8% /OGG
tmpfs             796M     0  796M   0% /run/user/54321
[oracle@rac1 ~]$
[oracle@rac1 ~]$ acfsutil size 7G /OGG
acfsutil size: new file system size: 7516192768 (7168MB)
[oracle@rac1 ~]$
[oracle@rac1 ~]$ df -h
Filesystem        Size  Used Avail Use% Mounted on
devtmpfs          3.9G     0  3.9G   0% /dev
tmpfs             3.9G  853M  3.1G  22% /dev/shm
tmpfs             3.9G  9.2M  3.9G   1% /run
tmpfs             3.9G     0  3.9G   0% /sys/fs/cgroup
/dev/sda2         134G   47G   88G  35% /
tmpfs             796M     0  796M   0% /run/user/0
/dev/asm/ogg-232  7.0G  376M  6.7G   6% /OGG
tmpfs             796M     0  796M   0% /run/user/54321
[oracle@rac1 ~]$

 

반응형
반응형

[기존 환경 확인]

[oracle@rac1 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 15 14:07:48 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +OCR/rac/ASMPARAMETERFILE/registry.253.1081948961
SQL> set linesize 150
SQL> col name for a20
SQL> col state for a10
SQL> col path for a40
SQL> select name, group_number "g_no", disk_number "d_no", state, redundancy, path from v$asm_disk order by 2;
NAME                       g_no       d_no STATE      REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
                              0          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk6
                              0          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk9
                              0          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk7
                              0          3 NORMAL     UNKNOWN /dev/oracleasm/asm-disk8
DATA_0000                     1          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk4
OCR_0000                      2          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk1
OCR_0002                      2          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk3
OCR_0001                      2          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk2
OGG_0000                      3          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk5
9 rows selected.
SQL>

--신규 ASM Diskgroup 생성
[oracle@rac1 ~]$ sqlplus "/as sysasm"
SQL> create diskgroup OCRVOTE normal redundancy disk '/dev/oracleasm/asm-disk7' ,'/dev/oracleasm/asm-disk8' ,'/dev/oracleasm/asm-disk9' attribute 'compatible.rdbms'='19.0.0.0', 'compatible.asm'='19.0.0.0', 'au_size'='4M';
--기존 OCR/Vote 확인
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     901284
         Used space (kbytes)      :      84420
         Available space (kbytes) :     816864
         ID                       : 1506319257
         Device/File Name         :       +OCR
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
[root@rac1 bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   79e105a1de7d4f6ebf0b83a4ddaf2cdd (/dev/oracleasm/asm-disk1) [OCR]
 2. ONLINE   376b031ec3134ff9bf86a7fa85182990 (/dev/oracleasm/asm-disk2) [OCR]
 3. ONLINE   01fe3ee7634c4f0abf310e15a97a2fde (/dev/oracleasm/asm-disk3) [OCR]

 

[OCR/VOTE Migration 및 확인]

[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@rac1 bin]# ./ocrconfig -add +OCRVOTE
[root@rac1 bin]# ./ocrconfig -delete +OCR
[root@rac1 bin]# ./crsctl replace votedisk +OCRVOTE
Successful addition of voting disk 4a613638d60f4f15bf2bd0115c6e9a49.
Successful addition of voting disk 5f4d8540a9424fd2bf3a5c65249130a6.
Successful addition of voting disk acbbe1dd19454fe2bfa48781899cd1f8.
Successful deletion of voting disk 79e105a1de7d4f6ebf0b83a4ddaf2cdd.
Successful deletion of voting disk 376b031ec3134ff9bf86a7fa85182990.
Successful deletion of voting disk 01fe3ee7634c4f0abf310e15a97a2fde.
Successfully replaced voting disk group with +OCRVOTE.
CRS-4266: Voting file(s) successfully replaced
[root@rac1 bin]#

--OCR/VOTE변경 확인
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rac1 bin]#
[root@rac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@rac1 bin]#
[root@rac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     901284
         Used space (kbytes)      :      84420
         Available space (kbytes) :     816864
         ID                       : 1506319257
         Device/File Name         :   +OCRVOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
[root@rac1 bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   4a613638d60f4f15bf2bd0115c6e9a49 (/dev/oracleasm/asm-disk7) [OCRVOTE]
 2. ONLINE   5f4d8540a9424fd2bf3a5c65249130a6 (/dev/oracleasm/asm-disk8) [OCRVOTE]
 3. ONLINE   acbbe1dd19454fe2bfa48781899cd1f8 (/dev/oracleasm/asm-disk9) [OCRVOTE]
Located 3 voting disk(s).
[root@rac1 bin]#

[Oracle ASM SPFile 위치 변경]

--ASM spfile 이동
[oracle@rac1 DATASYNCXML]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 15 16:00:05 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> create pfile='/home/oracle/DATASYNCXML/initasm.ora' from spfile;
File created.
SQL> !ls
initasm.ora  stop.txt
SQL> create spfile='+OCRVOTE' from pfile='/home/oracle/DATASYNCXML/initasm.ora';
File created.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@rac1 DATASYNCXML]$

[변경사항 확인 및 후속작업]

[oracle@rac1 DATASYNCXML]$ cd $ORACLE_HOME/bin
[oracle@rac1 bin]$ pwd
/u01/app/19.0.0/grid/bin
[oracle@rac1 bin]$ ./gpnptool get
Warning: some command line parameters were defaulted. Resulting command line:
         ./gpnptool.bin get -o-

<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="6" ClusterUId="11fd2242cacadff5ffb30b5fbc27e40f" ClusterName="rac" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="192.168.56.0" Adapter="enp0s8" Use="public"/><gpnp:Network id="net2" IP="192.168.10.0" Adapter="enp0s9" Use="asm,cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/oracleasm/*" SPFile="+OCRVOTE/rac/ASMPARAMETERFILE/registry.253.1088697629" Mode="remote" Extended="false"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>Ur5kuZgxkcFQhgXx1ZU+03Gse4U=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>VZw5Tw5YSo0L5SbRhpm5ju/RkoRDd9S+/mLkhMfNKGPaD0z6SZxCY5sIi3Wi5eCDAACdxGnPD6HIq7MaRbVRxG6+HmGJeGDcWq55Y7yxV0ehBPIDkc2zZ5rMxU3XxXwv81WrHka1V3rXhys6Pvsq2FOfWpFJHpAEH4rlKje0efcqU3mpGZUXSJK3DuJ6/Nf5
gURo7p6xci4rHZ2ky2BgrPRYCv4hXJ8FCrv5h7bCif6QjqQcsvFVaCKOydvRynEZ9+coH1n17yugVm6aDN/lM2EXSYpk1xuGVYhj9oIHxk6Z0tBmvdLyFJAoVL/Kw0iMyF7LltvXsXFsWsCJ5ouUCg==</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.
[oracle@rac1 bin]$

--Oracle CRS 재기동
[root@rac1 bin]# ./crsctl stop crs
[root@rac1 bin]# ./crsctl start crs

--기존 DIsk group 삭제
[oracle@rac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rac1 ~]$ srvctl stop diskgroup -g OCR
[oracle@rac1 ~]$ srvctl remove diskgroup -g OCR

 

반응형
반응형

[사전확인사항]

Database의 Init Parameter 중 remote_listener 파리미터 확인

-만약 remote_listener 파라미터에 IP로 되어 있는 경우 SCAN 재기동 전에 tnsnames.ora 파일에 수정 해야 한다.

SQL> show parameter remote_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_listener                      string       rac-scan:1521
SQL>

 

[Oracle SCAN IP 변경 전 상태 확인]

[oracle@rac2 ~]$ srvctl config scan
SCAN name: rac-scan, Network: 1
Subnet IPv4: 192.168.56.0/255.255.255.0/enp0s8, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.168.56.110
SCAN VIP is enabled.
[oracle@rac2 ~]$
[oracle@rac2 ~]$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-SEP-2021 15:06:46

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                27-SEP-2021 14:51:19
Uptime                    0 days 0 hr. 15 min. 27 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/rac2/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.110)(PORT=1521)))
Services Summary...
Service "TST" has 2 instance(s).
  Instance "TST1", status READY, has 1 handler(s) for this service...
  Instance "TST2", status READY, has 1 handler(s) for this service...
Service "TSTXDB" has 2 instance(s).
  Instance "TST1", status READY, has 1 handler(s) for this service...
  Instance "TST2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac2 ~]$

[Oracle SCAN IP 변경]

[oracle@rac2 ~]$ srvctl stop scan_listener
[oracle@rac2 ~]$ srvctl stop scan

--모든 Node에 /etc/hosts 파일에 sacn ip 부분을 변경

[root@rac2 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@rac2 bin]# ./srvctl modify scan -n rac-scan
[root@rac2 bin]# ./srvctl config scan
SCAN name: rac-scan, Network: 1
Subnet IPv4: 192.168.56.0/255.255.255.0/enp0s8, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.168.56.115
SCAN VIP is enabled.
[root@rac2 bin]#

[변경된 SCAN IP로 SCAN 기동 및 상태 확인]

[oracle@rac2 ~]$ srvctl start scan
[oracle@rac2 ~]$ srvctl start scan_listener
[oracle@rac2 ~]$ crsctl status res ora.scan1.vip -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.scan1.vip
      1        ONLINE  ONLINE       rac1                     STABLE
--------------------------------------------------------------------------------
[oracle@rac2 ~]$

[oracle@rac1 ~]$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-SEP-2021 15:19:03

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                27-SEP-2021 15:17:25
Uptime                    0 days 0 hr. 1 min. 37 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/rac1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.115)(PORT=1521)))
Services Summary...
Service "TST" has 2 instance(s).
  Instance "TST1", status READY, has 1 handler(s) for this service...
  Instance "TST2", status READY, has 1 handler(s) for this service...
Service "TSTXDB" has 2 instance(s).
  Instance "TST1", status READY, has 1 handler(s) for this service...
  Instance "TST2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac1 ~]$
How to Update the IP Address of the SCAN VIP Resources (ora.scan{n}.vip) (문서 ID 952903.1)
반응형
반응형

[증 상]

OEL7/RHEL7에서 Oracle DB 11.2.0.3 Install시 86%단계에서 Error 발생

-OEL6/RHEL6에서 Oracle DB 11.2.0.3 Install시 해당 Error 발생 하지 않음

[처 리 방 법]

$ORACLE_HOME/sysman/lib/ins_emagent.mk 파일의 175 Line 내용을 추가 후 "Retry" 클릭

#===========================
#  emdctl
#===========================

$(SYSMANBIN)emdctl:
        $(MK_EMAGENT_NMECTL)

#===========================
#  emdctl
#===========================

$(SYSMANBIN)emdctl:
        $(MK_EMAGENT_NMECTL) -lnnz11

 

[원 인]

Oracle DB 11.2.0.3은 OEL7/RHEL7에 인증 되지 않았음

반응형
반응형

[기존 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 ~]$
반응형

+ Recent posts

티스토리툴바