linux oracle11g 新建数据库,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