Oracle11G在Linux上手动创建数据库

Oracle11G在Linux上手动创建数据库

手动创建数据库：

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;