Fedora 安装 Oracle XE Database
Fedora 20Oracle XeOracle VM VirtualBoxFedora 安装oracle 数据库
环境：
Oracle VM VirtualBox 虚拟机4.3.6
Server : Fedora-Live-Desktop-x86_64-20-1.iso
Oracle Database:oracle-xe-11.2.0-1.0.x86_64
虛擬機的硬盤最好設置大一點：可以通過gparted-live-0.17.0-4-amd64這個工具來調整硬盤容量。
虛擬機的swap交換空間至少是2G： 可以通過創建文件的方式來改變swap的大小
1、下载合适的数据库版本:
username/password:oraclesuperuser@jiushiwo.com/Supersteve1234
(请不要修改用户密码)
2、将安装包拷贝至虚拟机以下目录：
/usr/local/share
3、解压缩zip文档
[steve@localhost share]$ sudo unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
解压完毕后会产生Disk1目录
4、进入Disk1目录,并安装oracle rpm包
[steve@localhost share]$ cd Disk1
[steve@localhost share]$ sudo rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
将会出现以下信息：
准备中... ################################# [100%]
正在升级/安装...
1:oracle-xe-11.2.0-1.0 ################################# [100%]
Executing post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
5、Oracle 配置
[steve@localhost Disk1]$ sudo /etc/init.d/oracle-xe configure
将会出现以下信息：
Oracle Database 11g Express Edition Configuration
This will configure on-boot properties of Oracle Database 11g 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 to accept the defaults.
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 11g Express Edition to be started on boot (y/n) [y]:n
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
说明安装成功。可以通过命令查看监听：
[steve@localhost Disk1]$ lsnrctl status
PS: 执行该命令前先修改profile文件：
[steve@localhost ~]$ sudo vi ~/.bash_profile
然后添加(在下面#所提示的那一行后面添加)：
User specific environment and startup programs
. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
保存退出后，执行以下命令，以便让配置生效：
[steve@localhost ~]$ source ~/.bash_profile
6、登陆，并创建用户 stevesys，密码为password
[steve@localhost Disk1]$ sqlplus sys/刚才输入的密码@//localhost/XE as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on 星期四 1月 9 15:27:10 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> create user stevesys identified by password default tablespace users;
用户已创建。
SQL> grant dba to stevesys;
授权成功。
SQL> grant create table to stevesys;
授权成功。
SQL> grant create trigger to stevesys;
授权成功。
SQL> quit
7、测试新用户stevesys
[steve@localhost Disk1]$ sqlplus stevesys/password@XE
SQL*Plus: Release 11.2.0.2.0 Production on 星期四 1月 9 15:30:46 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
至此，数据库安装成功！
命令：
查看监听:lsnrctl status
启动监听：lsnrctl start
启动oracle:sudo /etc/init.d/oracle-xe start
tnsnames.ora的目录：/u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora
listener.ora的目录：/u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
PS：
1、如果想要重新配置oracle， 删除以下文件即可：
/etc/sysconfig/oracle-xe
2、如果是手动启动oracle服务，启动顺序为：
启动监听 -〉启动oracle
3、如果从其他客户端远程访问该数据库，需要开放端口：请移步至：