Oracle 10g 手动建库

1.写参数文件

[code][oracle@oracle-s001 dbs]$ cat initzxpredb.orazxpredb.__db_cache_size=4932501504zxpredb.__java_pool_size=16777216zxpredb.__large_pool_size=16777216zxpredb.__shared_pool_size=3573547008zxpredb.__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

[code] CREATE DATABASE zxpredbCONTROLFILE REUSELOGFILEGROUP 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 200MMAXLOGFILES 10MAXLOGHISTORY 100MAXDATAFILES 1000MAXINSTANCES 2ARCHIVELOGCHARACTER SET AL32UTF8NATIONAL CHARACTER SET AL16UTF16DATAFILE  \'/data/oradata/zxpredb/opt/system01.dbf\' size 4gSYSAUX DATAFILE \'/data/oradata/zxpredb/opt/sysaux01.dbf\' SIZE 325M REUSEDEFAULT TEMPORARY TABLESPACE temp_ts tempfile \'/data/oradata/zxpredb/opt/temp01.dbf\' size 200m reuseUNDO TABLESPACE UNDOTBS1 datafile \'/data/oradata/zxpredb/opt/undo01.dbf\' size 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

3.执行脚本

[code]SQL> @?/rdbms/admin/catalog.sql  创建数据字典SQL> @?/rdbms/admin/catproc.sql  创建存储过程和包SQL> conn system/managerSQL> @?/sqlplus/admin/pupbld.sql --约1分钟，以conn system/manager 运行此脚本 作用：设置sqlplus的一些包，让其它用户可以登录sqlplusSQL> conn /as sysdbaSQL> select instance_name,status from v$instance; --检查状态，此时数据库应该是open状态