http://onlineAppsDBA.com

good one . Visit similar
http://atul-oracle.blogspot.com

 

hi buddy,i am very new in apps just put up in apps 3 days back. i searched ur site yesturday only.i dont knw about others bt its really a great help for me..i hope will serve the purpose for others also.i wish to tell u tht ur language is very much understandable so keep writing in this type.n one more thing i would like to tell tht u please provide some troubleshooting tact as u move day by day...
thanx once again

 

Hi Anonymous,
Thanks a lot for compliment. I have started writing a month back only after basics I am goign to pick each component one by one like WebServer , Concurrent Manager , forms ...and will update about troubleshooting there . In order to be a good troubleshooter basics are very important. So keep reading . Also write your name as well in comment as it brings more life to comment :) .

Visit my site at
http://teachmeoracle.com

 

Hi!

Atul,I am new kid on the block learning ABC of oracle Apps i Find your posting as first step to consolidate my information hunger.I appreciate your knowledge sharing Platform indeed a commendable job from all Quarter.keep this good work buddy.Guys like u a beacon in the midst of Sea of information.Precise ,Articulate!jus wonderful

Iam hearty in my approbation.....
Adios!

Andalib.

 

Andalib,
Thanks a lot for all those good words, amazed by your vocab.. :)

I'll try to put as much as possible regularly.

Atul

 

Appreciate your effort to help newbies.

I have downloaded 11i for linux from oracle website. I have a question can I install 11i from the hard disk without burning it into DVD's.
If I had to burn them then what content would go on which DVD, for example the download contains disks labelled Disk1...Disk11, how many disks should come on one DVD.

 

Hi Anonymous ,
Thanks for your compliment, I appreciate your comments but I'll be more happy if you update your name, it creates more intimacy with my readers.

Yes you can install directly from dump on your hard disk . Infact thats better way if you install it from disk ( called as staging area as you don't have to insert CD/DVD again & again).

Usually one DVD can store 3-4 GB data & I suppose if your total installation dump space is 12 GB , 3-4 DVD's should be enough .

Atul

 

Atul,
Thanks for all the support - I have one more question for you . I have the software downloaded to disk .. For the Ebsuiness suite install am I required to have 250GB of HD space?

 

Vidya,
I suppose 120GB would do for 11.5.10 . around 67 GB is enough for 11.5.9 vision.

Atul

 

Hi Atul,

Its me Megh,I had gone thru ur blog more than 10times and keep loking for performance issues / troubleshooting. Really a good work for the beginners.
I 'ld like to know the day to day tasks of Apps dba and critical issues and most common issues too.
Thanx for all the help once again.

And I hope ur blog too will be as famous as ASKTOM's oneday.
All the best.

Megh.

 

Megh,
Thanks a lot. I'll try to put more on performance slowly.

Atul

 

Hi Atul,

Its me Megh again.
I wanted to know what r the important configuration files, and also important tables in database that one has to know for Oracle Apps.
And can u tell us some important diagnostic scripts that Oracle is providing.

Thank u,
Megh.

 

Megh,
Nice to C ur questions and comments . Each component has its own configuration file, for Web Server Config files check

http://teachmeoracle.com/apc03.html for other components I'll update as and when I write about other components.

Few Important tables in apps are listed at

http://teachmeoracle.com/imptables.html

Diagnostic scripts I'll pick in my blog in future

 

Hi Atul,
I would like to know if we can freely download eBusiness Suite and what are the important Release Notes for Installation

 

You can download it from http://edelivery.oracle.com

For Installation Docs & release Notes check PDF mentioned in this post

 

Hi Atul,
I want to know ,can we load oracle 11i in a system having pentium 4 ,2.8 ghz Dual core and 1 gb hard disk. My system guy is not able to load . Can u give me a solution for it?

 

Yes, You can
What issues he is facing ?

Atul

 

hi buddy,this blog is very useful,
your articles are very easy to uderstand.the explanation provided is fantastic..keep up good work and please try to assemble these articles and provide book kind of thing.so it can be reached to more people.

what i mean to say is PDF kind of thing.

Regards,
Venkat.

 

hi atul,

i just started looking at your site,
it is very useful for the people new apps DBA.the articles very easy to undestand and the explanation is good.
please continue to explore new topics.

keep up good work.

Regards,
Venkat

 

Hi Venkat,
Thanks a lot for suggestions I have cook book for Apps DBA's in my mind (4-5)pages & soon you may seee this on site .

Thanks once again for your suggestions

 

Hi Atul,

I want to asked some questions about Oracle Apss :

1. When I setup fresh install there's one setting that make me doubt, it's about country specific functionalities. What would might be the problem and how to solve it assume that my country is not included in the list and I choose another nearest country?

2. How to configure PL/SQL Log & Out Directory. Just erase all directory links under utl_file_dir or just the tmp directory and then change to another directory we choose? I'd read oracle docs but still not clear on how to setup it.

3. About database initialization parameter, the installation doc from oracle wrote that : "The current init.ora settings allow for a total 100 connections. However , after the standard setup is complete, only a few users can be connected ... ." I compared the init.ora and init(SID).ora files from my vision machine and fresh install machine, other than directory links all are the same. So what caused only a few users can be connected and how do we change it because I don't know which one to change.

Thank you.

 

Hi Atul
very recently i have completed my oracle DBA and joined for Apps DBA in a institute but was not getting form where to get the material to read and how much to read , but your site helped me a lot to gather information and what to read and what not to.
Thnx for providing such a beautiful support.

 

Hi Atul, I am trying to install Oracle11 EBS on Windows vista. Ofcourse I am beginer. During rapid install, after the system check it gave me one "x" result i.e. system could not find the hard drive(cmd.exe command) where I have Drive F: as an external drive and path during the load is F:\Oracle.

And few with "!" result: it could not find the VC++ as I loaded Visual c++ 2005 on to my c: drive. VC++ is loaded automatically with out giving me any options to select directory. So the system loaded into default directory to "C:\program files\microsoft visual studio\....." (which contains spaces in path??). One more is "System Compatibility", I think it is because of Vista operating system. Can I ignore this item if not What I need to do?

 

Hi Atul, I am trying to install Oracle11 EBS on Windows vista. Ofcourse I am beginer. During rapid install, after the system check it gave me one "x" result i.e. system could not find the hard drive(cmd.exe command) where I have Drive F: as an external drive and path during the load is F:\Oracle.


And few with "!" result: it could not find the VC++ as I loaded Visual c++ 2005 on to my c: drive. VC++ is loaded automatically with out giving me any options to select directory. So the system loaded into default directory to "C:\program files\microsoft visual studio\....." (which contains spaces in path??). One more is "System Compatibility", I think it is because of Vista operating system. Can I ignore this item if not What I need to do?

Thanks for your help.
Veerakumar

 

Installing apps on windows is always pain . Try skipping compatibility issues

 

Hi Atul.
Thanks for your guidence.I have just started Apps DBA learning.
Looking forward for your kind help in future.

 

Hi can anyone post me screen shots of Oracle Apps 11.5.7 installation steps,I just learned oracle apps 11i technical,but i want to install on my own in my pc to have practice,ravikishore.k1@gmail.com

 

Ravi,
This is same as 11.5.9 or 11.5.10 so go for it

Atul

 

Hi Atul,

Great Job!
One question for you. I am going to buy a system to practice oracle 11i installation. Can you recomend minimum RAM required for this purpose? I'll have 100GB hard disk which I think should be okay.

Thanks,
Amit

 

Amit,
for 11i 100GB is enough for RAM I would suggest you go for 1 GB (Though I installed with 512 MB as well in past)

Atul

 

HAI THIS IS RAM FROM HYDERABAD...IAM GLAD TO THE MEMBER OF THIS SITE..AND IAM VERY HAPPY TO MEET SUCH A NICE PERSON LIKE YOU.....I WANT TO KNOW ...CAN I INSTALL ORACLE APPS TECHNICAL SOFTWARE IN MY OWN PC..AT HOME....IS IT POSSIBLE FOR WINDOWS 32 BIT WITH 200 GB HARDDISK AND 512 RAM.....PLZ LET ME KNOW AND HELP ME IN THIS .....IAM A B.TEH HOLDER PASSED OUT IN 2005 AND DID ORACLE AND D2K COURSES AND ALSO ORACLE APPS TECHNICAL ...SO THAT I WANT TO MAKE PRACTICE AT MY HOME...PLZ SEND ME DETAILS TO RAM_RAJUN@YAHOO.CO.IN OR HERE IN THIS SITE AT LEAST

 

Yes Ram, its possible to install on above configuration, kindly follow PDF guide mentioned in above post.

 

can u say me how to write a installation script for Oracle App Server in Windows?And i am new to scripting.

 

Hi atul

Very usefull web site keep it up.


Thanks
Selvam

 

hi atul, i feel very happy for you. this website is really very helpful for all apps dba aspirants who are in apps and 4 1 who wannts to mould their careers into apps dba.

 

These comments have been invaluable to me as is this whole site. I thank you for your comment.

 

Yo... APPS ATUL .. It is just sublime yaar.. It is really nice to see such a web site where even people who are novice to Apps can Learn and Excel.. Thanks a TON for sharing these useful information with US..

I'm basically CODE - HATING S/w Engr Turned Oracle DBA.. Now slowly moving into APPS..

Thanks once again and looking forward to explore your APPSBANK further..

Warm Regards,
Sundar.N

 

is it possible to install a multinode instance with apps tier on different platforms?both R12 and 11i?i mean con, admin on HP-PA and web,forms on say solaris.

 

Yes, it is possible to install apps 11i or R12 on multi node with different O.S. this is called as split configuration.

 

This comment has been removed by the author.

 

i thought split configuration is apps on 1 platform and db on a different platform.please correct me if i m wrong.

 

hi ,

Has anyone installed oracle apps 11i on windows vista succesfully and use it? What is the best Windows OS to have oracle 11i? please suggest me..

thanks

 

Hi Amit,

which window version is the best for apps installation for personal practice.

is it possible in windows professional?

regards
Abhaya

 

Hello Atul,

I am new to Oracle Apps but not to Oracle or Linux. But I am failing to install the oracle Apps on Linux installed on vmware. rapidwiz fails while performing system checks.

It errors out with - Unable to create directory with proper privileges

Kind of surprising, mount point exists and I could create a directory and file too.

Could you please throw some light on this.

Thanks in advance

BTW the information provided in the web page is very helpful

Thanks
Arun

 

Hi Atul,

I no need to say once again that this site is very very good the responce it self is saying that bcz i really trying for this same information today very luckely i got this in my brousing keep it up and try to share more these kind of informationand one more thing i needed your help can any one tell me how i can down load oracle applications 11i, financials and logistics modules from this sits http://edelivery.oracle.com/ i mean how to navigate i dried but i couldnt succeded. i want to instal for practice purpose if not this site is any other site is there that i can download .i am expecting any one from this site

Thanks and regards
Dona

 

Dona , We have moved to new site http://onlineappsdba.com/index.php/2006/07/30/installing-oracle-applications-become-apps-dba-ii so I'll respond to your queries in new site.

 

hai i am one of the user to access this sight to gain knowledge ,
need help to do fresh installation of apps on linux

 

Check link mentioned in above comment

 

Hi Atul,

Its been great reading this site. I didnt even have 1% of apps knowledge before this. But after reading this, i can proudly say that i m on my way to be an Apps DBA :)

Atul, I would like to know something about applying patches. How do i patch an environment after downloading the patch? For eg: In RDBMS, for Oracle Home, we use opatch utility. But how is it done it Apps???

Regards,
Sreejish Kumar P

 

Hi Atul,

Its been great reading this site. I didnt even have 1% of apps knowledge before this. But after reading this, i can proudly say that i m on my way to be an Apps DBA :)

Atul, I would like to know something about applying patches. How do i patch an environment after downloading the patch? For eg: In RDBMS, for Oracle Home, we use opatch utility. But how is it done it Apps???

Regards,
Sreejish Kumar P

 

Hi Atul,

Its been great reading this site. I didnt even have 1% of apps knowledge before this. But after reading this, i can proudly say that i m on my way to be an Apps DBA :)

Atul, I would like to know something about applying patches. How do i patch an environment after downloading the patch? For eg: In RDBMS, for Oracle Home, we use opatch utility. But how is it done it Apps???

Regards,
Sreejish Kumar P

 

iam installing oracle 11i(10.5.9) aps on window xp ,i have installed all the componentssuch as cygwin ,vc++,perl gnu make but still errors are coming ,i have even taken help from oracle mealink but the steps they are saying i have performed all that but still the result is not there now iam totally confused .i think i am not downloading the tools from the exact site

metalink only state to download cygwin ,gnu make etc they are not telling the exact source code


can u help me
please tell me or mail me the exact steps for installing aps on windows each and every sites from where we have to install the tools and how to apply them , im in trouble

 

Do you need to show your photo on every page? Your shirt is making my eyes go funny!

 

:) Photo is coming from template and hence on every page.

 

Hi Atul,
you have posted a real good step by step procedure to implement RAC and also Apps. I have just started Apps 11i. I see forward to complete it and ask for further help.
Its of great help to go through these blogs Im really very gratefull to these docs
Rgds
Zeeshan
getzeeshan@gmail.com

 

i am trying to install EBS on 2 win2k3 machines as a multinode config using 1 for app and 1 for db. the DB install went fine but the app install does not allow me to use the congi file created by the db installation and errors out with error:

RW-20019: No install actions have been found for this machine. Continue on to other uninstalled machines in your configur
ation, or fix the configuration file to correctly call out this machine.

the names in the file seem to make sense and correspond with the hostnames of the servers

any advice?

 

Check Server Name on machine if properly configured or not

 

Hi,

I am trying to install Oracle Apps R12 on Linux VMWare machine. After completing last steps it says

RW-20019: No install actions have been found for this machine. Continue on to other uninstalled machines in your configur
ation, or fix the configuration file to correctly call out this machine.

and comes out from installation.

Please suggest.

 

Hi Atul,

I am basically a sql & pl/sql developer since 5 yrs. Now, recently I started to learn about Oracle Apps. Your website gave me clear understanding about the difference between technical and functional. I am learning Oracle apps on my own. I thought of installing oracle 11i apps on my laptop which has config of 160 gb hdd, 1gb ram and windows vista as OS for learning purpose. I have downloaded that software from oracle website.I am more interested for Oracle HRMS technical could you please suggest me whether Oracle 11i installable on windows vista.

 

Hi Atul ..
Iam a beginer of Apps dba.I frequently check ur site , it is very helpful.
we resolved some issues after looking into site n forums.
thanx a lot.......

 

Dear Friends can anybody guide me How to install Oracle application 11.5.10.2 on Window vista..
Rahul

 

Hi guys,
am giri
i installed apps 11i successfully, i wrote one procedure

create or replace procedure pro1(errbuf out varchar,rectcode out varchar) is
begin
fnd_file.put_line(fnd_file.output('hai welcome to apps'));
end;

i registered in apps after subimiting this concurrent program i am getting one message in log .

"FND_FILE package FAILED to create TEMP file"

can give the solution to this problem.

Thanks & Regards
GIRI

 

Hi Giri,

Please check the application user has write permission on /tmp dir or free space on the same dir.

Hope it will help;

regards:
Rajesh

 

Hi Atul

I have started reading your blog on becoming an apps DBA and so far it is awesome. I am new to this game and have become stuck at the installation stage. What do i install, the Oracle download page has about 40 downloads. Do I need to download each and everyone.

Your help will be much appreciated.

Thanks Sat

 

Hi Atul ,

I am Oracle DBA looking to become apps 11i DBA , i am looking for consultant , who can charge me and give me web ex training for oracle app 11i .

Sudhir
1-416-274-8471

 

Have you ever restarted the server after installation? If yes, then did you find all the services up and running? If yes again, how do you do that, what are those binaries which one needs to run or put in /etc/rc*.d so that next time somebody doesn't suffer as I am suffering right now.

 

HI
Nice to be hear.I am installing Apps R12 on Centos 5.2.I have updated all the packeges and the specific kernal.When i want to run the perl script for staging it says permission denied.Although i have a user called applmgr.Can u suggest what could be the reason.Please list all the possiblities.
Thanks
Salman

 

Its very usefull site. Please keep it up.

Thanks,
Mohammad

 

Thanks,

I installed oracle 11i application on a single node and i got this error:
command : d01/oracle/proddb/9.2.0/temp/PROD_abjdb/adrun9i.sh
RW-50004.

Regards,

Fummy

 

Hi Atul,

please where can i download rpm such as ar, gcc, g++,ld,ksh,make, x display server for oracle 11 i installation on REd hat 5 linux,

Regards,

Fummy

 

Hi,

i am using oracle 11i apps. i have to receive mail from app server automatically if concurrent manager or workflow manager is down . plz help

Thanks

 

THis is a very good article, I am planning to convert my Windows XP laptop to Linux and then install R12 on it. Hoping I shall gett all the necc info from this blog. Thank you and keep up the good work

 

I really like your blog and your to the point explanation..I owe you a lot thnx!

 

Atul,
I am new to apps dba and trying to install 11.5.10 EBS on a linux box. Is there a way to install 11i ebs with 11g db and 10g apps server instead of 9i?
Mike