分类: Oracle
2006-03-03 22:59:47
debxe:~# alien -d oracle-xe-univ-10.2.0.1-1.0.i386.rpm oracle-xe-univ_10.2.0.1-2_i386.deb generated |
debxe:~# dpkg -i oracle-xe-univ_10.2.0.1-2_i386.deb Selecting previously deselected package oracle-xe-univ. (Reading database ... 20241 files and directories currently installed.) Unpacking oracle-xe-univ (from oracle-xe-univ_10.2.0.1-2_i386.deb) ... Setting up oracle-xe-univ (10.2.0.1-2) ... |
kernel.sem = 250 32000 100 128 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 |
debxe:~# sysctl -p kernel.sem = 250 32000 100 128 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 |
debxe:~# groupadd dba debxe:~# useradd -g dba -d /home/oracle -s /bin/bash oracle debxe:~# passwd oracle Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully debxe:~# mkdir /home/oracle debxe:~# cp /etc/skel/.bash* /home/oracle debxe:~# chown -R oracle:dba /home/oracle |
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server ORACLE_SID=XE export ORACLE_HOME export ORACLE_SID export PATH=$ORACLE_HOME/bin:$PATH export LANG=zh_CN.GBK export LC_ALL=zh_CN.GBK export LANGUAGE=zh_CN.GBK export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" |
debxe:~# chown -R oracle:dba /usr/lib/oracle |
debxe:~# chmod a+x /etc/init.d/oracle-xe |
sga_target=%sga_target% |
sga_target=150000000 |
pga_aggregate_target=%pga_aggregate_target% |
pga_aggregate_target=70000000 |
debian:~# dpkg -i libaio_0.3.104-1_i386.deb Selecting previously deselected package libaio. (Reading database ... 20245 files and directories currently installed.) Unpacking libaio (from libaio_0.3.104-1_i386.deb) ... Setting up libaio (0.3.104-1) ... |
debxe:~# /etc/init.d/oracle-xe configure Oracle Database 10g Express Edition Configuration ------------------------------------------------- This will configure on-boot properties of Oracle Database 10g Express Edition. The following questions will determine whether the database should be starting upon system boot, the ports it will use, and the passwords that will be used for database accounts. Press Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]: Specify a password to be used for database accounts. Note that the same password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after
initial configuration: Confirm the password:
Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]: Starting Oracle Net Listener...Done Configuring Database...Done Starting Oracle Database 10g Express Edition Instance...Done Installation Completed Successfully. To access the Database Home Page go to "" |
debxe:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# ls -al total 28 drwxr-xr-x 2 oracle dba 4096 2006-03-03 20:32 . drwxr-xr-x 4 oracle dba 4096 2006-03-03 20:33 .. -rw-r--r-- 1 oracle dba 5269 2006-03-03 20:32 cloneDBCreation.log -rw-r--r-- 1 oracle dba 1369 2006-03-03 20:31 CloneRmanRestore.log -rw-r--r-- 1 oracle dba 1123 2006-03-03 20:33 postDBCreation.log -rw-r--r-- 1 oracle dba 121 2006-03-03 20:32 postScripts.log |
debxe:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# ps -ef|grep oracle oracle 884 1 0 20:28 ? 00:00:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit oracle 988 1 0 20:32 ? 00:00:00 xe_pmon_XE oracle 990 1 0 20:32 ? 00:00:00 xe_psp0_XE oracle 992 1 0 20:32 ? 00:00:00 xe_mman_XE oracle 994 1 0 20:32 ? 00:00:00 xe_dbw0_XE oracle 996 1 0 20:32 ? 00:00:00 xe_lgwr_XE oracle 998 1 0 20:32 ? 00:00:00 xe_ckpt_XE oracle 1000 1 0 20:32 ? 00:00:01 xe_smon_XE oracle 1002 1 0 20:32 ? 00:00:00 xe_reco_XE oracle 1004 1 0 20:32 ? 00:00:00 xe_cjq0_XE oracle 1006 1 0 20:32 ? 00:00:01 xe_mmon_XE oracle 1008 1 0 20:32 ? 00:00:00 xe_mmnl_XE oracle 1010 1 0 20:32 ? 00:00:00 xe_d000_XE oracle 1012 1 0 20:32 ? 00:00:00 xe_s000_XE oracle 1014 1 0 20:32 ? 00:00:00 xe_s001_XE oracle 1016 1 0 20:32 ? 00:00:00 xe_s002_XE oracle 1018 1 0 20:32 ? 00:00:00 xe_s003_XE oracle 1022 1 0 20:32 ? 00:00:00 xe_qmnc_XE oracle 1049 1 0 20:33 ? 00:00:00 xe_q000_XE oracle 1051 1 0 20:33 ? 00:00:00 xe_q001_XE |
Database Characterset is AL32UTF8 |
debxe:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# netstat -lnp |grep tnslsnr tcp 0 0 127.0.0.1:8080 0.0.0.0:* LISTEN 884/tnslsnr tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 884/tnslsnr unix 2 [ ACC ] STREAM LISTENING 4141 884/tnslsnr /var/tmp/.oracle/sEXTPROC_FOR_XE unix 2 [ ACC ] STREAM LISTENING 4143 884/tnslsnr /var/tmp/.oracle/s#884.1 unix 2 [ ACC ] STREAM LISTENING 4150 884/tnslsnr /var/tmp/.oracle/s#884.2 |
debxe:~# su - oracle oracle@debxe:~$ sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 3月 3 20:59:18 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. 请输入用户名: system/oracle 连接到: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); PL/SQL 过程已成功完成. SQL> exit 从 Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production 断开 |
tcp 0 0 0.0.0.0:8080 0.0.0.0:* LISTEN 884/tnslsnr tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 884/tnslsnr unix 2 [ ACC ] STREAM LISTENING 4141 884/tnslsnr /var/tmp/.oracle/sEXTPROC_FOR_XE unix 2 [ ACC ] STREAM LISTENING 4143 884/tnslsnr /var/tmp/.oracle/s#884.1 unix 2 [ ACC ] STREAM LISTENING 4150 884/tnslsnr /var/tmp/.oracle/s#884.2 |
debxe:~# cd /etc/rc2.d debxe:/etc/rc2.d# ln -s ../init.d/oracle-xe S80oracle-xe debxe:/etc/rc2.d# cd ../rc3.d/ debxe:/etc/rc3.d# ln -s ../init.d/oracle-xe S80oracle-xe debxe:/etc/rc3.d# cd ../rc4.d/ debxe:/etc/rc4.d# ln -s ../init.d/oracle-xe S80oracle-xe debxe:/etc/rc4.d# cd ../rc5.d/ debxe:/etc/rc5.d# ln -s ../init.d/oracle-xe S80oracle-xe debxe:/etc/rc5.d# cd ../rc6.d/ debxe:/etc/rc6.d# ln -s ../init.d/oracle-xe K20oracle-xe debxe:/etc/rc6.d# cd ../rc0.d debxe:/etc/rc0.d# ln -s ../init.d/oracle-xe K20oracle-xe debxe:/etc/rc0.d# cd ../rc1.d debxe:/etc/rc1.d# ln -s ../init.d/oracle-xe K20oracle-xe debxe:/etc/rc1.d# |