ORACLE 报错ORA-00439、ORA-01078、LRM-00109、ORA-38760的解决方法

最新推荐文章于 2024-09-04 10:57:14 发布

原创最新推荐文章于 2024-09-04 10:57:14 发布 · 2.5k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

本文介绍了在Oracle数据库中遇到ORA-00439, ORA-01078, LRM-00109和ORA-38760错误的详细解决步骤。错误源于尝试启用Real Application Clusters特性但未成功。解决方法包括重新创建服务器初始化参数文件SPFILE，恢复PARALLEL_SERVER为默认值，并关闭数据库闪回功能。" 9274755,1147757,MFC对话框控件回车键焦点切换,"['MFC', '对话框编程', '键盘事件处理']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SYS@PR>alter system set
parallel_server=true;

SYS@PR>startup force;

[oracle@dd8bb trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 15 09:19:11 2017

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SYS@PR>startup

ORA-00439: feature not enabled: Real Application Clusters

出现原因：把parallel_server改为true后重启导致：

说明: 将 PARALLEL_SERVER 设置为 TRUE, 可以启用群集数据库选项。

值范围: TRUE | FALSE

默认值 : FALSE

解决方法：重新创建服务器初始化参数文件spfile，实际将parallel_server重置为默认值false

SYS@PR>create spfile from pfile;

create spfile from pfile

*

ERROR at line 1:

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file

'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initPR.ora'

解决方法：将$ORACLE_BASE/admin/PROD1/pfile中的init.ora.9132014233719 文件拷贝到

$ORACLE_HOME/dbs下，将文件名改为initPR.ora

SYS@PR>exit

[oracle@dd8bb
trace]$ oerr ora 01078

01078, 00000, "failure in processing system parameters"

// *Cause: Failure during processing of INIT.ORA parameters during

// system startup.

// *Action: Further diagnostic information should be in the error stack.

[oracle@dd8bb
trace]$ cd /u01/app/oracle/admin/PR/pfile/

[oracle@dd8bb
pfile]$ ls

init.ora.9132014233719

[oracle@dd8bb
dbs]$ cd /u01/app/oracle/admin/PR/pfile/

[oracle@dd8bb
pfile]$ cp init.ora.9132014233719 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initPR.ora

[oracle@dd8bb
pfile]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/

[oracle@dd8bb
dbs]$ ls

hc_PROD1.dat 
initPR.ora oranfstab snapcf_PR.f

hc_PROD2.dat lkPR orapwPROD1 snapcf_PROD2.f

init.ora lkPROD2 orapwPROD2 spfilePROD2.ora

[oracle@dd8bb
dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 15 09:28:25 2017

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SYS@PR>startup

ORACLE instance started.

Total System Global Area 1104814080 bytes

Fixed Size 1344400 bytes

Variable Size 671091824 bytes

Database Buffers 419430400 bytes

Redo Buffers 12947456 bytes

Database mounted.

ORA-38760: This database instance failed to turn on flashback database

解决方法：看ora错误提示：关闭数据库闪回， turn off database flashback

SYS@PROD1>alter database flashback off;

[oracle@dd8bb
trace]$ oerr ora 38760

38760, 00000, "This database instance failed to turn on flashback database"

// *Cause: Database flashback is on but this instance failed to

// start generating flashback data. Look in alert log for more

// specific errors.

// *Action: Correct the error or turn off database flashback.

[oracle@dd8bb
trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 15 09:42:44 2017

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@PR>alter flashback off;

alter flashback off

*

ERROR at line 1:

ORA-00940: invalid ALTER command

SYS@PR>alter database flashback off;

Database altered.

SYS@PR>alter database open;

Database altered.

SYS@PR>

至此问题解决