Oracle: 常用的数据库pfile及建库脚本
Oracle: 常用的数据库pfile及建库脚本
记录备忘:
pfile:
- mercury.__db_cache_size=289406976
- mercury.__java_pool_size=4194304
- mercury.__large_pool_size=4194304
- mercury.__Oracle_base='/oracle'#ORACLE_BASE set from environment
- mercury.__pga_aggregate_target=301989888
- mercury.__sga_target=503316480
- mercury.__shared_io_pool_size=0
- mercury.__shared_pool_size=192937984
- mercury.__streams_pool_size=0
- *.audit_file_dest='/oracle/mercury/adump'
- *.audit_trail='db'
- *.compatible='11.2.0'
- *.control_files='/oracle/mercury/oradata/ora_control1','/oracle/mercury/oradata/ora_control2'
- *.core_dump_dest='/oracle/mercury/cdump'
- *.db_block_size=8192
- *.db_domain=''
- *.db_name='mercury'
- *.db_recovery_file_dest='/oracle/mercury/recovery'
- *.db_recovery_file_dest_size=1G
- *.diagnostic_dest='/oracle/mercury/diag'
- *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
- *.fast_start_mttr_target=300
- *.memory_target=768m
- *.open_cursors=300
- *.processes=150
- *.remote_login_passwordfile='EXCLUSIVE'
- *.undo_tablespace='UNDOTBS1'
建库脚本
- set echo off
- connect / as sysdba
- create spfile from pfile
- spool /oracle/mercury/createdb.log
- startup nomount
- CREATE DATABASE mercury
- USER SYS IDENTIFIED BY lzx123
- USER SYSTEM IDENTIFIED BY lzx123
- LOGFILE GROUP 1 ('/oracle/mercury/oradata/redo01a.log','/oracle/mercury/oradata/redo01b.log') SIZE 50M BLOCKSIZE 512,
- GROUP 2 ('/oracle/mercury/oradata/redo02a.log','/oracle/mercury/oradata/redo02b.log') SIZE 50M BLOCKSIZE 512
- MAXLOGFILES 5
- MAXLOGMEMBERS 5
- MAXLOGHISTORY 1
- MAXDATAFILES 100
- CHARACTER SET ZHS16GBK
- NATIONAL CHARACTER SET AL16UTF16
- EXTENT MANAGEMENT LOCAL
- DATAFILE '/oracle/mercury/oradata/system01.dbf' SIZE 200M REUSE
- SYSAUX DATAFILE '/oracle/mercury/oradata/sysaux01.dbf' SIZE 200M REUSE
- DEFAULT TABLESPACE users
- DATAFILE '/oracle/mercury/oradata/users01.dbf'
- SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
- DEFAULT TEMPORARY TABLESPACE tempts1
- TEMPFILE '/oracle/mercury/oradata/temp01.dbf'
- SIZE 20M REUSE
- UNDO TABLESPACE undotbs1
- DATAFILE '/oracle/mercury/oradata/undotbs01.dbf'
- SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
- @?/rdbms/admin/catalog.sql
- @?/rdbms/admin/catproc.sql
- connect system/lzx123
- @?/sqlplus/admin/pupbld.sql
- spool off
创建数据字典和dbms包部分如果没有成功也是有可能的,需要手动重新创建即可;
评论暂时关闭