原创 2004年10月10日 14:38:00


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




1) ORA-1547

a) on Rollback segment when importing.

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

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

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.

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

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

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

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

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

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).

5) ORA-904 Invalid column name on import.

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

6) ORA-1034 Oracle not available.

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.

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

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.

8) ORA-604 what does it mean?

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.

9) My create database is failing with ORA-1519: error while processing file

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

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

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



  • xdfwsl
  • xdfwsl
  • 2006年07月29日 17:47
  • 634

oracle DBA面试题

ORACLE DBA面试题集 一:SQL tuning 类1 列举几种表连接方式 等连接、非等连接、自连接、外连接(左、右、全)2 不借助第三方工具,怎样查看sql的执行计划I) 使用Ex...
  • yuetengfei
  • yuetengfei
  • 2010年12月04日 20:27
  • 5679


C语言高级测试:为C程序员准备的0x10个最佳问题 整个测试遵循以下的约定:        假定在所有的程序中必须的头文件都已经被正确包含。 考虑如下的数据类型:        char ...
  • hbuxiaofei
  • hbuxiaofei
  • 2011年08月11日 20:40
  • 644


Oracle笔试题 oracle DBA 面试题及答案(国外公司)oracle数据库笔试题 DBA 国际大公司Oracle 面试笔试题oracle Database DBA Interview Que...
  • hailang99
  • hailang99
  • 2007年09月24日 09:48
  • 4677


1. Oracle安装完成后的初始口令? internal/oracle   sys/change_on_install   system/manager   scott/tiger   sysman...
  • zwhfyy
  • zwhfyy
  • 2006年05月10日 19:47
  • 1437

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

 This document contains information about errors frequently encountered by new DBAs, along with appr...
  • yjmtv0817
  • yjmtv0817
  • 2007年09月21日 10:11
  • 251


1、ORA-12541:TNS:没有监听器   原因:没有启动监听器或者监听器损坏。若是前者,使用命令启动监听:net start OracleOraDb10g_home1TNSListener(名字...
  • yuan882696yan
  • yuan882696yan
  • 2011年01月25日 15:55
  • 7885


Oracle数据库笔记 Jack Chaing 作者QQ595696297 交流群 127591054 祝大家学习进步。 如果大家想看Word版本的可以去下载:Word排版比较清晰一些。 htt...
  • Jack__Chiang
  • Jack__Chiang
  • 2017年04月11日 09:34
  • 7642

ORACLE数据库DBA 职责及日常工作职责

DBA 职责及日常工作职责:    1.安装和升级数据库服务器,以及应用程序工具构建和配置网络环境.    2.熟悉数据库系统的存储结构预测未来的存储需求,制订数据库的存储方案.    3.根据开发人...
  • lpioneer
  • lpioneer
  • 2010年10月15日 11:12
  • 3305


1、ORA-12541:TNS:没有监听器    原因:没有启动监听器或者监听器损坏。如果是前者,使用命令net start OracleOraHome81TNSListener(名字可能有出入)即...
  • Tan_yixiu
  • Tan_yixiu
  • 2011年09月09日 07:41
  • 855