安装oracle及数据的说明：
1.添加主机IP，编辑文件/etc/hosts
vi /etc/hosts
#添加内容，192.168.100.16为对应的主机IP，请根据实际情况作调整
127.0.0.1 localhost localhost.localdomain
192.168.100.16 testapp1
2.修改主机名为testapp1
点击菜单上的“系统”→“管理”→“网络”→“DNS”，修改主机名为testapp1，保存。
3.创建Oracle用户
groupadd -g 500 oinstall
groupadd -g 501 dba
groupadd -g 502 oper
useradd -u 500 -d /home/oracle -g oinstall -G dba,oper -m -s /bin/bash oracle
id oracle
##设置oracle用户密码为oracle
passwd oracle

4.切换到oracle用户，编辑系统属性
# su - oracle
$ vi ~/.bash_profile
添加以下内容
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=moepoc
export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs_1
export LD_LIBRARY_PATH=$ODBC_HOME/lib:$ORACLE_HOME/lib:$ORA_CRS_HOME/bin:/usr/lib64:/usr/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:/usr/bin:$PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
stty erase ^h
export ODBC_HOME=/etc
export ODBCINI=$ODBC_HOME/odbc.ini
umask 022

5.把文件拷贝到根目录，并解压文件到根目录,（由于解压文件为/u01,请确保/u01目录不冲突，可先执行"rm -rf /u01"
cd /
tar zxcf oracle.tar.gz

6.修改权限
chown -R oracle:oinstall /u01
chmod -R 755 /u01

7.重启系统后，启动数据库
reboot
su - oracle
lsnrctl start
sqlplus / as sysdba
startup

create smallfile tablespace xuesheng datafile '/u01/app/oracle/oradata/moepoc/moepoc01.dbf'
size 1600m autoextend on next 10m maxsize unlimited logging extent management local segment space management auto;

alter tablespace xuesheng add datafile '/u01/app/oracle/oradata/moepoc/moepoc02.dbf'
size 1600m autoextend on next 10m maxsize unlimited;

create user xuesheng
identified by moepoc123
default tablespace xuesheng
temporary tablespace temp
profile default;

grant connect to xuesheng;
grant dba to xuesheng;
grant unlimited tablespace to xuesheng;

drop tablespace xuesheng including contents and datafiles;

CREATE TABLESPACE "XUESHENG_YYZW"
LOGGING
DATAFILE '/u01/app/oracle/oradata/moepoc/XUESHENG_YYZW.dbf' SIZE 5000M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
alter tablespace XUESHENG_YYZW add datafile '/u01/app/oracle/oradata/moepoc/XUESHENG_YYZW2.dbf'
size 5000m autoextend on next 10m maxsize unlimited;

CREATE TABLESPACE "WWJHR"
LOGGING
DATAFILE '/u01/app/oracle/oradata/moepoc/WWJHR01.dbf' SIZE 5000M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

alter tablespace WWJHR add datafile '/u01/app/oracle/oradata/moepoc/WWJHR03.dbf'
size 5000m autoextend on next 10m maxsize unlimited;

CREATE TEMPORARY TABLESPACE "XUESHENG_YYZW_TMP"
TEMPFILE '/u01/app/oracle/oradata/moepoc/XUESHENG_YYZW_tmp.dbf' SIZE 2000M EXTENT
MANAGEMENT LOCAL UNIFORM SIZE 1M;



/**
创建用户
*/

CREATE USER "XUESHENG_YYZW" PROFILE "DEFAULT"
IDENTIFIED BY "moepoc123" DEFAULT TABLESPACE "XUESHENG_YYZW"
TEMPORARY TABLESPACE "XUESHENG_YYZW_TMP"
ACCOUNT UNLOCK;
/**
用户赋予权限
*/

GRANT CREATE PROCEDURE TO "XUESHENG_YYZW" WITH ADMIN OPTION;
GRANT CREATE SEQUENCE TO "XUESHENG_YYZW" WITH ADMIN OPTION;
GRANT CREATE TABLE TO "XUESHENG_YYZW" WITH ADMIN OPTION;
GRANT CREATE TRIGGER TO "XUESHENG_YYZW" WITH ADMIN OPTION;
GRANT CREATE VIEW TO "XUESHENG_YYZW" WITH ADMIN OPTION;
GRANT "CONNECT" TO "XUESHENG_YYZW" WITH ADMIN OPTION;
GRANT "DBA" TO "XUESHENG_YYZW" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "XUESHENG_YYZW" WITH ADMIN OPTION;

drop user XUESHENG_YYZW cascade;

declare
maxrecords constant int:=10000;
i int :=1;
begin
for i in 1..maxrecords loop
insert into xs01
(ZA0100,XJH,XM)
values
(SYS_GUID(), to_char('9999'+i),'测试' || to_char('9999'+i)) ;
end loop;
commit;
end;
/

select count(ZA0100) from xs01;

declare
maxrecords constant int:=2;
i int :=1;
begin
for i in 1..maxrecords loop

insert into xs01
(ZA0100,XJH,XM) select SYS_GUID(), to_char(XJH + i), '测试' || to_char(XJH + i) from xs01 ;

end loop;
commit;
end;
/
select count(ZA0100) from xs01;