RSS Feed (xml)
My daily Check list
Every day at the morning i do tow things
- Oracle applications and database check list.
- Oracle applications community check list.
In the first check list (apps and db) check list I check for the following
Check Apache server is up
Check Discoverer processes
Check Concurrent manager is up
Check forms is up
Clear tmp logs
Check disk space
Check memory usage
Look for new entries on alert log file
Verify success of database backup
Verify archive logs
Verify that all instances are up
In the second check list (apps community) check list I check the following websites and email lists
Oracle Apps Forums
Steven Chan an Oracle insider
Atul Become an Apps DBA
Sam Apps DBA Blog
Anil Apps Techno Functional Blog
I also keep monitoring the oracle-apps-l@Groups.ITtoolbox.com, oracle-db-l@Groups.ITtoolbox.com email lists.
If someone can add more resources please leave your comments
Oracle is not Magic, it just takes years of experience and doing my check lists ;-
Wednesday, July 9, 2008
My Daily Check list
Apps 11i Keys shortcut
Ctrl + U Update Record
Ctrl + B Block Menu
Shift + Page Down Next Block
Shift + Tab Previous Field
Down Arrow Next Record
Up Arrow Previous Record
Monitor your apps performance
I came across note 244040.1 the note name is (Recommended Performance Patches for Oracle E-Business Suite) this note states the following (This document contains a list of performance patches that E-Business Suite development recommends customers to apply)and have the following fields
Product: FORMS
Bug#: 2283443
Description: Menu toolbar icons not picked up from cached jar file.
Affected Versions: Regression in Forms Patchset 8 (Forms ver. 6.0.8.17).
Fix/Workaround: Fixed in Forms Patchset 10 ( Forms ver. 6.0.8.19.1) and higher.
Symptoms/Comments: Access log file of the web listener will show icon gif files being downloaded from the media directory for each Forms application startup.
I think apps dbas should monitor this note once in while so they can stay updated incase any patch related to apps performance needs to be applied.
Do you need info. about R12
As the day of lunching Oracle Apps R12 is getting closer I came across this document on metalink (404152.1) (Release Content Documents for E-Business Suite R12)
This document contains links to the published Release Content Documents for Oracle Applications, E-Business Suite Release 12. The RCD or Release Content Documentation communicates information about new or changed functionality in the specified release of the Oracle E-Business Suite. Existing functionality from prior point releases is not described. Use this document as a launchpad for R12 RCDs.
It includes info about all the Product Families on Oracle Application R12 so check it out
Ready for Apps R12 go and download it now
Congratulations apps dbas and functional people oracle e-business R12 is now available for download at http://edelivery.oracle.com/ the version available is for AIX, hp-ux itanium and Linux x86 the rest of other os will be available soon,
My friend ghassan is downloading the Linux version and after that he will download the hp-ux version for me (he has 2M ADSL connection). i will post incase i face problems during the installation (i will for sure face some:-)
Anyway people you need for the vision version around 160 GB.
(Metalink Note 394692.1) and at Check the documentation library at Oracle Applications Documentation Resources for Release 12oracle website
Enjoy
Fadi
Apps 11i with Windows vista
(just an update, As a workaround for IE on Vista issue, Apps 11.5.10 works fine on Vista with firefox)
Our network department has a plan to go with windows vista and they asked me to open a TAR with oracle to get their official response.
Below is oracle response
QUESTION
=========
Summarize customer's question here. One question per heading.
Unable to connect from MS-Vista Client on e-Business suite 11.5.10
RESEARCH
=========
Steven's Blog
ANSWER
=======
Currently Jinitiator is not certified on MS-VistaDevelepemt is working on it but we don't have any ETA for it So, please don't upgrade to MS-Vista Sorry for that
KNOWLEDGE CONTENT
=================
Platform / Port Specific? = Not certified for the moment
Easy tool for building ER diagrams
Sunday, March 25, 2007
Starting on apps field (my personal theory)
I receive this question (how can I start on apps technical filed? How can I be an apps dba?...etc)Well I am going to give some hints from my point of view, those hint may not be the ideal therefore any reader of this post can leave any suggestions to make the steps better and easier.
-First of all you need to have instance (vision demo database) so you can test things on it, by this I mean that you should read the installation guide which will guide you on how to build the stage area and what are the pre-requisites (hardware/software) for the installation and the installation process using rapidwiz
The installation will not finish successfully form the first time unless you are so lucky, and from the installation you will get a good experience.
-after the installation you need to understand the applications file system structure.
- also you have to read oracle applications concepts guide.
Then you can start reading about applications administration and maintaining procedures, you need to understand both adpatch and adadmin.
- By now if you manage to install oracle applications and to apply patches on it then you are in the right track.
-then after that you need to read about backup and recovery.
-you need also to monitor oracle forums and oracle blogs.
-keep metalink as your friend.
-when you see an interesting issue in forum or blog try to track it and maybe try to solve it if you can this will give you an add experience.
-try to participate on oracle applications email lists like ittoolbox …etc.
-try to get oracle applications administration books like dba filed guide and others.
finaly keep in mind that (no pain no gain)
Please leave comments on what you think the best way to be an apps dba
Fadi P.S all the guides mentioned above can be found under (for apps 11i)
Small issue after cloning
After I cloned my production system I faced the following error when I run adadmin or adpatch
"
AD code level : [11i.AD.I.4]
The Applications System names per the APPL_TOP and the database are different.
Applications System name per the APPL_TOP: clone
Applications System name per the database: prod
If you continue, the Applications System name per the APPL_TOP will be ignored.
Do you wish to continue [No] ?
"
To solve it I had to run the following update statement on my clone database
update FND_PRODUCT_GROUPSset APPLICATIONS_SYSTEM_NAME ='clone' ;commit;
Hope that helped
fadi
Workflow again
-an update on this we applied the patch and it solved our issue
Some end-users open cases with the support claiming that they don’t receive all the email notifications related to some of their purchase orders, I thought that maybe their email were spelled wrong or maybe they changed their email preference so they don’t receive an emails at oracle application level like the last time, I checked both but none of the above applies on the case so I had to check an one of there POs on the wf_notifications table, I run the following query
select * from wf_notifications where subject like '%200700001052%'
and the email_status value was ERROR so I took the notification_id and search for it in the emails that were sent by the notification mailer to the sysadmin and I found an email with the following content
"Event Error Name: -20001Event Error Message: ORA-20001: Oracle error -20001: ORA-20001: APP-FND-02500: Error occurred during product initialization for MO when executing 'begin MO_GLOBAL.INIT; end;'.SQLCODE = -20001 SQLERROR = ORA-20001: APP-FND-02902: Multi-Org profile option is required. Please set either MO: Security Profile or MO: Operating Unit profile option.has been detected in FND_GLOBAL.INITIALIZE."
I check that error on metalink and I found 5 notes saying that I must apply patch (5209533) p5209533_11i_GENERIC.zip
I will apply that patch on my test/clone instance this weekend and I will update you if the issue was resolved.
For more info you can check note (393847.1) or search for the error/patch
Hope that helped
Fadi
Oracle support day in amman
Been busy lately, yesterday I went to oracle support day at Hayyat Amman. It was presented by two oracle support managers, wael sadaqa from Oracle dubi and jafar al omary from Oracle Saudi Arabia, they presented how to work effectively with support and the escalation process and they also stressed on using oracle diagnostics and configuration support manager. They mentioned a little bit about R12 upgrade process and they mentioned that people who are doing upgrade will get more attention from oracle support.
It was good and helpful, the presentations can be downloaded from here
Fadi
An update on this (25-jun-2007)
The presentations can be downloaded from here
Support forum,
I am thinking of opening a forum here to share support cases with all users, even though I guess oracle forums a great place to post problems and to get answers quickly, I will try to open my own forum for 3 months period if it was successful I will keep it other wise I will stick with oracle forums.
Suggestion are welcomed
Fadi
Multi to Single node Cloning issue
A friend called me yesterday he was facing the following error when he tried to clone from multi node to single node cloning
"Could not create the high water mark manifest..Please re-run the program to create the manifest required for merging APPL_TOPs"
He faced this error after he run the (perl adpreclone.pl appsTier merge) and then he cancel it while running and then he run it again on the other node then he recived this error.
According to metalink notes 372819.1 and 372758.1 he should reapply the AD.I.x patch again to the node and then run Maintain snapshot and then run the perl adpreclone.pl appsTier merge again, we did so and every thing went fine.
Hope that helped and by the way this will be my last post before my Eye LASIK Surgery which is scheduled tomorrow morning at 8:30 a.m.
Fadi
ATG Rollup 4 and my Custom schema
After Appling ATG Rollup 4 patch no. (4676589) on our HP-UX server successfully we start to receive the following error only on our customized schema but not on the standard schemas.
The error was showing when we try to run any procedure from this customized schema we keep getting the following even though it used to work fine before the patch
"
ORA-00942: table or view does not existORA-06512: at "APPS.FND_CORE_LOG", line 23ORA-06512: at "APPS.FND_CORE_LOG", line 158ORA-06512: at "APPS.FND_PROFILE", line 2468ORA-06512: at "APPS.XX_PACKAGE_PA", line 682ORA-06512: at line 4
"
After checking on metalink we got a hint from note 370000.1 the note dose not apply for the same case but it did gave us the hint and the solution was as follow
connect as APPLSYSGRANT SELECT ON FND_PROFILE_OPTIONS TO SUPPORT;GRANT SELECT ON FND_PROFILE_OPTION_VALUES TO SUPPORT;
Support is my customized schema Custom
Have an error free day ;-)
fadi
How we solved a (ORA-02049 Timeout: Distributed Transaction Waiting for Lock) on our Apps Customized module
We have a customized Point of Sale module that is integrated with our Apps standard CRM and financial modules; we faced a serious issue on this customized module that is when users are trying to sale through this module they receive an ORA-02049 Timeout: Distributed Transaction Waiting for Lock, which require them to keep trying until they make the sale. This error used to show on daily basis on the peak hours only but we could not tell what the cause of it, simple search of the error on metalink return note 1018919.102 that advices that we should increases the distributed_lock_timeout value in the INIT.ORA file the default value was 60 seconds so we increased it to 300 seconds even though we don’t have any distributed transactions on the system all the transactions were local. We restart the issue and the problem became worse because now the end users have to wait for 5 minutes (300 seconds) before they receive the error message (ORA-02049) and because of that we had to set the value back to 60 seconds.
After that we tried to trace the error using different event trace levels but with no luck we were not able to determine what is causing the error.
We thought that it’s a database bug and oracle advised us to upgrade the database from 9.2.0.5 to 9.2.0.7 we did that but still the issue is there.
After a month of investigation/tracing and snapshot of when the problem is happing we managed to find out what was causing the problem. It was a bitmap index that was built on the table we were trying to insert data on.
When an end user was trying to sale without committing his transaction for some reason and at the same time another end user tries to sale he will receive the error message and a lock on the table happened and the error pops-up.
We solved the issue by dropping the bitmap index and creating a normal b-tree index even though the column has only three distinct values.
Sharing is Caring 3
Oracle wiki
is the new site from oracle where members of the Oracle community (employees and non-employees) collaboratively create and share content about Oracle-related subjects they're passionate about. http://wiki.oracle.com/
See you there
Fadi
Oracle EBS R12 beta exam are you ready
I received the following email from oracle certification program
“Oracle University is pleased to announce the availability of the following new Oracle E-Business Suite (R12) certification exam in beta version:
Oracle EBS R12: Install, Patch and Maintain Applications [1Z0-238]
This new exam is required as part of earning the new Oracle EBS R12 Applications Database Administrator Certified Professional certification.
By participating in this beta exam, you have the opportunity to provide the Oracle Certification program with feedback about exam content which is integral to the process of exam development. We depend on the contributions of experienced professionals and developers as we continually improve exam content and maintain the value of Oracle certifications.
Beta exam period runs:
January 03 – April 04, 2008
These beta periods are subject to change, please check the exam pages for the most up-to-date information
“
Good luck with your exams
fadi
Hail the Champions
I participate recently in a post from our famous Bolger OCP advisor, it a nice blog that help apps community with info. About Apps certification.
I am trying to be active again.
You can check his post here.
Good luck with your certification
Fadi
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