DBA가 되고 싶은 병아리
HP-UX-Oracle RAC 설치 시에 유의점 본문
최근에 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:
-
Log in as the root user.
-
Using any text editor, open the /etc/privgroup file, or create it if necessary.
-
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 -
Save the file, and quit the text editor.
-
Enter the following command to grant the privileges to the OSDBA group:
# /usr/sbin/setprivgrp -f /etc/privgroup -
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