Monthly Archives: July 2010

How to create a new Domain in Oracle service bus 10g R3.

Posted on July 31, 2010 by Udaya

Once after we install Oracle Service Bus 10.3, we need to create a new domain using the Configuration Wizard in order to access the OSB console screen. You can invoke the Configuration Wizard in the graphical mode or console mode. … Continue reading →

Posted in Oracle Service Bus (OSB) | Tagged configuration, creation, Domain, graphical, mode, Oracle, Oracle Service Bus (OSB), wizard | 5 Comments

Error while using “Routing Table” option in Proxy Service in OSB

Posted on July 30, 2010 by Udaya

Hi, I have created Business and Proxy services in my OSB console. I have used “Custom Query” option while creating the Database Adapter and I’m passing one input parameter to the query. My input parameter is “Name“. Based on the … Continue reading →

Posted in Oracle Service Bus (OSB) | Tagged message, Oracle Service Bus (OSB), processing, Proxy Service, replace, Unknown. Invocation | Leave a comment

Unable to find “NormalLoanApprovalService.wsdl” OSB tutorial file in OSB installation folder.

Posted on July 30, 2010 by Udaya

Hi, I have installed OSB 10.3.0, I’m new to OSB and want to learn its features by practicing the OSB examples and tutorials. When I started OSB tutorial, in one of the step says I need to use the “NormalLoanApprovalService.wsdl” … Continue reading →

Posted in Oracle Service Bus (OSB) | Tagged BEA_HOME, Examples, Insatllation, Oracle Service Bus (OSB), Samples, Tutorial, WSDL | 2 Comments

“Domain edit lock” error while publishing OSB project in Workshop

Posted on July 28, 2010 by Udaya

I’m using web logic server 10.3.0. I have started the server. I have created a OSB project in workshop. I created a Server connection in the workshop. When I tried to publish my OSB project in workshop, suddenly a pop … Continue reading →

Posted in Oracle Service Bus (OSB) | Tagged Access, Domain, Edit, Edit Lock, Lock, Oracle Service Bus (OSB), Publish, Server, Session, Weblogic, Workshop | 6 Comments

Error “requested array is larger than heap” in Weblogic Workshop while deploying into OSB.

Posted on July 28, 2010 by Udaya

I’m using Web logic Server 10.3.0. I have created a OSB application (Schema, WSDL, Business and Proxy service files) in Web logic Workshop. In workshop, I have created a Server connection to Web logic server. When I tried to Publish the … Continue reading →

Posted in Oracle Service Bus (OSB) | Tagged array, Error, Heap, Oracle Service Bus (OSB), requested, Server, Web logic | 2 Comments

How to pass parameters to IN clause in SQL query in DB adapter.

Posted on July 20, 2010 by Udaya

When you execute a syntactically correct SQL query having IN clause from SQL prompt, it will work as expected. If You type and execute the below query at SQL prompt and it returns the data as expected. SELECT EMP_ID, EMP_DEPT, EMP_SALARY, … Continue reading →

Posted in BPEL, Oracle Service Bus (OSB) | Tagged Clause, DB Adapter, IN, Oracle Service Bus (OSB), Query, SQL | 4 Comments

What is PATH, Classpath and how to set them.

Posted on July 19, 2010 by Udaya

Path: In command prompt or Environment variables PATH is used to register the executable files. Classpath: The Classpath is an argument – set either on the command-line, or through an environment variable – that tells the Java Virtual Machine where to look for user-defined classes and packages … Continue reading →

Posted in Java | Tagged Classpath, PATH, set | Leave a comment

Installation steps for Oracle Service Bus 10.3.1.0

Posted on July 16, 2010 by Udaya

To install Oracle service Bus 10.3.1.0, please follow below steps – 1 ) Execute the program “osb1031_wls1031_win32.exe” to start the installation process. This will open up the following wizardClick “Next” to start the installation. 2) Create a new BEA Home … Continue reading →

Posted in Oracle Service Bus (OSB) | Tagged Installation, Oracle Service Bus, Oracle Service Bus (OSB), Steps | 1 Comment

How to check the progress of created Job Scheduler objects in Oracle database.

Posted on July 12, 2010 by Udaya

The Progress of these Objects within the database can be verified by using the following Queries. –To view Scheduler database objects SELECT owner ,object_type ,object_name ,created ,status FROM dba_objects WHERE object_type IN (‘PROGRAM’, ‘JOB’, ‘JOB CLASS’, ‘SCHEDULE’, ‘WINDOW’) ORDER BY … Continue reading →

Posted in Oracle Database | Tagged Database, job, objects, Oracle, scheduler | 1 Comment

How to schedule a job in Oracle database.

Posted on July 9, 2010 by Udaya

For scheduling any Action in the database we need to create the following tasks Create Scheduling Object Create Program Object Create Job Object Let us go in detail about each task Creating Scheduling Object The schedule determines the time interval … Continue reading →

Posted in Oracle Database | 2 Comments