Oracle 10GManual creation of database Helloblock writing)
1. Set the Instance name:Modify the/home/oracle/. bash_profile file and add the following lines. Use the command source/home/oracle/. bash_profile to make the modification take effect.
2. Create related directories:Mkdir/u01/app/oracle/oradata/orclmkdir/u01/app/oracle/admin/orclmkdir/u01/app/oracle/admin/orcl/adumpmkdir/u01/app/oracle/ admin/orcl/bdumpmkdir/u01/app/oracle/admin/orcl/cdumpmkdir/u01/app/oracle/admin/orcl/udump
3. Create a password file:Cd/u01/app/oracle/product/10.2.0/db_1/dbsorapwd file = orapworcl password = oracle entries = 10 force = y
4. Create a parameter file:Cd/u01/app/oracle/product/10.2.0/db_1/dbscat init. ora | grep-v ^ # | grep-v ^ $> initorcl. ora
Modify initorcl. ora file, content: db_name = orcldb_block_size = 8192undo_management = autoundo_tablespace = undotbssga_target = 500mcontrol_files = ('/u01/app/oracle/oradata/orcl/control01.ctl ', '/u01/app/oracle/oradata/orcl/control02.ctl ') audit_file_dest = '/u01/app/oracle/admin/orcl/adump 'background _ dump_dest ='/u01/app/oracle/admin/orcl/bdump 'core _ dump_dest = '/ u01/app/oracle/admin/orcl/cdump 'user _ dump_dest = '/u01/app/oracle/admin/orcl/udump'
5. Generate the spfile file and start it to the nomount state:Sqlplus/as sysdbacreate spfile from pfile; startup nomount;
6. Create a database:Create database orcl user sys identified by oracle user system identified by oracle logfile group 1 ('/u01/app/oracle/oradata/orcl/redo01a. log', '/u01/app/oracle/oradata/orcl/redo01b. log ') SIZE 300 M, GROUP 2 ('/u01/app/oracle/oradata/orcl/redo02a. log', '/u01/app/oracle/oradata/orcl/redo02b. log ') SIZE 300 M, GROUP 3 ('/u01/app/oracle/oradata/orcl/redo03a. log', '/u01/app/oracle/oradata/orcl/redo03b. log ') SIZE 300 m maxlogfiles 20 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 500 MAXINSTANCES 5 character set AL32UTF8 national character set character datafile '/u01/app/oracle/oradata/orcl/comment 'size 500 M REUSE AUTOEXTEND on next 10 m maxsize unlimited extent management local sysaux datafile '/u01/app/oracle/oradata/orcl/sysaux01.dbf' SIZE 500 m reuse autoextend on next 10 m maxsize unlimited default tablespace users DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf' SIZE 500 m reuse autoextend on next 10 m maxsize unlimited default temporary tablespace temp TEMPFILE'/u01/app/oracle/oradata/ orcl/temp01.dbf 'size 300 m reuse autoextend on next 10 m maxsize unlimited undo tablespace undotbs datafile'/u01/app/oracle/oradata/orcl/comment 'size 200 M REUSE AUTOEXTEND ON NEXT 10 m maxsize unlimited;
7. Execute the script:Sqlplus/as sysdba @? /Rdbms/admin/catalog ;@? /Rdbms/admin/catproc ;@? /Rdbms/admin/catblock ;@? /Rdbms/admin/catoctk ;@? /Rdbms/admin/owminst. plb;
Sqlplus system @? /Sqlplus/admin/pupbld. SQL;
8. Set the default tablespace and the default temporary tablespace:Alter database default tablespace users; alter database default temporary tablespace temp;
Mail: helloblock@126.com
QQ: 1654294099
This article is from the "Helloblock DBA footprint" blog, please be sure to keep this source http://helloblock.blog.51cto.com/7899615/1294370
