记录备忘:
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包部分如果没有成功也是有可能的,需要手动重新创建即可;