'Database/Oracle' 카테고리의 글 목록

Database/Oracle

Oracle SYS/SYSTEM User 삭제 가능한 가? 2023.06.26
Oracle RAC 19c OCR/VOTE ASM Disk 추가 삭제 2023.06.19
Oracle RAC 19c Node 추가 #3 2023.06.12

Oracle SYS/SYSTEM User 삭제 가능한 가?

2023. 6. 26. 09:00

[상태 확인]

[oracle@datarac1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 31 09:51:29 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
SQL> col USERNAME for a15
SQL> select USER_ID, USERNAME, ACCOUNT_STATUS from dba_users where USERNAME in ('SYS','SYSTEM');
   USER_ID USERNAME        ACCOUNT_STATUS
---------- --------------- --------------------------------
         0 SYS             OPEN
         9 SYSTEM          OPEN
SQL>

[SYSTEM User 삭제]

SQL> show user
USER is "SYS"
SQL>
SQL> drop user system;
drop user system
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL> drop user system CASCADE;
drop user system CASCADE
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL>

[SYS User 삭제]

SQL> show user
USER is "SYSTEM"
SQL>
SQL> drop user sys;
drop user sys
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL> drop user sys CASCADE;
drop user sys CASCADE
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL>

[결론]
안된다.
그러니 이상한 소리 하지 말아라..

Oracle RAC 19c OCR/VOTE ASM Disk 추가 삭제

2023. 6. 19. 09:00

현 상태 확인

[root@datarac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@datarac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@datarac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84516
         Available space (kbytes) :     407168
         ID                       : 1930868031
         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@datarac1 bin]#
[root@datarac1 bin]# ./ocrcheck -details
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84516
         Available space (kbytes) :     407168
         ID                       : 1930868031
         Device/File Name         : +OCRVOTE/datarac/OCRFILE/registry.255.1137239017
                                    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@datarac1 bin]#
[root@datarac1 bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   8e99de0aed5d4f45bff8818da83cea68 (/dev/oracleasm/asm-disk01) [OCRVOTE]
 2. ONLINE   1c4f3d989f684fbebf542f9bfb363318 (/dev/oracleasm/asm-disk02) [OCRVOTE]
 3. ONLINE   124978c179a24f20bf37f7db95407eed (/dev/oracleasm/asm-disk03) [OCRVOTE]
Located 3 voting disk(s).
[root@datarac1 bin]#

--OCR/VOTE가 사용하는 ASM Disk 확인
[oracle@datarac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@datarac1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 23 09:21:38 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
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 6;
NAME                       g_no       d_no STATE      REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
OCRVOTE_0000                  2          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk01
OCRVOTE_0001                  2          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk02
OCRVOTE_0002                  2          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk03
DATA1_0000                    1          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk04
DATA1_0001                    1          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk05
DATA1_0002                    1          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk06
                              0          3 NORMAL     UNKNOWN /dev/oracleasm/asm-disk07
                              0          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk08
                              0          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk09
                              0          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk10
10 rows selected.
SQL>

OCR/VOTE용 ASM Disk Group에 ASM DISK 추가 삭제

--OCR/VOTE용 ASM Disk Group에 ASM DISK 추가
[oracle@datarac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@datarac1 ~]$
[oracle@datarac1 ~]$
[oracle@datarac1 ~]$
[oracle@datarac1 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 23 10:39:17 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
SQL> select * from v$asm_operation;
no rows selected
SQL> ALTER DISKGROUP OCRVOTE ADD DISK '/dev/oracleasm/asm-disk07' REBALANCE POWER 5;
Diskgroup altered.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA PASS      STAT      POWER     ACTUAL      SOFAR   EST_WORK
------------ ----- --------- ---- ---------- ---------- ---------- ----------
  EST_RATE EST_MINUTES ERROR_CODE                                       CON_ID
---------- ----------- -------------------------------------------- ----------
           2 REBAL COMPACT   WAIT          5          5          0          0
         0           0                                                       0

           2 REBAL REBALANCE RUN           5          5         62         62
      4241           0                                                       0

           2 REBAL REBUILD   DONE          5          5          0          0
         0           0                                                       0


GROUP_NUMBER OPERA PASS      STAT      POWER     ACTUAL      SOFAR   EST_WORK
------------ ----- --------- ---- ---------- ---------- ---------- ----------
  EST_RATE EST_MINUTES ERROR_CODE                                       CON_ID
---------- ----------- -------------------------------------------- ----------
           2 REBAL RESYNC    DONE          5          5          0          0
         0           0                                                       0
SQL> select * from v$asm_operation;
no rows selected
SQL>
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 6;

NAME                       g_no       d_no STATE      REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
OCRVOTE_0000                  2          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk01
OCRVOTE_0001                  2          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk02
OCRVOTE_0002                  2          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk03
DATA1_0000                    1          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk04
DATA1_0001                    1          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk05
DATA1_0002                    1          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk06
OCRVOTE_0003                  2          3 NORMAL     UNKNOWN /dev/oracleasm/asm-disk07
                              0          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk08
                              0          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk09
                              0          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk10

10 rows selected.

SQL>exit
--OCR/VOTE 확인
[root@datarac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@datarac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@datarac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84516
         Available space (kbytes) :     407168
         ID                       : 1930868031
         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@datarac1 bin]#
[root@datarac1 bin]#
[root@datarac1 bin]# ./ocrcheck -details
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84516
         Available space (kbytes) :     407168
         ID                       : 1930868031
         Device/File Name         : +OCRVOTE/datarac/OCRFILE/registry.255.1137239017
                                    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@datarac1 bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   8e99de0aed5d4f45bff8818da83cea68 (/dev/oracleasm/asm-disk01) [OCRVOTE]
 2. ONLINE   1c4f3d989f684fbebf542f9bfb363318 (/dev/oracleasm/asm-disk02) [OCRVOTE]
 3. ONLINE   124978c179a24f20bf37f7db95407eed (/dev/oracleasm/asm-disk03) [OCRVOTE]
Located 3 voting disk(s).
[root@datarac1 bin]#
--OCR/VOTE용 ASM Disk Group에 ASM DISK 삭제
[oracle@datarac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@datarac1 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 23 10:46:20 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
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 6;
NAME                       g_no       d_no STATE      REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
OCRVOTE_0000                  2          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk01
OCRVOTE_0001                  2          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk02
OCRVOTE_0002                  2          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk03
DATA1_0000                    1          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk04
DATA1_0001                    1          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk05
DATA1_0002                    1          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk06
OCRVOTE_0003                  2          3 NORMAL     UNKNOWN /dev/oracleasm/asm-disk07
                              0          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk08
                              0          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk09
                              0          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk10

10 rows selected.
QL>
SQL> ALTER DISKGROUP OCRVOTE DROP DISK OCRVOTE_0000;
Diskgroup altered.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA PASS      STATE           POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
------------ ----- --------- ---------- ---------- ---------- ---------- ---------- ---------- -----------
ERROR_CODE                                       CON_ID
-------------------------------------------- ----------
           2 REBAL COMPACT   WAIT                1          1          0          0          0           0
                                                      0

           2 REBAL REBALANCE RUN                 1          1         53         94       2148           0
                                                      0

           2 REBAL REBUILD   DONE                1          1          0          0          0           0
                                                      0


GROUP_NUMBER OPERA PASS      STATE           POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
------------ ----- --------- ---------- ---------- ---------- ---------- ---------- ---------- -----------
ERROR_CODE                                       CON_ID
-------------------------------------------- ----------
           2 REBAL RESYNC    DONE                1          1          0          0          0           0
                                                      0


SQL> select * from v$asm_operation;
no rows selected
SQL> select name, group_number "g_no", disk_number "d_no", state, redundancy, path from v$asm_disk order by 6;
NAME                       g_no       d_no STATE      REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
                              0          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk01
OCRVOTE_0001                  2          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk02
OCRVOTE_0002                  2          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk03
DATA1_0000                    1          0 NORMAL     UNKNOWN /dev/oracleasm/asm-disk04
DATA1_0001                    1          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk05
DATA1_0002                    1          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk06
OCRVOTE_0003                  2          3 NORMAL     UNKNOWN /dev/oracleasm/asm-disk07
                              0          2 NORMAL     UNKNOWN /dev/oracleasm/asm-disk08
                              0          1 NORMAL     UNKNOWN /dev/oracleasm/asm-disk09
                              0          3 NORMAL     UNKNOWN /dev/oracleasm/asm-disk10

10 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
[oracle@datarac1 ~]$
--OCR/VOTE 확인
[root@datarac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@datarac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@datarac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84516
         Available space (kbytes) :     407168
         ID                       : 1930868031
         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@datarac1 bin]# ./ocrcheck -details
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84516
         Available space (kbytes) :     407168
         ID                       : 1930868031
         Device/File Name         : +OCRVOTE/datarac/OCRFILE/registry.255.1137239017
                                    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@datarac1 bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   1c4f3d989f684fbebf542f9bfb363318 (/dev/oracleasm/asm-disk02) [OCRVOTE]
 2. ONLINE   124978c179a24f20bf37f7db95407eed (/dev/oracleasm/asm-disk03) [OCRVOTE]
 3. ONLINE   626f4793a1794fc9bfeec52aa161bbcf (/dev/oracleasm/asm-disk07) [OCRVOTE]
Located 3 voting disk(s).
[root@datarac1 bin]# exit

Oracle RAC 19c Node 추가 #3

2023. 6. 12. 09:00

Oracle DB S/W addnode

[oracle@datarac1 addnode]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 addnode]$ env | grep SID
ORACLE_SID=DATARAC1
[oracle@datarac1 addnode]$ pwd
/u01/app/oracle/product/19.0.0/db_1/addnode
[oracle@datarac1 addnode]$ ls
addnode_oraparam.ini  addnode_oraparam.ini.sbs  addnode.pl  addnode.sh
[oracle@datarac1 addnode]$
[oracle@datarac1 addnode]$
[oracle@datarac1 addnode]$ ./addnode.sh -silent -ignoreSysPrereqs -ignorePrereqFailure \
> -waitForCompletion CLUSTER_NEW_NODES=datarac3
[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
   CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/addNodeActions2023-05-22_05-51-48PM.log
   ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/addNodeActions2023-05-22_05-51-48PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.

Prepare Configuration in progress.

Prepare Configuration successful.
..................................................   7% Done.

Copy Files to Remote Nodes in progress.
..................................................   12% Done.
..................................................   18% Done.
..............................
Copy Files to Remote Nodes successful.
You can find the log of this install session at:
 /u01/app/oraInventory/logs/addNodeActions2023-05-22_05-51-48PM.log

Instantiate files in progress.

Instantiate files successful.
..................................................   52% Done.

Saving cluster inventory in progress.
..................................................   89% Done.

Saving cluster inventory successful.
The Cluster Node Addition of /u01/app/oracle/product/19.0.0/db_1 was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2023-05-22_05-51-48PM.log' for more details.

Setup Oracle Base in progress.

Setup Oracle Base successful.
..................................................   96% Done.

As a root user, execute the following script(s):
        1. /u01/app/oracle/product/19.0.0/db_1/root.sh

Execute /u01/app/oracle/product/19.0.0/db_1/root.sh on the following nodes:
[datarac3]


Successfully Setup Software with warning(s).
..................................................   100% Done.
[oracle@datarac1 addnode]$

추가 Node에서 root.sh 실행

[root@datarac3 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@datarac3 ~]#
[root@datarac3 ~]# /u01/app/oracle/product/19.0.0/db_1/root.sh
Check /u01/app/oracle/product/19.0.0/db_1/install/root_datarac3.localdomain_2023-05-22_18-00-18-763394494.log for the output of root script
[root@datarac3 ~]#

DB Instance 추가

[oracle@datarac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 ~]$ env | grep SID
ORACLE_SID=DATARAC1
[oracle@datarac1 ~]$
[oracle@datarac1 ~]$ dbca -silent -addInstance -gdbName DATARAC -nodeName datarac3 -instanceName DATARAC3
Prepare for db operation
40% complete
Adding instance
48% complete
52% complete
56% complete
60% complete
64% complete
68% complete
72% complete
80% complete
Completing instance management.
86% complete
100% complete
Instance "DATARAC" added successfully on node "datarac3".
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/DATARAC/DATARAC.log" for further details.
[oracle@datarac1 ~]$

최종 상태 확인

[oracle@datarac1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       datarac1               STABLE
               ONLINE  ONLINE       datarac2               STABLE
               ONLINE  ONLINE       datarac3               STABLE
ora.chad
               ONLINE  ONLINE       datarac1               STABLE
               ONLINE  ONLINE       datarac2               STABLE
               ONLINE  ONLINE       datarac3               STABLE
ora.net1.network
               ONLINE  ONLINE       datarac1               STABLE
               ONLINE  ONLINE       datarac2               STABLE
               ONLINE  ONLINE       datarac3               STABLE
ora.ons
               ONLINE  ONLINE       datarac1               STABLE
               ONLINE  ONLINE       datarac2               STABLE
               ONLINE  ONLINE       datarac3               STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       datarac1               STABLE
      2        ONLINE  ONLINE       datarac2               STABLE
      3        ONLINE  ONLINE       datarac3               STABLE
ora.DATA1.dg(ora.asmgroup)
      1        ONLINE  ONLINE       datarac1               STABLE
      2        ONLINE  ONLINE       datarac2               STABLE
      3        ONLINE  ONLINE       datarac3               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       datarac1               STABLE
ora.OCRVOTE.dg(ora.asmgroup)
      1        ONLINE  ONLINE       datarac1               STABLE
      2        ONLINE  ONLINE       datarac2               STABLE
      3        ONLINE  ONLINE       datarac3               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       datarac1               Started,STABLE
      2        ONLINE  ONLINE       datarac2               Started,STABLE
      3        ONLINE  ONLINE       datarac3               Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       datarac1               STABLE
      2        ONLINE  ONLINE       datarac2               STABLE
      3        ONLINE  ONLINE       datarac3               STABLE
ora.cvu
      1        ONLINE  ONLINE       datarac1               STABLE
ora.datarac.db
      1        ONLINE  ONLINE       datarac1               Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
      2        ONLINE  ONLINE       datarac2               Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
      3        ONLINE  ONLINE       datarac3               Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
ora.datarac1.vip
      1        ONLINE  ONLINE       datarac1               STABLE
ora.datarac2.vip
      1        ONLINE  ONLINE       datarac2               STABLE
ora.datarac3.vip
      1        ONLINE  ONLINE       datarac3               STABLE
ora.qosmserver
      1        ONLINE  ONLINE       datarac1               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       datarac1               STABLE
--------------------------------------------------------------------------------
[oracle@datarac1 ~]$

PREV 1 2 3 4 ···10 NEXT

Database Sync

Database/Oracle

Oracle SYS/SYSTEM User 삭제 가능한 가?

Oracle RAC 19c OCR/VOTE ASM Disk 추가 삭제

현 상태 확인

OCR/VOTE용 ASM Disk Group에 ASM DISK 추가 삭제

Oracle RAC 19c Node 추가 #3

Oracle DB S/W addnode

추가 Node에서 root.sh 실행

DB Instance 추가

최종 상태 확인

+ Recent posts

티스토리툴바