oracle ora错误文档,ORACLE ORA错误收集

从服务器下载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 fileCause: 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 rejectedARCH: 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 channelARC2: 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时报错