How to Drop and Recreate the DB Control Repository
Information in this article applies to: Oracle Enterprise Manager 10g Release 1 (10.1) Oracle Enterprise Manager 10g Release 1 (10.2) So: Goal: Provide detailed instructions on how to remove and recreate the DB Control R[...]
Exploring the Oracle Database Architecture
Explain the Memory Structures System Global Area (SGA) – The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The[...]
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 /[...]
