Feed aggregator

DBClarity Developer Beta 2 is Now Out

Sue Harper - Mon, 2012-02-13 06:46
What a funny old world this is, the more things change, the more they stay the same..., more of that thought another day.  What I can tell you is that Tristan's webinar introducing DBClarity Developer is now available to listen to and watch. This is just over 30 minutes and should show you where DBClarity Developer fits into the scheme of things - specially if you're still thinking it's another SQL Developer or TOAD tool.  Go on try it.
For a tool new to this market, it's interesting to see which companies are looking at DBClarity Developer and why they are - the story is the same - They have loads of developers, building ad hoc reporting queries and they want them to be efficient.  (that's both the developers writing the queries and the queries themselves!)  Now we know we can't all be SQL gurus, so if we can use a tool to produce more efficient SQL Queries then why not? So if you have 100s of developers writing ad hoc SQL reports, have a look at DBClarity Developer.  Today is as good as day as any as we have just released DBClarity Developer Beta 2!

I've spent the last few days recording more demo videos and will publish a few of those in the next few weeks.

So What's Different Then? Are you a PL/SQL Developer?

Sue Harper - Mon, 2012-02-13 06:46
Microgen's tools are new to me, and having worked with Oracle for so many years, I need to see where they fit in and why they may be of interest to you. I'm going to do another video to show you more "How To..." bits, but I thought the screenshot on our website might go a long way to helping you understand. The graphic on the left hand side is what you build, the code on the right hand side is what the product produces. I think it's really neat.  The main idea is that business end of the procedure can be discussed with a business user.

Take a look at Tristan's blog entry today, where he talks about just that "Why Microgen DBClarity Developer?" He's the product manager and has worked with customers and the products for some years.

There is a Free Download of DBClarity Developer (Beta), if you'd like to try it out.

Microgen DBClarity Developer: Getting Started

Sue Harper - Mon, 2012-02-13 06:46
"Microgen DBClarity Developer enables the graphical definition and implementation of SQL queries and procedures” http://www.microgen.com/dbclarity/

What does that mean? Sometimes it’s difficult to get passed the marketing as you try to develop a real understanding of what a product can do for you. In the case of DBClarity Developer, what do I mean by a “graphical design” when it comes to writing SQL code? Lots of database-related products allow you to create SQL queries using a drag-and-drop approach, so what’s new here? Well, before I get into all that, you should take a look at the product.

It’s always been a bit of a challenge for me to tell the story of a product in 5 minutes! I tend to be overenthusiastic while I attempt to show users every available feature. That may be fine if you’ve used the product in question before, as this approach can help to fill in the gaps, but if you’re new to a product, it’s overwhelming at best. With this in mind, I’ve created a short video (Posted on YouTube) to walk you through the first few minutes of working with DBClarity Developer.
The video is specifically a “Getting Started” demonstration and is designed to help you get up and running, once you have downloaded and installed the product. You can see the various examples we have provided with the product, there is a brief product tour and I show you how to create a database connection and review the SQL queries we have provided. I also show you how to build the tables and set up the demo environment associated with the tutorials. Once you have watched the video, you can start creating your own queries or watch the video on how to create your first query, which you can find on the DBClarity Developer website. http://www.microgen.com/dbclarity/

Updates, News and Beta Software

Sue Harper - Mon, 2012-02-13 06:46
Those of you who follow my blog, know that I write from time to time. I started blogging back in the day when I was working on modeling and the SQL support offered in Oracle JDeveloper and then in 2006, started this blog with the launch of Oracle SQL Developer and then later to SQL Developer Data Modeler. Recently my blogging dropped right off because, after 19 years at Oracle, I decided to “hang up my boots” and try something new. Although taking photos in Cornwall really appeals, it seems that when we decide to start fresh, perhaps we don’t venture too far from where we’ve been before- well, it is true for me.


After a restful, technology–free 2 month break, I started in a new position at Microgen, a company based in the City of London. (I can see St Paul’s Cathedral from the window!) I’m in the Microgen Aptitude Solutions Division; so still in technology, still working with products that build applications and still talking to databases. My new laptop has SQL Developer on it and I can connect to an Oracle Database!

Microgen DBClarity Developer is Beta

I’ll talk a little about the tools and technology I’m now involved with, in the weeks and months to come; today I want to tell you about a beta program we’re running for Microgen DBClarity Developer. This new product is focussed on people who want to query the database, by writing SQL queries and procedures, but who are not necessarily familiar with SQL syntax. The idea is that through the graphical interface IT and Business users can work together on gathering data. There is an overview on the website: http://www.microgen.com/dbclarity/

Consider writing a SELECT statement for a correlated query; if you’re a DBA, SQL or PL/SQL developer you can do this faster than I type these sentences, but if you’re with someone who knows what information they want from the tables they have access to, more complex SQL Queries may be daunting to them. If you can represent your queries graphically to them, then the whole discussion may become much easier. This tool is not a SQL Developer replacement, so why not download it, take a look and see what you think? I’d love to hear your feedback. I’ll be back soon with tips on how to get started and how to build a few basic queries. The software is shipped with a set of tutorial examples, so you can see what I mean quite quickly. Here’s how:

1. Download the software from here: http://www.microgen.com/dbclarity/

2. Expand “My Projects” and double-click to select the DBClarity Tutorial of your choice. (This opens a new tab set with the project selected.)

3. The tutorial projects are seeded with a number of defined objects. (I prefer to use the Dictionary View. You can switch to this by selecting the view choice icon just above the project. Once you have switched views, you’ll see a list that includes SQL Rules, SQL Expressions etc.)

4. Whether you switch views or not, expand the SQL Rules, select and double-click to open the rule. This displays a visual representation of your SQL Query.

5. To see the SQL Query, select the Show SQL icon.

For more help and information, take a look at the set of tutorial slides related to the examples on the website.

SQL Developer Data Modeler 3.1

As for my history…I see that SQL Developer Data Modeler 3.1 is now beta. Have fun with that!

Create Bigfile Tablespace – Oracle Managed Files (OMF)

Tyler Muth - Fri, 2012-02-10 10:40
Working with Exadata a lot (almost exclusively) I create almost all my tablespaces as bigfile using OMF. For some reason I can never find the right syntax for this when I need it. So, that’s the main reason for this post. On a related note, wow I use “column mode” in Notepad++ (link) a lot […]
Categories: DBA Blogs, Development

Model-based Cascading LOV's For JHeadstart

JHeadstart - Fri, 2012-02-10 02:32

Written By Peter Koletzke, 8 February, 2012 (posted by Steven)

SCENARIO

While searching for employees, users need to find a department by first finding a location from a City LOV (dropdown list). After selecting a city, the City and Postal Code appear on the screen.  LocationId also returns from the LOV, but is hidden because users should not see the ID.  

Then the user opens a Departments LOV (pop up LOV with query fields), which displays only departments within the selected city. After selecting a department, the Department ID and Department Name are returned to the screen. 

CONCLUSION

Implementing a cascading LOV consists mostly of work in the Model project. It is important that you prove that the cascading LOV works in the Model project before implementing it in the ViewController project. A brief list of the special components and settings needed to implement a cascading LOV follows. 

You can access a detailed recipe for this technique here. A sample application that results from this recipe is here.

MODEL PROJECT

  • Base view object for the Employees entity object: EmployeeMaster
  • Read-only view objects for the Locations LOV and Departments LOV queries
  • View criteria on the Departments LOV to represent a WHERE clause for location_id = :bind_variable
  • Locations and Departments added as reference entity objects to EmployeeMaster
  • Calculated attributes in EmployeesMaster as follows. All have Queryable as “true” and Display Hint as “Display.”
    • LocCity (LOCATIONS.CITY)
    • LocPostalCode (LOCATIONS.POSTAL_CODE)
    • LocLocationId (LOCATIONS.LOCATION_ID)
    • DeptDepartmentName (DEPARTMENTS.DEPARTMENT_ID)
  • Locations LOV on the Employees.LocCity attribute, returns city, location ID (hidden), and postal code
  • Departments LOV on the Employees.DepartmentName, returns DepartmentName and DepartmentId, uses DepartmentsLOV view object accessor with the detail LOV view criteria mentioned above (parameter value = LocLocationId)
  • AutoSubmit UI hint set for the two LOV items: LocCity, DeptDepartmentName
  • Dependencies to LocCity from DeptDepartmentName and DepartmentId (so they clear when the city changes)
  • View criteria on EmployeeMaster for a list of attributes needed in Quick Search area. An additional view criteria is needed for the Advanced Search area. LocLocationId is listed in both view criteria, but its UI Hint for Rendered Mode is “Never.” Deselect Show in List on the UI Hints tab.

VIEWCONTROLLER PROJECT

All actions are in the JHS application definition editor unless noted.

  • Set the LocLocationId item so it does not display in the table or in the form.
  • Set Quick Search View criteria and Advanced Search View criteria properties to the names of the appropriate (but separate) view criteria you created for to list attributes in these search sections
  • Set Depends On Item(s) properties for LocPostalCode as “LocCity,” for DepartmentId as “DeptDepartmentName,LocCity” so the LOV return fields on the edit page are set after an LOV selection.
  • Select the Clear/Refresh Value? property for DepartmentId so it clears when the city or department name changes.
  • For JHS 11.1.1.4: select Clear/Refresh? Value for DeptDepartmentName.
  • For JHS 11.1.1.3: edit adf-config-EmployeeMaster.xml after generation to define a depends-on refresh for DeptDepartmentName.


Categories: Development

Oracle Partner Event: Málaga 2012 Edition

Marc Kelderman - Thu, 2012-02-09 13:07
In the first half of February 2012, I joined the Oracle Partner Event in Málaga, Spain. This event is organized by Oracle for all partners and special guests. The goal of this event is to learn from each other, between the participators as well with Oracle. We also get the latests information on the Oracle product strategy. The event is split into workshops and presentation sessions. The first two days is all about Oracle strategy, product updates and customers cases. While the last two days the workshops are being executed on SOA Suite, WebCenter and Weblogic.

My goal was to see and talk to my (ex)Oracle colleagues, Development and to get the latest info of the SOA Suite product stack and Weblogic Server. Apart from this networking is key during all these sessions, so I did a lot of chat with the participators to share experience, issues and any other business that comes along.

My focus is off-course Oracle Fusion Middleware and everything that is related to SOA/BPM. Here are some teasers.

Weblogic 12c
Weblogic 12c was announced at Oracle Open World in 2011, and can already be downloaded already. In this session we got in-depth information on all the new features that is currently available and what will come in the next releases.
  • Java EE 6
  • Simplified Deployment
  • Integrated Traffic Management (Exalogic)
  • Enhanced HA and Disaster Recovery
  • Higher Performance (that is default with new releases ;-) )
  • Transactions can also be stored in database
  • Seamless Upgrade (!)
  • Support for Exalogic
  • Support for Oracle Public Cloud

SOA Suite Strategy
Everybody in the SOA community was excited on the SOA and BPM sessions, new features of the upcoming releases where presented. We had sessions on the new PS5 patch set and what will come in the 12c edition, both for SOA and BPM.
  • Enterprise Manager is improved fault analysis
  • Testing BPEL processes from JDeveloper
  • Copy/Paste in JDeveloper of BPEL activities
  • Improved purging (see also purging document with PS5 enhancements)
  • DBAdapter supports coherence
  • Debugging of BPEL processes
  • Templating
  • All consoles integrated in EM (SOA / BPM / OSB)
  • Single IDE for all SOA products
  • ...many many more...
Overall
I am not able to give any details on which functionality comes in which release or even when Oracle will release it. That was the only disappointment of this event, they will not give any dates. I think this will not change in a next event ;-)



Oracle Social Network
This presentation and demo, is off course running in the Cloud, but in this 'product' Oracle integrates a messaging system, with artifacts. In this case Siebel CRM was integrated with Oracle Social Network in such way that everybody can join the conversation; documents can be added, shared, annotations can be made and approvals are send back to Siebel CRM. Everything via social media on any device. This demo shows that business can me made via social media. Except this social media is not run publicly to everybody but in your own organization.

Apart of all the workshops, the global and parallel sessions, there was also time to relax. Oracle organized a dinner with live Andalusian music. We went to a traditional Spanish bodega were we had tapas and drinks. Here is a video to taste the atmosphere.



Here are also some pictures that I have made during this event, this gives you a small impression.


 The Weblogic 12c session from Maciej Gruszka from Oracle Product Development.

 Simone Geib from SOA Product Development during her session on PS5 and 12c.

 Join the social networks of SOA Suite from Oracle Development.

 The old castle of Malaga.

At the central square in Malage, with colorful houses.



I Need More Hardware!

Tyler Muth - Wed, 2012-02-08 15:00
Actually, this is one of the few times I can remember in my career when I can honestly say I have enough horsepower at my disposal. Want to guess what I’m running right now? This POV will probably generate a number of follow-up posts. One concept: there are always bottlenecks. When you remove the hardware […]
Categories: DBA Blogs, Development

Mobile APEX Apps – Next Steps

Marc Sewtz - Mon, 2012-02-06 15:18
It's been a few weeks since my last Blog posting on mobile development, or any topic for that matter. I've been busy doing Cloud development and talking about it at UKOUG and NYOUG. Then there's the ongoing work on APEX 4.1.1, which actually won't ship with jQuery Mobile bundled in, mainly due to jQuery Mobile's minimum requirement of jQuery 1.6.4 while APEX 4.1 includes jQuery 1.6.2, and a patch release won't be the right time to move that up. But as my previous mobile samples and especially the mobile version of the Oracle Learning Library show, it's certainly possible to use jQuery Mobile in APEX 4.1 today. So the full integration of jQuery Mobile with APEX, incl. declarative / wizard-driven support for building mobile web applications is currently planned for APEX 4.2, which actually was the subject of some recent meetings in Vienna, Austria.

While we wait for (and work on) APEX 4.2, I'm planning to continue blogging about what can be done with jQuery Mobile and APEX today, publish some ideas and gather feedback from our users on what they'd like to see in terms of mobile support in APEX 4.2. And one area that I found increasingly cumbersome in my mobile development efforts was to quickly try out my latest mobile creations on my iPhone and iPad. I kept sending emails to myself with the URL to my mobile APEX apps, bookmarked those URLs, but then ended up constantly creating new apps, requiring new boomarks. I also tried to just cloud-sync my bookmarks between my MacBook and mobile devices, but that wasn't ideal either.

Then I thought if I have these difficulties while developing, end users might have similar issues. For example, some of our new Cloud-based productivity applications will have a link that takes the user to the mobile version of a page or app. And that's great if they're already on a mobile device, but what if for example, a users sits at his desks, runs some analysis, and then needs to run to a meeting and he wants to take the results with him on his mobile device? Well, one possibility would be to just display a QR code on the desktop version of his report, and then allow him to scan that QR Code with his mobile device, which would then take him straight to the mobile version of that report.

Sounds like a good idea? Here's how this could look like, just open the following page on your desktop or laptop:


It's a very simple Interactive Report on the EMP table, and right next to it, in the sidebar, I show a QR code, which can be scanned with one of the many bar-code readers available for smartphones, like RedLaser.

Once scanned, you will typically be prompted by your smartphone whether you want to go to the URL, and if you proceed, your mobile browser opens and takes you to this page:


To generate the QR Code I wrote a very simple QR Code Generator APEX Region Plug-In that takes in the text your want to encode, and the width and height of the QR Code image and then calls out to Google to have the actual image generated.

If you would like to take a look at the app, see how it's done and use some ideas for your own apps, you can download the application here:



lose ends...

Nuno Souto - Sun, 2012-02-05 20:21
Finally worked out how to change the admin email ids in the blog!For some reason I never quite fathomed, Google took the wrong email id for admin of this blog when they took over Blogger. With the result that for quite a while I had to login with a different address than my usual gmail and/or yahoo to administer this blog.It's been a pain in the you-know-what to manage, with yet one more email Noonshttp://www.blogger.com/profile/04285930853937157148noreply@blogger.com6

Thanks Google Adsense! Sponsors Wanted!

OCP Advisor - Wed, 2012-02-01 21:45
Hundreds of clicks every week on this blog adds pennies to the dollar. The generous folks at Google Adsense check the meter reading and send in a small check once in a few months (actually when the total crosses a hundred dollars).
This blog is a not-for-profit exercise and I hope to pay back the amount I received from Google in the form of Oracle Certification Exam Vouchers for a lucky reader or two. Greatly appreciate the Pay Per Click (PPC) spend of Google advertisers on my blog.

On a related note, the blog author invites sponsors to display their ads on the blog in return for sponsorship of exam vouchers to our loyal readers. Corporations interested in sponsorship may e-mail OCP Advisor at ocp.advisor@gmail.com

OUM Certified Implementation Specialist Certification

OCP Advisor - Wed, 2012-02-01 01:27
Oracle is shortly launching the production release of Oracle Unified Method (OUM) Certified Implementation Specialist Certification. OUM certified professionals would be skilled in Oracle’s all inclusive methodology. The certification covers the core features the Oracle Unified Method suite including Focus Areas, Uses Cases, and Requirements Gathering. The certification proves a baseline of the consultant’s knowledge and allows the implementation team to work as a cohesive team from day one.

This certification is available to all candidates but is geared toward members of the Oracle Partner Network (OPN) who are focused on selling and implementing this technology. OPN Members earning this certification will be recognized as OPN Certified Specialists, which helps their companies qualify for the Oracle Unified Method Specialization.

There is only one exam for this certification called Oracle Unified Method 5 Essentials (1Z0-568). Details about the exam is available in the OUM Exam Study Guide. Oracle provides OUM training for partners. DevelopMentor is offering OUM training to the general public. For details about the OUM training, click here. The blog author attended the Level 3 training at Oracle Global User Group Leaders Conference in 2011. Read his OUM blog and begin your certification journey for OUM.

Have you taken the latest survey from OCP Program team?
Click here to take the Oracle Certification Program Salary and Satisfaction Survey 2012.

AQAdapter: Reset your datasource

Marc Kelderman - Mon, 2012-01-30 09:14

Using the AQ Adapter in a cluster environment, can cost you a lot of temporary tablespace. When you use AQ for dequeuing events and process them further with OSB or SOA Suite, there is always a connection to the database.

This connection is waiting for messages to appear on the Queue (it is subscribed). From middleware perspective everything works fine, data is being dequeued and your proxy-service or composite is running.

But at database level, the session is consuming tablespace. This is the temporary tablespace, so far so good. But if you use this on heavy load for a long time, the temporary space will grow to hundreds of mega or even gigabytes.

To determine how much temp space your sessions are using, you can execute the following SQL:

SELECT 
u.tablespace
, ROUND(((u.blocks*p.value)/1024/1024),2)||'M' "SIZE"
, s.sid||','||s.serial# SID_SERIAL
, s.username
, s.program
, s.machine
, s.logon_time
, Q.NAME
, s.event
FROM
sys.v_$session s
, sys.v_$sort_usage u
, sys.v_$parameter p
, sys.dba_queues q
WHERE p.name = 'db_block_size'
AND a.saddr = b.session_addr
AND a.username = 'SCOTT'
AND a.p1text = 'queue id'
AND a.p1 = q.qid
ORDER BY
a.machine
, u.blocks;

I try to solve this by playing with the AQAdapter settings and de XA-datasource behind it. Non of them fixed the issue. The only way I solved it was by resetting the data-source. On the Internet I find a nice article from Edwin Biemond and refined his script into one I prefer. This is the result:

#
# Usage:
#
# $ORACLE_HOME/common/bin/wlst.sh resetdatasource.py
#
# based on:
# http://biemond.blogspot.com/2010/04/resetting-weblogic-datasources-with-ant.html
#

#
# Crontab:
# 10 1 * * 6 /bin/bash -x /opt/weblogic/Middleware/Oracle_OSB/common/bin/wlst.sh a.py weblogic t@ctwl4cc t3://l2-mslaccadm02:7201 MslDQXaDS >>/data/logs/resetdatasource.log 2>&1
#
import sys
import traceback
import time
import datetime

print 'Started at: ' + str(datetime.datetime.now())
n1 = datetime.datetime.now()

#
# Parse command line paramteres
#
adminUser = sys.argv[1]
adminPassword = sys.argv[2]
adminUrl = sys.argv[3]
datasourceNames = String(sys.argv[4]).split(",")

connect(adminUser, adminPassword, adminUrl)
domainRuntime()

drs = ObjectName("com.bea:Name=DomainRuntimeService,Type=weblogic.management.mbeanservers.domainruntime.DomainRuntimeServiceMBean");
domainconfig = mbs.getAttribute(drs, "DomainConfiguration");
servers = mbs.getAttribute(domainconfig, "Servers");

#
# Loop over servers
for server in servers:
serverName = mbs.getAttribute(server, 'Name')
if serverName == "AdminServer":
print 'Server: ' + serverName + ' skipped!'
else:
print 'Server: ' + serverName
dsBean = ObjectName('com.bea:ServerRuntime=' + serverName + ',Name=' + serverName + ',Location=' + serverName + ',Type=JDBCServiceRuntime')
if dsBean is None:
print 'not found'
else:
datasourceObjects = mbs.getAttribute(dsBean, 'JDBCDataSourceRuntimeMBeans')
#
# Loop over datasources
for datasourceObject in datasourceObjects:
if datasourceObject is None:
print 'datasource not found'
else:
dsName = mbs.getAttribute(datasourceObject,'Name')

#
# Loop over datasource to be reset
for datasourceName in datasourceNames:
if dsName == datasourceName:
print ' Reset: ' + dsName
try:
mbs.invoke(datasourceObject, 'reset', None, None)
except Exception, err:
print 'print_exc():'
traceback.print_exc(file=sys.stdout)
print
print 'print_exc(1):'
traceback.print_exc(limit=1, file=sys.stdout)
else:
print ' Skipped: ' + dsName

n2 = datetime.datetime.now()
print 'Duration: ' + str(n2 - n1)
print 'Finished at: ' + str(datetime.datetime.now())

The script can be scheduled via the crontab on the admin server. The following example starts the script every sunday at 01:10 AM.

10 1 * * 6 /bin/bash -x 
/opt/weblogic/Middleware/Oracle_OSB/common/bin/wlst.sh
/data/scripts/resetdatasource.py weblogic welcome1
t3://myadminserver:7001 MyDQXaDS
>>/data/logs/resetdatasource.log 2>&1

Book Review: OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide - Packt Publishing

Kuassi Mensah - Sun, 2012-01-29 14:16

What i liked: the book is accessible to anyone; the examples and their screen casts make easy to see what exactly the author is talking about. Each chapter has a "Certification objectives covered" and a "Test Your Knowledge" sections which are helpful, something you'd expect from a certification guide. The book also covers (very slightly, though) how to use SQL with programming languages including PL/SQL, Perl, Python, and Java; but why is Ruby not covered (-:?

Bonus: introduction to APEX.


How to rename SQL Tuning Set ( STS )

Virag Sharma - Sat, 2012-01-28 23:16
Rename SQL Tuning Set‎( STS )

We can use SQL Performance Analyzer (SPA) to evaluate impact on SQLs of 11g R2 database upgrade from 10.2 .So created some demo , example ( with full code ). EM was very good option , but still preferred sql,pl-sql, command / api.

We all know to, use SPA for 10.2 to 11.2 database upgrade , we need one intermeiate 11g DB.
So we can run trial remotely.So we collected SQL Tuning Set (STS ) ( using demo code ) from Multiple databases and import on intermediate 11g DB. Problem started when unpacking STS, collected from different production / Test environment having same name because all
used demo code :).

So started looking for solution , is there any way to rename STS !!!! and end up with following code

-- Create new STS and copy from exiting one
DECLARE
l_cursor DBMS_SQLTUNE.sqlset_cursor;
BEGIN
-- Create STS
DBMS_SQLTUNE.create_sqlset(sqlset_name => 'STS_DBNAME_CMUL',description => 'new STS SQL tuning set from XYZ DB');
OPEN l_cursor FOR
SELECT VALUE(r)
FROM TABLE (DBMS_SQLTUNE.select_sqlset (
'STS_RAG_CMUL' -- old sqlset_name which need to rename
)
) r;
DBMS_SQLTUNE.load_sqlset (
sqlset_name => 'STS_DBNAME_CMUL',
populate_cursor => l_cursor);
-- Drop STS
dbms_sqltune.drop_sqlset('STS_RAG_CMUL');
close l_cursor;
END;
/
Categories: DBA Blogs

Managing Windows scheduled tasks - SCHTASKS output misleading

Nigel Thomas - Thu, 2012-01-26 07:04
Here's a little gem - found on Windows Server SP2 but still there on Windows Server 2008 R2 SP1 at least.

I wanted to write a little script to disable some scheduled tasks (for maintenance) then after a predetermined time to re0-enable them. This is a common support problem, and I find I often complete the maintenance and forget to re-enable the tasks which results in alarms going off - but maybe not until the start of the next working day.

Anyhow, Windows gives you (at least) two ways of interacting with scheduled tasks:

  1. SCHTASKS
  2. PowerShell and the PowerShellPack which includes a TaskScheduler module
Although Powershell is an attractive option for scripting, PowerShellPack is poorly documented and the TaskScheduler module is a bit lacking. You can create, start, stop, register or get a task but there doesn't seem to be a cmdlet for actually enabling or disabling a task.

So, back to using groovy as a wrapper to SCHTASKS. All fine, we can use execute to create a CMD process that calls SCHTASKS /query to get the task status. Here's an example using easy-to-parse CSV format:

C:\>schtasks /query /fo csv /tn "\Apple\AppleSoftwareUpdate"
"TaskName","Next Run Time","Status"
"\Apple\AppleSoftwareUpdate","31/01/2012 11:15:00","Ready"

We can see that "Status" is in field 3 on the heading line, and its value is "Ready" on the data line. That's great.
To disable the task, we can then:

C:\>schtasks /change /disable  /tn "\Apple\AppleSoftwareUpdate"
SUCCESS: The parameters of scheduled task "\Apple\AppleSoftwareUpdate" have been changed.

Now let's check the status again:

C:\>schtasks /query /fo csv /tn "\Apple\AppleSoftwareUpdate"

"TaskName","Next Run Time","Status"
"\Apple\AppleSoftwareUpdate","Disabled",""

Yay! The task is indeed disabled - but look how the status has swapped into field 2 - under "Next Run Time". Presumably because there is no next run time while the task is disabled. A blank 3rd field value has been provided, but it is in the wrong place. Whatever way you list out the data, the error is still there:

C:\>schtasks /query /fo table /tn "\Apple\AppleSoftwareUpdate"

Folder: \Apple
TaskName Next Run Time Status
======================================== ====================== ===============
AppleSoftwareUpdate Disabled


C:\>schtasks /query /fo list /tn "\Apple\AppleSoftwareUpdate"

Folder: \Apple
HostName: PIERO
TaskName: \Apple\AppleSoftwareUpdate
Next Run Time: Disabled
Status:
Logon Mode: Interactive/Background

OK, now I know this, I can work around it. But another example of MS inconsistency (which no doubt is now firmly baked in for "backward compatibility" for ever and a day...

tnsping without the TNSNAMES.ORA entry

Peter O'Brien - Wed, 2012-01-25 11:04
It isn't immediately obvious in the tnsping documentation, but it is possible to perform the ping without having the Transparent Network Substrate configuration in place (i.e net service name) on the client for the database in question.

$ORACLE_HOME/bin/tnsping <hostname>:<port>/<sid>

Oracle Service Bus Cookbook

Marc Kelderman - Wed, 2012-01-25 05:37
Former Oracle collegueus and business parnerts wrote a nice cok book on the usages of Oracle Service Bus. The book is full of examples and guide you through the working and usage of the Oracle Service Bus. The is very technical of useful for developers who just ant to start the OSB. Experienced developers will use this book for the complete examples on the different technologies using OSB, such as JMS, EJB.

When you use this book, it is expected that you understand the concepts of XML, XLST, WSDL, WebServices, JMS and SOAP and basic knowledge of SQL. This is not explained in the book. Which is a advantage! Refer to the w3schools for such things.



You can obtain it via Packt Publishing.

Some subjects I miss in the book; best practice on execption handing, throtteling, deployment.

The examples in the book are based Oracle Service Bus patch set #3, but can also be used on top of patch set #4. This release is already available since august 2010. Why didn't' the authors use this version? I expect that the examples in the book can also be applied on the upcoming patch set release #5.


Resumes & Job Objectives

Jeff Hunter - Tue, 2012-01-24 17:11
I've been reviewing a lot of resume's lately.  Please tell me, what is the purpose stating your "Job Objective"?  Isn't it implied that your objective is to find a new job, specifically my job? I assume you're dynamic and technical and your vast expertise will help my company conquer the world. Also, what is the purpose of summarizing your experience on the first page and then giving me eight

Pages

Subscribe to Oracle FAQ aggregator