Oracle11G在Linux上手动创建数据库.doc

《Oracle11G在Linux上手动创建数据库.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle11G在Linux上手动创建数据库手动创建数据库：1）定义实例名、数据库名实例名：mysid数据库名：mydb.bash_profileexportORACLE_SID=mysidexportORACLE_2)创建目录su-oraclemkdir-p/u01/app/oradata/mydbmkdir-p/u01/app/flash_recovery_areamkdir-p/u01/app/admin/mysid/adump3)创建参数文件vi/u01/app/product/11.2.0/dbhome_1/dbs/initmysid.ora*.compa

2、tible='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

3、_passwordfile='EXCLUSIVE'*.undo_tablespace='UNDOTBS1'*.undo_management=auto4)启动实例sqlplus/assysdbastartupselectinstance_name,statusfromv$instance;5)创建数据库createdatabasemydbusersysidentifiedbyoracleusersystemidentifiedbyoraclemaxinstances1maxloghistory100maxlogfiles5maxlogmembers3maxdatafi

4、les1000charactersetzhs16gbknationalcharactersetal16utf16logfilegroup1('/u01/app/oradata/mydb/redo01.log')size10m,group2('/u01/app/oradata/mydb/redo02.log')size10m,group3('/u01/app/oradata/mydb/redo03.log')size10mdatafile'/u01/app/oradata/mydb/system.dbf'size100mautoextendonnext1mmaxsize

5、unlimitedsysauxdatafile'/u01/app/oradata/mydb/sysaux.dbf'size50mautoextendonnext1mmaxsizeunlimiteddefaulttablespaceusersdatafile'/u01/app/oradata/mydb/user01.dbf'size50mautoextendonnext1mmaxsizeunlimiteddefaulttemporarytablespacetemptempfile'/u01/app/oradata/mydb/temp01.dbf'size50mautoe

6、xtendonnext1mmaxsizeunlimitedundotablespaceundotbs1datafile'/u01/app/oradata/mydb/undotbs01.dbf'size50mautoextendonnext1mmaxsizeunlimited;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;