熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

ORACLE在HP

2013-11-13 16:13:30  來源: Oracle 

  Oracle: 在HPUX 系統中配置Oracle
  問題
  如何在HPUX 系統中正確地配置Oracle
  配置
  操作系統 HPUX
  版本
  硬件系統 HP
  系統 K
  子系統 Oracle
  解決方法
  
  在HPUX 系統下正確配置Oracle 可執行如下步驟此信息摘錄自Oracle 安裝指南(產品部件號 A) 第二部分(設置環境) 頁碼
  可以在如下的URL鏈接中下載此文檔
  
   以root 登錄
  
   設置Oracle 服務器環境
   為Oracle 配置UXIX內核
   創建Mount 點
   為自己的Oracle軟件設置Unix賬號
   創建一個臨時bin 目錄
   創建oratab文件
   為Oracle 配置Unix內核
   為調節Oracle的SGA結構 配置Unix內核的進程間通訊(IPC)參數
  如果系統中沒有足夠的共享內存以調節SGA的話就無法啟動數據庫
    使用ipcs命令獲得系統當前共享內存和信號段以及他們的標識號及擁有者的列表
   由於HPUX系統中共享內存被動態裝載當運行ipcs您也可能會接到共享內存設施不在系統內的消息 共享內存驅動在Oracle服務器被執行後才被裝載 您可以使用系統管理員(SAM)來確認系統已經配有足夠的共享內存
  以如下的方式設置內核參數
   n 最大尺寸的共享內存段(SHMMAX)
   n 系統中最大數據的共享內存段(SHMMNI)
   n 用戶進程所能附屬的最大數目的共享內存段(SHMSEG)
   n 在全系統內可用於分配的最大共享內存數量(SHMMNS)
   用如下的公式確定總的可用共享內存數量SHMMAX*SHMESG
   在表中的參數控制著信號量與共享內存的分配推薦的數值對於一個實例來講是最優的並且也是基於init sidora文件的缺省值如果想安裝多個實例或是更廣泛地修改init sidora文件 可以把這些參數設得更高些Oracle公司推薦將這些參數在操作系統允許范圍內設置得盡可能高然而將這些參數設置得過高可能會阻止系統的啟動參見操作系統文檔可以得到這些參數的設置限定
   以最小的推薦值用SAM配置HPUX內核
   推薦值
    shmmax=
    shmmin=
    shmmni=
    shmseg=
    semmns=
    semmni=
   
  
  following with all English text
  Oracle: configuring Oracle on an HPUX system
  
  PROBLEM
  
  How do I properly configure Oracle on my HPUX system?
  CONFIGURATION
  Operating System HPUX
  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 systems current
    shared memory and semaphore segments and their identification
    number and owner
  
    Because the shared memory in HPUX 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
     systemwide (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 sidora file If you plan to install more than one
     instance or to modify the init sidora 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 HPUX 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
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.