Search:  
Gentoo Wiki

HOWTO_Install_Oracle_19g_Express_Edition

1.download oracle-xe-univ-10.2.0.1-1.0.i386.rpm

 http://www.oracle.com/technology/software/products/database/xe/index.html

2.

 emerge app-arch/rpm
 emerge app-arch/rpm2targz

3.chang the kernel parameters

 # vi /etc/sysctl.conf
 # Kernel Parameters for Oracle 10g
   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 -s glibc

 emerge -s libaio
 glibc-2.3.2
 libaio-0.3.96 
 应该已经高于此版本,只是rpm不认.

5.

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

6.modify the configuration file

 sed -i "s/\$SU -s \/bin\/bash \$ORACLE_OWNER -c/\$SU \$ORACLE_OWNER -l -c/g" oracle-xe
 sed -i "s/\$SU -s \/bin\/bash  \$ORACLE_OWNER -c/\$SU \$ORACLE_OWNER -l -c/g" oracle-xe

7.确认oracle 在dba组!!否则系统认证不能通过!

 groups oracle
 wheel dba

8. /etc/init.d/oracle-xe configure

9. netstat -an |grep 1521

  ps -ef |grep ora
  ok

10.SQL> CONNECT SYS/AS SYSDBA

  Enter password: 
  SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); (To enable remote access)
Retrieved from "http://www.gentoo-wiki.info/HOWTO_Install_Oracle_19g_Express_Edition"

Last modified: Sun, 27 Apr 2008 19:27:00 +0000 Hits: 1,264