![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle 报错
bigclouder
专注于金融领域……
展开
-
ORA-08002 序列XXXX尚未在此进程中定义
select sequence.currval 时报错 ORA-08002: 序列XXXX尚未在此进程中定义非要先select nextval后才能查询currval原创 2014-05-06 09:36:15 · 840 阅读 · 0 评论 -
mpr进程不能启动问题
今天,在某个备库上发现mpr进程不能启动,看报警日志Errors in file /u02/app/oracle/diag/rdbms/rfacdb/facdb/trace/facdb_rvwr_28530.trc:ORA-38739: Flashback log file is more recent than control file.ORA-38701: Flashback data原创 2015-01-23 15:04:23 · 1145 阅读 · 0 评论 -
Oracle错误ORA-03113: end-of-file on communication channel处理办法
Oracle错误ORA-03113: end-of-file on communication channel处理办法 机器遭遇断电,之后oracle就不能启动了,报错ORA-03113: end-of-file on communication channel (通信通道的文件结尾)?1234567891011原创 2015-02-04 17:12:12 · 1917 阅读 · 0 评论 -
由于standby_file_management造成的dg的问题
客户的Oracle11gR2 Active Data Guard环境,主数据库的standby_file_management=AUTO,备用数据库的standby_file_management=MANUAL,导致在主数据库为表空间添加的数据文件操作没有同步到备用数据库,在$ORACLE_HOME/dbs目录下也没有创建类似UNNAMED00003的文件,备用数据库有如下的告警日志Tue S原创 2014-12-26 12:56:36 · 1002 阅读 · 0 评论 -
ORA-24247: network access denied by access control list
Applies to: PL/SQL - Version 11.1.0.6 and laterInformation in this document applies to any platform.***Checked for relevance on 26-Jun-20136*** Prior to 11gR1 you were able to run PL/SQL cod原创 2014-12-09 14:23:29 · 984 阅读 · 0 评论 -
Exp-00009错误解決
13:59:09 SQL> grant connect,resource to DEVQUERY; Grant succeeded Executed in 0.062 seconds 13:59:26 SQL> grant EXP_FULL_DATABASE to DEVQUERY; Grant succeeded Executed in 0.016 seconds 14:原创 2015-01-14 14:00:53 · 2448 阅读 · 0 评论 -
IMP-00013
赋予 imp_full_Database的权限问题解决select * from dba_sys_privs where grantee='QAMODIFY';alter user qamodify default role CONNECT,resource,EXP_FULL_DATABASE,imp_full_database;原创 2015-01-14 15:05:57 · 536 阅读 · 0 评论 -
AWR:select output from table(dbms_workload_repository.awr_report_html( :dbid, * ERROR
... of the following errors: select output from table (dbms_workload_repository.awr_report_html (: Dbid, * ERROR at line 1: ORA-00904:: invalid identi . ...解决:sys用户授权grant all on dbms_wo原创 2014-12-09 17:36:48 · 3011 阅读 · 0 评论 -
ORA-32004: obsolete or deprecated parameter(s) specified for
background_dump_dest和user_dump_dest在11.2中已经被废弃了原创 2014-10-26 13:53:41 · 806 阅读 · 0 评论 -
生产分布式事务的处理
刚刚在生产的主数据库报了错误DISTRIB TRAN 41544f4d.3137322E31362E33302E3233332E746D32333333393030343535 is local tran 4645.21.804978 (hex=1225.15.c4872) insert pending prepared tran, scn=6069352057191 (hex=5原创 2015-03-05 14:58:38 · 1566 阅读 · 0 评论 -
alter database datafile '' offline drop以后的恢复
此时查看数据文件的状态11:03:02 sys@orcl> select name,status from v$datafile;11:03:21 sys@orcl> col name for a5011:03:24 sys@orcl> /NAME STATUS-----------原创 2015-03-26 20:34:03 · 2378 阅读 · 0 评论 -
安装em cc的注意点
1关闭自动统计信息收集SQL> BEGIN 2 dbms_auto_task_admin.disable( 3 client_name => 'sql tuning advisor', 4 operation => NULL, 5 window_name => NULL); 6 END; 7 /PL/SQL procedure successf原创 2015-11-05 00:08:02 · 645 阅读 · 0 评论 -
关于12c升级11g catalog bug的处理
我们再用12c的sqlplus 去连接11g的catalog的时候,会报如下的错误Recovery Manager: Release 12.1.0.2.0 - Production on Thu Oct 22 05:50:38 2015Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.原创 2015-10-22 22:37:44 · 1775 阅读 · 0 评论 -
12c weblogic安装 The OpenJDK JVM is not supported on this platform
Installation fails with: "The OpenJDK JVM is not supported on this platform" (文档 ID 1948742.1)转到底部In this DocumentSymptoms Cau原创 2015-11-04 23:39:35 · 18220 阅读 · 1 评论 -
EM12c : Login to GUI with the correct password causes authentication failure
So the other day I was trying to login to my EM12c R4 environment with the SSA_ADMINISTRATOR user, and I got the error :Authentication failed. If problem persists, contact your system administra转载 2015-11-04 09:31:36 · 699 阅读 · 1 评论 -
ORA-00270: error creating archive log
今天主库报了如下的错误******************************************************************LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2***************************************************原创 2015-04-17 13:17:49 · 9500 阅读 · 0 评论 -
ORA-600 [krr_assemble_cv_3]错误
今天主库上面报出了1404446:ORA-00600: internal error code, arguments: [krr_assemble_cv_3], [1], [], [], [], [], [], [], [], [], [], []1404449:ORA-00600: internal error code, arguments: [krr_assemble_cv_3], [原创 2015-04-12 13:06:52 · 1864 阅读 · 0 评论 -
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process .
刚刚,数据库报磁盘空间不足,登陆上去发现归档已经很多天没有被自动删除用rman手动执行删除归档的命令,发现报了如下的错误RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process .证明此时数据库还正在需要应用这些归档然后我们先登录到物理备库上面去看看原创 2015-04-12 21:58:24 · 7965 阅读 · 0 评论 -
一次逻辑备库延时故障的处理
凌晨收到报警,逻辑备库的restart time 停在了正常情况下,逻辑备库restart time 停在那儿是由于主库有事务没有提交导致了,可这次我们到主库上进行查询发现主库并没有为提交的事务此时我们再到逻辑备库上面进行查询发现在逻辑备库上面有这三个活跃的会话而如果我们在主库的v$tansaction视图里面进行查看原创 2015-04-11 16:51:18 · 699 阅读 · 0 评论 -
[INS-40406] The installer detects no existing Oracle Grid Infrastructure software on the system.
由于之前升级GI过程没成功,手动介绍了,本以为删除升级过程创建的新目录就OK了,没想到再次升级执行到第一步就报错[INS-40406] The installer detects no existing Oracle Grid Infrastructure software on the system.Cause - The installer was unable t转载 2014-11-11 16:24:02 · 1658 阅读 · 0 评论 -
ORA-31640: unable to open dump file 问题解决
在做ogg同步的时候,遇到了"ORA-31640: unable to open dump file "的错误.导入的命令如下:$nohup idmpdp system/******** directory=imp_dir dumpfile=full_db_20120823.dmp schemas=daanl,daanl_data logfile=imp_full_db_20120824.lo原创 2014-09-01 23:43:18 · 20751 阅读 · 0 评论 -
ORA-39700: database must be opened with UPGRADE option
Elapsed: 00:00:02.1215:45:15 idle>alter database open read only;ERROR:ORA-03114: not connected to ORACLEalter database open read only*ERROR at line 1:ORA-01092: ORACLE instance terminated. Di原创 2014-07-17 16:53:31 · 653 阅读 · 0 评论 -
ORA-00059: maximum number of DB_FILES exceeded
这是因为oracle 系统默认的db_files 设定的是200个,但在一个生产库上数据文件超过200个是hencha原创 2014-07-16 15:35:37 · 1124 阅读 · 0 评论 -
ORA-00060: Deadlock detected
今天早上,数据库报原创 2014-05-08 13:27:53 · 1001 阅读 · 0 评论 -
ORA-00445: background process "J000" did not start after 120 seconds
周一上班,查看报警日志发现生产库上报:原创 2014-05-12 14:56:18 · 9254 阅读 · 0 评论 -
Oracle11g ORA-609 TNS 12537 TNS 12560
alert_sid.log中有如下报错信息[plain] view plaincopyprint?Wed Dec 18 08:25:58 2013 *********************************************************************** Fatal NI connect error 12537,原创 2014-05-12 14:15:42 · 1324 阅读 · 0 评论 -
Oracle10gR2 ORA-3136 错误解决办法
警告日志文件中(alert.log)持续出现如下错误:$ vi alert_$ORACLE_SID.log...Sun Sep 27 12:39:14 2009WARNING: inbound connection timed out (ORA-3136)Sun Sep 27 12:44:26 2009WARNING: inbound connection timed原创 2014-05-12 10:05:12 · 791 阅读 · 0 评论 -
ORA-00600: 内部错误代码, 参数: [kdsgrp1]
今天早上,数据库报了ora 00600的错误,错误原创 2014-05-09 10:20:51 · 6892 阅读 · 0 评论 -
ORA-00932 :数据类型不一致:应为-,但却获得CLOB
select * from tb_object_0001 where f17_0001=(select f1_5044 from tb_object_5044 where f8_5044 in (select content_txt from sdc_globalevent@basedata));原创 2014-05-07 17:53:16 · 6888 阅读 · 0 评论 -
Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLA
在进行[09:41:05 oracle(db)@localhost grid]$ ./runInstaller Starting Oracle Universal Installer...Checking Temp space: must be greater than 120 MB. Actual 27856 MB PassedChecking swap spa原创 2014-07-22 09:52:42 · 1805 阅读 · 0 评论 -
ORA-09925: Unable to create audit trail file引发的错误
今天练习手工建库的时候,参数文件中audit_file_dest原创 2014-06-12 16:54:19 · 1407 阅读 · 0 评论 -
ORA-00054:资源正忙,但指定以NOWAIT方式获取资源,或者超时失效的问题
ORA-00054:资源正忙,但指定以NOWAIT方式获取资源,或者超时失效的问题 解决方法如下: SQL> select session_id from v$locked_object; SESSION_ID www.2cto.com ---------- 56 SQL> SELECT sid, serial#, username, osuser原创 2014-08-28 13:32:52 · 674 阅读 · 0 评论 -
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
数据库从10g升级到11g,在启动的过程中,报原创 2014-08-12 15:53:09 · 1368 阅读 · 0 评论 -
最常见的5个导致 RAC 实例崩溃的问题 (Doc ID 1549191.1)
文档内容 用途 适用范围 详细信息 问题 1:ORA-29770 LMHB 终止实例 问题 2:ORA-481 导致的实例崩溃 问题 3:ORA-600原创 2014-08-25 00:35:12 · 959 阅读 · 0 评论 -
安装Oracle11.2.0.3的时候都遇到PRCR-1079、?ORA-01031、CRS-5017、CRS-2674错误
多次没有按照文档一步步安装Oracle11.2.0.3的时候都遇到相同的错误:PRCR-1079 : Failed to start resource ora.tydb.dbORA-01031:insufficient privilegesCRS-5017:the resource action "ora.tydb.db start" encountered the following原创 2014-06-20 18:57:24 · 3002 阅读 · 0 评论 -
使用DBCA安装ASM单实例出现的PRCR-1079和ORA-12547的解决办法
使用DBCA安装ASM单实例出现的PRCR-1079和ORA-12547的解决方法我在安装ASM单实例的环境下,在安装到86%时出现以下错误:经网上搜索,亲自试验,解决方法如下:这个问题主要是由于权限和变量没有配好。我的oracle和grid用户是分开配置的。1、首先查看oracle和grid用户下$ORACLE_HOME/bin/oracle的权限原创 2014-06-20 18:08:11 · 858 阅读 · 1 评论 -
111
[root@ogg ~]# id oracleuid=200(oracle) gid=200(oinstall) groups=200(oinstall),201(dba),202(oper),205(asmdba)[root@ogg ~]# usermod -a -G asmadmin oracle[root@ogg ~]# id oracleuid=200(oracle) gi原创 2014-06-20 18:37:10 · 981 阅读 · 0 评论 -
OGG-00685 begin time <time> prior to oldest log in log history
今天早生产库的某个逻辑备库部署ogg同步几张表,报上述错误去moschauxn原创 2014-07-01 13:32:14 · 5588 阅读 · 0 评论 -
ERROR OGG-00396 Command not terminated by semi-colon.
库上ogg,进程启动报这个错误原创 2014-06-19 10:28:43 · 4625 阅读 · 0 评论 -
ASMCMD-9487: 'md῟backup' cannot be run with 'sysasm' privilege
我们在进行磁盘组备份的时候ASMCMD-9487: 'md῟backup' cannot be run with 'sysasm' privilege解决方法:修改$ORACLE_HOME/bin下面的oracle的权限为6751修改$GRID_HOME/bin下面的oracle的权限为6751这个时候我们再执行命令ASMCMD> md_backup /ho原创 2016-03-21 10:52:29 · 3390 阅读 · 0 评论