技术文章列表
512 篇impdp 导入AL32UTF8 字符集问题
背景：在使用ORACLE的过程中,会出现各种各样的问题,各种各样的错误,其中ORA-12899就是前段时间我在将数据导入到我本地机器上的时候一直出现的问题.不过还好已经解决了这个问题,现在分享一下,解决方案;出现ORA-12899,是字符集...
impdp ORA-31626,ORA-31637
HugePages on Oracle Linux 64-bit
Purpose Scope Details Introduction Why Do You Need HugePages? How to Configure Check and Validate the Configuration Trou...
Huge Archive_Redo Generation in System
Archive for April, 2015 Huge Archive/Redo Generation in System! Posted by FatDBA on April 14, 2015 On one of our product...
Huge archive log generation .. what to do_ what is causing it_
col name for a55col program for a20col username for a15select s.sid, n.name, s.value, sn.username, sn.program, sn.type, ...
How To Uninstall Or Reinstall Database Vault in 11g
Goal Solution References Applies to: Oracle Database Vault – Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2] I...
How to transport a tablespace from 10g ASM on Windows to 11g ASM on AIX | Oracle DBA – Tips and Techniques
How to transport a tablespace from 10g ASM on Windows to 11g ASM on AIX Posted by Gavin Soorma On August 31, 2009 2 C...
How to retrieve previous table statistics using Oracle dbms_stats – Blog dbi services
Sometimes, you need to modify the statistics of a table. There are various reasons: either for the performance analysis ...
How to recreate a control file in Oracle Database
Posted by Amit Rath at [](http://amit7oracledba.blogspot.com/2012/10/how-to-recreate-control-file-in-oracle.html) Reacti...
How to install Oracle RAC 18c in silent mode on Oracle Linux 7.5 with VirtualBox – Part 2_1
Both posts document how to install a 2-node Oracle RAC cluster with Oracle 18c on Oracle Linux 7.5 (OL7) with VirtualBox...
How to install Oracle RAC 18c in silent mode on Oracle Linux 7.5 with VirtualBox – Part 2
Both posts document how to install a 2-node Oracle RAC cluster with Oracle 18c on Oracle Linux 7.5 (OL7) with VirtualBox...
How to install Oracle RAC 18c in silent mode on Oracle Linux 7.5 with VirtualBox – Part 1_1
Both posts document how to install a 2-node Oracle RAC cluster with Oracle 18c on Oracle Linux 7.5 (OL7) with VirtualBox...
How to install Oracle RAC 18c in silent mode on Oracle Linux 7.5 with VirtualBox – Part 1
Both posts document how to install a 2-node Oracle RAC cluster with Oracle 18c on Oracle Linux 7.5 (OL7) with VirtualBox...
How to Increase SCN
ACID：ORA-600 [2662] ORA-600 [4000] 1.通过adjust_scn 2.通过_minimum_giga_scn 3.通过oracdebugoradebug poke <address> <l...
How to find Sessions generating high redo_archives in Oracle
12345678910111213141516171819202122232425262728293031323334 Run the below query tofind out the archive generation/hour f...
How to disable SSH timeout
SSH clients will automatically be disconnected from the server and prompt the below message after being idle or inactive...
How to Close and Expire Database Link
How to Close and Expire Database Link [ID 473635.1] Modified 09-DEC-2009 Type HOWTO Status PUBLISHED In this Document Go...
How to Clean Up After a Failed 10g or 11.1 Oracle CRS(Clusterware Installation)
Thursday, May 6, 2010 How to Clean Up After a Failed 10g or 11.1 Oracle CRS(Clusterware Installation) Runing following s...
How to avoid ORA-02153 when creating database links on 11.2.0.4 (the unsupported way) | DBA survival BLOG
Posted on August 31, 2015_Disclaimer (wow, most of my recent posts start with a disclaimer, I guess it’s bad): this post...