Oracle手动创建数据库
手动建库：bill ----database ---->db_name,instance_name
1.vim pfile -----nomount (control_files,undo)
initorcl.ora
compatible=10.2.0.1.0
db_name=bill
instance_name=bill
sga_max_size=500m
sga_target=300m
undo_tablespace=undotbs1
undo_management=auto
job_queue_processes=10
user_dump_dest=/vmware/app/oracle/admin/bill/udump
core_dump_dest=/vmware/app/oracle/admin/bill/cdump
background_dump_dest=/vmware/app/oracle/admin/bill/bdump
control_files='/vmware/app/oracle/oradata/bill/control01.ctl','/vmware/app/oracle/oradata/bill/control02.ctl'
2.orapwd file=.../orapwbill password=oracle
3. admin,oradata
4.
create database bill
maxinstances 2
maxdatafiles 200
maxlogfiles 32
maxlogmembers 5
maxloghistory 290
user sys identified by oracle
user system identified by oracle
character set utf8
national character set al16utf16
datafile '/vmware/app/oracle/oradata/bill/system01.dbf' size 300m
sysaux datafile '/vmware/app/oracle/oradata/bill/sysaux01.dbf' size 200m
undo tablespace undotbs1 datafile '/vmware/app/oracle/oradata/bill/ndotbs01.dbf' size 100m
default temporary tablespace temp tempfile '/vmware/app/oracle/oradata/bill/temp01.dbf' size 100m
logfile
group 1 '/vmware/app/oracle/oradata/bill/redo01.log' size 100m,
group 2 '/vmware/app/oracle/oradata/bill/redo02.log' size 100m;
/
sys--
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc
conn system/oracle
@?/sqlplus/admin/pupbld －－－－屏蔽登录时候错误提醒
<div style="font-size: 10pt;">
页:
[1]