 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 />
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 />   UploadFiles/200712579/2008291234618777802 />  Note: See A4074887 forUploadFiles/200712579/2008291234618777802 />  related information. UploadFiles/200712579/2008291234618777802>
UploadFiles/200712579/2008291234618777802 />  Note: See A4074887 forUploadFiles/200712579/2008291234618777802 />  related information. UploadFiles/200712579/2008291234618777802>新聞熱點
疑難解答