Oracle: 在HP
UX
系統中配置Oracle
問題
如何在HP
UX
系統中正確地配置Oracle
配置
操作系統
HP
UX
版本
硬件系統
HP
系統
K
子系統
Oracle
解決方法
在HP
UX
系統下正確配置Oracle
可執行如下步驟
注
此信息摘錄自Oracle
安裝指南（產品部件號 A
)
第二部分（設置環境）
頁碼
到
可以在如下的URL鏈接中下載此文檔
以root 登錄
設置Oracle
服務器環境
為Oracle 配置UXIX內核
創建Mount 點
為自己的Oracle軟件設置Unix賬號
創建一個臨時bin 目錄
創建oratab文件
為Oracle 配置Unix內核
為調節Oracle
的SGA結構
配置Unix內核的進程間通訊（IPC）參數
如果系統中沒有足夠的共享內存以調節SGA的話
就無法啟動數據庫
使用
ipcs
命令獲得系統當前共享內存和信號段
以及他們的標識號及擁有者的列表
由於HP
UX系統中共享內存被動態裝載
當運行
ipcs
時
您也可能會接到共享內存設施不在系統內的消息
共享內存驅動在Oracle
服務器被執行後才被裝載
您可以使用系統管理員（SAM）來確認系統已經配有足夠的共享內存
以如下的方式設置內核參數
n 最大尺寸的共享內存段（SHMMAX）
n 系統中最大數據的共享內存段（SHMMNI）
n 用戶進程所能附屬的最大數目的共享內存段（SHMSEG）
n 在全系統內可用於分配的最大共享內存數量（SHMMNS）
用如下的公式確定總的可用共享內存數量
SHMMAX*SHMESG
在表
中的參數控制著信號量與共享內存的分配
推薦的數值對於一個實例來講是最優的
並且也是基於init sid
ora文件的缺省值
如果想安裝多個實例
或是更廣泛地修改init sid
ora文件
可以把這些參數設得更高些
Oracle公司推薦將這些參數在操作系統允許范圍內設置得盡可能高
然而
將這些參數設置得過高可能會阻止系統的啟動
參見操作系統文檔可以得到這些參數的設置限定
以最小的推薦值用SAM配置HP
UX內核
推薦值
shmmax=
shmmin=
shmmni=
shmseg=
semmns=
semmni=
following with all English text
Oracle: configuring Oracle
on an HP
UX
system
PROBLEM
How do I properly configure Oracle
on my HP
UX
system?
CONFIGURATION
Operating System
HP
UX
Version
Hardware System
HP
Series
K
Subsystem
Oracle
RESOLUTION
Perform the following steps to properly configure Oracle
on
your
system:
Note: This information was extracted from the Oracle
Installation
Guide (Part Number A
)
Section
(Setting the
Environment)
pages
through
You can download this document from the following URL (Uniform
Resource Locator):
Log in as root
Setup the Oracle
Server environment:
Configure UNIX Kernel for Oracle
Create Mount Points
Create UNIX Groups for Database Administrators
Create UNIX Account to Own Oracle Software
Create a Local bin Directory
Create the oratab File
Configure UNIX Kernel for Oracle
Configure the UNIX kernel Interprocess Communication (IPC)
parameters to accommodate the SGA structure of the Oracle
Server
You will not be able to start the database if the
system does not have adequate shared memory to accommodate
the SGA
Use the
ipcs
command to obtain a list of the system
s current
shared memory and semaphore segments
and their identification
number and owner
Because the shared memory in HP
UX is dynamically loaded
when
you run
ipcs
you may receive a message that the shared memory
facility is not in the system
The shared memory driver is
loaded after the Oracle
Server is executed
You can use the
System Administration Manager (SAM) to verify that the system
has been configured with enough shared memory
Set the kernel parameters in the following manner:
n maximum size of a shared memory segment (SHMMAX)
n maximum number of shared memory segments in the system
(SHMMNI)
n maximum number of shared memory segments a user process can
attach (SHMSEG)
n maximum amount of shared memory that can be allocated
system
wide (SHMMNS)
Use this formula to determine the total allowable shared
memory:
SHMMAX * SHMSEG
The parameters in Table
control the allocation of
semaphores and shared memory
The recommended values are
optimal for one instance
and are based on the default
init sid
ora file
If you plan to install more than one
instance
or to modify the init sid
ora file extensively
set
these parameters higher
Oracle Corporation recommends that
you set these parameters as high as possible for the operating
system
However
setting these parameters too high for the
operating system can prevent the system from booting
Refer
to the operating system documentation for parameter limits
Use SAM to configure the HP
UX kernel with the minimum
recommended values:
shmmax=
shmmin=
shmmni=
shmseg=
semmns=
semmni=
Table
Shared Memory and Semaphore Parameters
Note: See A
for
related information
From:http://tw.wingwit.com/Article/program/Oracle/201311/17983.html
