Archive Monthly Archives: June 2008

Oracle Advanced Supply Chain Planning (ASCP)multi node implementation

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 […]

Read More

1Z0-233 : Oracle Apps DBA Certification Questions

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 […]

Read More

Sharing File System between SunOS Servers

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 […]

Read More

How to Change Apps Password in 11i, if you forget ?

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.  […]

Read More

Application Server Disaster Recovery Solution : AS Guard – Things You should Know

ASGuard which stands for Application Server Guardis Disaster Recovery Solution for Oracle Application Server/Fusion Middleware.   AS Guard in background uses Datagaurd for database (automatically creates standby database) and for middle tier configuration files it uses OracleAS backup and recovery tool. If you are implementing Oracle AS Guard, key points You should be aware of 1. […]

Read More

Introduction to Zones : Solaris 10

This post covers new feature ZONESintroduced in Solaris 10,  zone is virtualized solaris operating system within Solaris. You can install multiple Solaris Operating System (Multiple Machine) with in Single Big Machine. This will help in consolidating multiple small Solaris machine into one big machine with multiple Solaris operating system each running different application. Zones: is virtualized […]

Read More

Troubleshooting/Tuning Slow Form in Apps 11i

User reported that one form was taking too much time to save record and after sometime form was hanging (records were not saved). My initial question to user was 1) Is this happening for all forms or just one form ? 2) Is this issue happening for all users or a particular user ? and answer was, […]

Read More

Datapump-2

 This post is in continuation of my previous post on  Oracle Datapump Part I here   Directory: In Datapump syntax we found Directory, What does this directory means ? Does it talk about the OS level directory ??? well you can say that here directory means object. we need to create database level directory as well […]

Read More

Online 10g R2 Application Server Training for DBA’s / Administrators

After receiving tremendous response for our Online Apps DBA Training, we are pleased to announce Oracle 10g Application Server training starting from 19th July 2008. This is a web based online training designed to cover all the activities perform by an Application Server Professional. For Course Content details: Click Here KEY BENEFITS -Training material covering each […]

Read More

Database Listener Hangs Intermittently

      I would like to share one thing here, which i resolved recently. Problem was Database Listener hangs intermittently in 10.2.0.1 instance. It might happen in the 10g versions(10.1.0.3, 10.1.0.4, 10.1.0.4.2, 10.1.0.5, 10.2.0.1 and 10.2.0.2). This is mostly specific to Unix/Linux platforms. The issue was  —> Users were not able to connect to database  —> There […]

Read More
Not found