手动创建数据库
:
1)定义实例名、数据库名
实例名:mysid
数据库名:mydb
.bash_profile
export ORACLE_SID=mysid
export ORACLE_
2)创建目录
su - oracle
mkdir -p /u01/app/oradata/mydb
mkdir -p /u01/app/flash_recovery_area
mkdir -p /u01/app/admin/mysid/adump
3)创建参数文件
vi /u01/app/product/11.2.0/dbhome_1/dbs/initmysid.ora
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oradata/mydb/control01.ctl'
*.db_block_size=8192
*.db_name='mydb'
*.db_recovery_file_dest='/u01/app/flash_recovery_area'
*.db_recovery_file_dest_size=2G
*.diagnostic_dest='/u01/app'
*.memory_target=800M
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.undo_management=auto
4)启动实例
sqlplus / as sysdba
startup
select instance_name,status from v$instance;
5)创建数据库
create database mydb
user sys identified by oracle
user system identified by oracle
maxinstances 1
maxloghistory 100
maxlogfiles 5
maxlogmembers 3
maxdatafiles 1000
character set zhs16gbk
national character set al16utf16
logfile
group 1('/u01/app/oradata/mydb/redo01.log') size 10m,
group 2('/u01/app/oradata/mydb/redo02.log') size 10m,
group 3('/u01/app/oradata/mydb/redo03.log') size 10m
datafile '/u01/app/oradata/mydb/system.dbf' size 100m autoextend on next 1m maxsize unlimited
sysaux datafile '/u01/app/oradata/mydb/sysaux.dbf' size 50m autoextend on next 1m maxsize unlimited
default tablespace users datafile '/u01/app/oradata/mydb/user01.dbf' size 50m autoextend on next 1m maxsize unlimited
default temporary tablespace temp tempfile '/u01/app/oradata/mydb/temp01.dbf' size 50m autoextend on next 1m maxsize unlimited
undo tablespace undotbs1 datafile '/u01/app/oradata/mydb/undotbs01.dbf' size 50m autoextend on next 1m maxsize unlimited;
6)创建视图和过程
SQL>@/u01/app/product/11.2.0/dbhome_1/rdbms/admin/catalog.sql;
SQL>@/u01/app/product/11.2.0/dbhome_1/rdbms/admin/catproc.sql;
1)定义实例名、数据库名
实例名:mysid
数据库名:mydb
.bash_profile
export ORACLE_SID=mysid
export ORACLE_
2)创建目录
su - oracle
mkdir -p /u01/app/oradata/mydb
mkdir -p /u01/app/flash_recovery_area
mkdir -p /u01/app/admin/mysid/adump
3)创建参数文件
vi /u01/app/product/11.2.0/dbhome_1/dbs/initmysid.ora
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oradata/mydb/control01.ctl'
*.db_block_size=8192
*.db_name='mydb'
*.db_recovery_file_dest='/u01/app/flash_recovery_area'
*.db_recovery_file_dest_size=2G
*.diagnostic_dest='/u01/app'
*.memory_target=800M
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.undo_management=auto
4)启动实例
sqlplus / as sysdba
startup
select instance_name,status from v$instance;
5)创建数据库
create database mydb
user sys identified by oracle
user system identified by oracle
maxinstances 1
maxloghistory 100
maxlogfiles 5
maxlogmembers 3
maxdatafiles 1000
character set zhs16gbk
national character set al16utf16
logfile
group 1('/u01/app/oradata/mydb/redo01.log') size 10m,
group 2('/u01/app/oradata/mydb/redo02.log') size 10m,
group 3('/u01/app/oradata/mydb/redo03.log') size 10m
datafile '/u01/app/oradata/mydb/system.dbf' size 100m autoextend on next 1m maxsize unlimited
sysaux datafile '/u01/app/oradata/mydb/sysaux.dbf' size 50m autoextend on next 1m maxsize unlimited
default tablespace users datafile '/u01/app/oradata/mydb/user01.dbf' size 50m autoextend on next 1m maxsize unlimited
default temporary tablespace temp tempfile '/u01/app/oradata/mydb/temp01.dbf' size 50m autoextend on next 1m maxsize unlimited
undo tablespace undotbs1 datafile '/u01/app/oradata/mydb/undotbs01.dbf' size 50m autoextend on next 1m maxsize unlimited;
6)创建视图和过程
SQL>@/u01/app/product/11.2.0/dbhome_1/rdbms/admin/catalog.sql;
SQL>@/u01/app/product/11.2.0/dbhome_1/rdbms/admin/catproc.sql;