Oracle APPS R12 File system structure

In this blog I will show you the new R-12 file system tree structure.

As you can see in above tree structure, we have db, apps and inst as top level dir's

Under DB we have tech_st which is DB home and apps_st which holds DB datafiles.

Under apps, again we have tech_st which holds 1012 and 1013 homes, and apps_st holds APPL_TOP and OAD_TOP.

And finally inst which mainly stores instance specific files including runtime files, log files and configuration files

Note: If image is not been displayed fully, you can save the image to your desktop and open locally to see the full size image.

Using OEM, want to know database growth pattern of last one month/year ?

Here are the steps to know Database growth pattern for last one month/year using OEM

1) Login to OEM and Click on the Reports Tab
2) Navigate to Reports-->Storage-->Oracle Database Space Usage path and Click on Oracle Database Space Usage link.
3) Select the Target database and here we are getting Oracle Database space usage for last one Month.
4) Also we can get one year Database growth by setting Set Time Period Button.
5) Also we can find Oracle Database Tablespace Monthly Space Usage by Navigating Reports-->Storage-->Oracle Database Space Usage path and click on Oracle Database Tablespace Monthly Space Usage link.

I hope this helps DBA's to plan for future disk space requirements.

Using OEM, want to see the list of tables to reclaim some space in a database and chained rows?

Steps to find Object Fragmentation and Chained Rows in a Database is:

1) Login to OEM and Click on Targets tab and Choose Database sub tab.
2) Click on required database and follow the path under Space summary >Segment findings.
3) Click Configure tab on right side. Provide Reclaimable space(%) ,Reclaimable Space(MB), Row Chaining (%) and Click on add button and select Tablespaces to be checked for row chaining.

For Row Chaining, the navigation path is
Reports->Storage->Oracle Database Space Issues->Segments with Row Chaining Issues

For Objects Fragmentation, the navigation path is
Reports->Storage->Oracle Database Space Issues->Tablespaces with Reclaimable Space

Oracle Apps R12 Self Study quick guide

Are you an Apps 11i DBA and want to learn R12?
Here are some of the things you can try out your self and get confidence of working on R12

* Install R12.5 (HRMS + FIN)
* Languages: US and F
* Setup Workflow mailer
* Upgrade Discoverer version
* Apply latest CPU patches
* Apply latest High Priority patches
* Upgrade to latest certified DB version
* Install XX_TOP
* Custom Standard manager for SYSADMIN requests
* Configure BPEL
* Configure Database Data guard (Optional)
* Configure R12 Monitoring through OEM
* Configure printer
* Configure iRecruitment (concept only, using virtual servers, host entries etc)
* Configure DBVault
* Configure UPK

These steps are not in sequence, so you have to apply some logic before you do it.
Also you have to search Metalink / OTN / other sites to get the details steps for one major step.
And, lastly, dont forget to take backup before any major change you making.. :-)

After doing all this, I am sure you can support R12 with confidence..