[Install] HP Unix Install Oracle11g(Single Instance)

HP Unix Install Oracle11g(Single Instance)

1.Hardware check.
  (1)machinfo | grep -i memory   # memory>2G
  (2)swapinfo -a
  (3)bdf                         #Disk Space Require

2.Software Check.
   uname -a                    
     HP-UX hostname B.11.31 U ia64 hostid unlimited-user license
     swlist | grep -i qpk
     B.11.31.1609              # hp os 11.31 patch需要0809以上的版本.

3.Patch Check.
 swlist -l product | grep -i PHCO_43503              #已經安裝
 swlist -l product | grep -i PHCO_41479
 swlist -l product | grep -i PHKL_38038
 swlist -l product | grep -i PHKL_38938
 swlist -l product | grep -i PHKL_40941
 swlist -l product | grep -i PHSS_36354
 swlist -l product | grep -i PHSS_37042              #已經安裝
 swlist -l product | grep -i PHSS_37959
 swlist -l product | grep -i PHSS_39094
 swlist -l product | grep -i PHSS_39100
 swlist -l product | grep -i PHSS_39102
 swlist -l product | grep -i PHSS_38141
 swlist -l product | grep -i PHSS_39824
 swlist -l product | grep -i PHKL_39773               #for VERITAS File System
 
4.OS kernel Check.
                     Value             Oracle recommend
------------------------------------------------------------------
 ksi_alloc_max       56000             32768
 executable_stack    0                 0
 max_thread_proc     10000             1024
 maxdsiz             2147483648 (2G)   1073741824 (1G)  
 maxdsiz_64bit       4294967296 (4G)   2147483648 (2G)
 maxssiz             268435456 (256M)  134217728  (128M)
 maxssiz_64bit       1073741824 (1G)   1073741824 (1G)
 maxuprc             9000 (nproc*)/10  3686                      #設定nproc=10000
 msgmni              7000              4096
 msgtql              7000              4096
 ncsize              59072             35840
 maxfiles_lim        65536             32767
 maxfiles            16384             1024
 nflocks             7000              4096
 ninode              58048             34816
 nkthread            52516             7184
 nproc               10000             4096
 semmni              7000              4096
 semmns              14000             8192
 semmnu              9996 (nproc-4)    4092
 semvmx              32767             32767
 shmmax              17179869184 (16G) 1073741824 (1G)
 shmmni              4096              4096
 shmseg              512               512
 tcp_largest_anon_port/udp_largest_anon_port  kctune檢視沒有這個引數,如果需要設定，oracle recommend設定為65500
 
 如果要檢視的話，需要 kctune nproc 檢視設定的值,kctune 加上os 引數檢視.
 修改例子如下:
  kctune max_thread_proc=10000
     ==> Update the automatic 'backup' configuration first? y
       * The automatic 'backup' configuration has been updated.
       * Future operations will update the backup without prompting.
       * The requested changes have been applied to the currently
         running configuration.
  Tunable                    Value  Expression  Changes
  max_thread_proc  (before)   1200  1200        Immed
                   (now)     10000  10000
  kctune max_thread_proc
  Tunable          Value  Expression  Changes
  max_thread_proc  10000  10000       Immed

5.create user
 groupadd -g 900 oinstall
 groupadd -g 901 dba  
 useradd -u 900 -g oinstall -G dba -d /oracle oracle
 
6.Directory Create.
  mkdir /oracle
  mkdir /oradata
  chown oracle:oinstall oracle
  chown oracle:oinstall oradata
  chmod 775 oracle
  chmod 775 oradata
  ls -l
  drwxr-xr-x   2 root       sys             96 Oct 26  2016 diag
  drwxrwxr-x   3 oracle     oinstall        96 Jun 18 14:31 oracle
  drwxrwxr-x   3 oracle     oinstall        96 Jun 18 14:59 oradata

7.Configuring the oracle User's Environment
  export ORACLE_BASE=/oracle
  export ORACLE_HOME=/oracle/DB
  export ORACLE_SID=testdb
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/ccs/lib
  export SHLIB_PATH=$ORACLE_HOME/lib32
  export TNS_ADMIN=$ORACLE_HOME/network/admin
  export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/ccs/bin:/opt/networker/bin:/usr/sbin:$ORACLE_HOME/OPatch:
  export TEMP=/oracle/tmp
  umask 0022
 
8.Software Install  
  開啟圖形介面 xhost +
               ./runInstaller
  之後一步一步
  記住最後要執行orainstRoot.sh和root.sh兩個檔案.
 
  問題
  (1)提示oraInst.loc沒有許可權,HP Unix的這個檔案在/var/opt/oracle/oraInst.loc
  more oraInst.loc
  inventory_loc=/oracle/testdb/oraInventory
  inst_group=dba
  設定/oracle/testdb許可權或者刪除，直接刪除最保險。
  (2)export DISPLAY=xxx.xxx.xxx.xxx:0.0    (這個地方的IP要設定為xmanager所在機器的IP，一直設定安裝DB的Server的IP，瞎忙了半天，哎)
 
9.DBCA建立DB
  輸入dbca會跳出圖形介面
  dbca create database和windows下一樣，下一步下一步操作。
 
10.create listener
  在$ORACLE_HOME/network/admin中的listener.ora加入如下內容  
  SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (SID_NAME = testdb)
        (ORACLE_HOME = /oracle/DB)
      )
    )

  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx.xxxx.xxx.xxxx)(PORT = 1521))
      )
    )