The primary tool for checking for corruption in an Oracle database is DBVERIFY. It can be used to perform a physical data structure integrity check on data files whether the database is online or offline. The big benefit of this is that DBVERIFY can be used to check backup data files without adding load to […]

Popularity: 4% [?]

This post covers list of software required to install Oracle Applications R12/12i (E-Business Suite), including link to download required software (vc++, make, gnu, cygwin, Windows Server and Apps R12/12i).
Steps by steps installation of Oracle Apps R12/12i on windows coming soon

Operating System and required Utility
1. Windows Server 2003 (all edition) is ONLY supported version for installing Oracle […]

Popularity: 5% [?]

We are pleased to announce our new online Apps DBA training (11i & R12/12i) starting on 19th July 2008. This course in available via web conference (weekends or late evening) with hands on exercise on installation/patching/cloning.
Course content for Training:
Day 1
-Oracle Applications Architecture
-Oracle Application File systems-Operating System Configuration-Oracle Application Installation-Oracle Application Installation Troubleshooting-Log file locations-Login and […]

Popularity: 5% [?]

Oracle Advanced Supply Chain Planning (ASCP) is a comprehensive, Internet-based planning solution that decides when and where supplies (for example, inventory, purchase orders and work orders) should be deployed within an extended supply chain. This is the supply planning function. Oracle ASCP addresses the following key supply planning issues:
• How do I plan my supply […]

Popularity: 7% [?]

Its time to crack 11i certification (check our previous post here) and rush towards 12i Certification.
       I believe basic knowledge (which script does what, which table is useful for what purpose and How to use the ad* utilities….) is enough with some hands on to clear Oracle Apps DBA Certification Track.
so let’s start with some basic […]

Popularity: 8% [?]

Servers: Indapp001 and Usaapp002
To do: To mount “/export/home” of Indapp001 on Usaapp002.
Issue the following commands on Indapp001:
1. Share the required file system “/export/home” of Indapp001.
Start the nfs server on Indapp001.
# svcadm enable network/nfs/server
2. Share the “/export/home” of Indapp001 for everyone on the network.
#share -F nfs -o rw -d “home dirs” /export/home
Issue the following commands […]

Popularity: 7% [?]

We need to change apps password manually, if you forgot and can’t check it in wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg .
Please remember that the APPLSYS and APPS passwords always
have to be the same. Always change both at the same time. When changing these
passwords, it is important to change the APPLSYS password first and the APPS later. 
please back up the […]

Popularity: 10% [?]