db_name='tones'
db_block_size=8192
db_cache_size=33554432
db_domain=''
db_file_multiblock_read_count=16
dispatchers="(PROTOCOL=TCP) (SERVICE=tonesXDB)"
background_dump_dest='/u01/admin/tones/bdump'
core_dump_dest='/u01/admin/tones/cdump'
user_dump_dest='/u01/admin/tones/udump'
'/u01/oradata/tones/control03.ctl')
instance_name='tones'
job_queue_processes=10
java_pool_size=83886080
large_pool_size=16777216
shared_pool_size=83886080
processes=150
fast_start_mttr_target=300
remote_login_passwordfile='EXCLUSIVE'
open_cursors=300
pga_aggregate_target=25165824
sort_area_size=524288
undo_management=AUTO
undo_retention=10800
undo_tablespace='UNDOTBS1'
timed_statistics=TRUE
spool DBCreate.log
MAXINSTANCES 8
MAXLOGFILES 32
MAXDATAFILES 500
CHARACTER SET "UTF8"
NATIONAL CHARACTER SET AL16UTF16
DATAFILE
'/u01/oradata/tones/system01.dbf' SIZE 300M
EXTENT MANAGEMENT LOCAL
'/oradata/prd/sysaux01.dbf' size 50M autoextend on next 10240K maxsize unlimited
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u01/oradata/tones/tempts01.dbf' SIZE 100M
EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/u01/oradata/tones/undotbs01.dbf' SIZE 200M
LOGFILE
GROUP 1 ('/u01/oradata/tones/redo01.log') SIZE 100M,
GROUP 2 ('/u01/oradata/tones/redo02.log') SIZE 100M,
GROUP 3 ('/u01/oradata/tones/redo03.log') SIZE 100M;
orapwd file =orapwtones password=oracle entries=10
SQLPLUS / NOLOG
CONN / AS SYSDBA
ORACLE_SID=tones
/u01/oradata/tones 等等
6.生成spfile文件(spfiletones.ora). create spfile from pfile
@$ORACLE_HOME/dbs/crdb01.sql; ///run 也可以
创建时可以查看执行进度 :tail -f alert_tones.log |more
create tablespace mytbs datafile '/u01/oradata/tbs01.dbf' size 100M extent management local;
@?/sqlplus/admin/pupbld.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catalog.sql