I have been tagged

Gareth Roberts tagged me in the current round of OraBlog tag, you can check the rules.

Below are the 8 things you might not know about me:

1- Athens, Greece, Masters: I am currently doing my masters in managing business innovation and technology thurogh a scholarship here in Athens, Greece.
2- Having to change your job is a good thing: I started my oracle career after I had to change my previous job (well my old manager claims that my work was done there and the project i was working on was over, actually it turns out to be a good thing after that I changed my career path from Microsoft to Oracle)
3- Travel: I like to travel a lot and I am welling to take any chance to visit any new country/places.
4- Documentary: I am a T.V documentary addict; I can watch any type of documentary but prefer political ones.
5- Jogging: I jog 3-4 KM every other day I like jogging a lot.
6- Single: well still I am currently single. (Marry to oracle apps I guess ;-).
7- Reading: currently I am trying to get used to reading I have this book called (the management bible by John Wiley and sons) it’s a good book I guess every manager should read it, although I am not a manager yet but be prepared always. You never now what will happen next.
8- Sky is the limit and think big: Sky is the limit is my personal message at MSN messenger, and think big will be my next personal message at MSN.

My turn in tagging, I will tag.
OCP Advisor
Syed Jaffar Hussain
Lutz hartmann
Mark Rittman
Grant Ronald
Senthil Rajendran
Vikram Das
Famy Rasheed

have a nice tagging

fadi

Questions needed answers

Dears apps dbas,
I hope thing are well with you, I received the following questions from a friend of mine and I promised him to answer them and wanted to share them with you maybe you can help me answer most of them.
Appreciate your help.

(we have some of the answers by dave (thank you) in the comments and all of them under http://www.teachmeoracle.com/forum/viewtopic.php?t=4102)

1. How do we know that particular instance is cloned or normal installed?
2. How can you know that how many modules are already implemented in this instance?
3. How to enable archive log without shutting down your database?
4. How can we know that whether we already applied latest AUTOCONFIG patch or not at our instance?
5. Is this possible to clone a database from hotbackup? If yes plz tell how?
6. Suppose your database size is 2000GB now you want to clone a particular one datafile or tablespace. Plz tell how co clone a datafile or tablespace?
7. You are applying a patch but suddenly it HANGS but log file didn’t showing any error what should be the reason for that HANG?
8. How to clone from multimode to single node?
9. How to apply patch on forms/reports server?

Thanks again for help
Fadi

Sharing is Caring 4

Oracle Community
it the new site for oracle social networking, http://www.oraclecommunity.net/to make oracle community even smaller.

enjoy
Fadi

Add new node to apps 2

Please read http://oracle-magic.blogspot.com/2008/02/add-new-node-to-apps.html before reading the steps below,

After finishing configuring the clone instance by running adcfgclone.pl I had to run the adaddnode.pl script according to note 464018.1.
While running adaddnode.pl I faced the following error
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 16

I followed note 394615.1 to solve it and after I did the steps in the note I run adaddnode.pl again and I faced error related to AD_TIMESTAMPS_U1 I checked on metalink but I could not find anything then I search on google and found post by dave http://newappsdba.blogspot.com/2006/09/dont-hit-ctrl-c-while-running.html from his post I took a backup the ad_timestamps and then truncate it after that I run adaddnode.pl and it completed successfully.
Then I updated the xml file to have only the forms and web servers running on this new node following the same note 464018.1 I run autoconfig the start the service on both nodes a now able to access both nodes.

What I want to do now is to configure web cache as load balancer also I want to implement Step 2.4.1.2. Implement Forms Listener Servlet Support from note (Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i) Note:217368.1 in order to have Forms Server Load Balancing, so when one form server go down in one node users will be connect to the other forms node.Because the current configuration if I am connect to webnode1 and forms on that node is down I will not be able to connect to forms and I will receive an error but if load balancing is implemented it will take me to the other working forms server node.


Fadi

Soft-skills (not oracle related post)

Dears,
As a part of my study in my masters program we have to create a blog related to e-business course and it must be evaluated and one of the evaluation criteria is the number of users accessing it and comments so if you have free time can you access it and leave comments the blog has a good and helpful information.
the blog talks about soft skills and how they are important in our life check for example (speed reading post and managing a busy schedule post and many others)
please check and leave comments if you can
Thank you
Fadi

Cloning 11i with 10g database (you may need a patch

I faced the following error while configuring database when cloning apps 11i with 10g database and it happens directly after entering the path of the third data_top (by the way the script will always assume you have 4 data_tops even if you have more/less data_tops)

StackTrace:
java.lang.NullPointerException
at oracle.apps.ad.context.CloneContext.createContextFileForDbhomes(CloneContext.java:2816)
at oracle.apps.ad.context.CloneContext.getInputFromUsers(CloneContext.java:1485)
at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:627)
at oracle.apps.ad.context.CloneContext.main(CloneContext.java:6085)

On metalink there was the solution on Note:427981.1 Subject:RC-50004 When Specifying DATA_TOPS While Cloning a 10.2 Database
And the solution is to apply a patch with a version of CloneContext.java above 115.203. the following are possibilities patches

Patch 5473292, Patch 5732291, Patch 5604818, Patch 5456078, Patch 5474116

Well I did not do that because this means that I have to apply the patch and recopy the database, which take time.
So I recreate the database manually using control file. And when try to open the database I issued
SQL>alter database open resetlogs;
It failed with the following
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/ora_dev/data/system01.dbf'
Even though the database was completely down when I copied it I faced this error the good thing is 2 days ago I was reading bas post http://basklaassen.blogspot.com/2008/01/recover-database.html
I followed the steps for recovery and provided the path to my online log files and the recovery completed successfully.
Next down time for the production database for sure I will apply one of the patches above.

Hope that helped
Fadi

Oracle BI Discoverer 10.1.2.3 Release Details

Oracle Business Intelligence Discoverer 10.1.2.3 is released in mid March 2008. This is available on base platforms Windows and Solaris. It is also available primary porting platforms (Unix flavors) as well (Linux, HPUX, HPIA). Discoverer 10.1.2.3 is the third production patch in the series of 10.1.2 release train. And the latest patch can be applied over any 10.1.2.x instances, 10.1.2.0.0, 10.1.2.1.0 and 10.1.2.2 releases.

Highlights of Discoverer 10.1.2.3 release

• Discoverer Integration with Oracle BI Publisher
• D4O Enhancements
• Other enhancements

Discoverer integration with Oracle Business Intelligence Publisher

The integration of Discoverer with Oracle BI Publisher (previously known as XML Publisher) was delivered as a one-off patch in 2007, and is more widely available with 10.1.2.3 release.

Oracle BI Publisher is an enterprise reporting solution to author, manage, and deliver all types of highly formatted documents eliminating the need for costly point solutions.

Discoverer integration with Oracle BI publisher has the following benefits

· Rich formatting capabilities

o Use Oracle BI Publisher template builder for Microsoft® Word to use the formatting features of Microsoft Word to format content.

· Rich layout capabilities

o Use Oracle BI Publisher template builder for Microsoft Word to use the layout features of Microsoft Word.

· Multiple templates per Discoverer worksheet

o Layout templates can be built using familiar desktop applications such as Microsoft Word and Adobe Acrobat®. Oracle BI Publisher plugins are provided to help the report designer to build the layout they want in their favored application.

· View as PDF, RTF, XLS, PPT, XML

o Oracle BI Publisher is able to generate multiple output formats from a single data source and template in multiple formats.

· Schedule and distribute to thousands of users

o Schedule frequency (Once, daily, weekly, immediately) and delivery destinations (Email, FTP, WebDAV, FAX, Printer) can be configured in Oracle BI Publisher.

· Analyze and refresh Discoverer data in Microsoft Excel®

o Relational and OLAP data can be pulled into Excel from multiple data sources for analysis

This integration requires Oracle BI Publisher 10.1.3.3.0 or above. Since Oracle BI Publisher is also available with Oracle Business Intelligence Suite Enterprise Edition, version 10.1.3.3.0 of Oracle BI EE can also be used.

More information about Oracle BI Publisher can be found at:

http://www.oracle.com/technology/products/xml-publisher/index.html

D4O Enhancements

Advanced Calculated Members in Discoverer OLAP

Building on the introduction of calculated members functionality in the 10.1.2.2 release of Discoverer, advanced calculated members can be created with the new calculated member editor in the 10.1.2.3 release.

Easier Sharing of Workbooks

To increase the usability of sharing workbook functionality a share button is provided on the Open workbook catalog dialogue. This benefits from the earlier sharing of workbooks through copying the link in to shared folder.

Support for Offset based calculations

Collpse all , Expand all

Other Enhancements

• Scrolling behavior in Discoverer Plus [5450764]
• To enable selection of Discoverer Viewer data into clipboard
• Defining rows and columns in Discoverer worksheet portlet when called from list of worksheets portlet
• Define amount of databody to show in wide crosstab reports [5117216 ]
• New option to enable page navigation in Discoverer Viewer

Discoverer 10.1.2.3 can be downloaded from metalink

www.metalink.com Patch # 5983622

Important Notes

• Discoverer 10.1.2.3 does not include the cumulative patch releases CP4, CP5 and CP6. Customers are not encouraged to use discoverer 10.1.2.3 if they have applied any of the aforesaid CPs . We are building a combined CP(CP4+CP5+CP6) over 10.1.2.3 and will be released shortly.
• Discoverer for OLAP (D40) is not certified against Oracle 11g database
• Spreadsheet addin not available on Microsoft Windows Vista