命令行建库102050 RHEL6u5

--创建口令文件
orapw file=orapwfengsh entries=5 password=oracle

--创建参数文件
cp initdw.ora initfengsh.ora
vi initfengsh.ora  :%g/^#/d  :%g/^&/d 或者cat initdw.ora | grep -v ^# | grep -v ^& > initfengsh.ora
###############initfengsh.ora########
db_name=fengsh
db_block_size = 8192
pga_aggregate_target = 200M                                #DEMO
db_cache_size = 30M                                #DEMO
parallel_automatic_tuning = true
parallel_threads_per_cpu = 4                                 #SMALL
optimizer_mode = choose
star_transformation_enabled = true
db_file_multiblock_read_count = 16
query_rewrite_enabled = true
query_rewrite_integrity = trusted
sga_max_size=300M
sga_target=300M
processes=200
control_files=('/u01/app/oracle/oradata/fengsh/control01.ctl')
#####################################

--创建admin目录
mkdir -p /u01/app/oracle/admin/a{a,b,d,u}dump
mkdir -p /u01/app/oracle/oradata/fengsh/

--创建控制文件 1.sql
#######################
CREATE DATABASE fengsh
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/fengsh/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/fengsh/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/fengsh/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET zhs16gbk
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/app/oracle/oradata/fengsh/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/fengsh/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/fengsh/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/fengsh/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
######################

--执行创建
sqlplus / a sysdba
create spfile from spfile;
startup nomount;
@1.sql

--执行生成视图的脚本
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql

--创建默认表空间及数据文件属性修改
create TABLESPACE USER DATAFILE '/u01/app/oracle/oradata/fengsh/user01.dbf' size 5m ;
alter database default tablespace users;
altet database datafile 1 autoextend on;
altet database datafile 2 autoextend on;
altet database datafile 3 autoextend on;
altet database tempfile 1 autoextend on;

--创建监听文件
cp  /u01/app/oracle/product/10.2.0/db_1/network/admin/samples/listener.ora /u01/app/oracle/product/10.2.0/db_1/network/admin
cat /u01/app/oracle/product/10.2.0/db_1/network/admin
LISTENER =
  (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.10)(PORT=1521))
    (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))    
    
--数据库中注册监听文件
alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.10)(PORT=1521))'