Author Archive

Error 1044 in MySQL: Access denied when using LOCK TABLES

I got an error while using mysqldump mysqldump: Got error: 1044: Access denied for user x@y to database z when using LOCK TABLES To solve this problem, either ask you administrator to grant you the lock privileges, or u[...]


ORA-08102: index key not found, obj# … Solution to resolve

When updated table, found error: ORA-08102: index key not found, obj# 116528, file 96, block 8795 (2) This problem I had resolved by rebuild indexes (ORA-08102 on index objects). But today I can not use this solution: [...]


Freeing up db_recovery_file_dest reclaimable space.

I temporarily reduced db_recovery_file_dest_size to force the database to free reclaimable space from recovery_file_dest. This reduced disk usage of ASM_ORADATA217 by over 320GB. SYS>show parameter recovery NAME [...]


Cannot export empty tables in 11.2

In 11g there is no segment allocated to the table until you insert, so the EXP utility fails to export empty tables. [oracle@dev-oranode-221 ~]$ sqlplus a/a SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 30 14:38:06 [...]


Automatic Workload Repository (AWR) in Oracle Database 10g

Oracle have provided many performance gathering and reporting tools over the years. Originally the UTLBSTAT/UTLESTAT scripts were used to monitor performance metrics. Oracle8i introduced the Statspack functionality which[...]


A Unix/Linux “find” Command Tutorial

The find command is used to locate files on a Unix or Linux system.  find will search any set of directories you specify for files that match the supplied search criteria.  You can search for files by name, owner, gro[...]


Upgrade an Oracle Instance 10.2.0.3 to 10.2.0.4

To manually upgrade an Oracle Instance from 10.2.0.3 to 10.2.0.4 is pretty much a strait forward routine if one already have a 10.2.0.4 home on the machine. Simply shutdown the instance and edit the /etc/oratab and the /[...]


what is your 10 common linux commands?

What is your regular command you use? I am sure you must thinking of ls and cd. Yeah, they are common for every users, but how about the rest of them? I have construct a combos of commands to help you identify your top t[...]


List command line history with timestamp

History is a common command for shell to list out all the executed commands. It is very useful when it comes to investigation on what commands was executed that tear down the server. With the help of last command, you be[...]


Configure Databse to Run in ARCHIVELOG Mode

Part I) First of  all you must configure the following parameters related to database archiving: You have two main options for define archive log destinations: 1) Flash Recovery Area (recommended) In this part, first of[...]