db wOrLd

Skill sets needed by Developers and DBAs

2011-03-17T16:06:00.001+01:00

DBAs	Developers
Operations	Algorithms
Resource management	Languages
Troubleshooting	Frameworks
Physical data design	Design
System interfaces	User interfaces
Data modeling	Data modeling
SQL optimizer	Debugging, profiling, tracing
Oracle product features	Business-domain processes

Basic Data Mining Tutorial

2010-03-17T13:51:00.000+01:00

Memo to Myself

2010-03-09T12:26:00.000+01:00

Test (Sample) Data Generators

25+ Alternative & Open Source Database Engines

Hacking and Hardening Oracle XE (link)

2010-02-01T13:17:00.001+01:00

How to Install Oracle 11g Release 2 on OEL 5.4 on VirtualBox: Installing Grid Infrastructure

2009-11-07T11:27:00.000+01:00

How can I format xxxxxxxxx like xxx-xx-xxxx in Oracle?

2009-07-27T10:16:00.000+02:00

Creating Custom Authentication in APEX

2009-04-17T11:58:00.002+02:00

Installing Oracle 11g inside an Xubuntu Linux VMWare Image

2009-04-12T08:15:00.001+02:00

Apex Database Objects

2009-03-31T21:19:00.002+02:00

1. Workspace files: apex_workspace_files
Includes columns for:
file_name - name of file uploaded
file_id - unique identifier
application_id - application number
workspace_name - should always be your workspace
mime_type - e.g. text/plain, image/gif, application/excel
file_size - file size in bytes
created_by - e.g. APEX_PUBLIC_USER
created_on - sysdate
document - blob that contains contents of uploaded file

2. Apex access log: apex_workspace_access_log
Creates log record every time you log into application via Apex standard login page (I think). Must be workspace and Apex-owner schema-specific?
Columns include:
ip_address
seconds_ago - how log ago the access happened - dynamic?
access_date
authentication_result - e.g. AUTH_SUCCESS
custom_status_text - ?

3. Apex summary log: apex_workspace_log_summary
Includes columns:
application_id
page_views
distinct_pages
total_elapsed_time
first_view - date/time
last_view - date/time
period_in_days

4. Application activity log: apex_workspace_activity_log
Logs internal (Apex) as well as pages accessed in your application.
Columns include:
application_id
application_name
application_schema_owner - e.g. STEW_STRYKER
page_id
page_name - e.g. Load Import File - new
ip_address
error_message - e.g. ORA-00904: “ADDRESS_LINE_2_BILLING”: invalid identifier
error_on_component_type - report
error_on_component_name - Review Participants

5. Apex view definitions: apex_dictionary
Lists all views and their columns. The view columns are documented in this table in the Comments column.
To get a list of Apex Views
SELECT DISTINCT apex_view_name FROM apex_dictionary;
6. Installation-specific?
V3 Apex schema: flows_030000

Creating Oracle Extended RAC on Oracle VM

2008-12-30T11:15:00.000+01:00

Click here for details on Oracle Extended RAC on Oracle VM.

Oracle SQL Developer Data Modeling

2008-12-11T14:07:00.000+01:00

Oracle SQL Developer Data Modeling is the latest product offering to join the Oracle Database Tools. SQL Developer Data Modeling offers a full spectrum of data and database modeling tools and utilities, including Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of Design Rules.

SQL Developer Data Modeling can connect to any Oracle Database version 9.2.0.1 and later, and is platform independent. Initially available as a standalone product, with future releases available as an extension to Oracle SQL Developer. The second Early Adopter release is stand alone and file-based only.

Download

Apex Examples

2008-11-05T10:35:00.000+01:00

Are you looking for Apex examples ?

Packaged Apps
Carl Backstrom's
Denes Kubicek's
Dimitri Gielis's
Mark Lancaster's
Vikas's

Oracle Locator Express

2008-09-26T10:44:00.000+02:00

Oracle Locator Express is a small free utility with which you can switch the default Oracle Home on-the-fly, just like the Oracle Home Selector does.

http://www.dbmotive.com/ole/

You can get ...

2008-06-04T09:37:00.000+02:00

You can get OpenSolaris Live CD and Oracle Unbreakable Linux DVD shipped to you free of cost.
Order OpenSolaris
Order Oracle Unbreakable Linux

Developing own program using Oracle XE and APEX

2008-04-24T20:07:00.001+02:00

Steve Hall method:
1) Fresh install of Oracle XE to default location on new machine,
2) Run backup.bat script on my development machine (ApEx 3.1, my app etc),
3) Copied these files / folders from the development machine to the new installation :
flash_recovery_area\XE\AUTOBACKUP\*
flash_recovery_area\XE\BACKUPSET\*
product\10.2.0\server\database\SPFILE2INIT.ORA
4) Run the restore.bat script on the target machine.
Voila! ApEx 3.1 and my app on the target machine. It needs more testing and automating but it certainly seems to work 'in the lab'.

Suggestion: You can try the COMPRESS option in backup.

Andre method:
Basically the steps are as follows.

1. Create your schema.
2. Create a workspace using that schema.
3. Create your underlying db objects.
4. Import the application into the workspace.

This is pretty basic and there may be some other steps required to complete the job, such as importing images and workspace users but overall, once you do it once, its not that hard.

Connection to Oracle without using tnsnames

2008-04-03T08:18:00.000+02:00

You can use the following syntax to connect

sqlplus user/password@//host:[port]/service_name
sqlplus user/password@//host:[port]/service_name as sysdba

This syntax (known as EZCONNECT) is only available with sqlplus >= v10.2

Oracle Application Express (APEX) related open source projects

2008-01-04T11:08:00.000+01:00

ApexGen - The Oracle APEX Generator
A utility to generate Oracle Application Express pages based on a PL/SQL API.

The Oracle APEX Builder Plugin
The Plugin is a productivity and usability enhancement tool for the development evironment of Oracle Application Express (APEX).It integrates with Firefox and Internet Explorer 6 & 7 to put a wealth of new features to your favourite development tool.

ApexLib - The Oracle APEX Framework Project
The aim of this project is to provide "the" development framework for the Oracle web development environment APEX (Oracle Application Express). APEX is a very productive declarative web-development environment, but which has (as any tool) some short comings. Especially in the area of "out of the box AJAX features" and "out of the box client-side validation".

Oracle VM

2007-12-17T14:18:00.000+01:00

Tarry Singh at http://www.databasejournal.com/features/oracle/article.php/3712246
writes great article how to install Oracle VM.
It gives a really detailed step by step run through the oracle vm installation with loads of pictures showing the screens you see at each stage of the install.

Don't like to read:
8 minutes and you know all about installing Oracle VM
Check out you tube http://www.youtube.com/watch?v=R_W5_5wJy80

Great series about "Mining Information from the Listener Log" by Arup Nanda

2007-12-17T14:12:00.000+01:00

In this article, you will learn how to build an infrastructure to process the listener log and to use it to unearth information on your database operations. The information can be used in different scenarios, as you will see later.

On-line tutorials Oracle 10g, Java, XML and Web Services

2007-12-10T12:46:00.000+01:00

Advanced technical tutorials to help you learn Oracle 10g, Java, XML and Web Services.
These online Tutorials are self-paced, self-study lessons that contain numerous working examples and hands-on workshops.

Conditional Column Formatting in APEX

2007-12-01T23:09:00.000+01:00

An exmaple:

FREE book: IBM WebSphere Information Analyzer & Data Quality Assessment

2007-11-22T13:22:00.000+01:00

This redbook describes a usage scenario that covers all dimensions of profiling, rule building, deployment, and quality monitoring through a data integration lifecycle.

FREE book: Getting Started with DB2 Express-C V9.1

2007-11-22T11:30:00.000+01:00

Oracle Database Security Checklist - Nov 2007

2007-11-19T11:57:00.000+01:00

Columns to Rows - UNPIVOT (11g)

2007-11-19T11:35:00.001+01:00

O-RSS Reader

2007-11-18T10:42:00.000+01:00

O-RSS Reader - An Oracle PL/SQL API to enable persistent storage of RSS feeds within an Oracle DB.

1.1.0.1.0 version is now available on sourceforge. In that new version you will find a sample APEX application.

O-RSS can be used on Oracle Database 10g Express Edition

Data Warehouse Project Lifecycle by Dylan Wan

2007-11-04T20:29:00.000+01:00

Here is the typical lifecycle for data warehouse deployment project:

0. Project Scoping and Planning
Project Triangle - Scope, Time and Resource.
* Determine the scope of the project - what you would like to accomplish? This can be defined by questions to be answered. The number of logical star and number of the OLTP sources
* Time - What is the target date for the system to be available to the users
* Resource - What is our budget? What is the role and profile requirement of the resources needed to make this happen.

1. Requirement
* What are the business questions? How does the answers of these questions can change the business decision or trigger actions.
* What are the role of the users? How often do they use the system? Do they do any interactive reporting or just view the defined reports in guided navigation?
* How do you measure? What are the metrics?

2. Front-End Design
* The front end design needs for both interactive analysis and the designed analytics workflow.
* How does the user interact with the system?
* What are their analysis process?

3. Warehouse Schema Design
* Dimensional modeling - define the dimensions and fact and define the grain of each star schema.
* Define the physical schema - depending on the technology decision. If you use the relational tecknology, design the database tables

4. OLTP to data warehouse mapping
* Logical mapping - table to table and column to column mapping. Also define the transformation rules
* You may need to perform OLTP data profiling. How often the data changes? What are the data distribution?
* ETL Design -include data staging and the detail ETL process flow.

5. Implementation
* Create the warehouse and ETL staging schema
* Develop the ETL programs
* Create the logical to physical mapping in the repository
* Build the end user dashboard and reports

6. Deployment
* Install the Analytics reporting and the ETL tools.
* Specific Setup and Configuration for OLTP, ETL, and data warehouse.
* Sizing of the system and database
* Performance Tuning and Optimization

7. Management and Maintenance of the system
* Ongoing support of the end-users, including security, training, and enhancing the system.
* You need to monitor the growth of the data.

Article from http://blogs.oracle.com/DylanWan

Better SQL*Plus

2007-11-04T20:17:00.000+01:00

rlwrap - is a 'readline wrapper' that uses the GNU readline library to allow the editing of keyboard input for any other command. Now your's commands history is remembered :)

Oracle 11g RAC On Windows 2003 Using VMware Server

2007-10-25T09:43:00.001+02:00

11g on Windows (32-bit) is out!

2007-10-23T10:50:00.000+02:00

How to Give Your System a Break from Oracle XE

2007-10-23T10:49:00.001+02:00

How to install 10g on various Linux Distributions

2007-10-13T19:32:00.000+02:00

# 10g Release 2 on Centos 5 (and hence on RHEL5 generally)
# 10g Release 2 64-bit on 64-bit Linux (the one exception to the above rule!)
# 10g Release 2 on Fedora 7 64-bit
# 10g Release 2 on Oracle Enterprise Linux
# 10g Release 2 on Solaris 10 (x86)
# 10g Release 2 on Centos 4.x (and hence RHEL4 generally)
# 10g Release 2 on Suse 10 (works unchanged for Suse 10.1 and 10.2, too)
# 10g Release 2 on Ubuntu (describes Ubuntu 5.10 and 6.06)
# 10g Release 2 on Fedora Core 5

Installing Oracle 11g RAC on virtual servers using VMware

2007-10-09T10:53:00.000+02:00

This post describes the installation of Oracle 11g RAC on virtual servers.

Backing Up Apex Application(s)

2007-09-21T12:23:00.000+02:00

Are you looking for a way to automate the task of exporting applications?
1. Automatically Backing Up Your Apex Application(s)
2. Java export utility

How to install Oracle 11g on various Linux Distributions

2007-09-20T12:48:00.001+02:00

11g on Redhat EL 4, 5
11g on Ubuntu 7.4
11g on Enterprise Linux
11g on Debian
11g on Centos 4.5
11g on Xubuntu 7.04

Pivot in 11g

2007-09-19T09:35:00.000+02:00

Pivoting is a key technique in data warehouses. In it, you transform multiple rows of input into fewer and generally wider rows in the data warehouse. When pivoting, an aggregation operator is applied for each item in the pivot column value list. The pivot column cannot contain an arbitrary expression. If you need to pivot on an expression, then you should alias the expression in a view before the PIVOT operation. The basic syntax is as follows:

SELECT ....
FROM
PIVOT
(
aggregate-function()
FOR IN (, ,..., )
) AS
WHERE .....

Example: Pivoting

The following statement illustrates a typical pivot on the channel column:

SELECT * FROM
(SELECT product, channel, amount_sold
FROM sales_view
) S PIVOT (SUM(amount_sold)
FOR CHANNEL IN (3 AS DIRECT_SALES, 4 AS INTERNET_SALES,
5 AS CATALOG_SALES, 9 AS TELESALES))
ORDER BY product;

PRODUCT DIRECT_SALES INTERNET_SALES CATALOG_SALES TELESALES
---------------------- ------------ -------------- ------------- ---------
...
Internal 6X CD-ROM 229512.97 26249.55
Internal 8X CD-ROM 286291.49 42809.44
Keyboard Wrist Rest 200959.84 38695.36 1522.73

Documentation here

2007-09-15T11:18:00.000+02:00

Now I'm official technorati member :)
Technorati Profile

Implementing AJAX into APEX applications

2007-08-17T11:45:00.000+02:00

Create dynamic interfaces that minimize page refresh with Oracle Application Express.
Step-by-Step Instructions for Adding Tooltips

Free Oracle trainings and on-line tutorials

2007-08-13T09:50:00.000+02:00

Log Miner Implementation Summary

2007-07-27T10:27:00.000+02:00

"Log Miner is a powerful tool and all DBA's should know and master it."
- read more -

How manage database without spending a fortune

2007-07-27T10:14:00.000+02:00

Very good article in Computerworld discussing how DBAs manage their systems.

New Oracle Linux Test (OLT) Kit

2007-07-27T10:08:00.000+02:00

What is OLT?

Oracle Linux Tests are designed to verify Linux kernel functionality and stability essential for the Oracle Database. The Oracle Linux Test (OLT) kit, which is distributed as a set of rpms, provides an automated mechanism to define, execute and analyze tests. The kit contains tools such as DBT2 and DBT3 workloads against Oracle single instance or clustered databases, as well as specialized workload simulators. OLT can be used for running tests on Oracle Enterprise Linux, RHEL and SLES distributions and a variety of topologies ( storage attached network, network attached storage).
project site

Building pages with APEX using spatial data

2007-07-17T11:18:00.000+02:00

All about using Oracle Spatial with Google Maps.

- The Official Guide to using Oracle Spatial with Google Maps
- HTML DB and MapViewer: A Perfect Match
- Integrating APEX with Oracle AS 10g
- Oracle APEX/Spatial How to's
- Integration of Google Maps, Oracle Maps, ... into APEX
- Oracle Application Server MapViewer Sample Code and Demonstrations

-(Great tutorial) Google Maps in APEX on XE with spatial data

MySQL vs MS SQL Server

2007-07-16T10:28:00.000+02:00

Step by Step build RAC

2007-07-11T10:48:00.000+02:00

Part 1 : Install VMWare and Linux
Part 2 : Install virtual disk and network card
Part 3 : Install Oracle Clusterware and Cluster Database

Oracle 10g RAC On Linux Using NFS
Oracle 10g RAC On Windows 2003 Using VMware Server

Oracle 10g RAC Series

Server Monitoring With munin And monit On Debian Etch

2007-07-10T12:54:00.000+02:00

In this article Falko Timme describes how you can monitor your Debian Etch server with munin and monit. Munin produces nifty little graphics about nearly every aspect of your server (load average, memory usage, CPU usage, MySQL throughput, eth0 traffic, etc.) without much configuration, whereas monit checks the availability of services like Apache, MySQL, Postfix ...

Access migration to Application Express

2007-07-05T08:50:00.000+02:00

The only requirement, is that you have SQL access to any Oracle database (9iR2+), because the workbench is driven using an underlying migration repository. You could use the Express Edition of Oracle for this purpose, which is totally free, if you didn't have SQL access to an existing Oracle database.
Full text

Custom APEX Authentication / Authorisation Schemes

2007-07-02T09:21:00.000+02:00

Duncan Mein has created a nice How-to for setting up Custom Authentication (Part 1).

Top 15 free SQL Injection Scanners

2007-05-21T08:03:00.000+02:00

SQL Injection is perhaps the most common web-application hacking technique which attempts to pass SQL commands through a web application for execution by the back-end database.

More...

Store MS Word Documents in Oracle

2007-02-17T16:01:00.000+01:00

Follow the following steps..... :)

1) Create a table
CREATE TABLE my_docs (
name VARCHAR2(200) NOT NULL,
doc BLOB NOT NULL
);

2)Create a directory object which stores all your doc
CREATE OR REPLACE DIRECTORY documents AS 'C:\work';

3)Create a procedure
CREATE OR REPLACE PROCEDURE load_file_to_my_docs (p_file_name IN my_docs.name%TYPE)
AS
v_bfile BFILE;
v_blob BLOB;
BEGIN
INSERT INTO my_docs (name, doc)
VALUES ( p_file_name, empty_blob())
RETURN doc INTO v_blob;
v_bfile := BFILENAME('documents', p_file_name);
Dbms_Lob.Fileopen(v_bfile, Dbms_Lob.File_Readonly);
Dbms_Lob.Loadfromfile(v_blob, v_bfile, Dbms_Lob.Getlength(v_bfile));
Dbms_Lob.Fileclose(v_bfile);
COMMIT;
END;
/
4)Execute the db procedure...

[This is sgalaxy solution form Oracle forum]

Hacking SQL Server

2007-02-12T14:45:00.000+01:00

In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins!

Understanding Relationships in E-R Diagrams

2007-02-06T14:52:00.000+01:00

Few articles about E-R diagrams worth to read:

Understanding Relationships in E-R Diagrams (part 1, 2, 3)
Documenting Entities, Attributes & Relationships
E-R Diagram Relationship Integrity Constraints
Interpreting Cardinality and Dependency on an E-R Diagram
Guidelines for Naming E-R Attributes
Recursion in E-R Relationships
Notations on Entity-Relationship Models
Entity-Relationship Diagram Checklist

Mini data generator

2007-01-20T16:57:00.000+01:00

Will Hitchcock proposed a PL/SQL approach for generating the 1000 rows:

declare
i number := 1;
begin
for i in 0..999 loop
insert into pivot values (i);
end loop;
end;
/

Oracle Menu (om) is only a shell script.

2007-01-19T16:51:00.000+01:00

Oracle Menu is only a shell script.

What does it do?
It just helps with often performed tasks and navigating around the file system and can give you useful information quickly.
It can help you perform some of the more monotonous tasks a DBA has to perform without having to know too much.
It can help you if you work between many sites often as it can hide some of the underlying differences, such as filesystem layout etc.

Drupal + Oracle: Inside the OraDrup Project

2007-01-19T16:45:00.000+01:00

In this case study, it is described the OraDrup Project, which has the goal of combining the popular open-source Drupal CMS with Oracle Database.

Link 1
Link 2

Oracle RAC 10g on Oracle Enterprise Linux Using VMware Server

2007-01-06T07:43:00.000+01:00

In this guide, you will learn how to install and configure two nodes on running Oracle RAC 10g Release 2 on Enterprise Linux and VMware Server. Note that this guide is intended for educational/evaluation purposes only; neither Oracle nor any other vendor will support this configuration.

How to stop Oracle XE from starting up with your computer

2006-12-22T15:55:00.001+01:00

Eddie Awad blogs about "How to Give Your System a Break from Oracle XE".
---
There was a question on OraQA about how to stop Oracle XE from starting up with your computer. When you install Oracle XE on Windows, it creates a service called ?OracleServiceXE? with a startup type of ?Automatic? which means that the service starts automatically when the computer boots.

One way to prevent Oracle XE from starting up automatically is to change the startup type of the Oracle service to ?Manual?. You can do that by navigating to your Control Panel -> Administrative Tools -> Services, double click on the Oracle service and change the Startup type to Manual.

Another way to prevent Oracle XE from starting up automatically when Windows starts is to use the ORADIM command-line tool that is available with the Oracle database. From the DOS command line execute the following:

oradim -edit -sid XE -startmode manual

Now, when you want to use Oracle XE, you start it up like this:

oradim -startup -sid XE

And you shut it down like this:

oradim -shutdown -sid XE

Or you can use the ?Start Database? and ?Stop Database? shortcuts installed with Oracle XE. Navigate to Start -> All Programs -> Oracle Database 10g Express Edition ->Start/Stop Database

Now you know how you can squeeze out a bit of extra performance from your computer when you are not using Oracle XE :)

Sources and Resources:
- Eddie Awad's Blog
- ORADIM documentation
- Related AskTom thread

Integrigy Oracle Listener Security Check Tool Updated (v. 2.2)

2006-12-22T15:49:00.000+01:00

AppSentry Listener Security Check is a tool to check the security configuration of the Oracle Database Listener and listeners for Oracle Applications 11i. Four checks are performed:
1. is a password set,
2. is logging enabled,
3. is ADMIN_RESTRICTIONS enabled, and
4. is LOCAL_OS_AUTHENTICATION set for Oracle 10g.

Download lsnrcheck.exe (754KB)

Leverage your Oracle 10g skills to learn DB2 9.1 for Linux, UNIX and Windows

2006-12-19T08:29:00.000+01:00

If you're a database specialist interested in growing your DB2 skills, there's a good chance that you've already developed database skills with another relational database product somewhere along the way. Recently updated for the latest versions of DB2 and Oracle, this article shows you how to use your current knowledge of Oracle 10g to quickly gain skills in IBM DB2 9 for Linux, UNIX, and Windows.

Link

Ruby on Rails with Oracle FAQ

2006-12-12T09:29:00.000+01:00

Exploring Ruby on Rails (RoR)?
This FAQ provides basic information about connecting to Oracle, installation, and creating Oracle Database XE + RoR applications.
Link

Oracle built-in functions

2006-12-11T15:07:00.000+01:00

A nice matrix of Oracle built-in functions

Install the Oracle DBA Toolbar

2006-11-21T08:47:00.000+01:00

The Oracle DBA Toolbar (available for Internet Explorer only at the moment; a Mozilla/Firefox version is forthcoming) gives you one-click access to key DBA resources on OTN.

Features:
* Pop-up Blocker
* Integrated RSS Manager
* OTN Search
* One-click access to SQL*Plus install, Downloads, MetaLink, and more
* Online Support FAQ
Oracle DBA Toolbar

Developer: Open Source

2006-11-15T06:22:00.000+01:00

Ruby on Rails with Oracle FAQs by Casimir Saternos

What is Ruby?

Ruby is an object-oriented interpreted scripting language created by Yukihiro Matsumoto. Since the mid 1990s, it has grown in popularity in Japan and has gained recent attention as the language behind the Rails framework. You can use the language for a striking variety of functions?from basic scripting to creating Windows applications to developing Web applications. You can start using Rails without extensive knowledge of the language; the Rails framework generates the fundamental classes needed for the Web application and uses reflection to perform object-relational mapping to the database.

OTN's "Greatest Hits"

2006-11-15T06:18:00.000+01:00

The Oracle Technology Network (OTN) "Greatest Hits" CD is a compilation of the most popular technical articles, software downloads, podcasts, sample code, and documentation, we've published in a given 12-month period. The compilation provides you with convenient access to the "best" of OTN as well as an insight into the interests of the Oracle developer and DBA communities.
Greatest Hits - 2006 Edition ZIP (119MB)
Greatest Hits - 2006 Edition ISO (190MB)

Free Oracle Tutorial Downloads

2006-10-16T13:55:00.000+02:00

A lot of interesting tutorials:
Oracle
Others

Oracle Database Patch Sets

2006-08-15T09:24:00.000+02:00

Here you have a nice link to latest patch sets against platforms including release dates.

*You must have a MetaLink account to download patch sets.

Ultimate List of Free Windows Software from Microsoft

2006-08-03T15:17:00.000+02:00

Microsoft has over 150 FREE Windows Programs available for download -- but finding them all is extremely difficult. Until NOW

Helpful Ruby on Rails tutorials.

2006-07-19T12:53:00.000+02:00

Top 30 Ruby on Rails Tutorials from eConsultant

20 ways to Secure your Apache Configuration

2006-07-19T12:42:00.000+02:00

Here are 20 things you can do to make your apache configuration more secure.

Oracle DB feature matrix

2006-07-01T18:44:00.000+02:00

If you are interested in the features and options of the different editions of the Oracle database(XE,STD,EE) - this document contain a handy matrix.

Ruby on Rails on Oracle XE

2006-07-01T18:34:00.001+02:00

As you may have noticed, Oracle recently published an article about Ruby on Rails on Oracle. This articles introduces the Ruby on Rails framework and explains how to use it to access an Oracle database (Oracle Database 10g Express Edition (XE), to be precise).
If you are not familiar with Ruby on Rails, it is important to note that it has nothing to do with Java; it is a Ruby-based framework. Ruby on Rails is really interesting, powerful.
If you have nothing to do :) - check this 3 links:
Ruby on Rails on Oracle: A Simple Tutorial
Grails on Oracle for Java Developers
HR Schema on Rails

Starter Toolkit for DB2 on Rails

2006-06-16T11:49:00.000+02:00

A set of tools that enables rapid building of Web applications with Ruby on Rails and DB2.

Startup Toolkit for DB2 on Rails has everything you need packaged in to a single one-click installer that will make your Windows PC in to real RoR development workstation. This includes the Ruby language itself, the Rails framework, DB2 enablement for Ruby on Rails, assorted learning materials and, naturally, DB2 Express-C 9 test drive (formerly known as DB2 Viper). And, if you are familiar with DB2 Express-C then you know that there are absolutely no charge for developing, deploying, and even redistributing DB2 with your applications. Yes, completely free and including way cool pureXML technology.
There is also a new blog dedicated to DB2 and Ruby on Rails at http://db2onrails.com/blog/.

Free PHP and Oracle Manual is Available

2006-06-13T07:19:00.000+02:00

The free Underground PHP and Oracle Manual is hot off the press. Check it out. The OTN team describe it:
"Just starting out with PHP database development, or unsure how to install PHP and Oracle? This full-length guide (PDF format) includes everything you need to know (and more)."

RSS Available on my Page

2006-06-12T09:43:00.000+02:00

Now you can read RSS newsfeeds from your desktop.

What is RSS?
RSS provides a way for web sites to distribute their content outside of a web browser. A news web site might have an RSS newsfeed which contains breaking stories, while a magazine web site may provide a feed with excerpts of their latest articles.

Oracle Database 10g Express Edition (XE) Installation Issues Roundup for Windows

2006-06-12T09:14:00.001+02:00

After installing XE, one of the first things you'll do is to go to the database homepage. If something went wrong with the installation, you will see a generic error message...
More on Sergio's Blog

New Release of Oracle Database 10g Express Edition

2006-06-12T09:06:00.000+02:00

Oracle database XE now also available on Ubuntu, Mandriva, and Debian.
Get download packages for these additional distros here, and .deb install tips here.

Demos @ Oracle By Example

2006-06-11T10:45:00.000+02:00

You can use this page to play demos to learn how to use various features of the Oracle Database.

Here is a list of the demos you can find there at the moment, there will be more comming up:
Oracle Database 10g Release 2

Using SQL Baselines

Using Metric Baselines

Install ASM single instance in its own home

Install ASM single instance in the same home

Migrate a database to ASM

Setup XML DB to access ASM

Access ASM files using ASMCMD

Transport a tablespace version to another database

RAC scale example

RAC speedup example

Use Oracle Clusterware to protect the apache application

Use Oracle Clusterware to protect the Xclock application

Use Transparent Application Failover (TAF) with SELECT statements

Runtime Connection Load Balancing example

Install ASM in its own home in a RAC environment

Convert a single-instance database to a RAC database using Grid Control

Push Management Agent software using Grid Control

Clone Oracle Clusterware to extend your cluster using Grid Control

Clone ASM home to extend your cluster using Grid Control

Clone database home to extend your cluster using Grid Control

Add a database instance to your RAC database using Grid Control

Basic use of services in your RAC environment

One open source platform for managing your entire environment

2006-06-08T10:05:00.000+02:00

Hyperic has open sourced their management infrastructure.
HQ provides an inventory of all the hardware, software and services deployed in your infrastructure as well as supplying alerts on events and allowing control of various software resources.

Storing images on the database

2006-06-07T14:02:00.000+02:00

Article on OTN about storing images on the database.

Installing Oracle XE under Debian/(K)Ubuntu - it is easier than Windows by Jeroen van Wilgenburg

2006-06-06T15:53:00.001+02:00

Yesterday I installed Oracle XE at my Ubuntu Linux server at home. I wanted to do this for a long time but was a bit scared because installing non open source applications under Linux can be really painful. I searched on google and found a tutorial on OTN. That's a promising START.

Translation in APEX - Mini how-to

2006-06-06T15:45:00.000+02:00

Hi all,

I will try to give You my example of solving translation of application in APEX.

Main parameters:
Primary language: en (English)
Translation lang: hr (Croatian).

Read more

1.Firstly you have to define primary language (Application Builder>Application 500>Edit Globalization Attributes) and select your primary language (Application Primary Language: English (en).
2. On the sam page define Application Language Derived From as "Application preference (use FSP_LANGUAGE_PREFERENCE).
3. Define translation mapping "Application Builder>Application 500>Shared Components>Translate Application>Application Language Mappings" and create mappings for your second language (example is hr (Croatian)).
4. On the login page or first page if you don't have login, create hidden field (P101_LANG i n my example replace for your usage). It is used for rememebering current language
5. Create new application process (Application Builder>Application 500>Shared Components>Application Processes)
Name: redirect
Process point: On load before header
Type: PL/SQL Anonymous block
Conditions>condition type: Request=Expression1
Conditions>Expression1: LANG
Process text (here is the code):
BEGIN
IF nvl(:P101_LANG,'en')='hr' THEN
:P101_LANG:='en';
ELSE
:P101_LANG:='hr';
END IF;
HTMLDB_UTIL.SET_PREFERENCE ('FSP_LANGUAGE_PREFERENCE',:P101_LANG,:FLOW_USER);
owa_util.redirect_url('f?p='||:APP_ID||':'||:APP_PAGE_ID||':'||:SESSION);
END;

6. Login page: on this page create one button with label in your primary lang. point on second language. My example label is "Croatian" in english as primary language and translated to "English" in Croatian. This logic is used for having just one button saying "Croatian" when I'm in english web page and "English" when I'm in croatian web page.
Button has "Optional URL Redirect" with :
Target is: page in this application
Page : your login page number (most probably 101)
Request: LANG

7. For all other pages i use new item on navigation bar defined as:
Label: Croatian (secondary language) in Croatian translation label is "English"
Target>Target Type: Page in this application
Target>Page: &APP_PAGE_ID. (don't forget dot on the end)
Target>Request: LANG

8. Export XLIFF
9. Translate
10. Import translation
11. Publish translated app
12. Enjoy
That's all folks.

Main logic is to create same process for every page that is triggered if the request is LANG. This process changes the FSP_LANGUAGE_PREFERENCE preference that as far as I know can not be changed as other common app parameter but using HTMLDB_UTIL.SET_PREFERENCE function. With hte process in place you just have to implement link on every page for itself with request=lang and tha language will change.

I hope this is useful for everybody because it took me 6 bloody hours to do figure it out.

Published on Oracle forum by Dark Lord

Free e-book "1000 Java Tips"

2006-05-31T15:10:00.000+02:00

"1000 Java Tips" eBook is huge collection of big and small Java programming articles and tips. You need latest version of Acrobat Reader to be able to read it, because the content is digitally signed. The size of "1000 Java Tips" e-Book is 856 pages of A4 format!

Take your copy here [35MB].

Tips & Tricks

2006-05-27T20:18:00.000+02:00

Q.: How to see installed options like Oracle Text,OLS etc.
A.: select * from v$option

Read more

On my XE the result was:
(54 rows returned)

Partitioning	FALSE
Objects	TRUE
Real Application Clusters	FALSE
Advanced replication	FALSE
Bit-mapped indexes	FALSE
Connection multiplexing	TRUE
Connection pooling	TRUE
Database queuing	TRUE
Incremental backup and recovery	TRUE
Instead-of triggers	TRUE
[...]	[...]

Oraspeed 2.7

2006-05-27T20:06:00.000+02:00

Oraspeed 2.7 has been released.
Features: Using this Oracle IDE you can write and test Queries. Create, Compile, Execute and Debug your PL/SQL Programs. Execute Anonymous PL/SQL Blocks. Create/Edit Database object using advanced wizards. TKProf, PL/SQL Profiler, Parent Child Tables Data Explorer,Built-in reports, BLOB Editor and much more.

Interesting thing is how these products compare to Oracle's free SQLDeveloper or Qwest's TOAD. Any comments?

Project Lockdown by Arup Nanda

2006-05-27T10:05:00.000+02:00

Article Abstract:

(Arup Nanda) Imagine that you have just landed a new job as a DBA. On your first day, you hear rumors of an impending security audit driven by Sarbanes-Oxley requirements. You need to get to know your environment as soon as possible, so you know where to look and understand when to take immediate or preventive action.

Link

DBA Interview Questions

2006-05-25T12:30:00.000+02:00

Explain how you would restore a database using RMAN to Point in Time?
How does Oracle guarantee data integrity of data changes?
Which environment variables are absolutely critical in order to run the OUI?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
Why does Oracle not permit the use of PCTUSED with indexes?
What would you use to improve performance on an insert statement that places millions of
rows into that table?
What would you do with an "in-doubt" distributed transaction?
What are the commands you?d issue to show the explain plan for "select * from dual"?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
If you?re unsure in which script a sys or system-owned object is created, but you know it?s in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
Explain the concept of the DUAL table.
What are the ways tablespaces can be managed and how do they differ?
From the database level, how can you tell under which time zone a database is operating?
What?s the benefit of "dbms_stats" over "analyze"?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

from deep Internet

DB2 Universal Database Version 8.2 for Linux HOWTO

2006-05-20T22:28:00.000+02:00

DB2 Universal Database Version 8.2 for Linux HOWTO is intended for anyone interested in installing and using 32-bit IBM DB2 Universal Database on Linux. The information found in this document is based on experiences installing and configuring DB2 UDB Version 8.2.

Freeware Veritas Storage Foundation Basic 4.1

2006-05-19T08:10:00.000+02:00

Veritas Storage Foundation Basic is a free-license version of Storage Foundation, with an optional support subscription. Storage Foundation Basic combines the industry-leading Veritas File System and Veritas Volume Manager, offering a complete solution for heterogeneous online storage management.

System Requirements:
Storage Foundation Basic 4.1 is currently available on Solaris and Linux platforms:
Solaris 10 x64
Red Hat Enterprise Linux 4 32 and 64-bit (Xeon, EM64T and AMD Opteron)
Red Hat Enterprise Linux 4 64-bit (Itanium2)
Novell SUSE SLES 9 32 and 64-bit (Xeon, EM64T and AMD Opteron)
Novell SUSE SLES 9 64-bit (Itanium2)
---

Veritas Storage Foundation Basic jest darmową wersją znanego na całym świecie pakietu Storage Foundation. Wersja Basic łączy w sobie cechy Veritas File System and Veritas Volume Manager - dzięki czemu stanowi kompletne rozwiązanie dla ochrony danych.

ApEx 2.2 Evaluation

2006-05-09T08:30:00.000+02:00

Looks like the ApEx folks have an Evaluation Version of ApEx 2.2. There are also some new icons and themes... more and more.

Apex 2.2 update

Here are some other new or improved features in APEX 2.2:

Application Deployment Packaging

Component Attributes Screens (eg Regions, Items, Computations, & Processes)

Copy Application Feature

Finder Utility

Monitoring - Application Reports

Timestamp support

Report Attributes Page

Improved Page Debug Messages

Re-Ordering Widgets

Online Help

Oracle ORION

2006-04-26T07:06:00.000+02:00

ORION is the Oracle I/O Numbers Calibration Tool designed to simulate Oracle I/O workloads
- Without having to create and run an Oracle database
- Using the Oracle database's I/O libraries
- Using small I/Os to simulate OLTP workloads
- Using large I/Os to simulate data warehouses

ORION is useful for understanding the performance capabilities of a storage system, either to uncover performance issues or to size a new database installation.

Orion is available on otn for the following platforms:
-Linux AMD x86-64
-Linux i386
-Windows
--
ORION jest narzędziem służącym do symulowania obciążenia serwera Oracle. W prosty sposób możemy wykryć problemy z naszą bazą. Nie wymaga on instalacji Oracla, czy też tworzenia bazy danych.
--
Follow this link \ Więcej tutaj:
link 1 link 2

Centralny serwer logów MS Windows na PostgreSQL

2006-04-19T09:08:00.000+02:00

Zachęcam do zapoznania się z ciekawą koncepcją połączenia systemu logów MS Windows'ów z darmową bazą danych PostgreSQL. Autorem koncepcji i aplikacji jest Bartek Siębab.
Głównym założeniem projektu była centralizacja logów zbieranych z różnych systemów MS Windows z dzienników evenlog oraz innych (za pośrednictwem protokołu syslog) w jednej darmowej bazie SQL. Z powodu wymagań co do wydajności bazy, objętości gromadzonych dzienników oraz faktu iż baza ma być darmowa, sql'owa i ma być bazą (a nie programem do wyświetlania tabelek takim jak "mójsql" ;-) a ponadto koniecznym "połączeniem" do bazy w postaci komponentu .NET 2.0 na placu boju pozostał PostgreSQL...
Cały artykuł

Nagrody LinuxWorld rozdane

2006-04-13T10:55:00.000+02:00

Zwycięzcy tegorocznego "LinuxWorld Product Excellence Awards" byli prezentowani na "LinuxWorld Conference & Expo" w Bostonie.

A oto pełna lista zwycięzców:
Best Application Development Platform
- Novell Inc. - Mono Development Framework
Best Clustering Solution
- Continuent - Continuent p/Cluster
Best Desktop Solution
- SunWah - Linux Rays LX 1.5
Best Grid Computing Solution
- Themis - DCRM
Best Database Solution
- Oracle - Oracle Database 10g Express Edition
Best Messaging Solution
- Scalix - Scalix Appliance
Best Open Source Solution
- Xchange Server 5 - Open
Best Security Solution
- Barracuda Networks - Barracuda Spyware Firewall
Best Systems Management Tools
- rPath Inc. - rBuilder
Best Virtualization Solution
- Swsoft Inc. - Virtuozzo for Linux
Most Innovative Hardware
- AMD - Dual Core AMD Opteron processors Models 885, 285 and 185
Best Integration Solution
- Xandros - Xandros Server

źródło:LinuxWorld

Formatowanie składni SQL'a

2006-04-05T20:50:00.000+02:00

Często nasza składnia SQL'owa jest chaotyczna i trudna do odczytania, ale jest na to rada SQLinForm oraz Online SQL Formatter.

Czas na przykład:
- przed
select ename from (select ename from emp order by sal desc) where rownum <>

Historia baz danych

2006-04-02T22:54:00.000+02:00

Ciekawy artykuł dotyczący historii baz danych w języku angielskim.