Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Tuesday, December 30, 2008

Creating Oracle Extended RAC on Oracle VM

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

Wednesday, November 05, 2008

Thursday, April 03, 2008

Connection to Oracle without using tnsnames

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

Monday, December 17, 2007

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

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.

Monday, December 10, 2007

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

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.

Monday, November 19, 2007

Sunday, November 18, 2007

O-RSS Reader

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

Sunday, November 04, 2007

Better SQL*Plus

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 :)

Saturday, October 13, 2007

How to install 10g on various Linux Distributions

# 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

Tuesday, October 09, 2007

Installing Oracle 11g RAC on virtual servers using VMware

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

Wednesday, September 19, 2007

Pivot in 11g

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

Wednesday, July 11, 2007

Step by Step build RAC

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

Friday, January 19, 2007

Oracle Menu (om) is only a shell script.

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

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