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

最新推荐文章于 2022-11-28 11:22:22 发布

Dojo的频道

最新推荐文章于 2022-11-28 11:22:22 发布

阅读量962

点赞数

分类专栏： oracle与c++开发文章标签： oracle 数据库 character file database 脚本

本文链接：https://blog.csdn.net/lzx_bupt/article/details/6942307

版权

oracle与c++开发专栏收录该内容

69 篇文章 1 订阅

订阅专栏

记录备忘：

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包部分如果没有成功也是有可能的，需要手动重新创建即可；