是10g的,问题已经找到了,还是lock_sga参数的问题,我发现在spfile里的lock_sga=true,而solaris是不支持这个参数的(好像linux也不支持),我把spfile贴出来,给大家看看:

yanlao.__db_cache_size=1056964608

yanlao.__java_pool_size=16777216

yanlao.__large_pool_size=16777216

yanlao.__shared_pool_size=436207616

yanlao.__streams_pool_size=0

*.audit_file_dest='/zhptqyyl/orayl/product/10.2/admin/yanlao/adump'

*.background_dump_dest='/zhptqyyl/orayl/product/10.2/admin/yanlao/bdump'

*.compatible='10.2.0.3.0'

*.control_files='/zhptqyyl/data/yanlao/control01.ctl','/zhptqyyl/data/yanlao/con

trol02.ctl','/zhptqyyl/data/yanlao/control03.ctl'

*.core_dump_dest='/zhptqyyl/orayl/product/10.2/admin/yanlao/cdump'

*.cursor_sharing='SIMILAR'

*.db_block_size=16384

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_keep_cache_size=67108864

*.db_name='yanlao'

*.db_recovery_file_dest='/zhptqyyl/orayl/product/10.2/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.db_writer_processes=2

*.dispatchers='(PROTOCOL=TCP) (SERVICE=yanlaoXDB)'

*.job_queue_processes=10

*.lock_sga=TRUE

*.log_archive_dest_1='LOCATION=/zhptqyyl/arch'

*.log_archive_format='%t_%s_%r.dbf'

*.open_cursors=800

*.optimizer_index_caching=60

*.optimizer_index_cost_adj=40

*.optimizer_mode='FIRST_ROWS'

*.parallel_automatic_tuning=TRUE

*.pga_aggregate_target=3424649216

*.pre_page_sga=TRUE

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=1610612736

*.sort_area_size=122880

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/zhptqyyl/orayl/product/10.2/admin/yanlao/udump'

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐