Oracle DBV with Apps 11i Oracle Database Vault restricts highly privileged users’ access and enforces separation of duty for Oracle EBusiness Suite environments. Regulations such as SarbanesOxley (SOX), Payment Card Industry (PCI), and the Healthcare Insurance Portability and Accountability Act (HIPAA) require strong internal controls to protect sensitive information such as financial, healthcare, and credit […]
Read MoreOverview of R12 Tech Stack Changes:- The mid tier technology had a boost up in R12, continual improvement with changing technology. Here are the conversion of tech stack from 11i to R12. Application Server: 1.0 —-> 10.1 Servlet Container: Jserv —-> OC4J Apache: 1.3.19 —-> 1.3.31 (or 2.0) Forms: 6 —-> 10 What’s new in […]
Read MoreYou can have various methods to identify the large or fragmented indexes in 11i or you can just configure the Oracle Alert to receive a mail. This alert is scheduled to check the situation periodically say daily at mid night. The alert ‘Indexes too large or fragmented‘ is pre-defined alert. There are three possible ways […]
Read MoreWhile integrating Oracle E-Business Suite (Apps/11i) with Oracle Single Sign-On server (SSO) on one of test Instances, I received error like “Errors encountered running -txkSetSSOReg.pl“. Looking at error message carefully (check below), It was easy to figure out that value of Profile Option “Application framework Agent” was wrong. . Error Message on Screen applmgr@midtier>txkrun.pl -script=SetSSOReg […]
Read MoreOracle E-Business Suite Application Technology Group (ATG) is pleased to announce the availability of the Application Management Pack for Oracle E-Business Suite (EBS) version 2.0.2 Rollup update. Oracle strongly recommends that you apply the latest release, 2.0.2. Oracle application Management Pack 2.0.2 Application Management Pack 2.0.2 (Patch 6809246 ) is an OPatch rollup update […]
Read MoreSteps mentioned in this post is overview of Oracle database upgrade from 8i, 9i or 10g to 11g Rel 1 i.e. 11.1.X.X.X (Step by step Oracle 10g upgrade to 11g including pointer to documentation coming soon…) Things good to know for 11g Database Upgrade 1. Oracle 11g Database software must be installed in new ORACLE_HOME 2. If you […]
Read MoreI am trying to cover the password file information and root password recovery . It is not the task of DBA but sometimes the knowledge of Unix administration task help us to do the activities in effective manner . Password file information of root :- Operating system Sun Solaris :- /etc/passwd and /etc/shadow Operating system […]
Read MoreI just can’t believe that company like Oracle is charging their Employees 100$ for Oracle Open World Presentations (check here) . Can you (as an Employer) think of charging your employees for training, seminars or presentations ??
Read MoreMobile Supply Chain Applications allows you to perform common warehouse and shop floor transactions from any location in the manufacturing facility through the use of handheld devices. These include PDAs, handheld Radio Frequency (RF) units etc. This Application enables real-time interfaces to Oracle Applications through user interfaces. You can access the system from anywhere RF […]
Read MoreSolution available for backup and recovery of Oracle Database i) RMAN (Recovery Manager) ii) User Managed backup (using o.s. commands like cp, copy..) . RMAN (Recovery Manager) – is Oracle Database client that perform backup & restore task of oracle database. . Components in RMAN 1. Target Database – is Oracle database which you want […]
Read More