国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > Oracle > 正文

ORACLE在HP_UX下的系列問題處理(2)

2024-08-29 13:39:51
字體:
來源:轉載
供稿:網友
UploadFiles/200712579/2008291234618777802 />  Oracle: 在HP-UX 10.20系統中配置Oracle 8.0.5UploadFiles/200712579/2008291234618777802 />  問題UploadFiles/200712579/2008291234618777802 />  如何在HP-UX 10.20系統中正確地配置Oracle 8.0.5UploadFiles/200712579/2008291234618777802 />  配置UploadFiles/200712579/2008291234618777802 />  操作系統 - HP-UXUploadFiles/200712579/2008291234618777802 />  版本 - 10.20 UploadFiles/200712579/2008291234618777802 />  硬件系統 - HP9000UploadFiles/200712579/2008291234618777802 />  系統 - K580 UploadFiles/200712579/2008291234618777802 />   子系統 - Oracle 8.0.5UploadFiles/200712579/2008291234618777802 />  解決方法UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />  在HP-UX 10.20系統下正確配置Oracle 8.0.5 可執行如下步驟:注:此信息摘錄自Oracle 8 安裝指南(產品部件號 A64525-01), 第二部分(設置環境), 頁碼2-4到2-5 。 UploadFiles/200712579/2008291234618777802 />  可以在如下的URL鏈接中下載此文檔:UploadFiles/200712579/2008291234618777802 />   http://docs.oracle.com/f48198/SHIPHOME/DOC/prodUCt_0/a64525.pdfUploadFiles/200712579/2008291234618777802 />  1. 以root 登錄UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />  2. 設置Oracle8 服務器環境UploadFiles/200712579/2008291234618777802 />  - 為Oracle 配置UXIX內核UploadFiles/200712579/2008291234618777802 />   - 創建Mount 點UploadFiles/200712579/2008291234618777802 />   - 為自己的Oracle軟件設置Unix賬號UploadFiles/200712579/2008291234618777802 />   - 創建一個臨時bin 目錄UploadFiles/200712579/2008291234618777802 />   - 創建oratab文件UploadFiles/200712579/2008291234618777802 />  - 為Oracle 配置Unix內核UploadFiles/200712579/2008291234618777802 />   - 為調節Oracle8的SGA結構, 配置Unix內核的進程間通訊(IPC)參數。 UploadFiles/200712579/2008291234618777802 />  假如系統中沒有足夠的共享內存以調節SGA的話,就無法啟動數據庫。 UploadFiles/200712579/2008291234618777802 />  3.  使用'ipcs'命令獲得系統當前共享內存和信號段,以及他們的標識號及擁有者的列表。UploadFiles/200712579/2008291234618777802 />   由于HP-UX系統中共享內存被動態裝載,當運行'ipcs'時,您也可能會接到共享內存設施不在系統內的消息。 共享內存驅動在Oracle8服務器被執行后才被裝載, 您可以使用系統治理員(SAM)來確認系統已經配有足夠的共享內存。UploadFiles/200712579/2008291234618777802 />  4.以如下的方式設置內核參數:UploadFiles/200712579/2008291234618777802 />   - n 最大尺寸的共享內存段(SHMMAX)UploadFiles/200712579/2008291234618777802 />   - n 系統中最大數據的共享內存段(SHMMNI)UploadFiles/200712579/2008291234618777802 />   - n 用戶進程所能附屬的最大數目的共享內存段(SHMSEG)UploadFiles/200712579/2008291234618777802 />   - n 在全系統內可用于分配的最大共享內存數量(SHMMNS)UploadFiles/200712579/2008291234618777802 />   用如下的公式確定總的可用共享內存數量:SHMMAX*SHMESGUploadFiles/200712579/2008291234618777802 />   在表2-2中的參數控制著信號量與共享內存的分配。推薦的數值對于一個實例來講是最優的,并且也是基于init sid.ora文件的缺省值。假如想安裝多個實例,或是更廣泛地修改init sid.ora文件, 可以把這些參數設得更高些。Oracle公司推薦將這些參數在操作系統答應范圍內設置得盡可能高。然而,將這些參數設置得過高可能會阻止系統的啟動。參見操作系統文檔可以得到這些參數的設置限定。 UploadFiles/200712579/2008291234618777802 />  5. 以最小的推薦值用SAM配置HP-UX內核UploadFiles/200712579/2008291234618777802 />   推薦值:UploadFiles/200712579/2008291234618777802 />    shmmax=4294967295UploadFiles/200712579/2008291234618777802 />    shmmin=1UploadFiles/200712579/2008291234618777802 />    shmmni=100UploadFiles/200712579/2008291234618777802 />    shmseg=10UploadFiles/200712579/2008291234618777802 />    semmns=200UploadFiles/200712579/2008291234618777802 />    semmni=70UploadFiles/200712579/2008291234618777802 />   ORACLE在HP_UX下的系列問題處理(2)(圖一)UploadFiles/200712579/2008291234618777802 />   UploadFiles/200712579/2008291234618777802 />  .........following with all English text ....UploadFiles/200712579/2008291234618777802 />  Oracle: configuring Oracle 8.0.5 on an HP-UX 10.20 systemUploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />  PROBLEMUploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />  How do I properly configure Oracle 8.0.5 on my HP-UX 10.20 system?UploadFiles/200712579/2008291234618777802 />  CONFIGURATIONUploadFiles/200712579/2008291234618777802 />  Operating System - HP-UXUploadFiles/200712579/2008291234618777802 />  Version - 10.20UploadFiles/200712579/2008291234618777802 />  Hardware System - HP9000UploadFiles/200712579/2008291234618777802 />  Series - K580UploadFiles/200712579/2008291234618777802 />  Subsystem - Oracle 8.0.5UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />  RESOLUTIONUploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />  Perform the following steps to properly configure Oracle 8.0.5 onUploadFiles/200712579/2008291234618777802 />  your 10.20 system:UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />   Note: This information was extracted from the Oracle 8 InstallationUploadFiles/200712579/2008291234618777802 />      Guide (Part Number A64525-01), Section 2 (Setting theUploadFiles/200712579/2008291234618777802 />      Environment),UploadFiles/200712579/2008291234618777802> pages 2-4 through 2-5.UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />      You can download this document from the following URL (UniformUploadFiles/200712579/2008291234618777802 />      Resource Locator):UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />      http://docs.oracle.com/f48198/SHIPHOME/DOC/product_0/a64525.pdfUploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />   1. Log in as root.UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />   2. Setup the Oracle8 Server environment:UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />    - Configure UNIX Kernel for OracleUploadFiles/200712579/2008291234618777802 />    - Create Mount PointsUploadFiles/200712579/2008291234618777802 />    - Create UNIX Groups for Database AdministratorsUploadFiles/200712579/2008291234618777802 />    - Create UNIX Account to Own Oracle SoftwareUploadFiles/200712579/2008291234618777802 />    - Create a Local bin DirectoryUploadFiles/200712579/2008291234618777802 />    - Create the oratab FileUploadFiles/200712579/2008291234618777802 />    - Configure UNIX Kernel for OracleUploadFiles/200712579/2008291234618777802 />    - Configure the UNIX kernel Interprocess Communication (IPC)UploadFiles/200712579/2008291234618777802 />     parameters to accommodate the SGA structure of the Oracle8UploadFiles/200712579/2008291234618777802 />     Server. You will not be able to start the database if theUploadFiles/200712579/2008291234618777802 />     system does not have adequate shared memory to accommodateUploadFiles/200712579/2008291234618777802 />     the SGA.UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />   3. Use the 'ipcs' command to oBTain a list of the system's currentUploadFiles/200712579/2008291234618777802 />    shared memory and semaphore segments, and their identificationUploadFiles/200712579/2008291234618777802 />    number and owner.UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />    Because the shared memory in HP-UX is dynamically loaded, whenUploadFiles/200712579/2008291234618777802 />    you run 'ipcs', you may receive a message that the shared memoryUploadFiles/200712579/2008291234618777802 />    facility is not in the system. The shared memory driver isUploadFiles/200712579/2008291234618777802 />    loaded after the Oracle8 Server is executed. You can use theUploadFiles/200712579/2008291234618777802 />    System Administration Manager (SAM) to verify that the systemUploadFiles/200712579/2008291234618777802 />    has been configured with enough shared memory.UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />   4. Set the kernel parameters in the following manner:UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />    - n maximum size of a shared memory segment (SHMMAX)UploadFiles/200712579/2008291234618777802 />    - n maximum number of shared memory segments in the systemUploadFiles/200712579/2008291234618777802 />     (SHMMNI)UploadFiles/200712579/2008291234618777802 />    - n maximum number of shared memory segments a user process canUploadFiles/200712579/2008291234618777802 />     attach (SHMSEG)UploadFiles/200712579/2008291234618777802 />    - n maximum amount of shared memory that can be allocatedUploadFiles/200712579/2008291234618777802 />     system-wide (SHMMNS)UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />     Use this formula to determine the total allowable sharedUploadFiles/200712579/2008291234618777802 />     memory:UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />     SHMMAX * SHMSEGUploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />     The parameters in Table 2-2 control the allocation ofUploadFiles/200712579/2008291234618777802 />     semaphores and shared memory. The recommended values areUploadFiles/200712579/2008291234618777802 />     optimal for one instance, and are based on the defaultUploadFiles/200712579/2008291234618777802 />     init sid.ora file. If you plan to install more than oneUploadFiles/200712579/2008291234618777802 />     instance, or to modify the init sid.ora file extensively, setUploadFiles/200712579/2008291234618777802 />     these parameters higher. Oracle Corporation recommends thatUploadFiles/200712579/2008291234618777802 />     you set these parameters as high as possible for the operatingUploadFiles/200712579/2008291234618777802 />     system. However, setting these parameters too high for theUploadFiles/200712579/2008291234618777802 />     operating system can prevent the system from booting. ReferUploadFiles/200712579/2008291234618777802 />     to the operating system documentation for parameter limits.UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />   5. Use SAM to configure the HP-UX kernel with the minimumUploadFiles/200712579/2008291234618777802 />    recommended values:UploadFiles/200712579/2008291234618777802 />  UploadFiles/200712579/2008291234618777802 />    shmmax=4294967295UploadFiles/200712579/2008291234618777802 />    shmmin=1UploadFiles/200712579/2008291234618777802 />    shmmni=100UploadFiles/200712579/2008291234618777802 />    shmseg=10UploadFiles/200712579/2008291234618777802 />    semmns=200UploadFiles/200712579/2008291234618777802 />    semmni=70UploadFiles/200712579/2008291234618777802 />  Table 2-2 Shared Memory and Semaphore ParametersUploadFiles/200712579/2008291234618777802 />  ORACLE在HP_UX下的系列問題處理(2)(圖二)UploadFiles/200712579/2008291234618777802 />  Note: See A4074887 forUploadFiles/200712579/2008291234618777802 />  related information. UploadFiles/200712579/2008291234618777802>
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 盐城市| 泊头市| 隆尧县| 双城市| 昌黎县| 梁山县| 聂拉木县| 阿坝| 邓州市| 个旧市| 仁布县| 玛沁县| 保亭| 玉树县| 牡丹江市| 宁安市| 沙雅县| 马尔康县| 南涧| 瑞安市| 五峰| 梁山县| 大城县| 双桥区| 泽州县| 社旗县| 丰原市| 河曲县| 瑞金市| 洛宁县| 开封县| 建平县| 大宁县| 九寨沟县| 时尚| 百色市| 卫辉市| 安岳县| 衡水市| 河北区| 江口县|