手工创建oracle数据库
作者: Kttlon, 出处:linuxdiyf, 责任编辑: 李书琴,
2008-01-04 12:10
本文详细介绍了手工创建oracle数据库的全部过程……
内容如下：
| 以下是引用片段： --------------------------------------------------- dbtest.__db_cache_size=331350016 dbtest.__java_pool_size=4194304 dbtest.__large_pool_size=8388608 dbtest.__shared_pool_size=138412032 dbtest.__streams_pool_size=0 *._kgl_large_heap_warning_threshold=8388608 *.audit_file_dest='/opt/oracle/admin/dbtest/adump' *.background_dump_dest='/opt/oracle/admin/dbtest/bdump' *.compatible='10.2.0.1.0' *.control_files='/opt/oracle/oradata/dbtest/control01.ctl','/opt/oracle/oradata/dbtest/control02.ctl','/opt/oracle/oradata/dbtest/control03.ctl' *.core_dump_dest='/opt/oracle/admin/dbtest/cdump' *.db_2k_cache_size=33554432 *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=128 *.db_files=4000 *.db_name='dbtest' *.db_recovery_file_dest_size=4294967296 *.db_recovery_file_dest='' *.log_archive_dest='/opt/oracle/oradata/dbtest/archive' *.log_checkpoints_to_alert=FALSE *.open_cursors=300 *.parallel_execution_message_size=65535 *.parallel_max_servers=128 *.pga_aggregate_target=209715200 *.processes=150 *.recyclebin='OFF' *.remote_login_passwordfile='EXCLUSIVE' *.replication_dependency_tracking=FALSE *.session_cached_cursors=100 *.sga_target=500m *.shared_pool_size=100m *.undo_management='AUTO' *.undo_retention=0 *.undo_tablespace='UNDOTS' *.user_dump_dest='/opt/oracle/admin/dbtest/udump' *.workarea_size_policy='AUTO' _allow_resetlogs_corruption=true --------------------------------------------------- 可将此文件复制到：/opt/oracle/admin/dbtest/pfile/init.ora |
6--- 登陆oracle：
> sqlplus “/ as sysdba”
7--- 启动实例：
SQL> startup nomount pfile=/opt/oracle/admin/dbtest/pfile/init.ora
- 本文关键词：
