Oracle11g R2 ORA-32004故障解决

（3）查看参数文件内容

 [oracle@oracle dbs]$ cat inittest.ora                                                                                                                                                                  

test.__db_cache_size=184549376                                                                                                                                                                        

test.__java_pool_size=4194304                                                                                                                                                                        

test.__large_pool_size=4194304                                                                                                                                                                       

test.__shared_pool_size=88080384                                                                                                                                                                       

test.__streams_pool_size=0                                                                                                                                                                             

audit_file_dest='/u01/oracle/admin/test/adump'                                                                                                                                                          

background_dump_dest='/u01/oracle/admin/test/bdump'                                                                                                                                                    

compatible='11.2.0'                                                                                                                                                                                   

control_files='/dev/raw/raw2','/dev/raw/raw3','/dev/raw/raw4'                                                                                                                                           

core_dump_dest='/u01/oracle/admin/test/cdump'                                                                                                                                                           

db_block_size=8192                                                                                                                                                                                     

db_domain=''                                                                                                                                                                                           

db_file_multiblock_read_count=16                                                                                                                                                                        

db_name='TEST'                                                                                                                                                                                         

db_recovery_file_dest='/u01/oracle/flash_recovery_area'                                                                                                                                                                                                                                                                                                       

dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'                                                                                                                                                         

job_queue_processes=10                                                                                                                                                                                 

open_cursors=300                                                                                                                                                                                        

pga_aggregate_target=94371840                                                                                                                                                                           

processes=150                                                                                                                                                                                           

remote_login_passwordfile='EXCLUSIVE'                                                                                                                                                                  

sga_target=285212672                                                                                                                                                                                    

undo_management='AUTO'                                                                                                                                                                                  

undo_tablespace='UNDOTBS1'                                                                                                                                                                              

user_dump_dest='/u01/oracle/admin/test/udump'                                                                                                                                                           

db_recovery_file_dest_size=2G                                                                                                                                                                                                                                                                                                                                                                             

（4）将参数文件中的background_dump_dest和user_dump_dest注释掉                                                                                                                                                                                                                                        

（5）验证问题是否解决：                                                                                                                                                                                          

SQL> shutdown immediate;                                                                                                                                                                                

Database closed.                                                                                                                                                                                        

Database dismounted.                                                                                                                                                                                   

ORACLE instance shut down.                                                                                                                                                                                                                                                                                                                                        

SQL> create spfile from pfile;                                                                                                                                                                                                                                                                                                                                                                                 

File created.                                                                                                                                                                                           

                                         

SQL>startup;                                                                                                                                                                                           

ORACLE instance started.                                                                                                                                                                                

                                                                                                                                                                                                        

Total System Global Area  284565504 bytes                                                                                                                                                              

Fixed Size                  1336036 bytes                                                                                                                                                              

Variable Size             100666652 bytes                                                                                                                                                               

Database Buffers          176160768 bytes                                                                                                                                                               

Redo Buffers                6402048 bytes                                                                                                                                                               

Database mounted.                                                                                                                                                                                      

Database opened.                                                                                               

 

报错消失！                                                                   

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23898243/viewspace-687092/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23898243/viewspace-687092/