- 论坛徽章:
- 0
|
RedHat9.0, Oracle 9.2
我用dbca装了hr的demo数据库,成功安装,但打不开。
我的db name = db01
SQL>;conenct SYS/sys123 as sysdba
SQL>;startup pfile="/opt/ora9/product/9.2/dbs/spfiledb01.ora";
报错:invalid '0' character ...
打开我的spfiledb01.ora:
˜ 6í& *.aq_tm_processes=1
*.background_dump_dest='/opt/ora9/admin/db01/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/opt/ora9/oradata/db01/control01.ctl','/opt/ora9/oradata/db01/control02.ctl','/opt/ora9/oradata/db01/control03.ctl'
*.core_dump_dest='/opt/ora9/admin/db01/cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='db01'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='db01'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/ora9/admin/db01/udump'
我可以手工改动spfiledb01.ora吗?把空行和 "*." 去掉。 |
|