XIANHUAFANG的博客

SYMPTOMSIn container database, following errors are seen in the alert log:ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7165"ORA-20001: Statistics Advisor: Invalid task name for the current userORA-06512: at "SYS.DBMS_STATS", line 472

系统：CentOS7.9数据库：Oracle 11.2.0.4环境：磁盘组采用的asmlib方式创建异常描述：在安装单实例数据库创建GI时，条件检查步骤报错“OracleRestart Integrity”，如下所示：在 mos 上查确认为以下原因造成此异常：There is no GI (restart or clusterware) installation in place ,but there was previous GI installation which was not cleaned up

查看默认 RMAN 配置CONFIGURE CONTROLFILE AUTOBACKUP FORMATFORDEVICE TYPEDISKTO'%F'; #default修改控制文件自动备份路径CONFIGURE CONTROLFILE AUTOBACKUP FORMATFORDEVICE TYPEDISKTO'/data/backup/ctl.f';此时出现报错：RMAN-06492: control file AUTOBACKUP format "xxxx" must specify a

oracle 12.2.0.1版本报错：Errors in file /u01/app/oracle/diag/rdbms/easdb/easdb2/trace/easdb2_j000_27520.trc:ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_21" 出错ORA-20001: Statistics Advisor: Invalid task name for the current userORA-06512: 在 "SYS.DBMS_STATS",

思路分析：1、发现数据库宕机，检查alert日志发现如下出现控制文件：I/O错误Thu Apr 11 06:40:14 2019WARNING: Read Failed. group:2 disk:1 AU:675 offset:16384 size:16384WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 260 in group [2.3852408873] from d

dba_hist_tbspc_space_usage视图中存放了历史信息select a.name, b.*from v$tablespace a,(select tablespace_id,trunc(to_date(rtime, 'mm/dd/yyyy hh24:mi:ss')) datetime,round(max(tablespace_usedsize * 8 / 1024),2) used_size_MBfrom dba_hist_tbspc_space_usagewh

log_file_name_convert='/u01/app/oracle/oradata/AUXDB','/u01/app/oracle/oradata/AUXDB'log_file_name_convert 参数设置了的，每次duplicate target database for standby from active database nofilenamecheck;都会报这个错，导致备库没有日志文件。...

数据库内连接会话超过参数配置，导致报错ORA-00020:maximum number of processes (500) exceeded同时sys用户无法正常登录[oracle@xiaowu ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 23 10:48:12 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.ERROR:

[oracle@easdb2 ~]$ expdp \'/ as sysdba\' directory=OABAK dumpfile=oabak.dmp full=yExport: Release 19.0.0.0.0 - Production on Wed Feb 23 14:07:40 2022Version 19.13.0.0.0Copyright (c) 1982, 2021, Oracle and/or its affiliates.All rights reserved.Pas..

expdp时报错：ORA-39001: invalid argument valueORA-01775: looping chain of synonyms解决方法：删除SYS_EXPORT_SCHEMA_* 相关的同义词。SQL> select owner, object_name, object_type, status from dba_objects where object_name like '%SYS_EXPORT_SCHEMA_%' andOBJECT_TYPE='