4 m18994118189

尚未进行身份认证

我要认证

qq:137609516

等级
TA的排名 6w+

Listener in INTERMEDIATE status with “Not All Endpoints Registered“ (Doc ID 1454439.1)

2020-09-25 10:56:53

Unified Audit record write to audit trail table failed due to ORA-942. Writing the record to OS spil

Unified Audit record write to audit trail table failed due to ORA-942. Writing the record to OS spillover file 导致的原因ORA-942 IS SEEN IN ALERT LOG WHILE CREATING CDB BY DBCA (Doc ID 2258727.1)

2020-09-14 16:31:17

补丁31305087

1.在grid用户加载补丁31305087出现报错/oracle/app/19.0.0/grid/OPatch/opatch apply -oh /oracle/app/19.0.0/grid -local /oraclelog/psu/31305339/313050872.报错如下UtilSession failed: NApply was not able to get the list of patches to apply3.查看详细的日志信息说是/oracle/app/19

2020-09-11 16:50:30

Error 4 opening dom ASM/Self in 0x60027b0

19C: While Executing Root.sh on Remote Nodes HIT UNEXPECTED "ERROR 4 OPENING DOM ASM/SELF IN 0x57f7d60" (Doc ID 2571719.1)grid 安装时执行第二个脚本时,第2,3,4节点都出现Error 4 opening dom ASM/Self in 0x60027b0Domain name to open is ASM/SelfError 4 opening dom ASM.

2020-09-11 16:46:56

修改asm的ALLOCATION_UNIT_SIZE

SQL> select NAME,ALLOCATION_UNIT_SIZE from v$asm_diskgroup;NAME ALLOCATION_UNIT_SIZE--------------- --------------------CRSDG 4194304DATADG 1048576RECODG 4194304set ...

2020-09-11 08:53:39

Oracle - 截取指定日期的alert log

工作中DBA经常会查看alert log来检查数据库后台都记录了些什么日志,如果只想看某一天或者某段时间范围的日志,能够把这些日志从大的alert log中截取下来放到一个单独的文件中,对于查看和下载都是很有意义的事,接下来附上脚本script.sh#!/bin/bash################################################################################# this script is to get the spe

2020-05-28 14:01:33

oracle导出数据到txt文件方法整理

oracle导出数据到txt文件方法整理select 'sqlplus username/pswd@tns @spool_data.sql '||owner||' '||table_name from dba_tables where owner=upper('&schema_name') ;将下面的脚本内容,放入到spool_data.sql中set pagesize 0-- This script dumps a table to a comma delimited ASCII.

2020-05-26 16:38:26

ORA-39125,ORA-31642,DBMS_SCHED_EXPORT_CALLOUTS.SCHEMA_CALLOUT,DBMS_CDC_EXPDP

数据库版本10.2.0.4,对于这个版本如果使用parallel并行的话,说不定会遇到预料不到的bug,所以oracle10版本的数据库,数据量不是很大的话,一般不使用并行1.数据库alert日志Errors in file /oracle/oracle/admin/hmcz12/bdump/hmcz121_dw01_312250.trc:ORA-07445: exception encountered: core dump [kghfrf+063c] [SIGSEGV] [Invalid per

2020-05-24 11:44:55

ggsci error while loading shared libraries libnnz19.so

[oracle@primary oggsource]$ ./ggsci./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory[oracle@primary oggsource]$ ldd ggscilinux...

2019-12-06 09:22:47

[FATAL] [DBT-10201] Delete database operation canCAUSE: There are no databases present on the system

[oracle@standby admin]$ dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName sys -sysDBAPassword 'KerberosUser#example.com1'[FATAL] [DBT-10201] Delete database operation cannot be performed....

2019-12-04 09:08:35

使用redhat7.2及以上版本安装12c&19c要注意的事项

错误原因描述:在rhel7.2中,systemd-logind服务引入了一个新特性:在一个user完全退出OS后会remove掉所有的IPC对象。该特性由/etc/systemd/logind.conf参数文件中RemoveIPC选项来控制。详细请看man logind.conf(5)。在rhel7.2中,RemoveIPC的默认值是yes因此,当最后一个oracle或者grid...

2019-12-04 09:06:29

RAC系统主机修改ip、vip、scan_ip

1.停库、停集群登录pgprsdb1,使用grid执行srvctl stop database -db pgprsdb分别登陆pgprsdb1、pgprsdb2用root用户执行crsctl stop crs2.主机修改ip(虽然主机ip已经变了,但是主机名称没有变,不需要重新做互信)10.32.228.89 pgprsdb1---------->10.32.2...

2019-11-20 19:02:48

ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [950], ORA-00950: no er

进程日志报错2019-11-13 20:25:49 INFO OGG-00482 DDL found, operation [---捞取宽带订单总量明细---捞取宽带订单总量明细drop tab---捞取宽带订单总量明细le n_phb_ktsx(size 64)].2019-11-13 20:25:49 INFO OGG-0048...

2019-11-14 15:45:19

gipcd not coming up

hi all今天在回滚xcrmdb41上的补丁重启集群时gipcd.trc报如下错误,集群无法正常启动2019-11-12 17:10:09.019842 :GIPCXCPT:3: gipcmodNetworkProcessBind: failed to bind endp 600000000036c760 [0000000000000030] { gipcEndpoint : l...

2019-11-13 10:24:59

Manually Purge the Optimizer Statistics & AWR Snapshots to Reduce Space Usage of SYSAUX Tablespace

In this DocumentSymptomsChangesCauseSolutionReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterOracle Applications DBA - Version 12.1.3 to 12.1.3 [Release 1...

2019-11-05 15:13:45

数据库oracle目录清理分析

数据库在运行过程中会不停的产生各类的trc文件,需要及时清理操作系统oracle目录,防止数据库hang死1、清理oracle用户下的trc文件oracle@jecndb31:/home/oracle$bdumporacle@jecndb31:/oracle/app/oracle/diag/rdbms/ecndb3/ecndb31/trace$cd ..oracle@jecnd...

2019-11-03 14:54:02

4不受LRU算法的限制,不会被清除

4.使对象的相关定义,执行计划或执行代码驻留到shared_pool(library cache)里(表是驻留到数据字典里面的),不受LRU算法的限制,不会被清除主要是看这个字段kept为也是则不受LRU算法的限制SQL> exec dbms_shared_pool.keep('SCOTT.P1');SQL> select OWNER,NAME,KEPT from v$db_...

2019-10-09 09:28:16

ORA-1652: unable to extend temp segment by 8192 in tablespace XXX

实验环境一SQL> create table FACT_XX01( MAX VARCHAR2(10) not null, POLNO VARCHAR2(30), MAINPOLYEAR VARCHAR2(100) )tablespace test pctfree 10 initrans 1 maxtrans 255 storage (...

2019-10-02 13:24:35

数据库出现hang住,我们看到process已经超了

进行hanganalyze文件问题收集,怀疑是并行出现了问题这里的通过sql_id看不到全部的sql_text,也是个问题,这个先解决首要问题,所以先忽略 The SQL Text Stored for a Create Table As Select (CTAS) Statement is Truncated to 20 Characters in View DBA_H...

2019-09-23 15:56:21

警示:Oracle 12.1.2.0与Oracle 11.2.0.4通过DB Link查询触发BUG 17890099

在Oracle 12.1 版本通过 DB Link 连接 11.2.0.4 的数据库时,可能会因为特定原因触发BUG,引起数据库实例因 ORA-00600 错误而导致实例重启。案例的现象和过程范例:1.RAC节点因为 ORA-600 k2gteget: pdbid 而出现异常,级联错误 qsmmixGetIdxKeyStats-1,异常是由存储过程中基于 DB Link的查询触发:...

2019-09-23 15:51:06

查看更多

勋章 我的勋章
  • 领英
    领英
    绑定领英第三方账户获取
  • 持之以恒
    持之以恒
    授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里,不积小流无以成江海,程序人生的精彩需要坚持不懈地积累!
  • 勤写标兵Lv4
    勤写标兵Lv4
    授予每个自然周发布9篇以上(包括9篇)原创IT博文的用户。本勋章将于次周周三上午根据用户上周的博文发布情况由系统自动颁发。