'분류 전체보기' 카테고리의 글 목록

분류 전체보기

Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk 2024.07.01
Oracle SYS/SYSTEM User 삭제 가능한 가? 2023.06.26
Oracle RAC 19c OCR/VOTE ASM Disk 추가 삭제 2023.06.19

Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk

2024. 7. 1. 09:00

[증 상]
-Oracle Linux 9.4 + Oracle DB 19c 설치 과정에서 아래와 같은 메시지 출력

[원 인]
Oracle Linux 9 / Redhat Linux 9인 경우 Bug 33794281 - OL9: LIBPTHREAD_NONSHARED.A IS NEEDED FOR ORACLE DATABASE 23C AND 19C 임
해당 Bug는 DB RU 19.21에서 Fix 됨

그외 OS는 Oralce MOS예서 2760289.1 문서 확인 필요

[처리방법]
※주의 : Oracle Linux 9 / Redhat Linux 9인 경우에만 해당, 그외 OS 및 OS버전은 Oralce MOS예서 2760289.1 문서 확인 필요

-최신 OPatch로 교체

[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ol9 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.
[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ cd ..
[oracle@ol9 dbhome_1]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@ol9 dbhome_1]$ mv OPatch OPatch_OLD
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ cd /u01/STAGE/
[oracle@ol9 STAGE]$ unzip -d $ORACLE_HOME p6880880_190000_Linux-x86-64.zip
Archive:  p6880880_190000_Linux-x86-64.zip
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatchauto
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/doc/
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/bin/
   creating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/ocm/lib/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/features/com.oracle.glcm.patch.opatch-common-api-classpath.jar
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.sun.org.apache.xml.internal.resolver.jar
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.oracle.glcm.patch.opatchauto-wallet_12.2.1.42.0.jar
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/com.sun.xml.bind.jaxb-jxc.jar
  inflating: /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/modules/javax.activation.javax.activation.jar
[oracle@ol9 STAGE]$
[oracle@ol9 STAGE]$ cd $ORACLE_HOME/OPatch
[oracle@ol9 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ol9 OPatch]$
[oracle@ol9 OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@ol9 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.42

OPatch succeeded.
[oracle@ol9 OPatch]$

-최신 RU를 적용 하고 설치 작업

ex)

$ export CV_ASSUME_DISTID=OL8                          <<<<<   If performing Installation on Oracle Linux 9
$ export CV_ASSUME_DISTID=RHEL8                        <<<<<   If performing Installation on Red Hat Linux 9
$ ./runInstaller -applyRU <19.23 DBRU Patch 36233263 unzip Location> -applyOneOffs <19.23 OCW RU 36240578 unzip location>

[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ cd /u01/STAGE/RU/36233126
[oracle@ol9 36233126]$ ls -al
total 144
drwxr-x---. 8 oracle dba    159 Apr 12 10:03 .
drwxr-xr-x. 3 oracle dba     45 Jun 25 13:34 ..
drwxr-x---. 5 oracle dba     81 Apr 12 10:04 36233263
drwxr-x---. 5 oracle dba     62 Apr 12 10:03 36233343
drwxr-x---. 5 oracle dba     62 Apr 12 10:03 36240578
drwxr-x---. 4 oracle dba     48 Apr 12 10:04 36383196
drwxr-x---. 4 oracle dba     48 Apr 12 10:04 36460248
drwxr-x---. 2 oracle dba   4096 Apr 12 10:08 automation
-rw-rw-r--. 1 oracle dba   5824 Apr 12 19:44 bundle.xml
-rw-r--r--. 1 oracle dba 132988 Apr 16 21:15 README.html
-rw-r--r--. 1 oracle dba      0 Apr 12 10:08 README.txt
[oracle@ol9 36233126]$
[oracle@ol9 36233126]$ cd $ORACLE_HOME
[oracle@ol9 dbhome_1]$ ls
addnode     cfgtoollogs  ctx     dbs          dmu      has            inventory  jlib  mgw      olap        oracore  oui    precomp  rdbms        root.sh.old.1  slax          sqlplus   usm
apex        clone        cv      deinstall    drdaas   hs             javavm     ldap  network  OPatch      ord      owm    QOpatch  relnotes     runInstaller   sqldeveloper  srvm      utl
assistants  crs          data    demo         dv       install        jdbc       lib   nls      OPatch_OLD  ords     perl   R        root.sh      schagent.conf  sqlj          suptools  wwg
bin         css          dbjava  diagnostics  env.ora  instantclient  jdk        md    odbc     opmn        oss      plsql  racg     root.sh.old  sdk            sqlpatch      ucp       xdk
[oracle@ol9 dbhome_1]$
[oracle@ol9 dbhome_1]$ export CV_ASSUME_DISTID=OL8
[oracle@ol9 dbhome_1]$ ./runInstaller -applyRU /u01/STAGE/RU/36233126/36233263 -applyOneOffs /u01/STAGE/RU/36233126/36240578
Preparing the home to patch...
Applying the patch /u01/STAGE/RU/36233126/36233263...
Successfully applied the patch.
Applying the patch /u01/STAGE/RU/36233126/36240578...
Successfully applied the patch.
The log can be found at: /tmp/InstallActions2024-06-25_02-14-43PM/installerPatchActions_2024-06-25_02-14-43PM.log
Launching Oracle Database Setup Wizard...

The response file for this session can be found at:
 /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2024-06-25_02-14-43PM.rsp

You can find the log of this install session at:
 /tmp/InstallActions2024-06-25_02-14-43PM/installActions2024-06-25_02-14-43PM.log

[참고문서]

19c Database Installation/relink fails with :"Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk " (문서 ID 2760289.1)
Requirements for Installing Oracle Database/Client 19c (19.22 or higher) on OL9 or RHEL9 64-bit (x86-64) (문서 ID 2982833.1)

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

PREV 1 2 3 4 ···15 NEXT

Database Sync