手工创建数据库

1. su - oracle
2.export ORACLE_SID=bbk
3.cd $ORACLE_HOME/dbs/
4.orapwd file=orapwbbk password=oracle entries=10
5.vi initbbk.ora
bbk.__db_cache_size=1207959552
bbk.__java_pool_size=16777216
bbk.__large_pool_size=16777216
bbk.__oracle_base='/opt/oracle/app/oracle'#ORACLE_BASE set from environment
bbk.__pga_aggregate_target=2583691264
bbk.__sga_target=1610612736
bbk.__shared_io_pool_size=0
bbk.__shared_pool_size=352321536
bbk.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/app/oracle/admin/bbk/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_file_record_keep_time=7
*.control_files='/oradata/bbk/bbk/control01.ctl','/oradata/bbk/bbk/control02.ctl','/oradata/bbk/bbk/control03.ctl'#Restore Controlfile
*.db_block_size=8192
*.db_domain=''
*.db_name='bbk'
*.db_recovery_file_dest='/opt/oracle/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest='/opt/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=bbkXDB)'
#*.log_archive_dest_1='LOCATION=/backup/archive'
*.open_cursors=300
*.pga_aggregate_target=2577399808
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=555
*.sga_max_size=1073741824
*.sga_target=1073741824
*.undo_tablespace='UNDOTBS1'

6.sqlpus sys/oracle as sysdba;
startup nomount

8.vi creat.sql
CREATE DATABASE "bbk"
MAXDATAFILES 500
MAXINSTANCES 8
MAXLOGFILES 32
CHARACTER SET "UTF8"
NATIONAL CHARACTER SET AL16UTF16
ARCHIVELOG
DATAFILE
'/oradata/bbk/system01.dbf' size 300M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE
'/oradata/prd/sysaux01.ora' size 50M autoextend on next 10240K maxsize unlimited
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/oradata/bbk/tempts01.dbf' SIZE 100M EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/oracle_soft/product/oradata/bbk/undotbs01.dbf' SIZE 200M
LOGFILE
GROUP 1 (
'/oradata/bbk/redo01a.rdo',
'/oradata/bbk/redo01b.rdo'
)SIZE 100M,
GROUP 2(
'/oradata/bbk/redo02a.rdo',
'/oradata/bbk/redo02b.rdo'
)SIZE 100M,
GROUP 3(
'/oradata/bbk/redo03a.rdo',
'/oradata/bbk/redo03b.rdo'
)SIZE 100M
;
9.
CONNECT SYS/password AS SYSDBA
@/u01/oracle/rdbms/admin/catalog.sql
@/u01/oracle/rdbms/admin/catproc.sql
EXIT