-
编辑 删除
Oracle upgrade processes
DBA Notes: 2011/09/21Cheng Li Upgrade Oracle database As part of eHealthy application server upgrading, we support to upgrade repository database from Oracle 10.2.0.1 to Oracle 10.2.0....
-
编辑 删除
MYSQL REPARE TABLE
DBA Notes: 2011/09/20Cheng Li MYSQL Repair Table MySQL tables can become corrupt for several reasons, such as hardware failure, operating system bugs, viruses and bugs in MySQL. It is ...
-
编辑 删除
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with ...
DBA Notes: 2011/09/19Cheng Li ORA-16019 The usage of flash recovery area During our Oracle system upgrade to Oracle 10.2.0.1, we apply the flash recovery area feature. &nbs...
-
编辑 删除
How to use MYSQLBACKUP
DBA Notes: 2011/09/16Cheng Li How to use MYSQL Enterprise backup (MEB) MySQL enterprise backup, MEB, is a superset of the InnoDB Hot Backup product. The ibbackup command is available o...
-
编辑 删除
How to resolve Oracle deadlock
DBA Notes: 2011/09/15 Cheng Li How to resolve Oracle Deadlock From alert log, we are reported for ORA-000060: Deadlock detected. By diggering into trace file we can see following infor...
-
编辑 删除
Oracle trace event
DBA Notes: 2011/09/14 Cheng Li Oracle notes: sharing a article about oracle events Reference of Oracle event dump 1 Oracle background traces files &...
-
编辑 删除
How to build database connection among heterogeneous database
How to build database connection among heterogeneous database 1 Build database connection from SQL SERVER by linked server For the request to be access data from MYSQL from SQL server 2...
-
编辑 删除
How to use Oracle utility EXPORT/IMPORT
How to use Oracle utility EXPORT/IMPORTIn this case, we will use Oracle export/import to refresh database schema from production to DEV. Oracle data pump can enable parallel processing for high...
-
编辑 删除
Example for backup tablespace
In this case, we use networker to online backup a tablespace. For transportable tablespace, we can directly backup and copy among platform. and databases. For other tablespace, we should change the m...
-
编辑 删除
Tablespace Group usage and bug 5455880
Just for a technical hint, we can use temporary tablespace group in place of singe temporary tablespacce to be dynamic management of temporary space. Using a tablespace group f...
-
编辑 删除
How to handle ORA-01654
DBA Notes: 2011/09/09 Cheng Li(Database: Oracle 10g, OS: AIX 5L) How to handle ORA-01654 From daily alerts, we are reported an ORA-01645 oracle error, as following: 18:43:32 j...
-
编辑 删除
ORA-04030: shortage of RAM on a dedicated (non shared server) environment
How to handle ORA-04030 issues Issue Case: During the performing of data dump, we got a message of ORA-04031/ORA-04030 issues. 作为一般的原则，页面文件中的空闲容...
-
编辑 删除
How to configure MYSQL resource limitation
(Database: MYSQL 5.5, OS: RHEL) A case study about how to configure MYSQL resource limitationSet up MYSQL resource limitation at file: /etc/security/limits.conf Following is a case of ...
