ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle11g R2 ORA-32004故障解决

Oracle11g R2 ORA-32004故障解决

原创 Linux操作系统 作者:liu_qingwei2008 时间:2011-02-12 16:52:55 0 删除 编辑

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_destuser_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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    87645