Full Process of 10 Gb manual Oracle database creation in Linux

Lab Environment
 
1. Create a linux Virtual Machine RedHat5.0 system under vm8
 
2.10201 _ database_linux32 Database
 
Lab Purpose
 
1. Master the manual Oracle database creation
 
 
 
OK. Why do we need to create a database manually? A: Because DBCA databases are considered low, so you must learn to create a database manually.
 
The following describes the basic process of manual database creation. I am a newbie. After reading many documents from cool people, I found that manual database creation is not as complicated as I imagined. Of course, in this experiment, I only want to learn how to create a database manually,
 
The purpose and performance of the database are not taken into account. Therefore, many parameters use the default value. If you want to build a database with excellent performance, you should read the oracle read online documentation in detail to understand the purpose of each parameter.
 

1. create the required directory
 
1. $ oracle_home/admin
 
2. $ oracle_home/admin/oracle_sid/adump
 
3. $ oracle_home/admin/oracle_sid/bdump ---- alter_SID.log in this directory
 
4. $ oracle_home/admin/oracle_sid/cdump
 
5. $ oracle_home/admin/oracle_sid/dpdump
 
6. $ oracle_home/admin/oracle_sid/pfile
 
7. $ oracle_home/admin/oracle_sid/script
 
8. $ oracle_home/oradata/oracle_sid/
 
 
 
2. Create Related Files
 
1. Create pfile the database initialization file (under the $ oracle_home/oracle_sid/dbs directory)
 
2. Create a password file
 
3. Prepare the database creation script
 
4. Run catalog, catproc, pupbld
 
 
 
3. PFILE database initialization file (initSID. ora) (sid = wjtest in oracle experiment in this experiment)
 
Wjtest. _ db_cache_size = 188743680
 
Wjtest. _ java_pool_size = 4194304
 
Wjtest. _ large_pool_size = 4194304
 
Wjtest. _ shared_pool_size = 83886080
 
Wjtest. _ streams_pool_size = 0
 
*. Audit_file_dest = '/u01/oracle/admin/wjtest/adump'
 
*. Background_dump_dest = '/u01/oracle/admin/wjtest/bdump'
 
*. Compatible = '10. 2.0.1.0'
 
*. Control_files = '/u01/oracle/oradata/wjtest/control01.ctl', '/u01/oracle/oradata/wjtest/control02.ctl', '/u01/oracle/oradata/wjtest/control03.ctl'
 
*. Core_dump_dest = '/u01/oracle/admin/wjtest/cdump'
 
*. Db_block_size = 8192
 
*. Db_domain =''
 
*. Db_file_multiblock_read_count = 16
 
*. Db_name = 'wjtest'
 
*. Db_recovery_file_dest = '/u01/oracle/flash_recovery_area'
 
*. Db_recovery_file_dest_size = 2147483648
 
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = wjtestXDB )'
 
*. Job_queue_processes = 10
 
*. Log_archive_format = '% t _ % s _ % r. dbf'
 
*. Open_cursors = 300
 
*. Pga_aggregate_target = 94371840
 
*. Processses = 150
 
*. Remote_login_passwordfile = 'clusive'
 
*. Sga_target = 285212672
 
*. Undo_management = 'auto'
 
*. Undo_tablespace = 'undotbs1'
 
*. User_dump_dest = '/u01/oracle/admin/wjtest/udump'

1 2 Next Page