Feed aggregator

expdp of 9i database from 10g Oracle_Home

Vidya Bala - Tue, 2006-12-12 11:47
for some reason I thought I would be able to use expdp to export a 9i database using 10g expdp - obviously not supported as mentioned below.

Compatibility Matrix for Export & Import Between Different Oracle Versions
Doc ID:
Note:132904.1

Leaves me with the option of either using traditional "exp" can be very slow on a 100G+ database not sure if Cross Plaform Migration is an option with Standard Edition.
Categories: Development

Siebel Analytics

Vidya Bala - Mon, 2006-12-11 10:41
BI Suite Enterprise Edition Getting Started:

I have been spending the last few days setting up BI Reports using BI Suite Enterprise Edition as a proof of concept for Business users to evaluate the Product.

I have liked the Product so far,
(i) very user friendly
(ii)once the metadata layer is defined Business users are masked from underlying tables and relationships they don’t need to know about
(iii)A lot of sleek display features in the Product.
(iv)Skill Level not extremely difficult. If you have worked in the Database and BI world it should be fairly easy to learn how to use the Product.
(v) I will review a step by step evaluation of the Product once I have it installed in my system.

Details on the Product:

Key feature of the Product (mainly Siebel Analytics/Answers):

(i)Has a BI Server ; BI Web Console; BI Admin Client Tool
(ii)BI Server is not integrated with the 10g Application Server (it runs separately and is not a container in your Application Server like the way it was with Discoverer)
(iii)I believe there are claims that with 11G App Server the OEM Console can manage the BI Server as well.
(iv)When a request is sent to the webserver a Logical query is sent to the BI Server – The BI Server then checks if the data is in the Cache – if not in the cache a physical SQL is sent to the database.
(v)All metadata information is stored in flat files as opposed to any repository – so should be easy to move across environments – the metadata flat files also support multiuser capability.
(vi)Security Services available with your BI Server (VPD security)
(vii)BI Admin Tools – has pretty much 3 layers (a) the Physical Layer where datasources are defined; ODBC is used to define the datasources (b) the Business/ Mappings layer where you build your Business mappings and (c) Presentation Layer where define how your data needs to be presented.
(viii)The Webconsole has (a) Answers – this is what is used by your Business users to create Reports using data items available in your presentation layer. (b)Dashboard – is where Reports built using Answers can be published on your Dashboard (c)Admin – to manage user accounts , analytics catalog, dash board permissions etc (d) Delivers – can schedule jobs for web cache refreshes. Also Oracle XML Publisher is a part of the BI EE Suite

I am excited about having all our Reports moved to Siebel Analytics – I will have an end to end sneak preview of the Product posted on my blog soon.
Categories: Development

Coming back from Gartner's SOA Summit and heading out to Europe

Clemens Utschig - Fri, 2006-12-08 15:32
for the last days we have been at Gartner's SOA Summit, to show our new SOA Suite and discuss the latest trends on SOA and Integration.

Two sessions, of the many I attended, left me thinking on SOA and where we go from here.

Darrell Plummer, Gartner Analyst, held a How to workshop on creating SOA applications, which turned out great.. He fostered a broad discussion in the audience, on what methodologies to use, what a service really is - beyond WSDL, and so forth. A nice metric: out of 15 slides he wanted to show, he showed 5 :D (the rest of the time went into discussion)

and the Chief Architect of Eskom, talked about SOA and his experiences in South Africa - about a company, that adapted to agility, about key stakeholders, and the value of SOA. Overall - SOA is about humans - two thumbs up.

After being home for two days - I'll head to Europe today night (yes on LH 459, Kranich) - for JavaPolis, and to visit customers. Getting the chance to speak at JavaPolis 2006 is a great opportunity to evangelise on standards based SOA - and also that we got a slot for the university part.

Hugo Brand (from our EMEA PM team), Demed Lher (OEMS/ESB PM) and me will talk about Pragmatic SOA, and how you can build composite SOA applications today.

So if you are around, come by to get a 3 hour, intense, and interactive how to session - or just to say hello :D

AskTom website exception

Dong Jiang - Fri, 2006-12-08 05:17

This is the exception I got from AskTom website this morning, 6AM EST.
ORA-01688: unable to extend table ASK_TOM.WWC_ASK_ACTIVITY_LOG$ partition PART_12 by 64 in tablespace ASK_TOM_LOG

What can we tell from this?
1. Schema name is ASK_TOM
2. There’s a tablespace ASK_TOM_LOG
3. There’s a partitioned table WWC_ASK_ACTIVITY_LOG$. Partition PART_12 is in ASK_TOM_LOG tablespace.
4. Eh, time to call DBA?


GNUstep on my Solaris desktop

Siva Doe - Thu, 2006-12-07 19:40

After a couple of days work, I was able to run GNUstep on my Solaris (Nevada) box. Check out the screenshot. Boy, need I say, I like it a lot. Very snappy compared to the GNOME desktop (no flames please).

I also built some nice applications like GNUmail.app. I had set up to use the Menu interface to NSMacintoshInterfaceStyle. In the attached screenshot, you can see the Macintosh like menu.

I am also running Windowmaker as my window manager. In my startup script, I set the environment variable GTK2_RC_FILES=$HOME/.themes/GTK2-Step/gtk-2.0/gtkrc, which gives my other GTK apps like Firefox, Gaim to look very much like an GNUstep applicaiton.

I sure miss those days loong (may be one more 'o'?) time back, when we at Sun had an option to run OpenStep as an alternative desktop to CDE. Very slow it was though.

Some wishes though. More GNUstep apps, of course. Like a Web browser (Safari??), IM & Calendar clients. There is an IRC client though, which I dont use much anyway.

GNUMail.app/Addressbook lacks LDAP auto completion which I am so much used to.

I dont know how long can I continue using GNUstep, as for some reason or other I end up using the default JDS desktop only.

 

:-S

Oracle SOA Suite Patterns and Best Practices, Part 1 and 2

Clemens Utschig - Thu, 2006-12-07 16:50
While having this idea for a while now, it took considerable time to make it reality, first to allocate the necessary time, and maybe even more to get over the start of writing :D

The first 2 chapters are live and can be found here.

Chapter 1: Virtualizing your service endpoints in ESB and using them from BPEL
Chapter 2: Using the Service Registry to enable a dynamic, reusable SOA

- more to come soon

Jeff, Mr. B2B is on the way finishing his contribution on BPEL and B2B and how those two components can make trading simple and solid.

Also coming in the next time, migration, deployment concepts, and governance, all from the source.

We are also keen for your feedback, or if you like to contribute, jsut drop me a line with what you think helps the community most

It has not been an easy ride for us on Suse (SLES 8)

Vidya Bala - Thu, 2006-12-07 13:39
we have been on Oracle 9i SLES 8 for about 4 years now. And somehow or the other I always run into some issues on Suse - at times it makes me feel that we would have been better off with any other Linux flavor or Unix.

the issue this morning was:
we were trying to use the XML parser in the database
java OracleXML getXML -user "ccccc/ccccc" "select * from emp"
Exception in thread "main" java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path

CLASSPATH, LD_LIBRARY_PATH have all been set correctly.
I turned around ; added the jars on my Solaris box and ran the command ...........it worked.

so started looking at Suse Mailing Lists - and ofcourse a lot of people have been having problems with jdbc on suse- is there a bug fix? (well I dont know at this point - I have a tar opened).
Categories: Development

Things that had me surprised with 10G Standard Edition

Vidya Bala - Mon, 2006-12-04 15:09
Well we know that Standard edition is a marketing joke - but it is something we cannot avoid considering when we can save about 30K per cpu.

The following features not being supported by standard edition had me surprised(there are a lot more but this caught my attention)

1)Reorgs: Online index build, online table reorg/redef, online index coalesce. Global index maintenance during DDL
(some of the above we may overcome with third party LiveReorg Products)
2)Recovery: block level media recovery, Tablespace point in time recovery.
3)With 10g Std edition incremental backup and recovery is supported but not with 9i Std Edition - think of it which means you always have to do a full bkups.4)Indexes : Bitmap indexes are not supported while Function based indexes are supported in 10G Std edition.
Categories: Development

REGEXP_LIKE

Robert Vollman - Mon, 2006-12-04 13:57
Recently I invited anyone who has been considering joining the Oracle blogging community to jump right in. Please, help me encourage John H:Robert,Way cool blog. I really need to create one too. I like to adhere to best practices and love to read stuff from Tom K. and Steven F.!I have a question on regular expression check constraints and was wondering if you can help:alter table Robert Vollmanhttp://www.blogger.com/profile/08275044623767553681noreply@blogger.com2

Gartner Application Integration & Web Services Summit

Clemens Utschig - Fri, 2006-12-01 19:42
Over the next week a part of our team will head out to Gartner's AIWS Summit in Orlando - and we all look forward, as it is a great opportunity to meet other evangelists and customers to discuss the latest trends and stories around SOA, and Application Integration.

Dave Shaffer - Director of SOA Product Mgmt - and head of our group, Devesh Sharma - Mr. BPA, Jeff Hutchins - the mastermind of Oracle's B2B and me will be there. So if you are around, come by the booth to chat, see SOA Suite @ work or just for fun - to meet some of the faces behind Oracle's SOA strategy and offering.

For those who have not heart of it yet - visit http://www.gartner.com/2_events/conferences/apn17.jsp and hurry to register

c ya in orlando

Tips for using CVS with JDeveloper

Brenden Anstey - Thu, 2006-11-30 19:24
Versions
Server: Linux OS, CVS Version 1.11.1p1
Client: Windows XP, JDeveloper 10.1.3.1 using ADF BC / Faces
Other tools (non-mandatory but good to have), PuTTy, PAgent, PGen PSftp

Overview of the Setup Process
Create a generic user to own the CVS Repositry and a group which all the CVS users will belong. Create a user for each developer and add them to the same group.
To create a server repository as the generic user the command is:
cvs -d /oracle/cvs/CVSROOT init

JDeveloper uses a private public key pair and SSH2 (other protocols available) to connect to the CVS. The key pair is generated in JDeveloper and the public key has to be manually added to the users authorized_keys file in the .ssh directory within the users home directory. The CVSROOT is the root directory of the CVS repository which is created by the CVS owner mentioned above.

Key Points About Using JDeveloper with CVS
Using JDeveloper with a CVS will break dependencies within the project which are normally enforced by JDeveloper in single user mode. When updating your project from the CVS the dependencies between objects are not enforced resulting in objects becoming out of sync. For instance a standard ADF BC View Object may consist of two files, its XML definition and View implementation file. It will also be referenced by one or more Application Module(s) and possibly a Viewlink. To prevent missing references and broken dependencies all the referenced / referencing objects must be included when committing and updating the CVS.
Open and close the project if there are dependency errors that do not seem to be correct.
CVS does not implement locking, it is the developers responsibility to make sure that the files they wish to work on are up to date. If two developers have worked on a file simultaneously a merge will be required when synchronising the CVS.

How do I know if my source is up to date with the CVS?
The key to getting the CVS JDev integration working properly is using the Pending Changes window effectively. Within this window are three tabs, Outgoing, Incoming and Candidates. Outgoing contains changed items which are not up to date with the CVS. Incoming displays items are new or the local copy is out of date with the CVS. Candidates are files not yet checked in with the CVS. The most important tab in the Pending Changes window is the Incoming Tab. Watch this one with care as incoming changes are NOT reflected in the Application Navigator unlike other file statuses. New files are not shown in the Application Navigator because they are not in the project but may be referenced by existing objects updated from the CVS. Using the Incoming tab is key to keeping the project in sync.

Minimising Pain and Suffering with CVS
Develop your model first and view second. If the model is not complete before development of the user interface it is worth finalising it first. The reason being is that the user interface (JSP's, pageDef's and Databindings.cpx) are a lot easier to fix than the data model when the project gets out of date and or needs to be merged. Most people will do this anyway, but it not always the case that the model is completed first.
Commit all changes regularly and especially before leaving at the end of the day. In the morning check the Incoming tab and update as necessary.
Occasionally perform a full checkout of your project from the CVS. This will cause any synchronisation issues to come to the surface and recover any missing files from backup if necessary.
Have the Li/Unix administrator include the CVS in the server backups.

Project Files and the CVS
The project JPR files often report conflicts which cannot be resolved by merging or committing changes. Fortunately JDeveloper is smart enough to pick up any stray/new files and add them to the project. Close and open the project and if all files are present force an unchanged commit of the project JPR file.

Bugs and Annoyances
View link files are continually 'touched' when the AM is updated resulting in them being in changed status continually even though they are not out of date with the CVS. This also clutters the Outgoing tab which is a pain if some of them are legitimately updated.
JDeveloper occasionally hangs when performing some CVS actions from the navigator. CVS actions issued from the Pending Changes window seem to be more reliable.
Occasionally some files are not recognised as an Object (such as a VO) and are displayed as their individual files in the Application Navigator. If this happens close and reopen your project and the object will reappear and its supporting files will be attached.

Further Reading
Oracle® Application Development Framework Developer’s Guide For Forms/4GL Developers (chapter 32 Working Productively in Teams) This manual can be downloaded from otn.oracle.com

Oracle APEX Application Migration Workshop is now on OTN!

Donal Daly - Thu, 2006-11-30 17:10
While the road to release has not been as smooth as I would have liked (down to me in parts :-) ) , we have finally published the early adopter version on OTN.

We very much welcome your feedback on it. Our plans is to have this as a standard feature of Oracle APEX 3.0, so you have the chance of your feedback making a difference in the final product in a short timeframe. I look forward to receving your feedback and making the product better because of it.

You will find more details about it here.

Enjoy, Donal

du and ls report very different file sizes for Oracle Tempfiles on NFS v3 mounted volume on NetApp filer under Solaris 9

Stephen Booth - Thu, 2006-11-30 10:03
We have a NetApp FAS filer attached via Gigabit Ethernet to a Sun V440 running Oracle databases the files for which are stored on the filer The NetApp volume is mounted under NFS version 3 at $ORACLE_BASE/oradata. Under that directory are 7 directories .snapshot, dctm, dchr, dctm_backup, dchr_backup, dctm_nobackup, dchr_nobackup. .snapshot is where the NetApp filer stores snapshots of the Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com1

Develop with Oracle Fusion Middleware and win a trip to Oracle HQ

Clemens Utschig - Wed, 2006-11-29 23:32
Today - while looking for information on the OTN I fell over the below invitation ..

The Oracle Fusion Middleware Developer Challenge is looking for submissions in three exciting technology areas:
  • SOA-based applications or Web services

  • Web 2.0/Ajax-based user interfaces or mashups

  • Java-based applications demonstrating the combined use of Oracle and Open Source software
.. which can be found in full here.

Naturally we, all Oracle employees are excluded - so it's your term. Develop the coolest application on Oracle's new Fusion Middleware and win a trip to our Headquarters in Redwood Shores, California.

Oracle Open World 2006 slides and two new articles

Clemens Utschig - Wed, 2006-11-29 18:17
After being quiet for quite a while now, I thought to publish some information from my open world sessions and links to two of my (joint) articles that were recently published.

My slides about Advanced BPEL topics, including Compensation, Transactions, and WSIF can be found here.

Matt Shannon from the Content DB team and me teamed up to demo the integration between Content DB and Oracle BPEL PM, which currently evolves into a sample - slides are here

Also the introduction during Oracle XTreme that me and my whole team gave - on using all the components together to create a composite application is online - and to be found here

Attention: you need to login with cboracle/oraclec6

Also two recent articles were published, ..

One on Data Services in the Java Developers Journal, where Doug Clarke from Toplink PM team and me paired up, to write about "Accessing data in the Service Oriented World" is here.

The second one, where Jesus from TwoConnect, Heidi Buelow- one of my fellows on our team and I teamed up - to demonstrate "WSI with BPEL and WCF in the real world". It can be found here.

Also, to keep my fellow readers informed, I just started off with my best practice series on the SOA Suite, which explores patterns and best practices when using the components - more on this soon.

Design Goals for the Oracle APEX Application Migration Workshop

Donal Daly - Wed, 2006-11-29 10:18
We are in the home stretch now, to make the early adopter version of the Oracle APEX Application Migration Workshop available on OTN. We have released some more information about it on OTN and have created a new OTN forum to host discussions about migration from Microsoft Access to Oracle Application Express.

I thought it would be an opportune time, to outline some of our design goals behind this development. Firstly, we want to promote Database Refactoring, once you have gotten your schema and data migrated using the Oracle Migration Workbench. The better your Data Model is, the easier it will be to create good Oracle APEX applications. Currently we identify tables without primary or foreign keys and also promote the usage of UI defaults, a feature of Oracle APEX. We hope to expand on this in the future, based on feedback. A possibility could be to identify tables that could be leveraged as List of Values (LOV's) or try to identify incorrect usage of data types, e.g. dates being stored as varchar.

Our approach is one of Design Recovery. We want to provide as much information about the original Access Application that we could recover from the Access mdb file. We have taken a workshop approach, to provide the developer a productive environment to decide what Access objects they are interested in and should be in scope. You deal with any errors reported, so additional objects can also be included. By default all Access objects which we analyze and determine are valid are included in the scope your migration project by default.

Our goal is to only generate a native Oracle APEX application. We are not interested in emulating unique Access functionality. Access Applications could be classed as "rich client" applications whereas Oracle APEX applications are Web (Browser) based. It's a different UI paradigm, and this needs to be respected if you are to create, intuitive and useful applications. We don't migrate any VBA code, but we will show you the VBA code contained in your modules. You could then determine if this logic is still necessary and if so, could be reimplemented as PL/SQL procedures/functions.

We can generate either an application based on selected Access Forms or Reports or generate a maintenance style application which is a Report and a Form on each selected Tables and Views.
Our application generation leverages the Application Model behind the create application wizard.

I am looking forward to feedback on this new feature of Oracle APEX. I believe we have built a good foundation, to address additional feature requests we might receive. With input from the community we can ensure that the Application Migration Workshop increases the productivity of developers who seek to migrate Access applications to Oracle APEX, when it becomes a standard feature of Oracle APEX 3.0

Now back to the last round of testing...

Raise a Business Event from your OAF Page

Andries Hanekom - Tue, 2006-11-28 01:58

After quite a while of inactivity, due partly to a frantic schedule and the addition of a new obsession in the form of my new mountain bike, I am back on the horse and very excited to start blogging again. A Big thanks to Steven Chan for profiling the Oracle EBD Developer on his blog, just the kick I needed to get going again.

I recently had the opportunity to present the 11i/2.6 Implement Oracle Workflow course at Oracle South Africa, which turned me onto business events in a big way. Now I have previously blogged about launching an Oracle Workflow process from an OAF page using the oracle.apps.fnd.framework.webui.OANavigation class. In this post I would like to demonstrate how we can raise a business event through the Oracle Business Event System (OBES), which enables you to utilize the extensive functionality of the OBES to launch workflow processes and perform a number of diverse actions.

import oracle.apps.fnd.wf.bes.BusinessEvent;
import oracle.apps.fnd.wf.bes.BusinessEventException;
....
...
..
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processFormRequest(pageContext, webBean);

if (pageContext.getParameter("Submit") != null)
{
// Get Transaction
OAApplicationModule am = pageContext.getApplicationModule(webBean);
OADBTransactionImpl oadbTrx = (OADBTransactionImpl) am.getOADBTransaction();

// Create BE Object
String eventName = "companyabc.oracle.apps.xx.event.createrequest";
String eventKey = "1001-1";

BusinessEvent busEvent = new BusinessEvent(eventName, eventKey);

try
{
// Set Event Property
busEvent.setStringProperty("XX_TRX_TYPE", "NEW_REQUEST");

// Raise Event
busEvent.raise(oadbTrx.getAppsContext().getJDBCConnection());
}
catch (BusinessEventException exception)
{
// Set Message Tokens
MessageToken[] tokens =
{ new MessageToken("EVENT_EXCEPTION",
exception.toString())
};

OAException eventErrorMessage = new OAException("XX",
"XX_RAISE_EVENT_ERROR", tokens);

oadbTrx.rollback();
....
...
..
}

oadbTrx.commit();
....
...
..
}
}
}

recover database until cancel and online redo's

Vidya Bala - Mon, 2006-11-27 06:41
on a noarchivelog mode database, recover database until cancel will still prompt for archive logs.
This had me puzzled initially until I looked at the sequence number and realized, the sequence number corresponds to the online redolog (although the recovery command prompted for an archive log). When prompted if the appropriate online redolog is entered the Incomplete recovery will succeed.
Categories: Development

How people find this blog

Stephen Booth - Thu, 2006-11-23 02:38
I was just looking at my stat counter analysis for this blog, it's usually a good way to find out if anyone has linked to me. From the results it looks like the vast majority of people (around 97%) find this blog through a search engine, virtually all (over 99%) through Google. Most common search strings are or include "ORA-07445", "opmnctl failed to start process" and "ORA-01031".Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com0

10g Release 3 Forms and Report Services?

Vidya Bala - Wed, 2006-11-22 14:11
while helping a colleague of mine install Forms and Reports Services , I realized that 10g Release 3 although available for download , the Forms and Reports Services component is not available for 10g Release 3 yet (only if I missed something). I was wondering if there was any talk on an ETA for Forms and Reports Services on 10g release 3.
Categories: Development

Pages

Subscribe to Oracle FAQ aggregator