Feed aggregator

Oracle Metalink Notes for Oracle Apps DBAs.

Sabdar Syed - Sun, 2008-10-12 08:50
Dear Friends,

Here are the list of Oracle Metalink Notes, I do refer regularly. Moreover, these are very informative. So, I thought of sharing those note ids here with you.

Note: You have to have an account in Oracle Metalink to access notes.


Note: 452120.1 - How to locate the log files and troubleshoot RapidWiz for R12
Note: 329985.1 - How to locate the Rapid Wizard Installation log files for Oracle Applications 11.5.8 and higher
Note: 362135.1 - Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management
Note: 312731.1 - Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM
Note: 216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note: 279956.1 - Oracle E-Business Suite Release 11i with 9i RAC: Installation and Configuration using AutoConfig
Note: 294932.1 - Recommendations to Install Oracle Applications 11i
Note: 403339.1 - Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12.0.4 Upgrade
Note: 455398.1 - Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 11i
Note: 402311.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Microsoft Windows
Note: 405565.1 - Oracle Applications Release 12 Installation Guidelines

AD Utilities

Note: 178722.1 - How to Generate a Specific Form Through AD utility ADADMIN
Note: 109667.1 - What is AD Administration on APPS 11.0.x ?
Note: 112327.1 - How Does ADADMIN Know Which Forms Files To Regenerate?
Note: 136342.1 - How To Apply a Patch in a Multi-Server Environment
Note: 109666.1 - Release 10.7 to 11.0.3 : What is adpatch ?
Note: 152306.1 - How to Restart Failed AutoInstall Job
Note: 356878.1 - How to relink an Applications Installation of Release 11i and Release 12
Note: 218089.1 - Autoconfig FAQ
Note: 125922.1 - How To Find Oracle Application File Versions


Note: 419475.1 - Removing Credentials from a Cloned EBS Production Database
Note: 398619.1 - Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
Note: 230672.1 - Cloning Oracle Applications Release 11i with Rapid Clone
Note: 406982.1 - Cloning Oracle Applications Release 12 with Rapid Clone
Note: 364565.1 - Troubleshooting RapidClone issues with Oracle Applications 11i
Note: 603104.1 - Troubleshooting RapidClone issues with Oracle Applications R12
Note: 435550.1 - R12 Login issue on target after cloning
Note: 559518.1 - Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone
Note: 216664.1 - FAQ: Cloning Oracle Applications Release 11i


Note: 225165.1 - Patching Best Practices and Reducing Downtime
Note: 181665.1 - Release 11i Adpatch Basics
Note: 443761.1 - How to check if a certain Patch was applied to Oracle Applications instance?
Note: 231701.1 - How to Find Patching History (10.7, 11.0, 11i)
Note: 60766.1 - 11.0.x : Patch Installation Frequently Asked Questions
Note: 459156.1 - Oracle Applications Patching FAQ for Release 12
Note: 130608.1 - AdPatch Basics
Note::60766.1 - Patch Installation FAQ (Part 1)


Note: 461709.1 - Oracle E-Business Suite Upgrade Guide - Plan
Note: 293166.1 - Previous Versions of e-Business 11i Upgrade Assistant FAQ
Note: 224875.1 - Installation, Patching & Upgrade Frequently Asked Questions (FAQ's)
Note: 224814.1 - Installation, Patching & Upgrade Current Issues
Note: 225088.1 - Installation, Patching & Upgrade Patches Guide
Note: 225813.1 - Installation, Patching & Upgrade Setup and Usage Guide
Note: 224816.1 - Installation, Patching & Upgrade Troubleshooting Guide
Note: 216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note: 362203.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note: 423056.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (
Note: 726982.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (
Note: 452783.1 - Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)
Note: 406652.1 - Upgrading Oracle Applications 11i DB to DB 10gR2 with Physical Standby in Place
Note: 316365.1 - Oracle Applications Release Maintenance Pack Installation Instructions
Note: 418161.1 - Best Practices for Upgrading Oracle E-Business Suite


Note: 297522.1 - How to investigate printing issues and work towards its resolution ?
Note: 110406.1 - Check Printing Frequently Asked Questions
Note: 264118.1 - Pasta Pasta Printing Setup Test
Note: 200359.1 - Oracle Application Object Library Printer Setup Test
Note: 234606.1 - Oracle Application Object Library Printer Initialization String Setup Test
Note: 1014599.102 - Subject: How to Test Printer Initialization Strings in Unix


Note: 390137.1 - FAQ for Collections Performance
Note: 216205.1 - Database Initialization Parameters for Oracle Applications Release 11i
Note: 169935.1 - Troubleshooting Oracle Applications Performance Issues
Note: 171647.1 - Tracing Oracle Applications using Event 10046
Note: 153507.1 - Oracle Applications and StatsPack
Note: 356501.1 - How to Setup Pasta Quickly and Effectively
Note: 333504.1 - How To Print Concurrent Requests in PDF Format
Note: 356972.1 - 11i How to troubleshoot issues with printers


Note: 189367.1 - Best Practices for Securing the E-Business Suite
Note: 403537.1 - Best Practices For Securing Oracle E-Business Suite Release 12
Note: 454616.1 - Export/Import Process for Oracle E-Business Suite Release 12 using 10gR2
Note: 394692.1 - Oracle Applications Documentation Resources, Release 12
Note: 370274.1 - New Features in Oracle Application 11i
Note: 130183.1 - How to Get Log Files from Various Programs for Oracle Applications
Note: 285267.1 - Oracle E-Business Suite 11i and Database FAQ
Note: 453137.1 - Oracle Workflow Best Practices Release 12 and Release 11i
Note: 398942.1 - FNDCPASS Utility New Feature ALLORACLE
Note: 187735.1 - Workflow FAQ - All Versions

Oracle Applications 11i/12 Online Documentation


Note: Above are only the few important notes, there are bunch of notes on many other issues and topics in the metalink. I would suggest one to refer the metalink for more note ids.

Leave your comments if you feel these Oracle Metalink Notes help you in solving your Application issues.

Sabdar Syed,

Oracle SQL Developer Data Modeling - Early Adopter Release

Oracle Apex Notebook - Fri, 2008-10-10 10:37
 The long waited Data Modeling functionality for Oracle SQL Developer is here. Oracle SQL Developer Data Modeling runs on Microsoft Windows XP and Vista, Linux and Mac OS X. This is a first Early Adopter release, not a final product and I'm sure that the team behind the development, would appreciate all the feedback we can give them.
Categories: Development

Oracle Buys Primavera

Project Directions - Thu, 2008-10-09 09:08

See the full press release here.


Oracle Buys Primavera Creates First, Comprehensive Enterprise Project Portfolio Management Solution for Project-Intensive Industries
Redwood Shores, CA – October 8, 2008
News Facts:

Today, Oracle announced it has agreed to acquire Primavera Software, Inc., a leading provider of Project Portfolio Management (PPM) solutions, to accelerate its momentum in delivering mission-critical operational applications.

Primavera’s PPM software helps companies propose, prioritize and select project investments, and plan, manage and control the most complex projects and project portfolios.

Together with Oracle’s applications and infrastructure software, Oracle expects to provide the first comprehensive enterprise project portfolio management solution that helps companies allocate the best resources, reduce costs, meet delivery dates and ultimately make better decisions, all by using real-time data.

Oracle Enterprise PPM will be tailored to project-intensive industries such as engineering and construction, aerospace and defense, utilities, oil and gas, manufacturing, and professional services.

Primavera employees and management are expected to join Oracle to form a global business unit (GBU) focused on Enterprise PPM, and to help ensure a smooth transition for Primavera customers and partners. Primavera’s CEO Joel Koppelman is expected to lead the business unit as Senior Vice President and General Manager.

The transaction is subject to customary closing conditions and is expected to close in the second half of 2008. Until the deal closes, each company will continue to operate independently. Financial details of the transaction were not disclosed.

Agile PLM - Web Proxy Server Installation

Aviad Elbaz - Tue, 2008-10-07 11:01

It has been a while since I've posted about Agile PLM stuff..

In this post I'll go through implementing and configuring an Oracle Agile PLM Web Proxy Server.

Previous related posts:

Agile PLM - Part I - Introduction
Agile PLM – Part II – Database Node Installation
Agile PLM – Part III – Application Node Installation

First, who needs a Web Proxy server for Agile PLM?

In order to make Agile PLM accessible to external users, a Web Proxy server should be installed to allow connections from the internet.
This solution include a new server on DMZ behind a firewall which forwards calls to the internal Agile application server.

(* Image from Oracle Agile documentation)

The Agile Web Proxy Server installation consists of the following steps:

  • Installing and Configuring the IIS
  • Install the Agile Web proxy files on the IIS server in the DMZ
  • Configuring IIS as a Proxy Server for Agile PLM
  • Configuring IIS as a Proxy Server for Agile File Manager
  • Create new external File Manager

Now I'll show a detailed procedure to install Agile Web Proxy Server on Windows using IIS (Microsoft Internet Information Server).
*** When installing on Unix/Linux OS you'll use Apache as the web proxy server.

Installing and Configuring the IIS

  1. Install IIS on the new Agile Proxy Server (will be called agiledmz)
  2. Login to agiledmz server with administrator user
  3. Navigate to: Start -> Administrative Tools -> Internet information services (IIS) Manager
  4. Right click on Web Sites -> new -> Web Site -> Next

  5. Enter description: Agile PLM Web Site -> Next
  6. Enter the following:
    Ip: All unussigned
    port: 80
    host: null -> Next
  7. Path: C:\Inetpub\wwwroot -> Next
  8. Check the Read option only -> Next
  9. Click Finish  
  10. Right click on Agile PLM Web Site -> properties
  11. Select tab Directory Security -> Under 'Authentication and Access Control' click on Edit -> Uncheck the 'Integrated Windows authentication'
  12. Disable the default Web Site:  Right Click on Defaule Web Site -> Stop

Install the Agile Web proxy files on the IIS server in the DMZ

  1. Make sure IIS is up and running (Go to services screen - services.msc - and check that "IIS Admin Service" process is in Started state)
  2. Execute setup.exe from [INSTALLATION_BASE_DIR]\PN00168\Windows directory
  3. Click Next -> accept the license -> Next
  4. Enter User name, Company name and License key -> Next
  5. Check the Web Proxies only -> Next
  6. Specify directory on which agile files will be installed (D:\Agile\Agile9221)-> Next
  7. Select Oracle Application Server 10g -> Next
  8. Enter the Web Proxy server name (or IP) and port (80) -> Next
  9. Enter the server name and port on which Agile application is installed (The Agile Application Server) -> Next
  10. Keep the default "Agile" for Agile Application Server Virtual Path-> Next
  11. Keep the default "Use internal user account (ifsuser)" -> Next
  12. Keep the default "Filemgr" for Agile Primary File Manager’s Virtual Path -> Next
  13. Enter Agile's File Manager host name and port (might be the same as Agile Application Server)-> Next
  14. Click on Install
  15. Click on Done

Configuring IIS as a Proxy Server for Agile PLM

  1. Navigate to: Start > Administrative Tools > Internet Information Services (IIS) Manager
  2. Right click on Agile PLM Web Site -> properties
  3. Click the Home Directory tab -> update the execute permissions to Scripts and Executables
  4. Click the ISAPI Filter tab -> click Add 
  5. Filter name: oproxy , Executable: D:\Agile\Agile9221\AgileProxies\oracle_proxy.dll -> Ok -> Ok
  6. Right click on Agile PLM Web Site -> New -> Virtual Directory -> Next
  7. Alias: oproxy -> Next
  8. Path: D:\Agile\Agile9221\AgileProxies -> Next
  9. Check the Read and Execute -> Next -> Finish
  10. Select the Web Service Extensions -> Select the All Unknown ISAPI Extensions -> Click Allow -> Click Yes
  11. Close IIS Manager window
  12. Restart IIS from services screen
  13. Right Click on Agile PLM Web Site -> properties -> select the ISAPI Filters tab -> you should see a green arrow pointing up for oproxy.


Configuring IIS as a Proxy Server for Agile File Manager

  1. Login to the File Manager server
  2. Note the Connector Port number from [AGILE_HOME]\Tomcat\conf\server.xml
    <!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
        <Connector port="8009" enableLookups="false" redirectPort="8443" debug="0" protocol="AJP/1.3"/>
  3. Edit jk2.properties from [AGILE_HOME]\Tomcat\conf
    Add the following line at the end and save the file:

  4. Login to agiledmz - (The Web Proxy Server)
  5. Navigate to: Start > Administrative Tools > Internet Information Services (IIS) Manager
  6. Right click on Agile PLM Web Site -> properties
  7. Click the ISAPI Filter tab -> click Add
  8. Filter name: Jakarta IIS Connector , Executable: D:\Agile\Agile9221\AgileProxies\isapi_redirect.dll -> Ok -> Ok
  9. Right click on Agile PLM Web Site -> New -> Virtual Directory -> Next
  10. Alias: Jakarta -> Next
  11. Path: D:\Agile\Agile9221\AgileProxies -> Next
  12. Check the Read and Execute -> Next -> Finish
  13. Open the workers.properties file in [AGILE_HOME]\AgileProxies and make sure the File Manager server is correct in the following entry:
    worker.ajp13w.host=<File Manager host name>    
  14. Restart IIS 
  15. Right Click on Agile PLM Web Site -> properties -> select the ISAPI Filters tab -> you should see green arrows pointing up for both oproxy and jakarta.


Create new external File Manager

  1. Open the Agile Java Client
  2. Select 'Admin' Tab -> expand 'Server Settings' -> open 'Locations'
  3. Select the 'File Manager' tab -> click on the 'new' icon (you must have license for unlimited File Managers to enable it)
  4. Enter the following:
    Name - iFS_External
    File Manager URL - Use the web proxy server name (registered on the web) or IP, e.g. http://agile.company.domain/Filemgr/AttachmentServlet or
    Enabled - Yes
    Primary File Server - No
  5. Click on 'Ok'
  6. Expand the 'User Settings' -> open 'Users' -> find the user you want to use the external iFS and open his settings -> select the 'Preferences' tab -> update the 'Preferred File Manager' to 'iFS_External'.

*** Important Note
Agile architecture compels you to configure specific File Manager for each user.
Users configured to use the internal iFS will be able to utilize the File Manager from within the network only! They'll be unable to utilize the external iFS when login to Agile through the Agile Web Proxy Server.
The same behaviour for users configured to use the external iFS - They will be able to utilize the external iFS only.

Now you can login to agile from the internet through the Agile Web Proxy Server.
Use the following URL to get the login screen:  
http://[Agile Web Server Proxy IP or Name]/Agile/PLMServlet

Next post I'll show how to secure connections to Agile through the Proxy server using SSL (https) connection.

You are welcome to leave a comment and/or share your experience with Agile installation.


Categories: APPS Blogs

AIOUG - TechNight in Bangalore

Virag Sharma - Mon, 2008-10-06 23:27

The All India Oracle User Group with a 4 lakh -strong developer base and a community of seven-lakh users in India is organising a second meeting in Bangalore on
October 22 to share experiences and provide insights into shape of things to come. It is the second largest technology network of professionals for Oracle after the US. Soon these TechNights will be held in other parts of India, such as Pune, Mumbai and Delhi.

Like several successful Oracle user groups around the world, AIOUG is also a not for profit organization formed by Oracle users for Oracle users. Let’s join hands across the country to make AIOUG a global lead user group.

AIOUG first TechNight held at Hyderabad, Please click here to see TechNight pictures
Categories: DBA Blogs

Demo Application from Oracle World (and ODTUG too)

Carl Backstrom - Mon, 2008-10-06 12:41
As promised I've put up the export of my demo application from Oracle World , for people who were at ODTUG in New Orleans it's pretty much the same application I showed there.

Thanks, for everybody who showed up I had a great time and hopefully was able to give people some ideas. I'll see what the rules are for me putting my slides on slideshare or something like that , but at some point Oracle will putting up the slides and a recording of the session.

Download the Application


The application will only work in Firefox, but that is only because it was built specifically to show Firebug features.

If you remove anything that says console.log or console.dir it will work in other browsers.


My Blog Feedback Page

Sabdar Syed - Fri, 2008-10-03 18:37
Dear Blog Readers,

I wanted to have a feedback page as a post in my blog where my blog viewers can post their valuable comments and suggestion about my blog and articles.

In order to serve you better with required information in my blog, please leave your comments/suggestions/doubts/questions/requirements/ etc.

Link for comments here - Feedback Page !

Please check the comments submitted in the comments item below.

Thanks & Regards,
Sabdar Syed.

OOW recap (pt 1)

Carl Backstrom - Thu, 2008-10-02 14:06
Hi all it's been a week now since the end of Oracle World and finally have enough time to write up a brief recap of my experience of OOW.

HOL (Hands On Labs)
I helped out in a couple of the APEX Hands on Labs starting with the very first one at 10:30 am on Sunday and they seemed to run fairly smooth , some computer problems but were able to work through them, and were very well attended. Seeing some of the issues people ran into was very informative. Some are just places where we can improve the Hands on Labs themselves and others were where we can improve product, for that information alone I'm glad I volunteered to helped out.

Sessions (Not Mine)
I almost never have enough time for sessions at Oracle World , mainly because I like working the demo grounds, and usually completely ignore my scheduled demo ground times and just hang out what can I say I'm a people person :D , but I did make it to a few.

I was in Joel Kallman's APEX + Globalization session, which was very well attended, especially for a Sunday. Since globalization isn't something I usually have to deal with I always learn something new from these sessions. One thing I did learn about APEX is you don't have to take globalization into account from the very beginning of development comparative to some other development enrollments, though a bit of forethought helps, but can decide to translate and globalize your applications as needed.

The other session I was able to sit through in it's entirety was Raj Mattamal's Security: Writing Custom Authentication Schemes for Application Express session, and as always Raj put on a very enjoyable and informative session.

In fact if one thing ,at least for me, stands out about Joel's and Raj's sessions it's how well both of them communicate some complex very ideas and how easily some of these complex ideas can be implemented with APEX.

Demo Grounds
The demo grounds are my favorite part of Oracle World. Since I work from home usually most my communication , even with the APEX development team, is email / IM / phone calls. Oracle World not only allows me to remember what the people I work with look like but meet people I know from forums,blogs,etc face to face.

I also like demoing APEX, it's fun to show someone who's never seen APEX just how fast you can build and edit a complete working application , APEX pretty much sells itself in the 5 minute demo, and to see how they react when they hear they already own APEX with their current database license.

And for people that have seen or using APEX already I like demoing the new stuff. This OOW the new stuff was Websheets (interactive reports with built in edit and more) and Dynamic Actions (declarative javascript functionality).

As a developer's working on bugs and functionality on these features sometimes we lose track of how cool/useful/needed some of these things are. But to watch people reactions as we show them the stuff they can't play with yet ;) and to get comments and suggestions about the features (good or bad) really makes it worth it.

OOW recap (pt2) I'll go over the sessions I had a hand in , some miscellaneous events over the week.

The blog post after that will be about our plans with APEX + jQuery , it kinda deserves it's own post.

Undocumented Oracle Functions

Jared Still - Wed, 2008-10-01 18:58
Undocumented functions in Oracle are always fun, and you just may find something useful.

The caveat of course is that they are undocumented. They can change without notice between releases or patch levels, so building apps that depend on them may be unwise.

They are often quite useful from a DBA perspective when used in SQL scripts.

Here are a few that I've played with. These are all found in Oracle

These functions have one thing in common - they have a prefix of SYS_OP_

Some of these appear to be identical to documented functions.

I don't know of any official explanation regarding the purpose of undocumented functions that seem to mimic documented functions. It could be that the source for the documented functions are separate from those that are documented, ensuring that functionality will not change for an undocumented function that is used in the Oracle kernel, even though its documented doppelganger may change in future releases.

In any case, undocumented functions are always interesting, and here are a few to play with.

Just keep in mind that these are undocumented, and as such may change or disappear entirely in future releases

sys_op_vacand - Return the binary AND of two raw values. Results are in hex

SELECT sys_op_vecand(hextoraw('FF'),hextoraw('FE')) from dual;

16:13:12 SQL>SELECT sys_op_vecand(hextoraw('C3'),hextoraw('7E')) from dual;

sys_op_vecor - Return the binary OR of two raw values. Results are in hex

16:14:39 SQL>SELECT sys_op_vecor(hextoraw('FF'),hextoraw('FE')) from dual;

sys_op_vecxor - Return the binary XOR of two raw values. Results are in hex

16:14:39 SQL>SELECT sys_op_vecor(hextoraw('FF'),hextoraw('FE')) from dual;

sys_op_vecbit - Return the value of the bit at position N in a raw value

The return value is 0 or 1

This is an interesting function as it can be used to determine the value of bits in a number. If for instance some flags are stored in a bit vector and you need to know the value of the 3 bit, this is an easy way to do it.

I believe the upper limit on the number of bits is 127.

define decnum=10
prompt &&decnum dec = 1010 bin

16:16:27 SQL>select 'Bit 0 is ' || sys_op_vecbit(SYS_OP_NUMTORAW(&&decnum),0) from dual;
Bit 0 is 0

16:16:27 SQL>select 'Bit 1 is ' || sys_op_vecbit(SYS_OP_NUMTORAW(&&decnum),1) from dual;
Bit 1 is 1

16:16:27 SQL>select 'Bit 2 is ' || sys_op_vecbit(SYS_OP_NUMTORAW(&&decnum),2) from dual;
Bit 2 is 0

16:16:27 SQL>select 'Bit 3 is ' || sys_op_vecbit(SYS_OP_NUMTORAW(&&decnum),3) from dual;
Bit 3 is 1

sys_op_bitvec - This appears to be for used to build a bit vector, but I haven't figured out
how to use it. Please let me know if you do.

sys_op_map_nonnull - This has been thouroughly discussed on Eddie Awad's blog:
sys_op_map_nonnull discussion

sys_op_descend - Returns value as it would be used in a descending index. This is essentially
reverse() function with output in hex.

16:32:41 SQL>select sys_op_descend('ABC') from dual;

sys_op_undescend - The inverse of sys_op_descend. Well, almost

17:12:59 SQL>select sys_op_undescend(sys_op_descend('ABC')) from dual
17:12:59 2 /


Notice the output is in the original order, but in decimal rather than hex.

sys_op_dump - dump the data from an ADT/UDT (Abtract/User Data Type)

16:54:13 2 last_name varchar2(30),
16:54:13 3 first_name varchar2(30),
16:54:13 4 id number(6)
16:54:13 5 )
16:54:13 6 /
16:54:13 SQL>
16:54:13 SQL>
16:54:13 SQL>select sys_op_dump(my_adt('still','jared',234987)) from dual;


I don't use objects in the database, but this would likely be useful for someone that does.

sys_op_guid - this appears to be identical to sys_guid

17:00:50 SQL>select sys_guid(), sys_op_guid() from dual;

52BA7CF06BB488ECE040010A7C646200 52BA7CF06BB588ECE040010A7C646200
Categories: DBA Blogs

It's been busy and $700 billion bail-out

Peter Khos - Tue, 2008-09-30 10:12
Hi there,It's been busy. I couldn't even made it to OOW this year (even though I was given the approval to attend). I looked at the various draft post that I have had (never did get a chance to finish) over the last 12 months, it has been horrendous. Anyhow, just wanted to put in a couple of points re: $700b bailout asked by the Bush Administration. Wow! $700b! That's more than the GDP (GrossPeter Khttp://www.blogger.com/profile/14068944101291927006noreply@blogger.com1


Sergio's Blog - Tue, 2008-09-30 10:10
Categories: DBA Blogs

Search Through Region Source in Application Express

Sergio's Blog - Tue, 2008-09-30 09:46

As I was working to migrate an application and its theme over to Application Express 3.1.2 from 2.1.2 I needed to move some images around and update the references accordingly. I remembered that the Application Builder has a feature to search through region source, which came in handy.

Here's where you can find it:

I could have used this type of feature to search through templates as well. If anyone from the APEX team is reading this...

Categories: DBA Blogs

My OpenWorld 2008: 21 Set

Oracle Apex Notebook - Mon, 2008-09-29 12:31
Today I had the chance to attend 4 sessions. Two of them were Hands on Labs from Oracle Develop. Also, it was nice to put some faces in the names I’m used meet on the net. I met Carl Backstrong, Joel Kallman, David Peake, Dimitri Gielis, Francis Minault, John Scott and Patrick Wolf. Session 1: Hands-on Lab: Extending the Oracle Application Express Framework with Web 2.0 - APEX Development Team
Categories: Development

Oracle, the Innovation Company

Project Directions - Mon, 2008-09-29 11:34

Fresh on the heels of our very successful OpenWorld in San Francisco last week I wanted to highlight this favorable blog post from Joshua Greenbaum at ZDNet.com. 

In it Joshua highlights a few topics that are also of particular interest for Projects customers.  First of all there was a good presentation of the Fusion apps that impressed the author.  To quote him: “Oracle has made good on its promise to deliver Fusion Apps, and has greatly exceeded my expectations in doing so. A very impressive debut.”

Second, he recognized that our strategy for Apps Unlimited is delivering on our promise to continue to enhance the products already being used by our customers.  E-Business Suite (of which Projects is one application) has been enhanced in many ways and we showed and discussed the roadmap for Projects 12.1 at the conference.  Customers can find out more information on Metalink for all of the details on that release.

Joshua also discusses the enhancements to the Oracle Business Intelligence applications.  We presented a paper at OOW this year about the OBIEE solution coming for Project Analytics.  It was very well received and like our customers we are very excited for it’s release.  It will open up a a whole new level of analytics to our customers and give them even greater insight into their projects.

Finally the author touches on the AIA (Application Integration Architecture) strategy of Oracle.  Rolled out last year AIA is Oracle’s toolset to glue all of the acquired products together.  As Joshua writes:

“This product, which orchestrates all the different processes across the vast, and disparate, Oracle Applications stack, is the place where the vision of Oracle becomes reality: There is no way for Oracle to pull off rationalizing its massive acquisition strategy without AIA making all the interprocess communications between, say, Glog, Siebel, Oracle Financials and PeopleSoft HR (and SAP, while we’re at it) seamless, easy, and fast. Absent a highly performant AIA middleware layer, Oracle’s dream of cross application process functionality becomes a user nightmare.”

For Projects, we are no less interested in leveraging AIA than any other part of the company.  We’re excited to be able to tie our applications in with some of the best of breed products that we’ve acquired such as Agile and Hyperion.  We’d very much like to hear from our customers as to which apps you would find most useful to integrate with and provide input on our AIA roadmap.


Delete vs. Truncate - graphically

Claudia Zeiler - Sun, 2008-09-28 04:05
This is too funny to not share. Of course, everyone knows that a truncate is much more efficient than a full table delete. On my system, still suffering from a slow log writer, but absolutely quiet at the moment, I ran an insert of a million rows (ctas from tbl1 to tbl2), a delete of those million rows (from tbl2) , and then a truncate of them (from tbl1). I looked over at Enterprise Manager and this is what I saw: (I added the tags for benefit of blog readers)

I had not been expecting such a graphical re-enforcement of the rule. I had found the full table delete in some executing code and was curious how much redo it was generating. I ran René Nyffenegger's script 'how_much_redo' .
Assuming that it is giving accurate results, here is what I got for the 3 operations.


1161874 rows created.

SQL> exec how_much_redo;
New Redo Bytes Written: 408985600 (390 MB of redo TO INSERT)

SQL> delete from T1_DEL;

1161874 rows deleted.

Elapsed: 00:06:30.90 (6 MINUTES TO DELETE)
New Redo Bytes Written: 661496320 (630 MB of redo TO DELETE)

SQL> truncate table T1;

Table truncated.

Elapsed: 00:00:06.80 (6 SECONDS TO TRUNCATE)
New Redo Bytes Written: 815616 (less than 1Mb of redo to TRUNCATE)

My OpenWorld 2008: 25 Set

Oracle Apex Notebook - Sat, 2008-09-27 17:22
The day started too early after the big party the night before. It was that last day of OpenWorld 2008 and there were lots of people going home. Session 1: Dispelling myths about Apex – John Scott I surely didn’t expect to see a full room, being this session at 9 AM and having the big party the night before. I guess Jes is even more popular now that he has his own book :) I bought the book but
Categories: Development

Lazy Log Writer - The non Resolution

Claudia Zeiler - Sat, 2008-09-27 15:46
OK, after the huge emergency, "You can't attend the last day of open world because our problems are too big." After my debugging efforts, how did the problem of the slow writes to the redo log files resolve?

1. Management asked that the entire database be moved to the NAS disks because they initially seemed faster. I had to let them know, that, no, the writes there are not faster.

2. The efforts to cross the great divide and get the storage manager in the other company to actually look at his configuration resulted in, "Since the writes are slow on two different pieces of our machinery, it can't be our fault - it must be oracle. I'm debugging nothing."

3. The other company informed us, "By the way, we will be installing new hardware in a couple of weeks at the same time that you are making a major application upgrade." How does that sound for a prospect of a smooth transition? This was followed by an email, "Claudia, are you working with the other company on this?" Not only am I not working with them, I never heard of it!

4. Management informed me, "Since there will be a hardware change soon, don't bother to follow up on this problem."

So they will install the hardware, we will deploy the new application version, and there will be storm and drama about the excessive waits for redo log writes. I think that I should change my name to Cassandra.

How I Changed My Blog with 3 Column Template and Right & Left Sidebars?

Sabdar Syed - Sat, 2008-09-27 08:34

I have been looking for the steps/code to prepare my blog with 3 column template, but couldn’t get a proper reference for that. Luckily, today I came across a wonder full blog for “3 Column Templates Step by Step Guides”, which will fit to my blog template.

It’s as easy as simple.

Step -1: Before going to change the original template, I gave a try on the test template by creating a new blogspot for testing perpose ( This Step-1 is optional)

Step -2: Take the backup of template before trying out any customization that requires direct modification of the HTML code of original template.

Step -3: Follow the below link.

3 Column Templates : Rounders : Left and Right Sidebars

For other type of templates, then check this

3 Column Templates: Step by Step Guides


Sabdar Syed.

My OpenWorld 2008: 24 Set

Oracle Apex Notebook - Fri, 2008-09-26 10:22
It was a big day… Larry Ellison’s keynote with the X thing , my presentation and the Appreciation Event. I also had the opportunity to have preview demo of APEX 4.0 features at the Demo Grounds. Session 1: Soup-to-Nuts RAD development using Oracle SQL Developer and APEX – Mike Hichwa, Kris Rice & David Peake, Oracle I had lots of expectations for this session because of the new SQL Developer
Categories: Development

How We Resolved the Account Locked (Timed) issue?

Sabdar Syed - Fri, 2008-09-26 07:01
An application user account, in one of our Oracle 10g Databases, is being locked every time. Below are our findings and solution to resolve the issue.

Oracle Database Version:
10g R2 (
Application User: APPUSR
Error: ORA-28000: the account is locked

Login as SYSDBA

SQL> conn /as sysdba

Check the APPSUSR account status.

SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPUSR’;
-------------------- -------------------- ---------------

Here we can see the account status is LOCKED (TIMED) and the default user’s profile is DEFAULT.

Check the resource limits of DEFAULT profile.

SQL> SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';

-------------------------------- -------- ----------

All resource limits for DEFAULT profile is set to UNLIMITED, but only for FAILED_LOGIN_ATTEPTS attribute, it’s set to some value (10). Due to this the user account keeps getting locked(timed).When we check in the Oracle Documentations, it’s stated that FAILED_LOGIN_ATTEPTS attribute for DEFAULT profile has been changed from from UNLIMITED to 10.

What we can do is, either we may need to change the resource limit for FAILED_LOGIN_ATTEPTS attribute in DEFAULT profile, or create a new profile for that user with FAILED_LOGIN_ATTEPTS attribute value set to UNLIMITED. But for security reasons, we will not tamper the DEFAULT profile, which is not recommended too. Then let’s go for creating a new profile and assign that profile to the user.

Create a profile.


Profile created.

Assign the newly created profile to the user as default profile.

SQL> ALTER USER appusr PROFILE appusr_default;

User altered.

Unlock the user account:


User altered.

Now check again the status of APPUSR user.

SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPUSR’;
-------------------- -------------------- ---------------

Sabdar Syed,


Subscribe to Oracle FAQ aggregator