oracle: 常用的数据库pfile及建库脚本

记录备忘：

pfile:

mercury.__db_cache_size=289406976mercury.__java_pool_size=4194304mercury.__large_pool_size=4194304mercury.__oracle_base='/oracle'#ORACLE_BASE set from environmentmercury.__pga_aggregate_target=301989888mercury.__sga_target=503316480mercury.__shared_io_pool_size=0mercury.__shared_pool_size=192937984mercury.__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 offconnect / as sysdbacreate spfile from pfilespool /oracle/mercury/createdb.logstartup nomountCREATE 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.sqlconnect system/lzx123@?/sqlplus/admin/pupbld.sqlspool off

 

创建数据字典和dbms包部分如果没有成功也是有可能的，需要手动重新创建即可；