ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORACLE ORA错误收集

ORACLE ORA错误收集

原创 Linux操作系统 作者:tomshenhao 时间:2011-09-11 10:05:46 0 删除 编辑
 

从服务器下载ALERT日志文件,传输方式需要选择"ASCII"

ORA-01078: failure in processing system parameters

发生场景:新建数据库第一次启动时

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’

原因:oracle_sid没有配置正确

解决方案:

1. 修改oracle用户.bash_profile文件中ORACLE_SID后的内容;

2. 重新已oracle用户登录;

ORA-01157: cannot identify/lock data file string - see DBWR trace file
Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.
Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.

ORA-01157: cannot identify/lock data file 201 – see DBWR trace file
ORA-01110: data file 201: ‘/u01/app/oracle/oradata/orcl/temp01.dbf’

Cause:The tempfile belonging to the default temporary tablespace is missing.

ORA-03114: not connected to ORACLE

Errors in file /data1/admin/switch/bdump/switch_arc0_3887.trc:
Cause:备库实例或监听可能临时停止,不能接收归档

ORA-16055: FAL request rejected
ARCH: Connecting to console port...

Cause:备库实例或监听可能临时停止,不能接收归档

ORA-12535: TNS:operation timed out
ARC0: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing

Cause:备库实例或监听可能临时停止,不能接收归档

ORA-03113: end-of-file on communication channel
ARC2: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing

Cause:备库实例或监听可能临时停止,无法创建备库归档

ORA-12012: error on auto execute of job 47

Cause:执行oracle任务47时报错

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

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

注册时间:2011-07-14

  • 博文量
    260
  • 访问量
    393445