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

physical standby 转换给snapshot standby。snapshot转换为physical standby。（1）转换为snapshot。（2）expdp导出。（3）转换回物理备库。

Oracle数据库识别不了存储Diskgroup ORA-01078，需要Mount问题：sqlplus / as sysdbaSQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '+DATADG/orcl/spfileorcl.ora'ORA-17503: ksfdopn:2 Failed to open file +DATADG/orcl/spfileorcl

如题，trace文件目录产生大量的TRACE文件，文件中，包含RDMAV_FORK_SAFE,RDMAV_HUGEPAGES_SAFE具体文件内容如下：*** 2022-03-23T06:17:15.868135+08:00Required IPC RDMAV_FORK_SAFE environment not setRequired IPC RDMAV_HUGEPAGES_SAFE environment not setTrace file D:\ORACLE\diag\rdbms\orclwin\orc

问题现象：在用到LOB大对象的业务中，进行数据的插入，失败了，在报警文件中报错：ORA-00600: 内部错误代码, 参数: [25027], [10], [0], [], [], [], [], [], [], [], [], [] at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleComman

在数据库alert日志中发现频繁出现了这样的报错：ORA-48132:请求的文件锁正忙, [HM_RUN][...\diag\rdbms\...\lck\AM_1618_3044626670.lck]且RMAN备份确实存在失败的情况，查询文档，发现这一问题的解决方法 DOC ID 2565120.1APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document a

解决xhost: unable to open display ""实用技巧：在Linux下设置xhost方法步骤第一步：用root登陆linux，启动vnc服务；第二步：根据vnc起来的端口，设置export DISPLAY=localhost:1（1表示vnc在第一个tty上启动的），vnc的启动信息见附件1；第三步：执行xhost +，并且提示“access control disabled, clients can connect from any host”才正确。linux下的操作日志如下：[r

EM13.4:Install/Upgrade of Enterprise Manager Cloud Control on Linux Fails withan Error: "Failed to start Enterprise Manager. Diagnostic code 1" (DocID 2637385.1)In this DocumentSymptomsChangesCauseSolutionAPPLIES TO:Enterprise Manager Base Platform - Versi

有时候，DG中未应用的日志比较多，特别是RAC，有多节点，就更多，我只想看到每个节点日志已经应用到哪里了，可以通过以下SQL语句来查看：select thread#,max(sequence#),max(to_char(first_time,'yyyy-mm-dd hh24:mi:ss'))from v$archived_logwhere applied='YES'group by thread#order by 1；...

在12C以前，如果想控制客户端空闲时间，使用 profile 的idle_time 来控制，从12c开始，引入一个新参数，max_idle_time，直接通过设置改参数，单位为分钟，就可以控制多少空闲时间不操作，会主动被杀掉。废话不少说，我们来看看这个参数情况，我机器为19cC:\Users\ThinkPad X1E>sqlplus /nologSQL*Plus: Release 19.0.0.0.0 - Production on 星期二 6月 21 14:39:38 2022Version 19.3.0

系统：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

remap_table转换多个表时，TB1转换TB2、TB3转换TB4。1.remap_table=tb1:tb2 remap_table=tb3:tb42.remap_table=tb1:tb2,tb3:tb4impdp关于tables和remap_tables的一些注意事项1.expdp时写上tables=(表)表示导出某些表；impdp时不写tables条件表示导入dumpfile中的所有表，impdp时写tables=(表)条件表示只导入指定的表，当然如果tables=(dumpfile中的所有表)

RMAN> duplicate target database for standby from active database nofilenamecheck;Starting Duplicate Db at 13-JUN-22using channel ORA_AUX_DISK_1contents of Memory Script:{backup as copy reusetargetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwxxx'

12c dg环境测试 db_create_file_dest和db_file_name_convert参数,日志如下：（1）备库参数查看SQL> show parameter db_create_file_dest;NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_create_file

可以通过以下SQL语句缩小范围：select name,upper(value) from v$spparameter where isspecified='TRUE'minusselect name,upper(value) from v$parameter order by 1,2

Bug30284751 - Trace File With Messages "Required IPC RDMAV_FORK_SAFE /RDMAV_HUGEPAGES_SAFE" Is Generated In Windows Platform (Doc ID30284751.8) This note gives a brief overview of bug 30284751.The content was last updated on: 08-MAR-2022Affects:Product

'xxx' is not a valid login or you do not have permission. (Microsoft SQL Server, Error: 15007)原因是直接在数据库的用户处创建用户，会报这个错。应该是先创建登录用户，就不会报错了。

查看默认 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

不知道最近打 psu的注意到没有 ，从 opatch 12.2.0.1.5 及 11.2.0.1.14开始，我们的 opatch 工具目录下，再没有 ocm/bin/emocmrsp文件，原因是这个已经被毁弃。但一些打补丁的note中，还未更新，还在使用这种语法：# opatchauto apply <UNZIPPED_PATCH_LOCATION>/27006180 -ocmrf <ocm response file>遇到 这种，我们不用管 ocmrf部分即

在DBUA的升级检查报告中，有一项失败：here is a problem with javavm component and database upgrade cannot be performed until it is corrected.error: ora-29516 jol.c:11157。。。JAVAVM COMPONENT MUST BE FUNCTIONING PROPERLY BEOFER DATABASE UPGRADE根据网上的资料，设置java_jit_enable

executethe following batch file to deploy the agent from an AdministratorCommand Prompt (remembering to update ORACLE_HOSTNAME accordingly inyour .rsp file):agentDeploy.bat RESPONSE_FILE=D:\temp\12.1.0.3.0_AgentCore_233\agent.rspNOTE:If you hit t

Oracle报错ORA-00904: 标识符无效一般情况下，标识符错误是因为：语句中的列名在表中不存在，修改sql语句或者修改列名即可。特殊情况：正常建表语句如下：create table student(id int,name varchar2(100));但是如果建表语句写成了：create table student("id" int,"name" varchar2(100))若给列名加了双引号，表的列名查看时仍然为：id,name。 但是，若使用如

在oracle11.2.0.4 RAC上重启节点后，发现一个节点的数据库启动失败报错为：SQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '+DATA/test/spfiletest.ora'ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.oraORA-1

在 CENTOS7.6 64位上安装12C时报错：[oracle@localhost database]$ ./runInstallerStarting Oracle Universal Installer...Checking installer requirements...Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux

日志文件中出现ORA-01760报错（参考官方文档 ID317254.1）现象：CollectingIndex stats using dbms_stats.gather_index_stats might fail withORA-1760 when a materialized view is present on the base table.The error can also happen when we use cascade=> TRUE option with ei

问题背景：客户数据库服务器cpu很高，查询等待事件发现asynch descriptor resize等待事件从AWR报告里也看到的asynch descriptor resize事件。6 SQL> show parameter async78 NAME_COL_PLUS_SHOW_PARAM TYPE VALUE_COL_PLUS_SHOW_PARAM9 —————————— ———————- ——————————10 disk_asynch_io boolean

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

alter database add supplemental log data;alter database add supplemental log data (primary key,unique index) columns ;然后,通过一下命令去查询是否开启:select supplemental_log_data_min,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UIfrom v$database;SUPPLEME SUP

根据官方文档（ID:2267661.1）在oracle12.1.0.2及之后版本上创建物化视图时可能会出现报错：ORA 7445 [qsme_pls_string] during create mview with XML type functions.STACKskdstdst <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd<- sslsshandler <- sighandler <- qsme_p

手动将scan ip从一个节点切换到另一个节点，可以使用下面的命令：srvctl relocate scanRelocates a specific SCAN VIP from its current hosting node to another node within the cluster.Syntax and OptionsUse the srvctl relocate scan command with the following syntax:srvctl relocate

原来在主备库上发现日志应用存在异常时，都是通过拷贝的方式将归档日志从主库传到备库，然后注册应用在备库通过RMAN来获取归档日志更加简单1.在主库确认归档序号select NAME,DEST_ID,THREAD#,SEQUENCE#,COMPLETION_TIME,REGISTRAR,APPLIED,DELETED from v$ARCHIVED_LOG where SEQUENCE# between 44561 and 44566 and THREAD#=1 and DEST_ID=1;2.

APPLIES TO:Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.SYMPTOMSIn alert log:Wed Mar 20 06:01:42 2020Errorsin file C:\APP\ADMIN\diag\rdbms\orcl\orcl\trace\orcl_cjq0_5072.t

等待事件中，很多 db file async I/O submit 等待事件。查看数据文件是否开启异步IOSelect Name, Asynch_IoFrom V$datafile f, V$iostat_File iWhere f.File# = i.File_NoAnd (Filetype_Name = 'Data File' Or Filetype_Name = 'Temp File');NAME ASYN...

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

local_listener导致登录异常-------------------------------------------------------------------------------------------DB:12.1.0.2OS：Windows 64bit现象如下：SQL> startup nomount;ORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-001

执行一下脚本即可。ORACLE_HOME/rdbms/admin/emremove.sql有些时候，我们升级到19C后，发现大量的 SYSMAN用户的PLSQL对象无效，可以使用这个脚本把他删除。

工作当中有时候想查看一下数据库的具体版本号，这里简单整理了一下，可以通过：dba_server_registry、dba_registry_history、product_component_version、v$version视图查看，另外还可以通过Oracle Opatch命令查询具体的补丁版本1、查询dba_server_registry视图SQL> select comp_name,version from dba_server_registry;2、查询dba_registry_h

How to Create/Rebuild Bootstrap Indexes (文档 ID 1587581.1)SymptomsThe Following Indexes are Missing after Upgrade from 10gR2 to 11gR2:SYS.I_OBJ1SYS.I_OBJ2SYS.I_OBJ3SYS.I_OBJ4SYS.I_OBJ5SYS.I_USER1SYS.I_USER2This is Causing Some Data Dicti

在配置监听时，可以选择使用静默配置方式在解压出来的安装包下，有可以使用的静默安装配置文件在/database/response目录下，存在配置文件netca.rsp通过使用netca.rsp可以实现监听的静默配置命令为：netca -silent -responsefile /home/oracle/database/response/netca.rsp正在对命令行参数进行语法解析：参数"silent"=true参数"responsefile"=/home/oracle/data

在通过RMAN活动复制数据库时，出现这样的报错：RMAN-03002: failure of Duplicate Db command at 05/23/2021 14:54:54RMAN-03015: error occurred in stored script Memory ScriptORA-19625: error identifying file //system01.dbfORA-27037: unable to obtain file statusSVR4 Error: