ORACLE 18c
文章平均质量分 54
zuozhiji
这个作者很懒,什么都没留下…
展开
-
oracle自动收集统计信息
默认自动收集统计信息的时间为晚上10点(周一到周五,4个小时),早上6点(周六,周日,20个小时)由于平时默认每天只收集4小时,时间有点短了,改成每天可收集8小时。oracle 18c中默认是打开的。查看当前自动收集统计信息的时间。原创 2023-03-31 09:12:23 · 1916 阅读 · 1 评论 -
ORA-01455: converting column overflows integer datatype
ORA-01455: converting column overflows integer datatype原创 2022-06-28 15:59:00 · 889 阅读 · 0 评论 -
oracle 18c alert 日志 提示Resize Operation Completed For File#
File Extension Messages are seen in alert log.There was no explicit file resize DDL as well.Resize operation completed for file# 45, old size 26M, new size 28MResize operation completed for file# 45, old size 28M, new size 30MResize operation completed原创 2022-04-19 14:00:26 · 706 阅读 · 0 评论 -
Fatal NI connect error 12170.
alert_oracl.log里发现了很多连接错误的信息。Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 18.0.0.0.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 18.0.0.0.0 - Production TCP/IP NT Protocol Ad...原创 2022-04-19 13:52:28 · 2097 阅读 · 0 评论 -
oracle 18c impdp的directory不能指向soft link
建立软链接[oracle@qht120 /] ln -s /u02/dumpdata /u01/dumpdumpdataoracle下建立directorycreate directory dumppath as '/u01/dump/dumpdata';此时导入文件 就会出错:[oracle@qht120 genernal_ddl]$ impdp l5m/l5m directory=DUMPPATH dumpfile=dump_AMOTTVW_%U.dmp logfile=impdp_原创 2022-04-08 09:23:24 · 780 阅读 · 0 评论 -
bug:ORA-20002: Directory creation failed
dbca安装18c的时候出错如下:[oracle@yuanqu tmp]$ dbca -silent -createDatabase -responseFile ~/tmp/dbca_nopdb.rspPrepare for db operation10% completeCopying database files40% completeCreating and starting Oracle instance42% complete46% complete50% complete.原创 2022-03-28 15:26:04 · 1839 阅读 · 0 评论 -
centos7 hugepages的设置
当前系统centos7[root@qht116 ~]# uname -aLinux qht116 3.10.0-862.el7.x86_64 #1 SMP Fri Apr 20 16:44:24 UTC 2018 x86_64 x86_64 x86_64 GNU/Linuxoracle 18c安装好后,数据库启动时alertlog报以下提醒,是没有配置hugepage的原因系统默认的pagsize只有4k,对于大sga来说,pagesize对数据库和系统的交换性能起到很大的影响,cent..原创 2022-02-28 13:35:40 · 3521 阅读 · 0 评论 -
oracle18c报错ORA-12012: error on auto execute of job
新安装的oracle18c数据库,alert log一直出错:ORA-12012: error on auto execute of jobORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_222"ORA-20001: Statistics Advisor: Invalid task name for the current userORA-06512: at "SYS.DBMS_STATS", line 4953.原创 2022-02-28 10:36:39 · 1772 阅读 · 0 评论 -
oracle 10g 通过rman迁移到 18c出错
RMAN> alter database mount2> ;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================.原创 2021-08-10 15:31:15 · 148 阅读 · 0 评论