kiwi的专栏

select sequence.currval 时报错  ORA-08002: 序列XXXX尚未在此进程中定义非要先select nextval后才能查询currval

今天，在某个备库上发现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

Oracle错误ORA-03113: end-of-file on communication channel处理办法 机器遭遇断电，之后oracle就不能启动了，报错ORA-03113: end-of-file on communication channel （通信通道的文件结尾）?1234567891011

客户的Oracle11gR2 Active Data Guard环境，主数据库的standby_file_management=AUTO，备用数据库的standby_file_management=MANUAL，导致在主数据库为表空间添加的数据文件操作没有同步到备用数据库，在$ORACLE_HOME/dbs目录下也没有创建类似UNNAMED00003的文件，备用数据库有如下的告警日志Tue S

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

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:

赋予 imp_full_Database的权限问题解决select * from dba_sys_privs where grantee='QAMODIFY';alter user qamodify default role CONNECT,resource,EXP_FULL_DATABASE,imp_full_database;

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

background_dump_dest和user_dump_dest在11.2中已经被废弃了

刚刚在生产的主数据库报了错误DISTRIB TRAN 41544f4d.3137322E31362E33302E3233332E746D32333333393030343535 is local tran 4645.21.804978 (hex=1225.15.c4872) insert pending prepared tran, scn=6069352057191 (hex=5

此时查看数据文件的状态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-----------

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

我们再用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.

Installation fails with: "The OpenJDK JVM is not supported on this platform" (文档 ID 1948742.1)转到底部In this DocumentSymptoms Cau

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

今天主库报了如下的错误******************************************************************LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2***************************************************

今天主库上面报出了1404446:ORA-00600: internal error code, arguments: [krr_assemble_cv_3], [1], [], [], [], [], [], [], [], [], [], []1404449:ORA-00600: internal error code, arguments: [krr_assemble_cv_3], [

刚刚，数据库报磁盘空间不足，登陆上去发现归档已经很多天没有被自动删除用rman手动执行删除归档的命令，发现报了如下的错误RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process .证明此时数据库还正在需要应用这些归档然后我们先登录到物理备库上面去看看

凌晨收到报警，逻辑备库的restart time 停在了正常情况下，逻辑备库restart time 停在那儿是由于主库有事务没有提交导致了，可这次我们到主库上进行查询发现主库并没有为提交的事务此时我们再到逻辑备库上面进行查询发现在逻辑备库上面有这三个活跃的会话而如果我们在主库的v$tansaction视图里面进行查看

由于之前升级GI过程没成功，手动介绍了，本以为删除升级过程创建的新目录就OK了，没想到再次升级执行到第一步就报错[INS-40406] The installer detects no existing Oracle Grid Infrastructure software on the system.Cause - The installer was unable t

在做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

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

这是因为oracle 系统默认的db_files 设定的是200个，但在一个生产库上数据文件超过200个是hencha

今天早上，数据库报

周一上班，查看报警日志发现生产库上报：

alert_sid.log中有如下报错信息[plain] view plaincopyprint?Wed Dec 18 08:25:58 2013      ***********************************************************************    Fatal NI connect error 12537, 

警告日志文件中(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

今天早上，数据库报了ora 00600的错误，错误

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

在进行[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

今天练习手工建库的时候，参数文件中audit_file_dest

ORA-00054:资源正忙,但指定以NOWAIT方式获取资源,或者超时失效的问题 解决方法如下： SQL> select session_id from v$locked_object; SESSION_ID www.2cto.com ---------- 56 SQL> SELECT sid, serial#, username, osuser

数据库从10g升级到11g，在启动的过程中，报

文档内容 用途 适用范围 详细信息 问题 1：ORA-29770 LMHB 终止实例 问题 2：ORA-481 导致的实例崩溃 问题 3：ORA-600

多次没有按照文档一步步安装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

使用DBCA安装ASM单实例出现的PRCR-1079和ORA-12547的解决方法我在安装ASM单实例的环境下，在安装到86%时出现以下错误：经网上搜索，亲自试验，解决方法如下：这个问题主要是由于权限和变量没有配好。我的oracle和grid用户是分开配置的。1、首先查看oracle和grid用户下$ORACLE_HOME/bin/oracle的权限

[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

今天早生产库的某个逻辑备库部署ogg同步几张表，报上述错误去moschauxn

库上ogg，进程启动报这个错误

我们在进行磁盘组备份的时候ASMCMD-9487: 'md῟backup' cannot be run with 'sysasm' privilege解决方法：修改$ORACLE_HOME/bin下面的oracle的权限为6751修改$GRID_HOME/bin下面的oracle的权限为6751这个时候我们再执行命令ASMCMD> md_backup /ho