Oracle in World

Magento Installation does not proceed from Configuration window

2009-12-06T05:56:00.000-08:00

Problem Description While installing magento the first window is License Agreement which says " Welcome to Magento's Installation Wizard!" After accepting term and clicking continue Localizationwindow appears. Clicking continue button brings the windowConfigurationIn the configuration window you will see Database Connection, Web access options and Session storage options. After filling forms you

Audit and Profile Management Exercises in Oracle

2009-12-05T07:49:00.000-08:00

In your lab for this week you are going to work with three different areas and processes within the Oracle Database that can be used to control data security. Each of these three processes has its own distinctive application to providing levels of security. In each case the individual processes deal with either limiting a users access to the database, limiting access to processes within the

Oracle Object type Exercises - VARRAY

2009-12-05T07:40:00.000-08:00

For this lab you will begin by using the same set of tables that you used for Lab 1 so be sure that you are connected to Oracle as the DBM449_USER user. The objective of this lab will be to create a series of object-relational tables using the SQL*Plus editor that will allow data to be stored in a more "real-world" format. Data for your new tables can be found in the file Lab1_

Practice Oracle Joins Examples

2009-12-05T07:32:00.000-08:00

Before starting this lab let's assume that you have the following two files Lab1_initialization.sql and 2.PUPBLD.SQL Lab1_initialization.sql DROP USER DBM449_USER CASCADE; CREATE USER DBM449_USER IDENTIFIED BY DEVRY DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP; GRANT CONNECT, RESOURCE TO DBM449_USER; GRANT CREATE MATERIALIZED VIEW, CREATE DATABASE LINNK TO DBM449_USER; CONN DBM449_

Oracle Database Hot Backup Practices

2009-12-05T07:11:00.000-08:00

An open (hot) database backup is made with database running in ARCHIVELOG mode. This kind of backup can be performed while the database is open and the users are working with the database, thus it is also called online backup. Online backups are done by placing a tablespace in backup mode, copying it somewhere else on disk or tape, and then taking the tablespace out of backup mode. After backing

Database Archival Exercises

2009-12-05T07:08:00.000-08:00

Successful database recovery relies on the database being in ARCHIVELOG mode. This is what enables the database to recover data that was lost due to a media failure, loss of power or any other type of disaster. Each time the online line redo logs fill up in a log group the DBMS issues a log switch that will move the log writer process from the current redo log group to the next one in line. If

Oracle Security Practices

2009-12-05T06:53:00.000-08:00

Oracle, like many other databases, uses the combination of specific user definitions, privileges, and roles to control access to the data in the database. In turn, it provides various layers of security. When the database is first created, there are several users created for the purpose of not only installing various components of the database, but also to manage and administer the database

Practice with User Profiles and User Roles in Oracle

2009-12-05T06:47:00.000-08:00

HANDS-ON #1: User profiles Your company has hired several new people for a new department project in your regions. This department will have some different requirements from regular works, and the DBA wants to ensure that the new hires will not be getting stepped on by current users in the database and vise versa. To help insulate the new hires, it has been decided to create a specific

Exercises with Oracle Create Table Add Columns

2009-12-05T06:44:00.000-08:00

Step 1: Creating a basic table First, we need a couple of tables. Create two tables, one named EMP and the other named DEPT, based on the following specifications. Add the necessary definition to your create statements to place the two tables in the USERS01 tablespace. Be sure that you explicitly name your constraints. I would suggest that you use a format of table_column_type, for example

Temporary Tables and Data Types Exercises

2009-12-05T06:41:00.000-08:00

I N D I V I D U A L E X E R C I S E S HANDS-ON #1: Temporary tables Your project is complete and now you are ready to start testing. Your application reads data from one table, processes portions of the data and makes some changes, then inserts the changed data into two additional tables before committing the work. Errors are captured in an external SPOOL file for evaluation and

Oracle Tablespace Exercises for Newbie

2009-12-05T06:18:00.000-08:00

One of the more confusing aspects of the Oracle database is the fact that you musts deal with both a logical and a physical side to some of the more important database objects. Both the Redo Log and Tablespace in the Oracle database have a logical side and physical side in referencing the object. The logicalreference is the notation in the data dictionary that defines the object and its storage

Logical Database Architecture Exercises

2009-12-05T06:08:00.000-08:00

Often times, the job of a DBA involves making assessments and decisions about the database, using data that is accumulated through testing and monitoring the database activity. There are all sorts of things that can affect the performance of a database, and most of them are not restricted to the number of people logged on and using the database. Obviously, the rate at which the database grows

Database Architecture Exercises - Control file Redo logfile Examples

2009-12-05T06:04:00.000-08:00

The Oracle database uses two very important files for database support, stability, and recovery. The Control file is one of the most important files in the database, as it is the file that keeps track of where everything is and where it should be at any given time. Since the database itself only needs one Control File to operate with, multiplexing the Control File is a very important part of

Database Administration Exercises - Week 3

2009-12-05T05:43:00.000-08:00

I N D I V I D U A L E X E R C I S E S HANDS-ON #1: Dictionary Views to help you work Using your text and any other sources you wish, make a list of the data dictionary views you feel would be the most helpful to a programmer who is writing applications that perform DML actions on rows from tables in the database. Give a brief explanation for your choice of each view. Place and

OMF, init.ora Parameter files, Startup, Shutdown Exercises

2009-12-05T05:28:00.000-08:00

G E N E R A L O V E R V I E W Scenario/Summary Oracle provides two primary types of file management; User Managed Files (UMF) and Oracle Managed Files (OMF). As part of this exercise, you will need to supply some information as to how you would use both of these approaches and discuss some of the advantages of each. Along with creating a database, there are other additional files that

Oracle Database Creation Exercises

2009-12-05T00:52:00.000-08:00

L A B O V E R V I E W Scenario/Summary Although Oracle provides a very nice graphical interface tool call "Enterprise Manager" to aid the DBA in working with the database, it is not always the tool of choice. Many DBAs find it preferable to use command-line execution of scripts and procedures to do administrative work. One such case is in the creation of a new database within the

Oracle Database Installation Exercises

2009-12-05T00:44:00.000-08:00

Oracle was developed as a Client/Server database, although there is a mainframe version. Although the process is somewhat automated, the Oracle Enterprise Database is not your simple auto-run installation application. The truth is that there is some pre-configuration work of the OS system, as well as some forethought about naming conventions and the like, that really need to be done before the

Oracle Enterprise Manager Excercises

2009-12-05T00:02:00.000-08:00

As we begin our journey through the world of Oracle and explore the Oracle database architecture and functionality, it might first be helpful to start becoming familiar with one of the Oracle tools that you have not yet had a chance to work with in some of your other database courses. Oracle Enterprise Manager (OEM) is the Oracle database GUI tool that allows the DBA to do many of the

Database design practice for a Movie Company

2009-12-04T23:58:00.000-08:00

The More Movies company has hired you to redesign a database system for them that can facilitate the process of renting out and returning movies. They already have an Oracle database that stores information about movies, members who rent the movies, and the rentals. This is the database that you already have become familiar with, which includes tables: MM_MOVIE, MM_MOVIE_TYPE, MM_MEMBER,

Oracle UTL_FILE package practice examples

2009-12-04T23:01:00.000-08:00

To practice the exercise you need the schema. You can found the schema from the post http://arjudba.blogspot.com/2009/12/basic-oracle-sql-exercise.html and before practice these exercises you must first run those sqls so that you can get tables and data to practice. After you know the answer of each step please post your PL/SQL inside comment section so that other can check and understand it and

Exercise Oracle Trigger and Package

2009-12-04T22:43:00.000-08:00

Scenario/Summary This week we are going to continue to expand the functionality of our database schema by adding a couple of triggers to that will help us automate some of the processing we already have in place. Triggers can be used to automate repetitive tasks within the database, such as adjusting inventory levels based on other actions taken in the database. Once you have created and

Exercise Oracle package and package body

2009-12-04T22:37:00.000-08:00

Oracle Procedure and Function Practice

2009-12-04T11:03:00.000-08:00

Practice Exercise for Oracle PL/SQL

2009-12-04T10:40:00.000-08:00

Basic Oracle Sql Exercise

2009-12-04T09:46:00.000-08:00

Here goes database schema. We will use this schema to test in our exercise. So before exercising the steps run these sqls/ create table/ insert statements in your oracle database schema. DROP TABLE MM_MOVIE_TYPE CASCADE CONSTRAINTS PURGE; DROP TABLE mm_pay_type CASCADE CONSTRAINTS PURGE; DROP TABLE mm_member CASCADE CONSTRAINTS PURGE; DROP TABLE mm_movie CASCADE CONSTRAINTS PURGE; DROP TABLE