Oracle: Common Database pfile and database creation scripts

Record memo:

Pfile:

1. Mercury. _ db_cache_size = 289406976
2. Mercury. _ java_pool_size = 4194304
3. Mercury. _ large_pool_size = 4194304
4. Mercury. _ Oracle_base = '/oracle' # ORACLE_BASE set from environment
5. Mercury. _ pga_aggregate_target = 301989888
6. Mercury. _ sga_target = 503316480
7. Mercury. _ shared_io_pool_size = 0
8. Mercury. _ shared_pool_size = 192937984
9. Mercury. _ streams_pool_size = 0
10. *. Audit_file_dest = '/oracle/mercury/adump'
11. *. Audit_trail = 'db'
12. *. Compatible = '11. 2.0'
13. *. Control_files = '/oracle/mercury/oradata/ora_control1', '/oracle/mercury/oradata/ora_control2'
14. *. Core_dump_dest = '/oracle/mercury/cdump'
15. *. Db_block_size = 8192
16. *. Db_domain =''
17. *. Db_name = 'mercury'
18. *. Db_recovery_file_dest = '/oracle/mercury/recovery'
19. *. Db_recovery_file_dest_size = 1G
20. *. Diagnostic_dest = '/oracle/mercury/diag'
21. *. Dispatchers = '(PROTOCOL = TCP) (SERVICE = ORCLXDB )'
22. *. Fast_start_mttr_target = 300
23. *. Memory_target = 768 m
24. *. Open_cursors = 300
25. *. Processses = 150
26. *. Remote_login_passwordfile = 'clusive'
27. *. Undo_tablespace = 'undotbs1'

Database creation script

1. Set echo off
3. Connect/as sysdba
5. Create spfile from pfile
7. Spool/oracle/mercury/createdb. log
9. Startup nomount
11. Create database mercury
12. User sys identified by lzx123
13. User system identified by lzx123
14. Logfile group 1 ('/oracle/mercury/oradata/redo01a. log','/oracle/mercury/oradata/redo01b. log') SIZE 50 m blocksize 512,
15. GROUP 2 ('/oracle/mercury/oradata/redo02a. log','/oracle/mercury/oradata/redo02b. log') SIZE 50 m blocksize 512
16. MAXLOGFILES 5
17. MAXLOGMEMBERS 5
18. MAXLOGHISTORY 1
19. MAXDATAFILES 100
20. Character set ZHS16GBK
21. National character set AL16UTF16
22. EXTENT MANAGEMENT LOCAL
23. DATAFILE '/oracle/mercury/oradata/system01.dbf' SIZE 200 M REUSE
24. Sysaux datafile '/oracle/mercury/oradata/sysaux01.dbf' SIZE 200 M REUSE
25. Default tablespace users
26. DATAFILE '/oracle/mercury/oradata/users01.dbf'
27. SIZE 100 M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
28. Default temporary tablespace tempts1
29. TEMPFILE '/oracle/mercury/oradata/temp01.dbf'
30. SIZE 20 M REUSE
31. Undo tablespace undotbs1
32. DATAFILE '/oracle/mercury/oradata/undotbs01.dbf'
33. SIZE 100 m reuse autoextend on maxsize unlimited;
35. @? /Rdbms/admin/catalog. SQL
36. @? /Rdbms/admin/catproc. SQL
38. Connect system/lzx123
40. @? /Sqlplus/admin/pupbld. SQL
42. Spool off

It is also possible to create the data dictionary and dbms package if the package is not successful. You need to manually create a new one;