DBA가 되고 싶은 병아리

HP-UX-Oracle RAC 설치 시에 유의점 본문

OS관련/HP-UX

HP-UX-Oracle RAC 설치 시에 유의점

미스틱스 2019. 8. 12. 08:53

최근에 HP에서 오라클 RAC를 설치할 기회가 있었다. 중간에 오류가 발생하여 메뉴얼을 찾아보니 아래와 같은 내용이 특이 사항으로 있었다.

 

B.4 Asynchronous I/O

The asynchronous I/O pseudo-driver on HP-UX enables Oracle Database to perform I/O to raw disk partitions using an asynchronous method, resulting in less I/O overhead and higher throughput. You can use the asynchronous I/O pseudo-driver on both HP-UX servers and workstations.

B.4.1 MLOCK Privilege

To permit Oracle Database to process asynchronous I/O operations, the OSDBA group (dba) must have the MLOCK privilege. To give the dba group the MLOCK privilege:

  1. Log in as the root user.

  2. Using any text editor, open the /etc/privgroup file, or create it if necessary.

  3. Add or edit the following line, which begins with the name of the OSDBA group, specifying the privilege MLOCK:

    Note:

    You must use only one line to specify the privileges for a particular group in this file. If the file already contains a line for the dba group, then add the MLOCK privilege on the same line.

    dba RTPRIO RTSCHED MLOCK
  4. Save the file, and quit the text editor.

  5. Enter the following command to grant the privileges to the OSDBA group:

    # /usr/sbin/setprivgrp -f /etc/privgroup
  6. Enter the following command to verify that the privileges are set correctly:

    # /usr/sbin/getprivgrp dba

출처: https://docs.oracle.com/cd/B19306_01/server.102/b15658/appb_hpux.htm#UNXAR349

 

Administering Oracle Database on HP-UX

13/20 B Administering Oracle Database on HP-UX This appendix provides information about administering Oracle Database on HP-UX. It contains the following topics: B.1 HP-UX Shared Memory Segments for an Oracle Instance When an Oracle Database instance start

docs.oracle.com