ora-4193/4194故障处理一则 - 数据库编程

l','/oracle/oradata/lixora/control03.ctl' *.core_dump_dest='/oracle/admin/lixora/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='lixora' *.db_recovery_file_dest='/oracle/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dbwr_io_slaves=5 *.disk_asynch_io=FALSE *.dispatchers='(PROTOCOL=TCP) (SERVICE=lixoraXDB)' *.fast_start_parallel_rollback='FALSE' "/tmp/pfile.ora" 34L, 1105C written [oracle@localhost lixora]$ vi /tmp/pfile.ora lixora.__db_cache_size=394264576 lixora.__java_pool_size=4194304 lixora.__large_pool_size=4194304 lixora.__shared_pool_size=171966464 lixora.__streams_pool_size=4194304 #*._allow_resetlogs_corruption=TRUE ------------------这里需要把这个隐含参数注销掉 *.audit_file_dest='/oracle/admin/lixora/adump' *.background_dump_dest='/oracle/admin/lixora/bdump' *.compatible='10.2.0.1.0' *.control_files='/oracle/oradata/lixora/control01.ctl','/oracle/oradata/lixora/control02.ctl','/oracle/oradata/lixora/control03.ctl' *.core_dump_dest='/oracle/admin/lixora/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='lixora' *.db_recovery_file_dest='/oracle/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dbwr_io_slaves=5 *.disk_asynch_io=FALSE *.dispatchers='(PROTOCOL=TCP) (SERVICE=lixoraXDB)' *.fast_start_parallel_rollback='FALSE' *.job_queue_processes=5 *.open_cursors=300 *.pga_aggregate_target=193986560 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=581959680 *.undo_management='AUTO' ---------------------1 *.undo_tablespace='UNDOTBS2' ------------------------2 ；这两个参数需要设置一下 *.user_dump_dest='/oracle/admin/lixora/udump' *.utl_file_dir='/tmp' SQL>

exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options [oracle@localhost ~]$ !sq sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 21 10:13:51 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup pfile='/tmp/pfile.ora' ORACLE instance started. Total System Global Area 583008256 bytes Fixed Size 2022504 bytes Variable Size 184550296 bytes Database Buffers 394264576 bytes Redo Buffers 2170880 bytes Database mounted. Database opened. SQL>

ora-4193/4194故障处理一则(三)