《Oracle11G在Linux上手动创建数据库.docx》由会员分享,可在线阅读,更多相关《Oracle11G在Linux上手动创建数据库.docx(3页珍藏版)》请在三一办公上搜索。
1、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.
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 *.proce
3、sses=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 10
4、0 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/
5、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 tablesp
6、ace 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;