ubuntu下安装oracle

http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/oracle-xe-universal_10.2.0.1-1.1_i386.deb
sudo dpkg -i ~/Downloads/oracle-xe-universal_10.2.0.1-1.1_i386.deb
sudo /etc/init.d/oracle-xe configure

里面大多数按回车,到了数据库密码输入一下就可以了

sudo gedit /etc/profile
export ORACLE_SID=XE
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export PATH=$ORACLE_HOME/bin:$PATH
source /etc/profile

以下是oracle日常操作:

sudo ps aux |grep oracle
http://127.0.0.1:8080/apex
sudo /etc/init.d/oracle-xe start
sudo /etc/init.d/oracle-xe stop
su - oracle
sqlplus /nolog
SQL> conn / as sysdba
SQL> startup
SQL> shutdown
su - oracle
lsnrctl
LSNRCTL> start
LSNRCTL> stop
su - oracle
emctl start dbconsole
emctl stop dbconsole

相关推荐