OraNA :: Oracle News Aggregator

OBIEE Migrating Oracle BI Discoverer to OBIEE

John Minkjan — Fri, 08 Aug 2008 15:53:31 -0500

OBIEE can convert your discoverer EEX files to OBIEE .RPD files. The manual for this can be found on your OBIEE 10.3.4.0 server in ..\OracleBI\server\Document\DiscovererMetadataConversionAssistant.pdf. I did some prelimanary testing with and it seems to work just fine.

Till Next Time

Upgrade 11i/9i vision to 11i/11g

Vikram Das — Fri, 08 Aug 2008 15:58:31 -0500

I am currently doing a test upgrade of a freshly installed 11i vision instance with database 9.2.0.6 to database version 11.1.0.6. Till now I have achieved the following:

Install Oracle Enterprise Linux 5
Install pre-requisite patches for 11.5.10.2 on OEL5
Install E-Business Suite 11.5.10.2 Vision instance
Apply pre-requisite patch ATG_PF.H RUP6
Install 11g software

I am proceeding with the upgrade now.

I'll update this post with more details about this activity.

Six Weeks Till Open World…

bex — Fri, 08 Aug 2008 14:38:27 -0500

Just six weeks until Oracle Open World 2006. I anticipate chaos. Fun and learning, yes, but also chaos...

I used their online schedule builder to sift through the 1700 sessions they were offering, and built a personal calendar... from a usability perspective the schedule builder is very much sub-par, but its vastly better than what they offered last year... I'm mainly focusing on the ECM track, plus a bit about Portals, Mashups, and a little bit of the WebCenter stuff.

I'm giving four talks this year, two in the general sessions, and two at the associated Open World Unconference... for those who aren't aware, an unconference is the technology equivalent of "open mic" night. Here's my schedule:

Monday 1pm-2pm: Enterprise 2.0, What it is and How You'll Fail, at Moscone West, 3rd Floor Overlooks #1
Monday 4pm-5pm: A Pragmatic Approach to Oracle ECM, at Moscone South, Rm 301, session 299246.
Wednesday 11am-12pm: Communication For Geeks -- How to influence your peers, your boss, and your clients, at Moscone West, 3rd Floor Overlooks #2
Thursday 10:30am-11:30am: Top 10 Ways To Integrate With Oracle ECM, at the Marriott, Golden Gate room C1, session 300043.

The first talk is essentially what I gave last week at the Enterprise 2.0 kickoff. The second one is mostly based on my upcoming book. The third is a repeat of the talk I gave at the MinneBar Unconference a few months back. The last one is a new twist on my "50 Ways to Integrate With UCM" talk.

Besides the sessions, there are also a handful of places to just "hang out," recharge your laptops, and escape the bustle:

OTN Lounge: Moscone West, Floor 3 , near the Unconference.
Fusion Middleware Lounge: in the Yerba Buena Foyer at the Marriott Hotel (north of Moscone North).
Exhibition Hall Demo Grounds: usually at the back of the hall, filled with folks who know their stuff, and ask interesting questions.

Even tho Twitter ticked me off big time a while back, I'll probably be using it at this conference to keep track of folks, and let folks find me. Follow me on either Twitter or FriendFeed if you want to meet up at Open World.

Automatic Storage Manager (ASM) Enhancements in 11g…

Tim... — Fri, 08 Aug 2008 15:12:49 -0500

More OCP revision notes. This time an overview of ASM enhancements…

Automatic Storage Manager (ASM) Enhancements in Oracle Database 11g Release 1

Cheers

Tim…

DBD::Oracle 1.22 Released

John Scoles — Fri, 08 Aug 2008 14:47:11 -0500

The latest release of DBD::Oracle is now ready and can be found at: CPAN DBD::Oracle. It is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles, under the auspices of The Pythian Group as open source/free software.

This release is largely a maintenance release that fixes a number of bugs (new and old) and cleans up the POD. I have also spent a good deal of time cleaning up the tests, compile warnings, and the Makefile.PL. A thank-you goes out to Martin Evans and H. Merijn Brand for their help on that.

As for new items, the ORA_VERBOSE attribute was added so that you can debug/trace DBD::Oracle without seeing any DBI debug/trace output. OCILobGetLength was added to the LOB functions, thanks to Milo van der Leij, I have also dropped support for Oracle 8 and earlier clients; see the POD for details on this.

Finally, I have also cleaned up and expanded how persistent LOBs work. A thank-you to Eric Simon for his work on this.

The release has been fully tested with version (1.601) of DBI. Below is the list of the changes and/or fixes in this release.

(more…)

These icons link to social bookmarking sites where readers can share and discover new web pages.

Ask the Experts - 14

Nitin Pai — Fri, 08 Aug 2008 15:01:57 -0500

my problem is on sqr. i don't know how to test dynamic where clause in sqr. can you please help me

Thanks for posting your question!

Dynamic where clause is tested by the below steps-

1. Assign all the dynamic Where Clause Criteria’s to a Variable $var

2. Verify the variable value by using SHOW Command

3. Finally call the procedure to execute BEGIN-SQL/BEGIN_SELECT command by using Square Brackets to variable like this [$var]

Thanks

Kannappan K.

Actually I already created the CI but the problem is I don’t have idea to insert multiple rows in a child record (scroll Leve).

What ever I have created that is working fine to add one row in parent level and Child level.
From people books I came to know that we can insert child rows by using insertitem() function but dont know how to use this? in above example for first three rows 'bunit' will go to Zero level and remaining values goes to scroll level.

Can you please explain me how to put this locgic in CI?

Rama

Thanks for posting your question!

Rama, you do not have to put that logic exclusively in CI. Open any peoplecode event and then drag and drop your CI in that event. It will generate the code automatically for you to create, and save the CI.

Thanks,
Sachin

How to find the DNS domain name of your server

Vikram Das — Fri, 08 Aug 2008 15:29:40 -0500

There is a command called domainname in Unix. However, the 'domainname' command returns the NIS domain name. This is unrelated to the DNS domain, although you could set them to be the
same. Unfortunately, there's no general way to obtain the DNS domain. Parsing the 'domain' line from /etc/resolv.conf is probably the best way. If the local hostname is fully-qualified, you could split it at the first dot to obtain the hostname. If it isn't, you could qualify it with a DNS lookup first.

awk '$1=="domain" {print $2}' /etc/resolv.conf

EclipseLink 1.0 Released

Doug — Wed, 09 Jul 2008 14:34:57 -0500

The Eclipse Persistence Services project (EclipseLink) has completed its incubation phase and the 1.0 release is available for download. This release completes the transition of the persistence functionality developed in Oracle TopLink to being fully developed and maintained as an open source project at Eclipse. This also signifies the first release of a project under the recently created top-level Runtime (RT) project at Eclipse.

EclipseLink delivers persistence services for efficiently working with Java and relational, XML, and non-relational data sources. The highlights include:

· Compact: Standard Java distribution is composed of a single implementation jar and utility jars that can be used in any Java SE, IDE, or Java EE hosted environment.

· OSGi: EclipseLink is also available as a set of OSGi bundles. This distribution offers out of the box support for compliant OSGi implementations, as well as Equinox-specific extensions.

· JPA: Superior Java Persistence API 1.0 implementation with many advanced features offering greater flexibility and performance for mapping, caching, querying and transaction processing.

· MOXy: Object-XML binding support with JAXB, offering highly flexible mappings as well as a meet in the middle configuration approach.

· SDO: Service Data Objects 2.1 implementation enabling flexible service integration with dynamic and static models.

· Utils: Migration utilities to assist developers currently using Oracle TopLink or TopLink Essentials in their upgrade to EclipseLink as well as the workbench for compatibility with classic object-relational and object-XML mapping.

A complete index of features and the full user documentation for EclipseLink is available on the Eclipse wiki.

Standards Focused

The mandate of the EclipseLink project is to deliver a set of persistence services that leverage the leading Java standards. In addition, advanced features were added based on user requests but implemented in a way that allows developers to leverage them when needed but not be obstructed by them when they are not needed.

This is particularly true in JPA, where many advanced features are available through JPA persistence unit properties and query hints, in addition to custom annotations and XML. With EclipseLink replacing TopLink Essentials as the reference implementation for JPA 2.0, some of these advanced features will evolve into the specification defined metadata and interfaces. This approach of leading through delivery of advanced functionality, and then contributing back to the standards, is an important aspect of the EclipseLink project.

Growing The Community

The EclipseLink committers understand very well that developing in open source is much more than just providing access to the source code. Building a successful open source project is really about building an active community based on open communication and a transparent development process. We encourage the Java community to try out the 1.0 EclipseLink release and provide feedback. Your contributions and suggestions are valuable to us and will help ensure the project meets your current and future needs.

EclipseLink is currently available directly from the EclipseLink project web site and is also included within the GlassFish and Spring Framework distributions. Going forward, the Oracle TopLink product releases within the Oracle WebLogic Server will also include EclipseLink as its strategic persistence provider.

At present the project has committers from Oracle and Sun but we also have a growing community of users and developers contributing back enhancements. We are eager to expand this community on all fronts to establish the EclipseLink project as the leading persistence solution across Java EE, Java SE, and OSGi.

Openworld Blog Features OCP Blog on “Around The World”

noreply@blogger.com (Your OCP Advisor) — Fri, 08 Aug 2008 15:00:44 -0500

Oracle Openworld Blog featured the OCP blog on it's blog post entitled "Around The World"
It's never too early to start planning your Oracle OpenWorld agenda. So read the blog post above to see what sessions and events people from around the world are talking about this week.

Oracle Application Express and Oracle MetaLink

Joel R. Kallman — Fri, 08 Aug 2008 14:43:49 -0500

When customers have questions about the scalability of Oracle Application Express or Oracle’s commitment to Application Express, the use of Application Express in Oracle MetaLink is often cited by other customers.

Recently, an e-mail from the Oracle MetaLink team went out to MetaLink users, inviting them to try out the new Oracle MetaLink and get their feedback. The new MetaLink is not written with Oracle Application Express, prompting some customers to write an e-mail to me and ask me what’s going on. There was also a recent discussion on one of the ODTUG mailing lists about this very topic. Here are some statements which will undoubtedly be inferred from this change:

Oracle is no longer committed to Oracle Application Express
Oracle Application Express couldn’t handled the scalability needs of Oracle MetaLink

Let me say that both of these statements are false.

Oracle acquired many companies and products over the past few years. Included in these acquisitions was software to help manage the customer relationship. This really became a business decision of either continuing to maintain and extend custom-written software in Oracle Application Express and PL/SQL, or use the off-the-shelf software that Oracle sells. As Tom Kyte often references the “Buy versus Build” decision, this one was even simpler – “Buy versus Own”.

That’s the decision in a nutshell. Anything else inferred from this change would be factually incorrect.

Oracle Openworld 2008 APEX Update

noreply@blogger.com (David Peake) — Fri, 08 Aug 2008 12:48:00 -0500

Only six weeks until San Francisco gets a distinctive red coating!

I have just finished updating the APEX Schedule with the last of the Oracle Mix sessions and updating the remaining seats. There is only Anton Nielsen's session that hasn't come up in the Schedule Builder or Content Builder yet.

It even includes full descriptions and other useful information by viewing the full record.

For all of those attending - please go through the Schedule Builder and sign up for the sessions you are interested in. Many of them are filling fast and you will be turned away if you have not registered and the room is fully booked.

There are a number of sessions being held in Moscone West and South which are often larger rooms but it is just as important to register your support for those speakers.

Action Item for Speakers:
I can not determine the Room Capacity for many of the rooms but Speakers should be able to for their own sessions. Could each of you go through the same link you used to accept your invitation as a speaker Content URL and click on Content Management in the left navigation bar. Click on My Sessions and then click on the title for your session. Across the top you will see a tab Session Schedule and on this page it will list the Set Capacity. This is the number I need (not the Actual Capacity). Once all the hard work is done it is a simple matter of sending me an email or replying to this post with your Room (e.g. Salon 03, Marriot) and the Set Capacity.

Look forward to catching up with many of you there!

David

Happy Birthday Singapore!!

Sanjit Anand — Fri, 08 Aug 2008 12:57:56 -0500

Today is special day in this island, so here is my wish. Happy 43th Birthday Singapore…. May country grows higher and happier…

Top 18 EBS UI : Provides all users with a highly productive interface

Sanjit Anand — Fri, 08 Aug 2008 12:35:56 -0500

Oracle’s EBS delivers a user interface that was designed to increase the productivity of all users. Here are the compiled list of some of the features that user experiences such rich UI functionality who moved from SAP to Oracle Apps. Folders for screen layout in which you can change Prompts, Field Orders, Size etc. Refer this [...]

Oracle Applications FND Useful Tables

shivmohan purohit — Fri, 08 Aug 2008 12:25:41 -0500

Hello Friends , here is some of quite commonly used AOL FND ( Foundation) tables and their usage. There are many other tables also in FND but here i am putting only few commonly used tables. for other table if needed we can dig furthur. Let go through below article and let me know if [...]

Log Buffer #109: A Carnival of the Vanities for DBAs

David Edwards — Fri, 08 Aug 2008 12:00:11 -0500

It’s time again for another edition of the weekly review of database blogs, Log Buffer. Since it was a big week for SQL Server, let’s start there, shall we?

The big news — SQL Server 2008 is released, as reported by SqlServer-qa.net, in seven different versions. Aaron Bertrand introduces a new kid on the block: SQL Server 2008 Web Edition — “. . . designed for highly available Internet facing web serving environments for the next generation Windows Server,” according to MS. (I’ve heard it rains quite a lot in Seattle. I guess it also drizzles, too.) Says Aaron, “Basically, it has higher scalability than Express or Workgroup Editions : it supports up to 4 CPUs, no artificial limit on RAM, and unlimited database size.”

(Before you crack open your server case, Tara Kizer on Ramblings of a DBA has some advice on how to get physical CPU count on a server.)

The SQL Server Express Express blog helpfully offers a table outlining the differences in the features of the differences between SQL Server 2008 Express editions.

A couple little issues with the release have already emerged. Here’s Euan Garden on SQL Server 2008 Installation Confusion, VS 2008 Sp1 and NetFx 3.5 Sp1: “SQL Server 2008 has dependencies on (and includes) VS 2008 SP1 and its components (BIDS is just VS 2008, SSMS uses components), plus NetFx 3.5sp1. SQL includes the RTM versions of both of these, HOWEVER they are not broadly released yet. There is a check in SQL Server Setup that if you have an old version (Beta, RC, whatever) it will bounce the install and ask you to upgrade to the RTM bits…which of course are not yet available independent of SQL.” Click through for the KB and some other help. Denis Gobo and his readers have some more to say about this.

In all this change, you may lose sight of an important fact or two, and you may ask yourself, how did I get here . . . what version of SQL Server am I running? A couple resources are shared by Kevin Kline.

(more…)

These icons link to social bookmarking sites where readers can share and discover new web pages.

MS Live Mesh Overview

(author unknown) — Fri, 08 Aug 2008 07:19:35 -0500

LewisC's An Expert's Guide To Oracle Technology

You might not think of remote desktop as a cloud tool but MS has added cloud storage to remote desktop and called it Live Mesh. I have been using it recently and it is pretty nice. I use VNC fairly extensively and, when I'm not using VNC, I tend to use <a hr

OBIEE cusstomising your PCXML

John Minkjan — Fri, 08 Aug 2008 10:09:08 -0500

Altough NOT supported by Oracle you can do a lot of customizing of your PCXML files. These file control the appearance of your Charts and craphs in OBIEE.

Some documentation can be found on your OBIEE server: ..\OracleBI\corda50\docs\graph_reference\graph_reference.pdf

Till Next Time

Pah-tay-toe, Pah-tah-toe

Karen — Fri, 08 Aug 2008 08:00:16 -0500

After a brief hiatus, I figured I'd better blog a little something to let everyone know I was still out here. So, here you go...

I was reading something recently that caught my fancy in that "this is weird and kinda funny" way. It went something like this:

If deer meat is called venison and cow meat is called steak, why is chicken just called chicken?

How did the chicken miss out? Somehow if I went to a nice restaurant and the menu offered me Prime Cut of Cow instead of NY Strip, I don't think I'd find it quite so appealing. But, when I see Grilled Chicken on the menu, I'm completely fine with that. Hmmmm....

Hopefully next week I'll have something more interesting to say, but for now, I'll leave you to ponder. :)

Interesting thought…

Thomas Kyte — Fri, 08 Aug 2008 08:16:14 -0500

I read this yesterday...

Got me thinking about Q&A sites...

I believe the author there has something - if you introduce a barrier to entry, it will have it so that only those that really want in - are in. I don't know that metafilter is better/worse/same as reddit and digg - I do know that I used to follow digg, then it became a "not as good place" for me. I follow reddit - but it is becoming very much the same. I've never used metafilter (on my todo list now) so cannot compare it. But the *idea* proposed, the concept - it does seem to have merit.

It would be neat to know if this has ever been studied before - does anyone know? Thoughts?

Annonce : Oracle IT Service Management Suite

Jean-Philippe Pinte — Fri, 08 Aug 2008 04:07:40 -0500

Oracle IT Service Management Suite, combination des solutions Oracle Enterprise Manager et Siebel Service Desk, a reçu la certification V2 pour ITIL de la part de Pink Elephant.
En détail, cela signifie que la suite couvre 6 des 7 processes : Incident, Problem, Change, Configuration, Release et Service Level Management