Oracle E-Business Suite 12.2 Now Available

Finally long wait for Oracle E-Business Suite 12.2 is over. Now officially available from Oracle

Oracle E-Business Suite 12.2 Now Available

Cheers!!!

Getting Started as an E-Business Suite DBA

There is an excellent article from Mr. Lauren Cohn about getting started as an Apps DBA.

I think, the best answer to "How does one become an EBS DBA?" you can find best answer from the link

Getting started as an E-business suite DBA

Cheers!!!

How to create an Oracle VirtualBox host-only network adapter in Windows 7

Yesterday I have downloaded Sample Application OVM for OBIEE 11.1.1.5 and while I was configuring SampleApp_V107 with Oracle VirtualBox, I have noticed VirtualBox host-only network adapter was not created. And I got below error message, when I add an VirtualBox host-only network adapter thru VirualBox console(GUI)

"Failed to create host-only network interface"

To solve this problem, I have to create an Oracle VirtualBox host-only network adapter with following steps

1. From Control Panel, Add New Hardware  (New network adapter)

2. Click Have Disk; (point it to C:\Program Files\Oracle\VirtualBox\drivers\network\netadp\VBoxNetAdp.inf)

3. Select VirtualBox Host-only Ethernet Adapter

4. OKay to install the unsigned driver

After completed instation, go to Oracle VM VirtualBox console and choose Preference network and add an VirturalBox host-only network adapter.

Again I have started SampleApp_V107 through OVM, its coming up without having any problem and working fine my OBIEE 11.1..5 sample applications

Cheers!!!

Error While Loading Shared Libraries: libdb.so.2 on RedHat Linux 5

After clonning (or installing) an Oracle Applications Release 12.0 or 12.1 instance on Linux 5, an error may occur while starting up the Apache service. The error would be this: 

You are running adapcctl.sh version 120.6.12000000.4
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
adapcctl.sh: exiting with status 204


After review the HTTP log file. The error is very clear about the missing soft link. It would show this error:

/u01/apps/AJI_apps12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u01/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared
libraries: libdb.so.2: cannot open shared object file: No such file or directory

Soft link libdb.so.2 is missing.


To solve this issue, Shut down all Oracle Application Services

As root user, create a soft link as follows:
# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Start up all Oracle Application Services

Cheers!!!

Oracle Fusion Applications architecture

So, its time for Fusion Applications....

Oracle Fusion Applications follows a modular, standards-based architecture and making it highly adaptable. This standards-based technology enables you to respond effectively to change with flexible, modular, user-driven business software that is powered by best-in-class business capabilities built on open standards. Its technology framework includes the following products:

Oracle WebCenter - design time and runtime tools for building enterprise portals, transactional websites, and social networking sites.

Oracle Business Intelligence 11g -  analyze, present, report, and deliver organizational data.

Oracle Universal Content Management - document management, Web content management, digital asset management; and records retention functionality to build and complement your business applications.

Oracle Service-Oriented Architecture (SOA) Suite  - designing, deploying, and managing SOA composite applications

Oracle WebLogic Server - scalable, enterprise-ready application server based on Java Enterprise Edition (Java EE).

Oracle JDeveloper  - modeling, developing, debugging, optimizing, and deploying Java applications and web services.

Oracle Enterprise Manager  - applications management, integrated application to disk management, integrated systems management, and support experience.

Oracle Identity Management -  user identities and to secure access to enterprise resources and assets.

Using a standards-based architecture drives down cost for integration and enables you to reuse systems and technologies. Standards-based architecture also enables the flexibility of the applications. You can fit the applications to your business by configuring not only the user interface, but also the business objects, the business processes, the business logic, and business intelligence.

This picture illustrates the architecture of Oracle Fusion Applications.

Oracle Fusion Applications uses a unified data model, which is a superset of E-Business Suite, PeopleSoft, JD Edwards, and Siebel entities and attributes and you can extend this data model while maintaining consistent semantics.

So its time to start the installation and configuration. Wait for Oracle Fusion Applications installation details in next post

Cheers!!!

Glimpses of E-Business Suite 12.2: WebLogic Server and Online Patching

Finally 12.2 is on the way. Read more from Steven Chan blog
There are lots of updates coming in this release, but from a technology stack perspective, EBS 12.2 will be notable for two things:

1. Replacing Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g
2. Online Patching support via 11gR2 Edition-Based Redefinition

Cheers!!!

ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments

Windows 2008 Enterprise
Oralce 11.2.0.2
After upgrade from 11.1.0.7 to 11.2.0.2 release, as part of R12 dbtier post-installation procedure, required to run adstats.sql and getting the following error

ERROR at line 1:
  ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
  [1350], [1], [23], [], [], [], [], [], [], [], [], []
  ORA-06512: at "SYS.DBMS_STATS", line 24098
  ORA-06512: at "SYS.DBMS_STATS", line 24629
  ORA-06512: at line 3
  ORA-06512: at line 33

Finally found the cause of the error, environment variable ORA_NLS10 not set even though successfully completed the  $ORACLE_HOME/nls/data/old/cr9idata.pl executed to create $ORACLE_HOME/nls/data/9idata from upgrade notes

set ORA_NLS10=%ORACLE_HOME%\nls\data\9idata

Retest the issue by running adstats.sql again .

adstats.sql should run successfully now.


Cheers!!!