CentOS7安装Oracle-xe
准备介质
- oracle-xe-11.2.0-1.0.x86_64.rpm.zip
安装步骤(root用户安装)
# 下载需要的依赖包
yum install libaio bc flex
# 上传oracle-xe包到指定目录,进行解压
unzip -q oracle-xe-11.2.0-1.0.x86_64.rpm.zip
# 进入Disk1
cd Disk1
# rpm安装
rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
# 执行 configure
/etc/init.d/oracle-xe configure
# 执行脚本oracle_env.sh
cd /u01/app/oracle/product/11.2.0/xe/bin
. ./oracle_env.sh
# 给指定用户的环境变量添加以下内容,注意.bash_profile是隐藏文件!!!
vi .bash_profile
添加:. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
# 令.bash_profile生效
source .bash_profile
测试
[root@ms3 bin]
SQL*Plus: Release 11.2.0.2.0 Production on Wed Sep 21 08:17:26 2011
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect sys/密码 as sysdba
Connected.
SQL>
创建用户
sqlplus /nolog 登陆后:
connect sys/oracle as sysdba
create user ecas identified by ecas;
alter user ecas account unlock;
grant dba to ecas;
quit;
sqlplus ecas/ecas
ecas用户登陆成功
修改字符集
# 查看当前字符集
select * from nls_database_parameters where parameter ='NLS_CHARACTERSET';
# 停掉服务
shutdown immediate;
# 约束方式启动(其他人不可访问)
startup restrict
ALTER DATABASE CHARACTER SET AL32UTF8; 或者 ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
shutdown immediate;
startup
修改system表空间大小
ALTER TABLESPACE SYSTEM ADD DATAFILE 'system01.dbf' SIZE 200M AUTOEXTEND ON NEXT 1024M MAXSIZE 8192M;
linux卸载oracle-xe