oracle uncatalog数据库备份文件
Oracle 11g rac
Oracle报错ORA-27127
单机环境19.3数据库启动后自动关闭,告警日志提示:ORA-27157,ORA-27300,ORA-27301,ORA-27302
SUSE12SP4系统安装
SUSE系统安装过程
达梦dmrman备份报错[-7103]:创建命名管道失败
达梦DMRMAN工具冷备份
中标麒麟达梦8数据库安装和卸载
国产数据库:dm8单机安装介绍 国产数据库图形工具使用比较多,也建议使用图形界面。
ORACLE 数据导出LOB字段报错ORA-31693,ORA-02354,ORA-22924
周末加班进行数据导出导入工作,在一个LOB字段的表上消耗时间比较多,特此铭记。
ORA-17500: ODM err:ODM ERROR V-41-3-2-207-5 Mirror Number too large
ORA-17500: ODM err:ODM ERROR V-41-3-2-207-5 Mirror number too large for given offset
11g rac 等待事件resmgr:cpu quantum
排名第一大量等待事件:resmgr:cpu quantum,且CPU 使用率居高不下
SQL优化1
SQL执行38秒返回16行结果,走的NESTED LOOP嵌套,被驱动表扫描570次
Oracle 数据文件回收
针对有些朋友理论不是很清楚,特此测试如下: 测试表的高水位的块无法回收,即使删除也没有释放空间,块已分配给表的及时truncate 也无法分配给其它段使用;
tomcat 8.5.51配置http及https访问
协助应用发布war包,需求:https + http访问 http端口:8100 https端口:443
ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS
数据库版本12.2,近期总收到此告警,每次看到alter.log 都是先启动个job,然后跟着这个错误; 为了跟领导解释,特意MOS了一把
12C 在线MOVE
12C已上线多年,到此已出现20C,周日闲来无事测试验证网上的发帖,自己动手测试才是真的。哈哈 版本:12.2.0.1.0 PS:数据库未开归档
ASM集群文件系统ACFS(ASM Cluster File System)
近期遇到前同事咨询ACFS问题,自己测试一把做个记录
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Errors in file /oracle/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_1135.trc: ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Linux-x86_64 Error: 11: Resource temporarily unavailable Additional information: 3 Additional information: 128 Additional information: 978444928
OGG-01423
启动OGG报错:OGG-00446 Oracle GoldenGate Capture for Oracle, extkafka.prm: The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT , TRANLOG, THREADS 2, BEGIN...).
ORA-00054: resource busy and acquire with NOWAIT specified
开发针对表添加字段报错:ORA-00054: resource busy and acquire with NOWAIT specified
OGG-01117 Received signal: Program interrupt (2)
监控告警: ERROR OGG-01117 Received signal: Program interrupt (2). ERROR OGG-01668 PROCESS ABENDING.
Apache解决Access-Control-Allow-Origin多域名跨域问题
开发人员反馈:No ‘Access-Control-Allow-Origin’ header is present on the requested resourcevi httpd.conf 取消如下注释#LoadModule headers_module [...]然后VirtualHost服务中添加Header set Access-Control-Allow-Origin &qu
Linux 安装字体
应用需要罗马字体,服务器应用打印报表需求