RSS订阅
PHP程序员站--WWW.PHPERZ.COM  
网站地图
高级搜索
收藏本站

 当前位置:主页 >> 数据库 >> Oracle >> 文章内容
Oracle DBA最常碰到的10个Oracle错误
[收藏此页[打印本页]   
来源:互联网  作者:未知  发布时间:2007-12-22

Oracle DBA最常碰到的10个Oracle错误 

This document contains information about errors frequently encountered by
new DBAs, along with appropriate actions to be taken in each circumstance.

phperz.com

+==+

www.phperz.com

Summary:
10 COMMON RDBMS ERRORS

phperz.com

+=+

php程序员站

1)  ORA-1547

www.phperz.com

   a) on Rollback segment when importing. php程序员站

      Specify commit=y and a large buffer on import. This way the Rollback
      will be released after each array, as opposed to each object. php程序员之家

   b) when allocating an extent on a tablespace with alot of free space.

www~phperz~com

      Select max(blocks) from DBA_FREE_SPACE. You may have free space but it
      might not be contiguous. Make sure it is greater than the extent it
      is trying to allocate. You can reduce the storage parameters NEXT and
      PCTINCREASE if it isn't. www.phperz.com

2)  ORA-1556 max extents of 121 exceeded when storage is set for maxextents
   of 999. phperz.com

   Most platforms have a max of 121 even though it allows you to specify
   999.  (see the readme for your platform) phperz~com

3)  ORA-1090 shutdown in progress when starting up even after a shutdown was
   issued quite some time ago.

www~phperz~com

   If the background processes aren't running the SGA could have been left
   out there... Issue a startup force open (which does a shutdown abort
   first). php程序员站

4)  IMP-0003, ORA-942 and IMP-00023 on import. phperz~com

   Run catalog.sql and expvew.sql (renamed catexp.sql in v7) as sys before
   the import. Both files are in $ORACLE_HOME/rdbms/admin (UNIX). php程序员站

5)  ORA-904 Invalid column name on import. www~phperz~com

   Run expvew.sql (catexp.sql) before the import.

www.phperz.com

6)  ORA-1034 Oracle not available. php程序员之家

   Startup the DB first...if it is started check your searchpath.
   Make sure that ORACLE_SID is set correctly  For setuid issues, see
   PRE 1006554.6. phperz.com

7)  ORA-1578 Oracle Data Block corrupted (file # num and block # num) phperz.com

   To determine where the corruption is:
   select * from sys.dba_extents where file_id = filenum and blocknum
   between block_id and (block_id + blocks - 1);
   The filenum and blocknum are the numbers in the 1578 error.
   This query should give the segment_name and segment_type
   (i.e table and its name).
   In order to salvage the uncorrupted part of the table you can add
   an entry to the init.ora:
   event = "10231 trace name context forever"
   This will skip the corrupted block on a table scan. Export the table,
   drop and recreate it from import.

www~phperz~com

8)  ORA-604 what does it mean? www.phperz.com

   Usually it comes with another error such as 1547....if it can't be found
   in any of the trace files try setting the following event in init.ora and
   restarting the DB.
   event="604 trace name errorstack forever"
   for the output of this look in the trace files in the directory given by
   the USER_DUMP_DEST parameter in init.ora.

www.phperz.com

9)  My create database is failing with ORA-1519: error while processing file php程序员站

   Take out the INIT_SQL_FILES param out of init.ora, run the scripts
   by hand after the database is created.

php程序员之家

10) Out of shared memory (ORA-4031).

phperz.com

   Try de-fragmenting the shared pool by running an 'alter system flush
   shared_pool' If that is not enough, increase the shared_pool_size
   parameter.

phperz.com


 
 相关文章
 
发表评论
全部评论(0条)
 
 站内搜索
 热门搜索 基础  mysql  url  adodb
高级搜索 网站地图 站长工具 IP查询 收藏本站
 热点文章
 随机推荐
网站首页 | 网站地图 | 高级搜索 | RSS订阅
PHP程序员站 Copyright © 2007,PHPERZ.COM All Rights Reserved 粤ICP备07503606号 联系站长