Ask TEM Dba

How to Use DVSYS.DBMS_MACADM procedures to Prohibit Data Access to Users

sysdba — Tue, 19 Oct 2010 10:23:16 +0000

A realm is created on HR schema objects : how to prohibit the access to HR objects to the accounts SYSTEM and SYS without using the Database Vault Administrator GUI tool (dva) ? 1. Realm creation and schema objects selection : SQL> execute dvsys.dbms_macadm.CREATE_REALM(‘Test HR’,'Protects data from DBA access’,'Y’, 1); SQL> execute DVSYS.DBMS_MACADM.ADD_OBJECT_TO_REALM ( ‘Test HR’, [...]

How to Drop and Recreate the DB Control Repository

sysdba — Thu, 14 Oct 2010 08:17:17 +0000

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 Repository in a 10g Database 1. Stop the DB Console if not already stoped: $ORACLE_HOME/bin/emctl stop dbconsole On Unix Systems: 1. Run 10g DB $OH/sysman/admin/emdrep/bin/RepManager NOTE: Type RepManager by itself [...]

Exploring the Oracle Database Architecture

sysdba — Fri, 08 Oct 2010 14:12:51 +0000

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 SGA is shared by all server and background processes. Examples of data stored in the SGA include [...]

Error 1044 in MySQL: Access denied when using LOCK TABLES

sysdba — Tue, 13 Jul 2010 08:31:10 +0000

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 use the following command instead. mysqldump -u username -p database --single-transaction >dump.sql

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

sysdba — Fri, 11 Jun 2010 15:16:25 +0000

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: What is about this error? Error: ORA-08102 Oracle10g Message Text: index key not found, obj# %s, file %s, block %s (%s) Oracle [...]

Freeing up db_recovery_file_dest reclaimable space.

sysdba — Thu, 03 Jun 2010 09:22:56 +0000

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

sysdba — Tue, 01 Jun 2010 16:57:23 +0000

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 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production With the Partitioning, OLAP, [...]

Automatic Workload Repository (AWR) in Oracle Database 10g

sysdba — Fri, 28 May 2010 13:49:18 +0000

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 Oracle9i extended. In Oracle 10g statspack has evolved into the Automatic Workload Repository (AWR). AWR Features AWR Features The AWR is used to collect performance statistics including: Wait events used to [...]

A Unix/Linux “find” Command Tutorial

sysdba — Wed, 26 May 2010 14:37:10 +0000

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, group, type, permissions, date, and other criteria. The search is recursive in that it will search [...]

Upgrade an Oracle Instance 10.2.0.3 to 10.2.0.4

sysdba — Thu, 20 May 2010 16:12:17 +0000

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 /usr/local/oraenv (if this has been changed from the original version) to make sure your instance now uses the new [...]