2010年3月16日

Install Oracle 11g R2 on Ubuntu

Ubuntu is not an official supported linux version from Oracle, so I still get some errors during the install process even with required configuration, anyway, it can work and what i'm doing here is try to setup an experiment environment, it's enough to me, any one who want to deploy Oracle in product mode should have supported linux platform like RedHat, OK, following is the steps i have to install it:

1. If you were in multihomed enviroment, set the ORACLE_HOSTNAME variable:
    export ORACLE_HOSTNAME=machine_name.domain_name

2. Create create OSDBA (dba) group, Oracle Inventory group (oinstall)  and a user "oracle" which has "dba" as its login group and oinstall as its 2nd group.

3. Modify /etc/sysctl.conf, set kernel parameter:

kernel.shmall = 2097152
kernel
.shmmax = 2147483648
kernel
.shmmni = 4096
kernel
.sem = 250 32000 100 128
fs
.file-max = 65536
net
.ipv4.ip_local_port_range = 1024 65000
net
.core.rmem_default = 1048576
net
.core.rmem_max = 1048576
net
.core.wmem_default = 262144
net
.core.wmem_max = 262144

4. Modify /etc/security/limits.conf to improve the "number of process" and "number of open file"  performance for oracle:
oracle              soft    nproc   2047
oracle              hard    nproc   
16384
oracle              soft    nofile  
1024
oracle              hard    nofile  
65536

5. Modify /etc/pam.d/login, add:
session    required     /lib/security/pam_limits.so
session    required     pam_limits
.so

6. Modify /etc/profile:
if [ $USER = "oracle" ]; then
        
if [ $SHELL = "/bin/ksh" ]; then
              ulimit 
-16384
              ulimit 
-65536
        
else
              ulimit 
-16384 -65536
        fi
fi

7. Change user to oracle if you haven't done it yet

8. Create base directory, for me it's "/app/oracle"

9. Export ORACLE_BASE, ORACLE_SID
export ORACLE_BASE=/app/oracle
export ORACLE_SID
=orcl

10.  If you're trying to install oracle with a X window:
DISPLAY=your.ip.address:0.0 ; export DISPLAY

11. run installer:
./runInstaller

12. Oracle should start, if the installer GUI cannot be start, check the error messages, most time it's because a wrong X window configuration, if you are running X window with Xming, just like me, please do make sure to check the "No Access Control" check box in the launch, otherwise, Xming will reject the connection.

13. Now the GUI shoudl open, like what you did in the Windows system, fullfill required value and click next, ingore all errors if there is any condition that is not match, click finish in the last step, it should start install process.

14. After install oracle, the installer GUI will ask you to run two .sh files, run it with a root role.

15. You can try to visit https://you.ip.address:1158/em to see is that OK for you.

16. How to start oracle:
export ORACLE_BASE=/app/oracle
export ORACLE_HOME
=/app/oracle/product/11.2.0/dbhome_1
export ORACLE_OWNR
=oracle
export ORACLE_SID
=orcl
export PATH
=$PATH:$ORACLE_HOME/bin


lsnrctl start

sqlplus 
/nolog
connect /as sysdba
startup
quit

emctl start dbconsole


Reference
http://download.oracle.com/docs/cd/B19306_01/install.102/b15660/pre_install.htm#BABDFJAE

posted @ 2010-03-16 15:57 Find it, try it, experience it 阅读(587) | 评论 (0)编辑 收藏

<2010年3月>
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910

导航

统计

公告

If there is any question you have, please don't hesitate, let me know ASAP, you can find me at kenees@gmail.com or QQ: 9808873, hope to make friends with you ;)

常用链接

留言簿(1)

随笔档案

文章档案

搜索

积分与排名

最新评论

阅读排行榜

评论排行榜