Oracle 10g 手动建库（非dbca）

1.写参数文件

[oracle@oracle-s001 dbs]$ cat initzxpredb.ora 
zxpredb.__db_cache_size=4932501504
zxpredb.__java_pool_size=16777216
zxpredb.__large_pool_size=16777216
zxpredb.__shared_pool_size=3573547008
zxpredb.__streams_pool_size=33554432
*.audit_file_dest='/home/oracle/admin/zxpredb/adump'
*.audit_sys_operations=TRUE
*.audit_trail='DB_EXTENDED'
*.background_dump_dest='/home/oracle/admin/zxpredb/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/data/oradata/zxpredb/opt/control01.ctl','/data/oradata/zxpredb/opt/control02.ctl','/data/oradata/zxpredb/opt/control03.ctl'
*.core_dump_dest='/home/oracle/admin/zxpredb/cdump'
*.db_block_size=8192
*.db_cache_size=4294967296
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=400
*.db_name='zxpredb'
*.fal_client='STANDBY'
*.java_pool_size=0
*.job_queue_processes=10
*.log_archive_config='dg_config=(ltdb,ltdbstd)'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=1672478720
*.processes=2000
*.recyclebin='OFF'
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=2205
*.sga_max_size=8589934592
*.sga_target=8589934592
*.statistics_level='ALL'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/home/oracle/admin/zxpredb/udump'

2.create database

 CREATE DATABASE zxpredb
   CONTROLFILE REUSE 
   LOGFILE
      GROUP 1 ('/data/oradata/zxpredb/opt/redo_01.log', '/data/oradata/zxpredb/opt/redo_01_b.log') SIZE 200M, 
      GROUP 2 ('/data/oradata/zxpredb/opt/redo_02.log', '/data/oradata/zxpredb/opt/redo_02_b.log') SIZE 200M 
   MAXLOGFILES 10 
   MAXLOGHISTORY 100 
   MAXDATAFILES 1000
   MAXINSTANCES 2 
   ARCHIVELOG
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
    DATAFILE  '/data/oradata/zxpredb/opt/system01.dbf' size 4g
   SYSAUX DATAFILE '/data/oradata/zxpredb/opt/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TEMPORARY TABLESPACE temp_ts tempfile '/data/oradata/zxpredb/opt/temp01.dbf' size 200m reuse
   UNDO TABLESPACE UNDOTBS1 datafile '/data/oradata/zxpredb/opt/undo01.dbf' size 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

3.执行脚本

SQL> @?/rdbms/admin/catalog.sql  

创建数据字典

SQL> @?/rdbms/admin/catproc.sql  

创建存储过程和包

SQL> conn system/manager

SQL> @?/sqlplus/admin/pupbld.sql 

--约1分钟，以conn system/manager 运行此脚本 作用：设置sqlplus的一些包，让其它用户可以登录sqlplus

SQL> conn /as sysdba
SQL> select instance_name,status from v$instance; --检查状态，此时数据库应该是open状态