Basic knowledge: Installation of oracle9i under Hp-unix ____oracle

basic knowledge: Installation of oracle9i under Hp-unix

one. Work as root user 1. Configuring Kernel Parameters Log in with root user #sam access to System Administrator Manager In which select kernel configuration, enter later in the selection configurable parameters Modify the following parameters Maxdsiz 1073741824 Maxdsiz_64 2147483648 Maxssiz 134217728 Maxssiz_64 1073741824 Maxusers 1000 Nproc 20+8*maxusers Semmni 500 Semmns 1000 SEMMSL 2048 SEMVMX 32767 Semmnu 500 SHMMAX 1073741824 (the maximum allowable for this machine is this value, which should be the largest physical memory) Shmmni 512 SHMSEG 200 Vps_ceiling 64 2. Disk space required to install Oracle9201 Create 2 file systems, one to install Oracle, not less than 4G, can be named/oracle, another to store Oracle installation files, and not less than 4G, named/oradata, while ensuring that the/TMP directory has more than 55M of free space. 3. Creating DBA groups and Oracle users Log in with root user #sam进入system Administrator Manager In which you select accounts for users and groups Select groups to select Add in the Actions option in menu Enter group name as DBA, and then determine Back to accounts for users and groups Select users to select Add in the Actions option in menu Enter login name for Oracle,home directory for/home/oracle,primary group name for DBA, OK, enter password Oracle and confirm. two. Setting Oracle's Environment variables #su –oracle Login with Oracle Users $vi. Profile Modify Parameter file At the end of the file, add the following parameters Oracle_base=/oracle oracle_home=/oracle/product/9.2.0.1 Oracle_sid=test Oracle_term=xterm Export Oracle_base oracle_home oracle_sid oracle_term Nls_lang=american_america. Zhs16gbk Export Nls_lang ora_nls33= $ORACLE _home/ocommon/nls/admin/data Export ORA_NLS33 Ld_library_path= $ORACLE _home/lib: $ORACLE _home/ctx/lib:/lib:/usr/lib:$/oracle_home/rdbms/lib: $ORACLE _home/lib32 Shlib_path= $ORACLE _home/lib32: $ORACLE _home/rdbms/lib32 oracle_doc= $ORACLE _base/product/9.2.0.1 Export Shlib_path Ld_library_path Oracle_doc Path=/bin:/usr/bin:/usr/sbin:/opt/bin:/usr/local/bin: $ORACLE _home/bin:/usr/contrib//bin: $PATH Export PATH Classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home//Rdbms/jlib Classpath= $CLASSPATH: $ORACLE _home/network/jlib Export CLASSPATH Editor=vi Export EDITOR Note: the "/" symbol at the end of the line indicates that the next line continues on the previous line. $. ./.profile Application environment variable file three. Installing a system patch Need to install the patch is: Goldqpk11i,megpatch, phkl_25506,phss_26263,phss_24638, the first patch in the attached CD-ROM, the disc mount up later with swinstall–s/cdrom/ goldqpk11i to install, the remaining 3 can be found in the itrc.hp.com, download the first use of the SH command to unlock the. depot file, and then install the patch with Swinstall–s file name, such as phkl_25506, assuming download to/tmp directory. #cd tmp #sh phkl_25506 #swinstall –s/tmp/phkl_25506.depot Note: If the operating system has played a random system patch, just play phss_26263 this patch on the line. Four. To modify a system bug Execute the following command #cd/usr/lib #ln –s/usr/lib/libx11.3 LIBX11.SL #ln –s/usr/lib/libxie.2 LIBXIE.SL #ln –s/usr/lib/libxext.3 LIBXEXT.SL #ln –s/usr/lib/libxhp11.3 LIBXHP11.SL #ln –S/USR/LIB/LIBXI.3 LIBXI.SL #ln –s/usr/lib/libxm.4 LIBXM.SL #ln –S/USR/LIB/LIBXP.2 LIBXP.SL #ln –s/usr/lib/libxt.3 LIBXT.SL #ln –s/usr/lib/libxtst.2 LIBXTST.SL Five. Install Oracle and establish a database (the following should be completed for integrators or vendors) Will download down the server_9201_hpunix64_disk1.cpio.gz,server_9201_hpunix64_disk2.cpio.gz,server_9201_hpunix64_ disk3.cpio.gz,server_9201_hpunix64_disk4.cpio.gz four files into/oradata, extract gunzip file name into 4. cpio files, then use CPIO–IDCMV < The filename extracts the 4 cpio files and generates 4 directory DISK1,DISK2,DISK3,DISK4. Install Xmanager and login to the server with an Oracle user, and start a terminal to enter in the terminal: $DISPLAY =your PC ip:0.0 $export DISPLAY $/oradata/disk1/runinstaller And then there's universal installer. The name and home in the Next,source path and destination should already be set, and if destination is not set, the path to enter name and Home,home is the same as the. Profile set. Click Next, select Oracle9i dababase 9.2.0.1.0, click Next Select Custom, click Next, select the component to install, click Next In component locations, click Next directly. In both the Administrator group and the operator group are DBAs, click Next Select No in the CREATE database, click Next JDK home is/OPT/JAVA1.3/JRE, Dot next Look at the summary, then click Install to start the installation After installation, prompts to run the root.sh,telnet server with root login. #cd/oracle/product/9.2.0.1 #sh root.sh Tip Local Bin directory is/usr/local/bin, direct return If there is duplication, cover After performing root.sh return xmanager, click OK The NET Configuration Assistant dialog box appears, click Next Select No, I want to defer this configuration to another time, click Next Enter the name of listener, click Next TCP protocol already installed, click Next Use default port 1521, click Next To indicate whether you want to configure another listener, select No, click Next Listener configuration complete, click Next Select No, I do not be change the naming methods configured, click Next Oracle Net Configuration Complete, point finish The database configuration Assistant appears, click Next Choose Create a database, click Next Select General Purpose, click Next Enter the name and SID number of the database, click Next Select Dedicated Server mode, click Next Select character sets, select Choose from the list of character sets, select ZHS16GBK, click Next The Database Storage window appears, click Next Choose Create DATABASE, click Finish Take a look at summary, okay? Then you start building the database and you need to enter the SYS and system user's password later. Complete the installation, exit exit.