Expertise in Oracle Apps....

Oracle E-Business Suite 12.2 Now Available

2013-09-24T15:37:00.002+04:00

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

2013-03-01T18:30:00.002+04:00

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

2011-07-25T01:35:00.029+04:00

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

2011-07-10T05:12:00.000+04:00

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

2011-06-20T21:07:00.003+04:00

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

2011-06-08T05:39:00.005+04:00

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:

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

Cheers!!!

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

2011-02-14T07:07:00.002+04:00

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!!!

Blank Page Accessing R12 - 'Missing class: _RF' in OACore application.log

2011-02-13T05:14:00.001+04:00

On 12.0, trying to connect to the home page, which shows a blank page.

Further more, the application.log file of the OACore OC4J shows the following error stack:

javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException:

Missing class: _RF

Dependent class: oracle.jsp.runtimev2.JspPageInfo
Loader: oc4j:10.1.3
Code-Source: /oracle/apps/tech_st/10.1.3/j2ee/home/lib/ojsp.jar
Configuration: code-source in META-INF/boot.xml in /oracle/apps/tech_st/10.1.3/j2ee/home/oc4j.jar

This load was initiated at oacore.web.html.jsp8892557:0.0.0 using the loadClass() method.

The missing class is not available from any code-source or loader in the system.
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:387)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)

To solve this issue, there are two ways
1. Set the JSP compilation to Automatic
2. Recompile the JSP manually

How to set the JSP compilation to Automatic
Use the vi editor to edit the $CONTEXT_NAME.xml context file used by AutoConfig and change the value for "s_jsp_main_mode" from "justrun" to "recompile" (without the double quotes)

Backup the context file before editing it.

Run Autoconfig to propagate the changes to the configuration files.

Verify that now the
$INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml has

init-param
[param-name]main_mode[/param-name]
[param-value]recompile[/param-value]
/init-param

Restart the Middle Tier services and access the applications to load JSP's which will cause them to be recompiled on the run.

After successfully accessing the applications, use the vi editor to edit the $CONTEXT_NAME.xml context file used by AutoConfig and revert the value for "s_jsp_main_mode" to "justrun" (without the double quotes) in order not to hamper the performance of your system.

Run AutoConfig to propagate the changes.

How to recompile the JSP manually

You can always use the this option to compile JSP's manually at any time.
Connect application tier using applmgr user and source the environment by running the script:

/oracle/apps/apps_st/appl/APPSSID_host.env

Run the commands
UNIX
cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 2

Windows
cd %FND_TOP%\patch\115\bin
- perl -x ojspCompile.pl –compile –flush

Restart the Middle Tier services.

Cheers!!!

Step by step process 11i to R12.1.1

2011-01-24T15:30:00.000+04:00

Hi everybody, recently I have made complete iteration from fresh PROD 11i instance to R12.1.1 with database 11.2.0.2

I have used VMware for this iteration, the following step involved to achieve this upgrade from 11i to R12.1.1

OS – OEL 4.6
Memory 3GB
Instance 11i CU2
Database 9.2.0.6

My VMware installation has been running on P5 processor with 4GB memory under Windows 7 (64 bits) machine.
Before starting this iteration, I have enabled multi-org. So please follow multi-org enabled procedure prior to this step.

The following steps performed successfully to complete this hectic upgrade from 11i instance to R12.1.1

• Upgrade 9.2.0.6 to 10.2.0.4

– Patches applied before 10g upgrade are 5478710, 4676589, 4653225

– Changed some of the OS kernel parameters

– Created new oracle home directory

– Installed 10gR1 (software only)

– Installed 10gR1 companion CD

– Installed 10g patch set 3 (10.2.0.4)

• Configuration section for 10g

– Created nls/data/9idata

– Run the script cr9idata.pl

– Copied environment file from 9i home to 10g home and made changes to reflect the directory structure of 10g home

– Copied TNS_ADMIN directory from 9i to 10 home and made changes according to new home

– Copies admin directory from 9i to 10g home and make necessary changes

– Shutdown 9i database and listener

– Startup 10g listener

– Upgraded 9i to 10g using dbua from 10g home

• Shutdown database and listener

• Create temporary tablespace

• Apply RDBMS Patches

• Fix Korean Lexers

• Run Adgrants.sql

• Grant create procedure privilege on CTXSYS

• Implement and run Autoconfig

• Gather statistics for SYS schema

• Recreate grants and synonym for apps

• Restart application server process

• Preparing for the Upgrade R12.1.1

– Apply AD.I.6

– Apply TUMS utility

– Run AD preparation scripts

Backup database and applications

• Startup 11i Instance

• Check for Invalid Objects etc...

• Create R12 application user

• Create R12 Base folder

• OS Kernel setting etc

• (Refer Metalink: 761564.1 - Oracle E-Business Suite Installation and Upgrade Notes R12.1.1 for Linux x86)

• Installation of R12.1.1 applications

• Enable maintenance mode in R12

• Apply AD 12.1.1 upgrade driver (7461070)

• Source the R12 Applications environment file

• Run the Patch Application Assistant

• Run the adgrants.sql

• Apply patch

• Re-Create grants and Synonyms

• Compile APPS schema

• Modify tablespace

• Run the American English upgrade patch driver 6678700

• Review patch history and timing

• Install R12.1.1 again for configuration purpose

• Startup / shutdown applications and database

• Try with autoconfig in both tiers

• Restart services

• Upgrade 10.2.0.4 to 11.2.0.2

• Patches applied before 11gR2 upgrade are 9062910, 8919489, 9868229, 10024524

• Autoconfig latest version with 9852070 and 9738085

• OS kernel parameters for 11gR2

• Created new oracle home directory

• Installed 11gR2 (software only)

• Installed 11g Examples CD

• Configuration section for 11gR2

• Created nls/data/9idata

• Run the script cr9idata.pl

• Copied environment file from 10g home to 11g home and made changes to reflect the directory structure of 11g home

• Copied TNS_ADMIN directory from 10g to 11g home and made changes according to new home

• Copies admin directory from 10g to 11g home and make necessary changes

• Apply 11.2.0.2 RDBMS Patches – 4247037 and 10149223

• Shutdown 10g database and listener

• Startup 11g listener

• Run DBUA

• Perform post-install instructions

• Run adgrants.sql

• Grant create procedure privilege on CTXSYS

• Set CTXSYS parameter

• Validate Workflow ruleset

• Implement and run AutoConfig in the new Oracle home on the database server node.

• Gather statistics for SYS schema

• Re-create grants and synonyms

• Restart Applications server processes

• Synchronize Workflow views

Very detailed step-by-step notes with screen shot also prepared along with this iteration, if anybody looking for this iteration material or VMware copy don’t forget to drop me mail.

Cheers!!!

How to check if the Workflow Mailer is Running?

2011-01-19T19:55:00.000+04:00

There are situations whether the Workflow Standalone Mailer processes are up & running without logging to the Application. Just follow the steps below

1. opmnctl status

2. Check the component container
ps -ef | grep OC4J_SECURITY

3. Is Java Mailer running ?
ps -ef | grep Service_Component_Container

or

SQL> select SC.COMPONENT_TYPE, SC.COMPONENT_NAME,
FND_SVC_COMPONENT.Get_Component_Status(SC.COMPONENT_NAME) COMPONENT_STATUS
from FND_SVC_COMPONENTS SC
order by 1, 2;

Cheers!!!

Guidance or Training for Oracle Apps, OBIEE 11g, .NET and Java

2010-12-30T20:28:00.000+04:00

Wishing you a Happy New Year 2011.
As a new year offers to my readers, me and my friend would like to announce free training for first 5 students in Oracle Apps, OBIEE 11g, .NET and Java technology as part of their project or assignment to university courses.

Hurry....

Cheers!!!

How to reset root password in OEL 5.5

2010-12-29T02:11:00.001+04:00

Recently one of my colleague forgotten his Linux OEL 5.5 box root password, so he have been successfully re-login his Linux with password reset option available under single user mode.

The steps involved in this procedure as follows

Restart Linux Machine

You are presented with a prompt that looks similar to the following:

If you use the default boot loader, GRUB, you can enter single user mode. To do so, at the boot loader menu, use the arrow keys to highlight the installation you want to edit and type [a] to enter into append mode.

Press the Spacebar once to add a blank space, and then add the word single to tell GRUB to boot into single-user Linux mode. The result should look like the following:

Grub append> ro root=LABEL=/ rhgb quiet / single

Press [Enter] and GRUB will boot single-user Linux mode. After it finishes loading, you will be presented with a shell prompt similar to the following:

sh-3.2#

You can now change the root password by typing

passwd root

You will be asked to re-type the password for verification. Once you are finished, the password will be changed.

Now you can restart your machine by typing init 6, this command will restart immediately

Cheers!!!

FNDCPASS Fails With "ORA-01017" Error When Changing Password with 11G Database

2010-12-26T06:06:00.003+04:00

After upgrading to 12.0 and database from 10.2.0.2 to 11.1.0.6 getting 'ORA-01017' error when tried to change the application password using FNDCPASS utility.

The reason for this issue is that, database SEC_CASE_SENSITIVE_LOGON parameter defaults to TRUE in 11G. When this occurs the password sensitivity conversion does not occur. Passwords that are input as lower case are automatically updated as upper case. As a workaround set the parameter to FALSE in the init.ora, run autoconfig on application tiers and bounce the database.

Please refer Note 567116.1 Init.ora Parameter "SEC_CASE_SENSITIVE_LOGON"

Cheers!!!

R12 - How to enable Apache, OC4J and OPMN logging

2010-12-10T14:48:00.005+04:00

Whenever raise SR with Oracle support for R12 application logging related issue, they will ask you to produce the logging details by enabling the Apache, OC4J and OPMN components and its services. Compared to 11i, Oracle Applications R12 introduces new easy way in order to enable logging for any of the components that are being used within it. The details about how to enable logging of these component you can also follow as explained in this post.

Oracle Configuration Home for Apache, OC4J & OPMN is
$ORA_CONFIG_HOME/10.1.3

Apache server is still being used and its configuration path is as following:
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf

but OC4J services, by default Oracle Applications R12 creates 3 OC4J instances:
1. OACore: runs OA Framework-based applications
2. Forms: runs Forms-base applications
3. OAFM (Oracle Apps Fusion Middleware): runs web services, mapviewer, ascontrol

Configuration files path for the above 3 OC4J instances is:
$ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/config

Configuration file used to adjust log file path for the above 3 OC4J instances is:
$ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/application-deployments/[oacore, forms, oafm]/orion-application.xml

Log files types:
Oracle Applications / E-Business Suite R12 can be configured to generate one of two types of logs files as following:

1. Plain text (default):
   - No log rotation available
   - Log files need to be manually removed
2. Oracle Diagnostics Logging (ODL) XML:
   - Logs rotation based on filesize, directory size
3. R12 logs by default are configured to generate plain text

Log files locations:
All log files are written in one home ( $LOG_HOME ) which is by default the (logs) directory under ($INST_TOP ).

Please note that after enbaling the logging for any of the following services you have to bounce the services in order the changes to take effect.

Steps to enable Apache logging:
Apache Logging ( Plain Text )

1) Edit the file $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf and set
LogLevel warn (s_apache_loglevel in context file)
2) Bounce the apache
3) Try to access the home URL or reproduce the issue.
4) Collect the following logfiles from $LOG_HOME/ora/10.1.3/Apache
  access_log.
  error_log.

Values that can be set to LogLevel variable in httpd.conf file
LogLevel = emerg,alert,crit,error,warn,notice,info,debug.

Apache Logging (ODL Logging)
1) Set the following parameters in file $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf
OraLogMode [oracle|odl|apache]
OraLogSeverity [message type]:[message level]

Message type: INTERNAL_ERROR, ERROR, WARNING, NOTIFICATION & TRACE
Message level: 1-32 (1 most severe, 32 least)
2) Bounce the apache
3) Try to access the home URL or reproduce the issue.
4) Collect the logfiles from $LOG_HOME/ora/10.1.3/Apache/oracle

Steps to enable OC4J logging:

Log file path is specified in the file
$ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/application-deployments/[oacore, forms, oafm]/orion-application.xml

1. Open the file to set the following log level $ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/config/j2ee-logging.xml
2. Come to the location located as
logger name=’oracle’ level=’NOTIFICATION:1‘ …..
3. Set the desired logging using following values
message type:message level
Message type: INTERNAL_ERROR, ERROR, WARNING, NOTIFICATION & TRACE
Message level: 1-32 (1 most severe, 32 least)
4. Locate the log file path from the file
$ORA_CONFIG_HOME/10.1.3/j2ee/[oacore, forms, oafm]/application-deployments/[oacore,forms,oafm]/orion-application.xml
(Will be identified with tag : log file path=… /log)
5. Bounce the OC4J instance and reproduce the issue
6. Collect the log files from the following locations .

Plain text
$LOG_HOME/ora/10.1.3/j2ee/[oacore, forms, oafm]/[oacore,forms,oafm]_[default_group_1]/application.log

ODL Log
$LOG_HOME/ora/10.1.3/j2ee/[oacore, forms, oafm]/[oacore,forms,oafm]_[default_group_1]/log.xml

Steps to enable OPMN logging:
There are 3 log files generated:
   - (opmn.log): contains commands, exit status
   - (opmn.dbg): contains debug log messages
   - (opmn.out): contains stdout & stderr messages

1) Open the file $ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml to set the logging parameter
2) Logging is enabled per component (internal, ons or pm)
3) Levels that can be set are (component codes) as following:
   none, fatal, error, warn, notify (written to .log)
   debug1, debug2, debug3, debug4 (written to .dbg)
Ex :
  opmnctl set target=log comp=warn
  opmnctl set target=debug comp=debug1
4) Bounce opmn services and reproduce the issue
5) Collect the opmn log files generated in $LOG_HOME/ora/10.1.3/opmn
   opmn.log , opmn.dbg and opmn.out

NOTE : Logfiles can be enabled for rotation using parameter s_opmn_log_rotation_size, s_opmn_log_rotation_time in opmn.xml

Components (Services) Status & Logs:
1. You can check the status of the services/components by passing 'status' parameter to any AD script in $ADMIN_SCRIPTS_HOME.

adapcctl.sh status

2. The various logs written while starting and stopping the services are created in ($LOG_HOME/appl/admin/log/), the logs files are:

TNS Listener Start/Stop log - adalnctl.txt
Fulfillment Server Start/Stop log - jtffmctl.txt
Oracle HTTP Server start/stop log - adapcctl.txt
Concurrent Managers and ICM start/stop log - adcmctl.txt
Forms OC4J start/stop log - adformsctl.txt
OACore OC4J start/stop log - adoacorectl.txtq
OAFM OC4J start/stop log - adoafmctl.txt
OPMN start/stop log - adopmnctl.txt

(adstpall.log) and (adstrtal.log) will record the messages while starting or stopping all services.
See also
how to enable and logging Apache, OC4J and OPMN
How to enable and logging Apache and Jserv in 11i

Cheers!!!

How to find the SID information for a running request

2010-12-07T04:17:00.005+04:00

Always good to know the long running request SID information of apps for analysis and troubleshoot purpose. The following query will help to identify that, pass long running 'request id' as parameter

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = &Request_ID
AND a.phase_code = 'R';

Cheers!!!

How to Relink Oracle Database Software

2010-12-06T02:49:00.001+04:00

Its better to know the relinking of oracle software manually when there is a situation like

An OS upgrade has occurred.
A change has been made to the OS system libraries. This can occur during the application of an OS patch.
A new install failed during the relinking phase.
Individual Oracle executables core dump during initial startup.
An individual Oracle patch has been applied.

So, relinking Oracle manually is suggested way under the above circumstances.

Those who want to (or have been advised to) manually relink should follow the procedure below.

Step 1 - Log into the UNIX system as the Oracle software owner
Typically this is the user 'oracle'.

STEP 2 - Verify that your $ORACLE_HOME is set correctly:
echo $ORACLE_HOME

Step 3 - Verify and/or Configure the UNIX Environment for Proper Relinking
Set LD_LIBRARY_PATH to include $ORACLE_HOME/lib

Step 4 - For all Oracle Versions and UNIX Platforms:
Verify that you performed Step 2 correctly:

env|pg ....make sure that you see the correct absolute path for
$ORACLE_HOME in the variable definitions.

Step 5 - For all Oracle Versions and UNIX Platforms:
Verify umask is set correctly:
umask

This must return 022. If it does not, set umask to 022.
umask 022
umask

Step 6 - Run the OS Commands to Relink Oracle:

Before relinking Oracle, shut down both the database and the listener.
The following commands will output a lot of text to your session window. To capture this output for upload to support, redirect the output to a file.

For all UNIX platforms:

Oracle 7.3.x
For executables: oracle, exp, imp, sqlldr, tkprof

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

For executables: svrmgrl, svrmgrm

cd $ORACLE_HOME/svrmgr/lib
make -f ins_svrmgr.mk linstall minstall (linstall is for svrmgrl, minstall is for svrmgrm)

For executables: sqlplus

cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

For executables: dbsnmp, oemevent, oratclsh

cd $ORACLE_HOME/network/lib
make -f ins_agent.mk install

For executables: names, namesctl

cd $ORACLE_HOME/network/lib
make -f ins_names.mk install

For executables: tnslsnr, lsnrctl, tnsping, csmnl, trceval, trcroute

cd $ORACLE_HOME/network/lib
make -f ins_network.mk install

Oracle 8.0.x
For executables: oracle, exp, imp, sqlldr, tkprof, mig, dbv, orapwd, rman, svrmgrl, ogms, ogmsctl

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

For executables: sqlplus
cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

For executables: dbsnmp, oemevent, oratclsh, libosm.so

cd $ORACLE_HOME/network/lib
make -f ins_oemagent.mk install

For executables: tnslsnr, lsnrctl, namesctl, names, osslogin, trcasst, trcroute

cd $ORACLE_HOME/network/lib
make -f ins_network.mk install

Oracle 8.1.X, 9.X.X, 10.X.X or 11.X.X
*** NEW IN 8i AND ABOVE ***
A 'relink' script is provided in the $ORACLE_HOME/bin directory.
cd $ORACLE_HOME/bin
relink
...this will display all of the command's options.
usage: relink
accepted values for parameter: all, oracle, network, client, client_sharedlib, interMedia, precomp, utilities, oemagent, ldap

relink all

11.2.X special instructions

In 11.2 relink script will only accept "all" as argument
-or-
Since the 'relink' command merely calls the traditional 'make' commands, you still have the option of running the 'make' commands independently:

For executables: oracle, exp, imp, sqlldr, tkprof, mig, dbv, orapwd, rman, svrmgrl, ogms, ogmsctl
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

NOTE: After relinking the oracle executable, make sure that the permissions on the executable are 6751 (-rwsr-s--x). If they are not, run the following command as the Oracle software owner:
cd $ORACLE_HOME/bin
chmod 6751 oracle

For executables: sqlplus
cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

For executables: isqlplus (Oracle9i and higher versions)

cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install_isqlplus

For executables: dbsnmp, oemevent, oratclsh

cd $ORACLE_HOME/network/lib
make -f ins_oemagent.mk install

NOTE: After relinking the dbsnmp executable, it is necessary to run the following commands as root (so that the ownership/permissions on the executable are correct):

# cd $ORACLE_HOME/bin
# chown root dbsnmp
# chmod 6750 dbsnmp

For executables: names, namesctl

cd $ORACLE_HOME/network/lib
make -f ins_names.mk install

For executables: osslogin, trcasst, trcroute, onrsd, tnsping

cd $ORACLE_HOME/network/lib
make -f ins_net_client.mk install

For executables: tnslsnr, lsnrctl

cd $ORACLE_HOME/network/lib
make -f ins_net_server.mk install

For executables related to ldap (for example Oracle Internet Directory):

cd $ORACLE_HOME/ldap/lib
make -f ins_ldap.mk install

How to Tell if Relinking Was Successful:

If relinking was successful, the make command will eventually return to the OS prompt without an error. There will NOT be a 'Relinking Successful' type message.

If You Receive an Error Message During Relinking:
Confirm that the message you received is an actual fatal error and not a warning. Relinking errors usually terminate the relinking process and contain verbage similar to the following:
'Fatal error', 'Ld: fatal', 'Exit Code 1'
While warnings will look similar to: 'ld: warning: option -YP appears more than once, first setting taken' and can most often be ignored.

If you receive an error that terminates the relinking process, your first step should be to extract the relevant information about the error from the make output:

This can be broken down into three basic steps:
1. Identify the OS utility that is returning the error.
'ld', 'make', 'cc', 'mv', 'cp', 'ar' are common sources.
2. Identify the type of error:
'Permission Denied', 'Undefined Symbol', 'File Not Found' are common types.
3. Identify the files or symbols involved.

Cheers!!!

Startup/Shutdown process of OBIEE 11g on Linux

2010-12-05T04:11:00.002+04:00

As I have promised earlier post, I am writing the startup steps of OBIEE 11g on linux box. Before that make sure that FMW(Fusion Middle Ware) Repository database and the listener are up and running. If database status is running, we can start. Or else start the database and listener now.

First step is to start the Weblogic server. As you may have noticed that the directory structures are totally different, so it will take sometime to get used with the new scripts and directories.

Startup scripts are located under $FMW_HOME/user_projects/domains/bifoundation_domain/bin

Setting the environment by running these two script
$ . setOBIDomainEnv.sh
$ . setDomainEnv.sh

Now you can startup the WLS:

Use the script startWeblogic.sh as shown below to start the WLS

. startWebLogic.sh -Dweblogic.managment.username=weblogic -Dweblogic.management.password=weblogic1 &

weblogic and weblogic1 are the username and password I have given during the OBIEE 11g installation. Make sure you use “&” at the end of the command so that the script runs in the background

2. Once WLS running status, you can Login to WLS Console:

Default port to login to the console is 7001 unless different ones are specified during the installation

Now goto http://[BIserver]:7001/em to access the enterprise manager to startup the rest of the services

Select from the menu Weblogic Server –> Control –> Startup to start the service

3. NodeManager – Node manager is a java utility that allows us to perform operations such as startup and shutdown for Managed Server. So in order for us to remotely startup the bi_server we need the node manager utility up and running

Now to startup node manager, get back to a telnet session and go to $WLS_HOME/server/bin directory

Set environment

Run the script setWLSEnv.sh

$ . setWLSEnv.sh

Starting Nodemanager

$ . startNodeManager.sh &

Next is startup opmn services

cd $FMW_HOME/instances/instance1/bin
$ . opmnctl startall

Now Lets' try analytics url

Cheers!!!

Developer 6i Patch Set 19 upgrade with EBS 11i

2010-12-03T11:30:00.000+04:00

As part of Extended support for 11i, upgrade Developer 6i patchset 19 is a must, this post will help to you do so. I am writing the "step-by-step" upgrade instructions for linux box
*** All patches must be installed on all Application tier nodes
Stop all application processes by adstpall.sh
Apply the latest certified Developer 6i patch set 19 (6194129)
- Source applications environment (e.g source . /app/apps/ajiappl/APPSORA.env)
- Verify that $ORACLE_HOME is the 806_ORACLE_HOME
- Execute with applmgr user
$ unzip p6194129_60828_LINUX.zip
$ cd developer6i_patch19
$ ./patch_install.sh 2>&1 | tee patch_install_p19.log
- Check patch_install_p19.log for any errors
- Execute the following to relink Procedure Builder, Forms, Graphics and Reports
$ cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
$ cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
$ cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
$ cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install

Apply patch 9863561
Unzip Patch file p9863561_60828_GENERIC.zip
$cd 9863561
   Backup the Forms class files
cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main\$1.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main\$1.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/RunformBundle.class $ORACLE_HOME/forms60/java/oracle/forms/engine/RunformBundle.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/CancelQueryDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/CancelQueryDialog.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormPrintableImpl.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormPrintableImpl.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$DeferredItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$DeferredItem.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$1.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$1.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/IHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/IHandler.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/MenuInfo.class $ORACLE_HOME/forms60/java/oracle/forms/handler/MenuInfo.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormMenu.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormMenu.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/HeavyBeanManager.class $ORACLE_HOME/forms60/java/oracle/forms/handler/HeavyBeanManager.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VImage.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VImage.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FScalingImageCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FScalingImageCanvas.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrabRemover.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrabRemover.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrab.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrab.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextArea.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextArea.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/SmartBar.class $ORACLE_HOME/forms60/java/oracle/forms/ui/SmartBar.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FLWTextArea.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FLWTextArea.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/ClipboardErrorUtils.class $ORACLE_HOME/forms60/java/oracle/forms/ui/ClipboardErrorUtils.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$NewlineDisplayFilter.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$NewlineDisplayFilter.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$FormsPWAccess.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$FormsPWAccess.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer.class $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer\$1.class $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer\$1.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/delegates/VComponentDelegate.class $ORACLE_HOME/forms60/java/oracle/forms/ui/delegates/VComponentDelegate.class.PRE_BUG9863561

Special Instructions
cd $ORACLE_HOME/forms60/java
jar -xvf f60all.jar oracle/forms/ui/VBean.class
cd $Patch_HOME/9863561/oracle/forms/engine
cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
cp Main\$1.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main\$1.class
cp RunformBundle.class $ORACLE_HOME/forms60/java/oracle/forms/engine/RunformBundle.class
cd $Patch_HOME/9863561/oracle/forms/handler
cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
cp BlockScroller.class $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class
cp CancelQueryDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/CancelQueryDialog.class
cp ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
cp FormCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class
cp FormWindow.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class
cp FormPrintableImpl.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormPrintableImpl.class
cp FormMenu.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormMenu.class
cp TextComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class
cp UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
cp UICommon\$DeferredItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$DeferredItem.class
cp UICommon\$1.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$1.class
cp FormsMouseWheelHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class
cp IHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/IHandler.class
cp MenuInfo.class $ORACLE_HOME/forms60/java/oracle/forms/handler/MenuInfo.class
cp HeavyBeanManager.class $ORACLE_HOME/forms60/java/oracle/forms/handler/HeavyBeanManager.class
cd $Patch_HOME/9863561/oracle/forms/ui
cp VImage.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VImage.class
cp FScalingImageCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FScalingImageCanvas.class
cp FormMouseGrabProvider.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider.class
cp FormMouseGrabProvider\$MouseGrabRemover.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrabRemover.class
cp FormMouseGrabProvider\$MouseGrab.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrab.class
cp VTextArea.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextArea.class
cp SmartBar.class $ORACLE_HOME/forms60/java/oracle/forms/ui/SmartBar.class
cp FLWTextArea.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FLWTextArea.class
cp ClipboardErrorUtils.class $ORACLE_HOME/forms60/java/oracle/forms/ui/ClipboardErrorUtils.class
cp VTextField.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField.class
cp VTextField\$FormsPWAccess.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$FormsPWAccess.class
cp VTextField\$NewlineDisplayFilter.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$NewlineDisplayFilter.class
cd $Patch_HOME/9863561/oracle/forms/ui/mdi
cp MDIContainer.class $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer.class
cp MDIContainer\$1.class $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer\$1.class
cd $Patch_HOME/9863561/oracle/forms/ui/delegates
cp VComponentDelegate.class $ORACLE_HOME/forms60/java/oracle/forms/ui/delegates/VComponentDelegate.class

For ewt3.jar please follow these additional steps:
Backup the Forms java subtree and extract the changed files
  cd $ORACLE_HOME/forms60/java
  cp -r oracle/ewt oracle/ewt.PREBUG9863561
  jar -xvf $Patch_HOME/9863561/ewt3.jar
  rm META-INF/MANIFEST.MF
  rmdir META-INF
Verify that the EWT version has been updated under the
cd $ORACLE_HOME/forms60/java
ls -la oracle/ewt | grep 3_4_49
Now regenerate jar files using adadmin.
- Regenerate Jar files
  - Execute adadmin
  - Select the "Generate Applications Files menu" option
  - Select "Generate product JAR files"
  - Do you wish to force regeneration of all jar files? => Yes
  - Spot check that the JAR files have been generated by verifying the timestamp
$ cd $OA_JAVA/oracle/apps/fnd/jar
$ ll fndforms.jar fndewt.jar

Apply patch 6125732
- Unzip patch file + Apply patch
$ unzip p6125732_60828_LINUX.zip
$ cd 6125732
$ sh patch.sh

Apply patch 6857221
- Unzip patch file + Apply patch
$ unzip p6857221_60828_LINUX.zip
$ cd 6857221
$ sh patch.sh
- Relink f60webmx for Oracle Applications
$ adrelink.sh force=y "fnd f60webmx"

Apply patch 5232832
Make a patch directory for this fix, and put your patch files in it:
$ cd $ORACLE_HOME
$ unzip p5232832_600_Linux.zip
$ cd 5232832
3) Copy your original librw60.a file in case you ever need it, get new file:
$ cd $ORACLE_HOME/lib
$ cp librw60.a librw60.a.PRE_5232832
$ ar -r librw60.a $Patch_HOME/5232832/rwffm.o
5) If you don't have genshlib in $ORACLE_HOME/bin directory then copy this file over there:
$ cp $Patch_HOME/5232832/genshlib $ORACLE_HOME/bin
$ chmod ug+x $ORACLE_HOME/bin/genshlib
6) Generate the shared libraries:
$ cd $ORACLE_HOME/lib
$ $ORACLE_HOME/bin/genshlib rw60 0

Relink the reports executables:
$ cd $ORACLE_HOME/reports60/lib
$ make -f ins_reports60w.mk install

Apply patch 8888124

Unzip Patch file 8888124
$ cd 8888184
$ sh patch.sh

Apply patch 7329300
Unzip Patch file
$ cd 7329300
$ sh patch.sh

Apply patch 6747939
Unzip Patch file
$ cd 6747939
$ sh patch.sh
adrelink.sh force=y "fnd f60webmx"
Apply patch 7552880
Unzip Patch file
$ cd 7552880
$ sh patch.sh
adrelink.sh force=y "fnd f60webmx"

If 11i.ATG_PF.H.RUP6 or above, you have to apply this ====
Apply patch 9094950
Unzip Patch file
$cd 9094950
  Adpatch using u9094950.drv
Relink applications executables
- Run adadmin
- Select (2) "Maintain Applications Files Menu"
- Select (1) "Relink Applications programs"
- List of product to link: fnd
- Generate specific executables …: Yes
- Relink with debug: No
- Enter executables to relink: f60webmx ar60run ar60runb ar60rund
==
Relink these executables by running adadmin
When the Main Menu appears select 'Maintain Applications Files Menu' and then select 'Relink Applications Program'
Answer the questions below as follows, in order to select the individual executables for relinking.
Enter list of products to link ('all' for all products)[all] : fnd
Generate specific executables for each selected product [No] ? y
Relink with debug information [No] ? n
(You will then be offered a list of executables that are available for relinking)
Enter executables to relink, or enter 'all' [all] : f60webmx ar60run ar60runb ar60rund *
* In a multi-node configuration, not all these executables exist on each node. The list of executables will show those that do exist on the node you are currently running on, and only those should be entered to avoid errors.

Apply patch 9935935 (Apps Interoperability)
- Unzip patch file
$ unzip p9935935_11i_GENERIC.zip
- Enable maintenance mode: adadmin -> (5) Change Maintenance Mode -> (1) Enable Maintenance Mode
- apply patch with adpatch
- Disable maintenance mode: adadmin -> (5) Change Maintenance Mode -> (2) Disable Maintenance Mode
Verify your upgrade
- Check the timestamp for the following files:
$ cd $OA_JAVA/oracle/apps/fnd/jar
$ ll fndforms.jar fndewt.jar
If the timestamp is not current - run adadmin => Maintain Applications Files => Generate Product JAR Files.
Start all applications processes (adstrtall.sh)
- You can also verify your upgrade by login to forms responsibility -> Help -> About Oracle Applications
  You should see: Oracle Forms version: 6.0.8.28.0

Cheers!!!

How to verify Oracle HTTP Server MLR Patchset 4393827 applied or not?

2010-12-02T12:11:00.006+04:00

As we are all knows premier support for Oracle E-Business Suite Release 11i ends yesterday, November 30, 2010. Extended Support for EBS 11i begins today, December 1st, 2010. And a new set of minimum technical requirements for Apps 11i goes into effect. The new minimum baseline patch requirements for Extended Support on Oracle E-Business Suite 11.5.10 explained in Note 883202.1. These are baseline patch minimum
1. Oracle E-Business Suite Release 11.5.10 Consolidated Update 2 plus additional patches
2. ATG Rollup Patchset 6 (11i.ATG_PF.H.delta.6, Patch 5903765)
3. 10.2.0.4 Database or 11.1.0.7 Database
4. Forms6i Patchset 19 (version 6.0.8.28, Patch 6194129)
5. Oracle HTTP Server MLR Patchset 4393827
6. Sun Java Runtime Engine (JRE) 1.6.0_03 or higher

In addition to the major technology stack components shown above, Note 883202.1 contains additional minimum baseline requirements.

Ok fine, here what I am explaining is that, how to identify whether Oracle HTTP Server MLR Patchset in my instance is required any additional patchset or not. The way to find-out the current Oracle HTTP Server MLR Patchset are:

Login as APPLMGR in your Web server node and set environment

Then you can run "$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v".

This command should return "Rollup 5" if The patch 4393827 has been already applied, like the following example:

[applmgr@devtapps ~]$ cd /apps/devtora/iAS/Apache/Apache/bin/
[applmgr@devtapps bin]$ httpd -v
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Feb 22 2005 18:51:19 (iAS 1.0.2.2.2 rollup 5)

Following are Oracle HTTP Server Patch List
Release Rollup Version iAS Patch Number Applications Interop patch Patch Included in Rapid Install
1.0.2.2.2 Rollup 5 4393827 4104924 None
1.0.2.2.2 Rollup 4 3072811 3239694 11.5.10
1.0.2.2.2 Rollup 3 2674529 2757379 11.5.9
1.0.2.2.2 Rollup 2 2488351,2362590,2517475 2641718 11.5.8
1.0.2.2.2 Rollup 1 2120450 2549489 11.5.7
1.0.2.1S Rollup 1 2050415 3035685 None

Cheers!!!

OBIEE 11g Linux - But required Admin Tool on Windows, How to solve?

2010-11-30T17:12:00.001+04:00

After successful intallation of OBIEE 11g on linux box, I am thinking about Admin tool.exe on my laptop, but required Windows box to run that. As a work around, did a fresh installation of OBIEE 11g software again on my local Windows XP machine. After than I have copied the admin tool.exe along 'server' folder from C:\[OBIEE_PATH]\bifoundation

As a first step, I have created same directory structure OBIEE 11g installation path of local machine to my laptop and then copied all the files.
Next step, i have created a cmd file for register all the DLL files from C:\[OBIEE_PATH]\bifoundation\bin directory with regsvr32 /s option. This will help to register all these DLLs in single a command. (If anybody required this information, don't hesitate to leave your request with valid email id)

After that from my local machine, exported two registry entries.
1. [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
2. [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle BI Server 11g_OH741068320]

I have made some changes to the first reg exported file, because its required only Oracle BI Server entry info. So that removed unnecessary lines from first reg exported file. And its look like

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"Oracle BI Server 11g_OH741068320"="Installed"

After that added these entries to my laptop using

regedit /s [exported file name]

Finally created one ODBC Connection to laptop pointing to the Linux box DB. Now I can able to open my RPD file in offline as well as online

Cheers!!!

TNS-12557: TNS:protocol adapter not loadable

2010-11-30T00:40:00.001+04:00

Yesterday, I have installed OBIEE11g to my laptop. Installation was successful and working fine to me. But after that I have encountered issues connecting to the database using my existing connection string. I have added these db connection string to the OBIEE11g home tnsnames.ora file but no luck.
I have did some work around, firstly checked my TNSPING, but the result showing as below

So I have checked my PATH setting and discovered the original PATH setting missing my old Oracle Home details. This below is my present PATH environment setting.

PATH=C:\Program Files\PC Connectivity Solution\;C:\WINDOWS\system32;C:\Middlewar
e\Oracle_BI2\bin;C:\Middleware\Oracle_BI2\opmn\bin;C:\Middleware\Oracle_BI2\opmn
\lib;C:\Middleware\Oracle_BI2\perl\bin

After experimentation revealed that my exiting TNS_ADMIN and bin directory has been missing from PATH environment, so I have decided to add the existing directory and now its looks like. (close the command window and open another one)

PATH=C:\OraHome_1\bin;C:\OraHome_1\network\ADMIN;C:\Program Files\PC Connectivit
y Solution\;C:\WINDOWS\system32;C:\Middleware\Oracle_BI2\bin;C:\Middleware\Oracle_BI2\opmn\bin;C:\Middleware\Oracle_BI2\opmn\lib;C:\Middleware\Oracle_BI2\perl\bin

As a result of this path setting, again open one command window (startup->cmd) and tried with same command. Now its working fine

Simple but spend some time to identify the issue.

Cheers!!!

Install & Configuration of OBIEE 11g

2010-11-25T04:22:00.008+04:00

I would like to share my experience of installation of OBIEE 11g on linux with you all.
There are four steps

Once you have restarted your linux box, do the following steps for startup

How to startup OBIEE 11g on linux

Cheers!!!

Oracle 11g R2 Patchset 1 (11.2.0.2) installation on OEL 5.5

2010-11-25T00:51:00.003+04:00

Please makes sure that the following or later versions of packages are successfully installed along with operating system. These are pre-requisite for oracle 11g installation.

binutils-2.17.50.0.6

compat-libstdc++-33-3.2.3

elfutils-libelf-0.125

elfutils-libelf-devel-0.125

elfutils-libelf-devel-static-0.125

gcc-4.1.2

gcc-c++-4.1.2

glibc-2.5-24

glibc-common-2.5

glibc-devel-2.5

glibc-headers-2.5

kernel-headers-2.6.18

ksh-20060214

libaio-0.3.106

libaio-devel-0.3.106

libgcc-4.1.2

libgomp-4.1.2

libstdc++-4.1.2

libstdc++-devel-4.1.2

make-3.81

numactl-devel-0.9.8.i386

sysstat-7.0.2

To use ODBC, you must also install the following additional 32-bit ODBC RPMs, depending on your operating system:

unixODBC-2.2.11 (32-bit) or later
unixODBC-devel-2.2.11 (32-bit) or later

Modify of add these entries in /etc/sysctl.conf using vi editor

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

If necessary, update the resource limits in the /etc/security/limits.conf configuration file for the installation owner. For example, add the following lines to the /etc/security/limits.conf file:

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

Modify or add the following entry in /etc/pam.d/login using vi editor

session required pam_limits.so

Next create the group and user for oracle database

/usr/sbin/groupadd -g 500 oinstall

/usr/sbin/groupadd -g 501 dba

/usr/sbin/groupadd -g 502 oper

/usr/sbin/useradd -u 500 -m -g oinstall -G dba,oper oracle

id oracle

passwd oracle

Create the installation directory for oracle installation

mkdir -p /u01/oracle

chown -R oracle:dba /u01/oracle

chmod -R 775 /u01/oracle

Create staging directory for oracle installation

mkdir -p /u01/stage

chown -R oracle:dba /u01/stage

After unzipping the installation files change to the directory containing uninstaller. You must be the oracle user (not root) and you must verify your shell is set correctly. As the oracle user and start the Oracle installer.

$ cd /u01/stage/database

$./runInstaller.

You can ignore this email setting

You can skip software updates

From installation option, select create and configure a database.

From the server class, choose server class

For a standalone database choose the first option.

Choose Install type as Advance Install.

Database Edition should be Enterprise Edition.

As we created earlier, choose /u01/oracle as Base and Software location will be similar to the below picture

This database is for OBIEE 11g, so please choose Data Warehousing

Here you can edit your database name.

If this database is for demo purpose, so I have to keep with minimum configuration

You can choose File System. But if you are planning for ASM refer configuration details from installation document.

Better to choose the second option this time.

Accept the defaults

This is a typical result. Based on your OS configuration, please read the oracle Installation documents for more info.

The following information is good for future reference.

This will take some time to complete. Be ready for that…

Now the database creation is going on.

Finally database configuration success. If you want to change the password, you can use Password Management button.

From this screen, will prompt to do two things. As a root, you have executed these commands.

Now database 11gR2 (11.2.0.2) is ready for use.

Cheers!!!

Repository Creation Utility - OBIEE 11g

2010-11-25T00:25:00.002+04:00

Download V22398-01.zip from edelivery.oracle.com Oracle Fusion Middleware Repository Creation Utility 11g (11.1.1.3.3) for Linux x86. To extract the contents of the zip file to the staging directory

Here I have created one user called applmgr for OBIEE installation

When you have unzipped V22398-01.zip, this will produce a directory called rcuHome. Change the directory to rcuHome/bin and start the Repository creation utility using

$ ./rcu

Click on Next in the first RCU screen. Choose the create option and click on Next

In the next screen, enter the following details

Hostname :

Port : 1611

Service Name : AJI

username : system

Password : use the same password as the one that was given at the time of installation of 11g DB

This will do a pre-requisite check, click on OK to proceed.

Choose the Oracle Business Intelligence option, this will automatically enable the Metadata services, Click on Next

Click OK in the next screen in the next screen Enter password and Click on Next

Leave the default values as is, click on Next

Click OK to create the suggested tablespaces

Click on OK once the tablespaces have been successfully created.

Once completed click on Close to finish the RCU process.

Cheers!!!

OBIEE 11g installation on OEL 5.5

2010-11-25T00:19:00.004+04:00

Download the following from edelivery.oracle.com

Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 1 of 2) V22330-01 Part 1 of 2

Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 1 of 2) V22330-01 Part 2 of 2

Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 2 of 2) V22331-01 Part 1 of 2

Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 2 of 2) V22331-01 Part 2 of 2

Extract these four zip files, will create a folder called bishiphome and under that four Disks. To lunch the OBIEE 11g installation, goto bishiphome/Disk1

$./runInstaller

Click on Next in the first screen

Choose Enterprise Install option and then click on Next

Ensure that all the pre-requisite checks are passed 100%. Click on next

Choose the Create New BI System option. Enter the password. Leave the username and the domain with the default values. Then click on Next

Enter the /u01/oracle/MiddlewareHome as the Middleware Home location. This will automatically fill the remaining fields. Leave those values with the defaults and click on Next

Leave the next screen with default options (all components enabled). Click on Next

On the database details screen, enter the details of your database and BIPLATFORM username and password, click on Next to proceed.

Choose the default Auto Port option and click on Next

Disable the I wish to receive Security Updates option and click Next

Click Yes in the confirmation pop-up window

Click on Install

The first step in the install process will copy the install files into Middleware Home. This will take sometime to complete.

After copying, the configuration process will start. Ensure that all the components are configured correctly.

After the configuration is complete click on Next

This screen will get all the details of the services started.

Now using web browser, naviagte to http://visr12.apps.local:7001/console. When prompted, enter weblogic as the username and enter the password when the you given at the time of installation.

After logging in, click on the bifoundation_domain link.

Now using web browser, naviagte to http://visr12.apps.local:7001/em. This will open up the login window of the Enterprise Manager Fusion Middleware Control. Again type in weblogic as the username and password at the time of installation.

Navigate to the Business Intelligence folder and click on coreapplication

Now access analytics using http://visr12.apps.local:9704/analytics

For accessing Bi Publisher Enterprise, http://visr12.apps.local:9704/xmlpserver

Now the installation of OBIEE 11g is completed successfully. I will write the steps for startup and shutdown these services in the next post.

Cheers!!!