gentoo上安装oracle-xe

1、下载oracle-xe-univ-10.2.0.1-1.0.i386.rpm 网址 http://www.oracle.com/technology/software/products/database/xe/index.html

2、安装rpm工具

   emerge app-arch/rpm

   emerge app-arch/rpm2targz

3、设置内核参数

File: /etc/sysctl.conf

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

使其生效：

sysctl -p

4、安装需要的包

emerge  glibc libaio bc

5、添加安装用户

groupadd oinstall
useradd -g oinstall oracle
passwd oracle

 

6、安装oracle-xe

rpm -ivh downloads/oracle-xe-univ-10.2.0.1-1.0.i386.rpm --nodeps

如果出现如下错误：
rpmdb: Berkeley DB library configured to support only private environments
rpmdb: Berkeley DB library configured to support only private environments
error: db4 error(22) from dbenv->open: Invalid argument
error: cannot open Packages index using db3 - Invalid argument (22)
error: cannot open Packages database in /var/lib/rpm

请如下操作

1. create the /etc/rpm directory

mkdir -p /etc/rpm

2. insert the following line in /etc/rpm/macros:

echo "%__dbi_cdb  create cdb private mpool mp_mmapsize=16Mb mp_size=1Mb" >> /etc/rpm/macros

3. retry to install oracle:

rpm -ivh downloads/oracle-xe-univ-10.2.0.1-1.0.i386.rpm --nodeps

7、配置

oracle-xe

修改/etc/init.d/orace-xe文件

sudo sed -i -e "s//$SU -s //bin//bash /{1,2/}/$ORACLE_OWNER -c//$SU /$ORACLE_OWNER -l -c/g" oracle-xe

User and group

确保用户dba在oracle组

groups oracle
wheel dba

配置初始话数据库

/etc/init.d/oracle-xe configure

根据提示输入如下信息

• http图形界面端口 (8080)
• 监听器端口 (1521)
• SYS SYSTEM 管理员口令
• 是否系统启动时启动数据库

提示：如果需要重新配置数据库，请先删除/etc/default下的oracle-xe文件。然后重新运行

/etc/init.d/oracle-xe configure

启动关闭：

/etc/init.d/oracle-xe start
/etc/init.d/oracle-xe stop

根据gentoo wiki修改翻译：原文http://www.gentoo-wiki.info/HOWTO_Install_Oracle_10g_Express_Edition