Feed aggregator

Oracle Blog Tag is dead (or should be pretty soon)

Peter Khos - Sun, 2008-01-13 20:02
So, the recent Blog Tag should be almost over by now and the debate over whether one should or should not participate is over. It's interesting to see how a simple thing like this can become such a sticky point for a number of folks. Jake K obviously didn't expect such a reaction to starting the blog tag.For me, it's an exercise in team building. I find that folks tend to work and get along Peter Khttp://www.blogger.com/profile/14068944101291927006noreply@blogger.com3

I've been tagged 3 times; 8 things about me

Pawel Barut - Sat, 2008-01-12 10:17
Few busy days without any blog reading and after I've gone through my feeds it occurred that I've been tagged 3 times:
  1. By Eddie Awad
  2. By H.Tonguç YILMAZ
  3. By Jorrit Nijssen (Jornica)
Thanks You for tagging.
Now I feel that I really need to write something about me:
  1. I was born and grow up in Krosno in south-east Poland (see satellite picture),
  2. I 15th when Communism fall down in Poland. At this moment Poland is member of Schengen Agreement, and I can travel around Europe without passport. Lot of changes in last 19 years,
  3. I'm Thawte Web of Trust Notary,
  4. In 1993 I took 2nd place in Nation Contest in Programming for College Students. Unfortunately I was 6 month too old to take part in international final :(
  5. In 1990 I've sold my first program; small DB written in Clipper. I did not think that this program will be used for so many years. In 1999 I had to do some changes to support year 2000,
  6. My first program was written in Basic and was run on PSP-80 (page in Polish)
  7. I'm married and we have 2 daughters (6 and 2 years old),
  8. My favourite TV show is Top Gear with Jeremy Clarkson , Richard Hammond and James May.
I will not invite anyone directly as I do not want to accused of spam. All my readers that have blogs are welcome to post 8 things about themselves.

Categories: Development

Tag flood

Christian Bilien - Fri, 2008-01-11 10:08
  Amid the tag furry, I was tagged some days ago by Jeff Moss so I’ll have to give some pieces of information about myself presumably of low interest to most. I had not put any personal information on my blog, so here are 8 of them which I’ll keep short anyway: I come from […]
Categories: DBA Blogs

Smart Space: What is it?

Oracle EPM Smart Space - Fri, 2008-01-11 09:26
Smart Space is a radical departure from the traditional BI/EPM application. For years the BI/EPM market has been focused on providing more and more features. These features are added to backend services bringing us to the ‘system’ we have today. However most of these features are simply added to existing user interfaces. Over time these interfaces, though packed with features, have become difficult to use, underperforming and nearly impossible to customize. It seems that the market has shifted the focus away from analytic consumers toward the power users which is narrowing the reach of BI/EPM solutions.

With Smart Space, we have taken a completely new approach. It is simple and elegant. We leverage the power of the entire Windows client (including the browser) to deliver a rich end user experience leveraging the powerful back end EPM processes in place today. Very few are taking this approach today and it clearly differentiates Oracle from any other BI/EPM vendor.

So, let’s look at Smart Space in a little more detail…

Smart Space creates a BI/EPM environment within the Windows desktop. This is done by installing a small, lightweight engine that is tightly integrated with Windows. The installation uses a technology called ClickOnce which is simple with automatic update capabilities. Let’s face it, customers expect any client software to be easy to install and self maintaining.

Smart Space is then “Always On”, taking advantage of the power of the desktop with its ability to multitask. Because Smart Space is “Always On”, the user connects to the BI/EPM system one time and never has to connect again. This combination of a single login and being “Always On” is a perfect example of a simple enhancement that will make BI/EPM software much more useable and responsive.

Instead of creating one large application with hundreds of features, Smart Space breaks down an application into its functional pieces. These subsets of functionality are then presented to the user in the form of gadgets. The users are then free to choose the functionality they need and organize their gadgets according to their workflow.

Smart Space also enhances the analytical experience by introducing simple collaboration into the BI/EPM environment. The collaboration capabilities of Smart Space allow for “in context” discussions about the BI/EPM content that is both secure and auditable.

Smart Space will change the way people use BI/BPM software. Instead of using BI/BPM only when necessary, Smart Space allows a wide variety of knowledge workers to easily integrate this valuable BI/BPM information into their everyday desktops.
Categories: Development

The blog tagging thing

Yasin Baskan - Fri, 2008-01-11 06:50
During the last few days lots of Oracle bloggers have been busy tagging each other and posting eight unknown things about themselves. I was also tagged by some friends and was asked to post eight things about myself. I have never forwarded any chain e-mails or messages to anyone and in parallel to that I have not written anything about myself after this either.

What I think about this blog tagging thing is very similar to what Howard Rogers thought about it. He shut his site down for some time and you can read what he thinks when you go to his blog. My thoughts on this are here in the comments to an Eddie Awad post. Howard has also posted a comment there to explain further.

So I've been tagged...

Peter Khos - Thu, 2008-01-10 23:49
Apparently the blog tagging thing is still going strong. Doug Burns tagged me early this week. Thanks Doug, now I got two problems: a) figure out 8 things that people don't generally know about me and b) figure 8 other bloggers to tag. You can see Howard Rogers' comments to this blog tagging at the above mentioned Doug Burns' blog entry. I don't agree with Howard's comments but he has every Peter Khttp://www.blogger.com/profile/14068944101291927006noreply@blogger.com3


Jornica - Thu, 2008-01-10 16:58

 Gareth Roberts tagged me. Thanks for the invitation. And here are 8 things you did not know about me.

  1. My nickname Jornica is derived from Jorrit Nijssen. However five characters is often not enough for an username. By adding some extra random chosen characters ca it is long enough...
  2. I maintain another non Oracle related blog as well: Etc.
  3. Keywords of my favorite holidays: sea, sun and hills. Did I mention volcanoes?
  4. My roots are in the southern part of the Netherlands; I like music from artists like De Janse Bagge Bend, Gé Reinders and Rowwen Hèze.
  5. I like to watch fire engine movies on You Tube with my son.
  6. My family believes I'm a good cook.
  7. My favorite Linux distribution is homemade Linux From Scratch. It's about building your own Linux system from source code.
  8. I use Lifehacker as a source for new software: Windows tools and utilities.

And now, who's next (sorry 3 out of 8).

Gadget/Widgets, What are They and Why Do I Need Them?

Oracle EPM Smart Space - Thu, 2008-01-10 14:18

I hear these terms a lot now a days when talking about software, and just a year or so ago I would of thought a widget was a generic term for a product and a gadget was some new electronic device. Not anymore, these terms have quickly taken on new meaning and have a place in the world of delivering information. The bad thing about these terms is that everyone uses them a little different and there are already variations on the terms. So I am going to give you my take on these terms as I see if and how they apply to Business Intelligence (BI) & Enterprise Performance Management (EPM).

First let’s try and make things simple and assume that the terms Widget and Gadget are synonyms and understand that I usually use the term Gadget. So in this post when you see the word ‘gadget’ you can replace it with ‘widget’ in your head if you so desire. My simple explanation for why there are two terms is because more than one company decided to use these ‘things’ and they have decided to differentiate. Short explanation Apple used the term ‘Widgets’ so Microsoft decided to use the term ‘Gadgets’. So that brings us to the key players in the space, I am sure there are more but I see four key players on the consumer side of things.

These companies all have gadgets and the frameworks that run them but many of them have different variations. These variations fall into three general categories. Desktop, web, and mobile with each of the above companies playing in one or all of the three categories. Even with all of these variations I think I can sum up in general what the purpose of these things are:

Gadgets (or Widgets) are mini applications that expose key content (bits of data) or features generally from a larger (full) application and they deliver these features or data in a simple and visually pleasing manner.

Data (Weather) – The larger application is your weather person or weather.com, these people and sites have lots of great data points but all I really care about is current conditions and tomorrows conditions. I really don’t have a desire to understand how isobars or barometric pressure impacts the weather. Thus a gadget.

Feature (Play Music) – The larger applications are iTunes, WMP, Zune, Songbird, Music Match and many others, these are cool full applications packed with rich features but I just want to play a song or playlist most of the time. Thus the gadget.

You can apply this concept to almost any feature you use most often or data you look at on a regular basis. The variations of desktop, web or mobile do not really matter the definition holds in any case.

Now that we know what gadgets are lets think about if we need this new application class in our life. Here I think the answer is simple to arrive at. Just ask yourself if you have ever opened a program for a single feature or piece of information? If yes then explore the possibility that others are doing it. I doubt that very many people can say no to this question. I used to do it every morning before going on my runs. I would go to weather.com and look up the forecast for my zip code and filter through all the other features to get the temp so I could decide to how to dress for the run. Now I just glance at the gadget and I can tell if I need a hat or not.

So now we know what they are and we think that they have at least some utility but can we apply these concepts to BI and EPM? This is the very question among others we had to answer when we were creating Smart Space. We came to the conclusion that BI and EPM companies where building products and adding features based on the needs of their most active users. This makes for really good, feature rich applications that some user may find offer too much. So we starting playing with BI and EPM concepts and applying them to gadgets and it worked. Here is an example:

Reporting – Over the years we have found that many users look at the same reports over and over again. Maybe it is the monthly closing process and there is a ‘book’ of reports the accounting department reviews, or a sales representative is looking at pipeline data every day. This is the feature. The larger application would be the BI tool used to present this data or reports like Oracle Answers, Financial Reporting, or Publisher. So why not let the user pick the reports or report pieces that they feel are most useful for their tasks and have them always open and ready for them. Thus a gadget.

Smart Space Smart Book Gadget:

Because the concept was so easily applied we decided to make gadgets one of the many key features in Smart Space. The gadgets in Smart Space are complemented by a bunch of other great features that make the gadgets easy to use and lend to the overall user experience.

With Smart Space gadgets we decided to not use an existing gadget framework or engine for a number of reasons. Above I used the word ‘consumer’ when I talking about existing gadget frameworks or engines and this is because to date they have been focused on the mass market and have not applied the concept to businesses or business applications. For example they have lots of gadgets for weather, stock, fantasy football, cpu meters, and even countdown to the OC. The point is that these are great, I use them, my kids have used them, but they have not crossed over to business application and the needs of business. These special needs are what differentiates Smart Space gadgets from consumer gadgets. Some of the key needs are as follows.

Gadgets are just one part of the overall user experience and there are many other features needed to enhance or complement the gadgets. For example Smart Space has a top notch Windows shell integration that allows user to easily add BI and EPM content to their gadgets. This shell integration presents application content in an enterprise repository as if it were a flash drive. Consumer frameworks do not offer these features.

Deployment and control came up as a major issue and we spoke with customers. IT organizations managing a rollout of BI application do not want their users to just go and download gadgets. Also IT wants control over who develops the gadgets that the users can install. Administrators also told us that they need this framework to be able to install on restricted user desktops. With the consumer frameworks the control and deployment differences were show stoppers. Smart Space allows administrators to publish gadgets to a ‘gadget store’ for user to select from and the users can download and install the client and new gadgets with no administrative rights.

So in summary, whatever you call it, gadgets or widgets they are a key part of computing for the consumer space and this trend will continue to move into the business space. I challenge everyone to share thoughts and ideas on how you would apply these concepts to a business application.

Categories: Development

I have been tagged

Fadi Hasweh - Thu, 2008-01-10 14:17
Gareth Roberts tagged me in the current round of OraBlog tag, you can check the rules.

Below are the 8 things you might not know about me:

1- Athens, Greece, Masters: I am currently doing my masters in managing business innovation and technology thurogh a scholarship here in Athens, Greece.
2- Having to change your job is a good thing: I started my oracle career after I had to change my previous job (well my old manager claims that my work was done there and the project i was working on was over, actually it turns out to be a good thing after that I changed my career path from Microsoft to Oracle)
3- Travel: I like to travel a lot and I am welling to take any chance to visit any new country/places.
4- Documentary: I am a T.V documentary addict; I can watch any type of documentary but prefer political ones.
5- Jogging: I jog 3-4 KM every other day I like jogging a lot.
6- Single: well still I am currently single. (Marry to oracle apps I guess ;-).
7- Reading: currently I am trying to get used to reading I have this book called (the management bible by John Wiley and sons) it’s a good book I guess every manager should read it, although I am not a manager yet but be prepared always. You never now what will happen next.
8- Sky is the limit and think big: Sky is the limit is my personal message at MSN messenger, and think big will be my next personal message at MSN.

My turn in tagging, I will tag.
OCP Advisor
Syed Jaffar Hussain
Lutz hartmann
Mark Rittman
Grant Ronald
Senthil Rajendran
Vikram Das
Famy Rasheed

have a nice tagging


procedure for Calculating Database Growth and scheduling in DBMS JOBS....

Ayyappa Yelburgi - Thu, 2008-01-10 04:18
1. Create a Table By the Name db_growth...with following details... Name Null? Type ----------------------------------------- -------- ---------------------------- DAY DATE DATABASE_SIZE_MB NUMBER DAILY_GROWTH_MBayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com13

Agile PLM – Part III – Application Node Installation

Aviad Elbaz - Wed, 2008-01-09 08:48
This is the 3rd (and last..) post about Oracle Agile installation.
In this post we will see the Agile application node installation step by step including all Agile application required components.

Previous related posts:
- Agile PLM – Part I
- Agile PLM – Part II – Database Node Installation

The Agile Application node installation composed from the following steps:
- Complete all application installation pre requisites
- Oracle Application Server Installation
- Oracle Applications Server Patch
- Agile Application Installation
- Agile Viewer Installation
- Deploy Agile application on Oracle Application Server
- Verify Installation
- Configure IIS as a Proxy Server for Agile PLM
- Configure File Manager with IIS
- Verify File Manager installation


1) Copy Platform directory from Disk2 to Disk1 to the setup.exe level
2) Make sure Microsoft IIS (Internet Information Services) is installed on this box.

*** It is important to install MS IIS before proceeding with the Oracle AS installation, otherwise you might get into port conflict between IIS and Oracle AS

Oracle Application Server Installation

1) Run installer - setup.exe (from Disk1 directory)

2) Oracle Home destination:
a. Name: oracleas1
b. Path: d:\OraHome_1

3) Language: Choose the appropriate languages.

4) Check the Administrative privileges

5) At Select Configuration Options window, leave the upper 2 options checked only

6) Port configuration: Automatic

7) Fill in the Instance name and ias_admin password:

8) Install

9) Exit

10) Shutdown Oracle AS:
a. Open a cmd window
b. cd oraHome_1\bin
c. emctl stop iasconsole
d. opmnctl stopall

Oracle Applications Server Patch Installation

1) Open a cmd window
a. set ORACLE_HOME=d:\OraHome_1
b. cd [Installation Dir]\Windows\patches\oas101202\OPatch
c. opatch apply d:\ [Installation Dir]\Windows\patches\oas101202\OPatch\3992805

2) Type "Y" (for : Is this system ready …?)

Agile Application Installation

1) From Disk1: cd [Installation Dir]\Windows
2) Execute setup.exe

3) Accept the license agreement
4) Enter license & username

5) Select Applications Server + File Manager + Web Proxies

6) Location to install Agile application: D:\agile\Agile9221

7) Select Oracle Application Server 10g (

8) Select Standalone Installation

9) Enter Oracle Application Server Home directory: d:\OraHome_1

10) Click on Use Existing

11) Choose: No, use a Database for authentication

12) Hostname: agileapp.[domain]

13) Web Server information: agileapp.[domain]:80

14) Agile viewer information: agileapp.[domain]:5099

15) Database details:
a. Agile Database Host Name: agiledb
b. Agile Database Port: 1521
c. Agile Database SID: agile9
d. Agile Database User: agile

16) Virtual path: Agile

17) At File Manager User Authentication window select: Use Internal user account

18) File Manager Virtual Path: Filemgr

19) Agile File Manager window: agileapp.[domain]:80

20) Agile File Manager Storage Location: e:\agile\agile9221\files

21) Select to create product icons in an new Program Group called: Agile

22) Install…

23) Restart the system

Agile Viewer Installation

1) From Agile Viewer installation directory execute: setup_win.exe

2) Accept the license agreement
3) Enter User name and License key
4) Check the Agile Viewer only

5) Select New Install

6) Location: d:\Agile\Agile9221

7) Select Regular Agile Viewer

8) Enter hostname & port: agileapp.[domain]:5099

9) Done

Deploy Agile application on Oracle Application Server

1) cd OraHome_1\opmn\bin
a. Stop all Oracle AS processes - opmnctl stopall
b. Start all Oracle AS processes - opmnctl startall
c. cd d:\agile\agile9221\agileDomain\bin
d. Execute command: DeployAgile

2) Verify deployment
a. cd \OraHome1\dcm\bin
b. dmctl listapplications

Verify Installation

1) Run in browser the following url: http://agileapp:7777/Agile/PLMServlet
2) Connect with admin user

Configure IIS as a Proxy Server for Agile PLM

1) Navigate to: Control Panel -> Administrative tools -> Internet Information Services (IIS) Manager

2) Right click on “Default Web Site” (under Web Sites) -> properties
3) Select the “Home Directory” tab
4) In the “Execute permissions” list, select “scripts and executables”

5) Select the “ISPAI filter” tab -> add
a. Filter Name: oproxy
b. Executable: D:\Agile\Agile9221\AgileProxies\oracle_proxy.dll

6) Right click on Default Web Site-> new -> Virtual directory

7) Alias: oproxy

8) Path: d:\agile\agile9221\AgileProxies

9) Check the read and execute options

10) Finish.
11) Navigate to “Web service extension” -> select: “all unknown ISAPI extensions and Click “Allow”

12) Navigate to: Control Panel -> Administrative tools -> Services
13) Restart the “IIS Admin Service”
14) Run in browser: http://agileapp/Agile/PLMServlet (without port 7777)
15) Logon with admin user to verify IIS configuration.

Configure File Manager with IIS

1) Edit d:\agile\agile9221\Tomcat\conf\server.xml
2) Look for the port after the following text:
!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 --

3) Edit file jk2.properties -> channelSocket.port=8009 (the previous port)
4) Navigate to: Control Panel -> Administrative tools -> IIS Manager
5) Go to ISPAI Filter tab -> add
a. name: Jakarta IIS Connector
b. Executable: D:\Agile\Agile9221\AgileProxies\isapi_redirect.dll
6) Right click on default web site-> new -> Virtual directory
a. Alias : Jakarta
b. Path: d:\agile\agile9221\agileproxies
7) Check the read and executable options
8) Restart IIS Admin Service again.

Verify File Manager installation

1) Startup tomcat server by: d:\agile\agile9221\tomcat\bin\catalina start
2) Open the following url in browser to check Java installation on client: http://agileapp/JavaClient/start.html

3) In order to use the Agile java client we should install Java JRE 1.5.x
4) Open the following url again: http://agileapp/JavaClient/start.html
5) Click on Launch
6) Login with admin user.
7) Navigate to: Server setting -> locations
Verify all locations (especially under the File Manager tab)

Now when the Agile application node installed, the Agile system are ready for use.
If you have an initial dump file to export, you can do it now with agile9imp.bat script.

For more information:
Installing Agile PLM for OAS

You are welcome to leave a comment for any issue or additional information.


Categories: APPS Blogs

Introduction to Simple Oracle Auditing

Ayyu's Blog - Wed, 2008-01-09 06:20
Categories: DBA Blogs

Introduction to Simple Oracle Auditing

Ayyappa Yelburgi - Wed, 2008-01-09 06:20
IntroductionThis article will introduce the reader to the basics of auditing an Oracle database. Oracle's RDBMS is a functionally rich product and there are a number of auditing alternatives available to the reader. Because auditing Oracle is such a huge subject, doing all of it justice would take an entire book, so this paper will cover the basics of why, when and how to conduct an audit. It ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com8

BEA mashup platform - Genesis

Rakesh Saha - Tue, 2008-01-08 17:43

Monitors in Server Manager

Mark Vakoc - Tue, 2008-01-08 17:42


Most of my posts thus far have been about installation, troubleshooting, and other server manager basics. Today begins a series of posts outlining the new or enhanced capabilities provided by SM.

Monitors are the mechanism by which administrators can be alerted through e-mail when an event of interest occurs. Much of this functionality is a direct carryover from that provided by the SAW SMC infrastructure in previous tools releases with some significant enhancements to boot.

As you may be aware by now Server Manager is a complete replacement for SAW and SMC. Among the other benefits, such as deployment and configuration management, we wanted to enhance and make easier to use the functionality provided by the SAW application.

While evaluating the SMC monitoring capabilities we identified the need to improve it in the following ways:

* Simplify the setup required to monitor servers and configure events of interest

* Enhance the monitored events to include some key items of interest, such as a user being unable to login to the E1 HTML Server

* Permit configuration of the hours in which alert e-mails should be sent for sites that make use of multiple administrators that are responsible for particular times of the week

* Maintain a history of past events and record the e-mail messages that were sent

We also changed the mechanism by which the events of interest are obtained. Beginning with 8.97 our server products contain an embedded variant of the management agent that provides server manager with the runtime information about the servers. Using this mechanism to obtain events provided two primary benefits: many of the events are reported to SM immediately upon occuring and events can be obtained from clustered or multi-JVM configurations for our web based products.

Currently monitoring is supported for our enterprise server and HTML server products only.

To get started select the monitors link from the quicklinks section. Note you must be signed into the management console as the jde_admin user or another user that as been granted the 'monitorConfig' permission to make changes to the monitoring configuration.

SMTP Configuration

The first step is to configure the SMTP mail server that will be used by server manager to send emails. Simply supply the mail server name, TCP/IP port to use, and sender email to use as the 'from' address. Some SMTP servers may require the sender email be from the same domain the mail server is configured to use. Note: SMTP servers that require authentication to send emails is not currently supported.

After making any changes you may supply an email address to test the settings. Server Manager will send an email to the supplied address to ensure the mail server configuration is correct.

Getting Started

The next step is to create a new monitor. You may have as many monitors as you wish. For example you may wish to create multiple monitors that listen for different events and each have different email recipients. Enter a name for the new monitor and select the 'Create' button. You will be redirected to a page used to configure the newly created monitor.

The first option in the general settings controls how often the monitor should poll for events. Some events will be detected immediately; when they occur a notification is sent to the management console and then to each running monitor. If this event is enabled for a particular monitor an email will be sent immediately. Other events are polled on a periodic basis. For example checking the free disk space on an enterprise server occurs on this period poll. You can change the frequency in which the monitor will check for these events.

Checking for monitored events is a low impact activity. That said if you have a large number of monitors it may be advisable to increase this interval from the default of 30 seconds.

Secondly you may configure whether this monitor should be automatically started when the management console application is started. Regardless of this selection an authorized user may start and stop monitors at any time using the previous page.

Instance Selection

The next step involves selecting the managed instances that this monitor should observe. Simply move the desired instances from the available options list to the selected options. Note that any changes made here on a running monitor will take effect immediately; the monitor need not be restarted.

Event Selection

Now that we have selected which managed instances we should monitor we now need to select which events we wish to observe. You do so by simply selecting the events of interest in the next section of the page. Each event has a help box next to it describing what the event is and when it may occur.

Some events may have threshold values that allow you to define a limit that, once reached, will trigger an email notification. The example below shows the limits for simultaneous users.

Once a threshold limit is reached on an enabled event a email notification will be sent. Notifications will not be resent unless the threshold goes higher. Consider the simultaneous users event. If we set the threshold to 50 we would receive a notification once 50 users are on at the same time. If two users sign off and two new users sign back on we are back at 50 simultaneous users. An email will not be sent; an email for 50 users has already been sent. If another user signs on, so we are at 51 sessions, and email will be sent; we have gone higher then the highest threshold reached.

I won't go into what all the events are in this post; they are documented with online help within the application.

Notification Hours

For a particular monitor you may specify which hours in the day and which days of the week email notifications should be sent. This may be helpful for those who administer in shifts. Those interested in events on weekdays may be different then those interested in weekend events, for example.

When you create a new monitor the default will be to enable notifications for all hours of all days. You can change this by modifying the times for each day using 24 hour notation. To disable events for an entire day simply set the start time and end time to both be 00:00.

The management console will use the clock and time zone information provided by the JVM on which it runs. That is the times should be considered to be the times as known to the management console machine.

Email Recipients

Finally we specify the email recipients that should receive notifications. You may add as many recipients as you wish. Any changes made to this list will take effect immediately; you need not restart the monitor.

Emails are sent individually to each recipient defined for a monitor using the from address configured previously. The subject and content of the email will contain details of the event. The mail format is plain text and is suitable for email, pager, and SMS mailboxes.

If an email could not be sent for any reason the failure will be recorded in the monitor's history, as discussed below.

Monitor History

Server Manager maintains a history for each monitor. Each start of a monitor will be listed in the monitor history.

You may view the history of a particular monitor to see all the events that occurred and the emails sent by clicking the appropriate icon in the grid row.

Each event that occurred will be listed along with the same type if information that was contained in the email sent. A grid will contain a listing for each email recipient of the monitor showing the successful sending of the email, an email that wasn't sent because it was outside the notification hours configured, or a email that failed to send for some reason such as an invalid recipient.

You may delete the monitor history if you no longer wish to view it. You may not delete the history for an actively running monitor.

Cloning Monitors

We have made it easy to clone an existing monitor. Simply select the corresponding icon in the 'Create Duplicate' column in the list of available monitors.

All the settings, selected managed instances, events, notification hours, and email recipients from the selected monitor will be copied to a new monitor definition. This makes setting up monitors for shifts much easier; the events and other setup need not be configured multiple times.


Hopefully you see that setting up and using monitors in Server Manager is much easier than previous solutions and the added events make administering your E1 servers much easier. Dig in, play with monitors, and enjoy.

UPDATE: I think the issue with missing images has been resolved.

10 Scripts Every DBA Should Have

Ayyu's Blog - Tue, 2008-01-08 06:06
Categories: DBA Blogs

10 Scripts Every DBA Should Have

Ayyappa Yelburgi - Tue, 2008-01-08 06:06
I. Display the Current Archivelog Status :ARCHIVE LOG LIST;II. Creating a Control File Trace FileALTER DATABASE BACKUP CONTROLFILE TO TRACE;III. Tablespace Free Extents and Free Spacecolumn Tablespace_Name format A20column Pct_Free format 999.99select Tablespace_Name,Max_Blocks,Count_Blocks,Sum_Free_Blocks,100*Sum_Free_Blocks/Sum_Alloc_Blocks AS Pct_Free from(select Tablespace_Name, SUM(Blocks) ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com6

Hail the Champions

Fadi Hasweh - Tue, 2008-01-08 01:55
I participate recently in a post from our famous Bolger OCP advisor, it a nice blog that help apps community with info. About Apps certification.
I am trying to be active again.
You can check his post here.

Good luck with your certification

Fix for Rails 2.0 on Oracle with database session store

Raimonds Simanovskis - Mon, 2008-01-07 16:00

As I started to explore Rails 2.0 I tried to migrate one application to Rails 2.0 which is using Oracle as a database. Here are some initial tips for Rails 2.0 on Oracle that I found out.

Oracle adapter is no more included in Rails 2.0 so you need to install it separately. It is also not yet placed on gems.rubyforge.org therefore you need to install it with:

sudo gem install activerecord-oracle-adapter --source http://gems.rubyonrails.org

The next issue that you will get is error message “select_rows is an abstract method”. You can find more information about it in this ticket. As suggested I fixed this issue with the following Oracle adapter patch that I call from anvironment.rb file:

module ActiveRecord
  module ConnectionAdapters
    class OracleAdapter
      def select_rows(sql, name = nil)
        result = select(sql, name)
        result.map{ |v| v.values}

And then I faced very strange behaviour that my Rails application was not working with database session store – no session data was saved. When I changed session store to cookies then everything worked fine.

When I continued investigation I found out that the issue was that for each new session new row was created in “sessions” table but no session data was saved in “data” column. As “data” column is text field which translates to CLOB data type in Oracle then it is not changed in Oracle adapter by INSERT or UPDATE statements but with special “write_lobs” after_save callback (this is done so because in Oracle there is limitation that literal constants in SQL statements cannot exceed 4000 characters and therefore such hack with after_save callback is necessary). And then I found that class CGI::Session::ActiveRecordStore::Session (which is responsible for database session store) does not have this write_lobs after_save filter. Why so?

As I understand now in Rails 2.0 ActiveRecord class definition sequence has changed – now at first CGI::Session::ActiveRecordStore::Session class is defined which inherits from ActiveRecord::Base and only afterwards OracleAdapter is loaded which adds write_lobs callback to ActiveRecord::Base but at this point it is not adding this callback to already defined Session class. As in Rails 1.2 OracleAdapter was loaded together with ActiveRecord and before Session class definition then there was no such issue.

So currently I solved this issue with simple patch in environment.rb file:

class CGI::Session::ActiveRecordStore::Session 
  after_save :write_lobs

Of course it would be nicer to force that OracleAdapter is loaded before CGI::Session::ActiveRecordStore::Session definition (when ActionPack is loaded). If somebody knows how to do that please write a comment :)

Categories: Development


Subscribe to Oracle FAQ aggregator