Thursday, August 19, 2010

On Sun Fire 3800/4800/4810/6800, V1280, and Netra 1280 Domains, Time of Day (TOD) May Drift or Jump

Product
Sun Fire 3800 Server
Sun Fire 4800 Server
Sun Fire 4810 Server
Sun Fire 6800 Server
Sun Fire V1280 Server
Netra 1280 Server

Bug Id
SUNBUG: 4876369

Date of Workaround Release
10-SEP-2003

Date of Resolved Release
04-NOV-2003

Impact

On very rare occasions, the Time of Day (TOD) on Sun Fire 3800/4800/4810/6800, V1280, and Netra 1280 domains may be susceptible to a clock drift or jump. As a result, any functionality that relies upon the System Controller (SC) timer may be inaccurate.

Contributing Factors

This issue can occur in the following releases:

SPARC Platform

* Sun Fire V1280 and Netra 1280 with firmware (ScApp) 5.13.0014 or earlier
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.12.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.13.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.14.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.15.0, 5.15.1 and 5.15.2

Note: Systems with firmware 5.11.x are not affected by this issue. Use the "showsc -v" command to display the firmware version of the SC.

Symptoms

This issue may occur after 528 days of SC continuous uptime, where the TOD within a domain in the system may become random and unstable. The intervals reported have varied, but the behavior is generally that the TOD jumps backwards approximately one hour up to as much as one month. The TOD as seen by the SC itself does not jump.

There are no specific messages that would indicate this issue has occurred. It can only be discovered by the domain exhibiting unexpected behavior due to the domain TOD changing unexpectedly.

Resolution

This issue is addressed in the following releases:

* Sun Fire V1280 and Netra 1280 with firmware (ScApp) 5.13.0015 (as delivered in patch 113751-05 or later)
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.15.3 (as delivered in patch 112884-04 or later)

Note: The patch must be added to both system controllers to remedy this issue.

Discoverer Startup Fails on Solaris

Discoverer Startup Fails on Solaris

When running the addischtl.sh start script, you see the following message:

Registering Discoverer Preference Repository oadutil.reg:Failed to bind to OAD
Workaround

Set the TMPDIR environment variable to the Oracle home directory of the release 8.0.6 visibroker directory. The following is an example of commands required to make this change:

% TMPDIR=/mount_point/product/8.0.6/vbroker
% export TMPDIR

Wednesday, August 18, 2010

ADSSTATS.SQL fails while applying R12.1.1 NLS Upgrade Patch 6678700

When attempting to Apply Patch 6678700,
the following error occurs.
ERROR
-----------------------
sqlplus -s APPS/***** AD_TOP\12.0.0\patch\115\sql\adsstats.sql 

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this operating system.declare
*
ERROR at line 1:
ORA-20000: ORA-20001: invalid column name or duplicate columns/column
groups/expressions in method_opt Error while executing
FND_STATS.GATHER_SCHEMA_STATISTICS package.
ORA-06512: at line 91

ERROR: While running adsstats.sql :
object_name=FII.FII_FIN_ITEM_HIERARCHIES***ORA-20001: invalid column name or duplicate columns/column
groups/expressions in method_opt Error while executing
FND_STATS.GATHER_SCHEMA_STATISTICS package.
ORA-06512: at line 9

Solution
Please apply the following solution:
1. Make sure to have a valid backup for FND_HISTOGRAM_COLS table.

2. Run the following to delete column 'PARENT_FLEX_VALUE' from FND_HISTOGRAM_COLS.

delete from FND_HISTOGRAM_COLS
where table_name = 'FII_FIN_ITEM_HIERARCHIES'
and column_name = 'PARENT_FLEX_VALUE'


3- Restart the failed worker.

FRM-92101: Forms Server Java Exception: oracle.forms.net.ConnectionException: Forms session failed during startup:

After installing E-Business Suite R12, try to access system by Forms and the following error is displayed:

FRM-92101: Forms Server

Java Exception:
oracle.forms.net.ConnectionException: Forms session <1> failed during startup: no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown Source)
at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DataOutputStream.flush(Unknown Source)
at oracle.forms.net.HTTPConnection.connect(Unknown Source)
at oracle.forms.engine.FormsDispatcher.initConnection(Unknown Source)
at oracle.forms.engine.FormsDispatcher.init(Unknown Source)
at oracle.forms.engine.Runform.initConnection(Unknown Source)
at oracle.forms.engine.Runform.startRunform(Unknown Source)
at oracle.forms.engine.Main.createRunform(Unknown Source)
at oracle.forms.engine.Main.start(Unknown Source)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
In $LOG_HOME/ora/10.1.3/j2ee//_/application.log next error is displayed:

yy/dd/mm

In formsstd.out next error is displayed:

$ORACLE_HOME/bin/frmweb: error while loading shared
libraries: libXm.so.2: cannot open shared object file: No such file or directory

Solution

To implement the solution, please execute the following steps:

1. Install package openmotif rpm.
For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is:
openmotif21-2.1.30-11.EL5.i386.rpm.
2. Bounce the services.
3. Retest.

References

NOTE:402310.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (32-bit)

IE 8 is Supported for the following cases in R12

The Cases are given bellow:
E-Business Suite Release 12.0 Prerequisites
  • Oracle Applications Technology R12.ATG_PF.A.DELTA.6 (patch 7237006) or later
  • Oracle Forms Version 10.1.2.3 or later
  • Desktop client running Microsoft IE 8 on:
  • Windows XP Service Pack 2 or 3
  • Windows Vista Service Pack 1 or 2

E-Business Suite Release 12.1 Prerequisites

  • Oracle E-Business Suite 12.1.1
  • Desktop client running Microsoft IE 8 on:
  • Windows XP Service Pack 2 or 3
  • Windows Vista Service Pack 1 or 2

R12 Performance issue when clicking 'Monitor Request' after Submitting Concurrent Requests

In R12, when clicking on the 'Monitor requests' button after submitting a request, It is taking longer time for this screen to open. This performance issue can be reproduced when invoking the standard concurrent request submission (or) View request page  from Oracle Application Framework (OAF) from various modules like Quoting, Report Manager, etc.

Solution

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 9747291
2. Ensure that you have taken a backup and Apply the patch in a test environment. .
3. Confirm the following file versions

RequestSummarySearchVO.xml  120.14.12010000.3
You can use the commands like the following:
strings -a $JAVA_TOP/oracle/apps/fnd/cp/viewreq/server/RequestSummarySearchVO.xml | grep Header

4. Retest the issue.
5. Migrate the solution as appropriate to other environments.

After Cloning Some files and symbolic links still contain references to the source system

After Cloning Some files and symbolic links still contain references to the source system

$ORACLE_HOME/bin/qxmlctl
$ORACLE_HOME/bin/clscfg
$ORACLE_HOME/bin/clsfmt
$ORACLE_HOME/bin/dbca
$ORACLE_HOME/bin/dbua
$ORACLE_HOME/bin/dropjava
$ORACLE_HOME/bin/emagentdeploy.pl
$ORACLE_HOME/bin/emtgtctl
$ORACLE_HOME/bin/emutil
$ORACLE_HOME/bin/emca
$ORACLE_HOME/bin/emutil
$ORACLE_HOME/bin/netca
$ORACLE_HOME/lib32/ldflags
$ORACLE_HOME/lib/hsdb_inf.so -> /lib32/hsdb_inf.so
$ORACLE_HOME/lib/hsdb_odbc.so -> /lib32/hsdb_odbc.so
$ORACLE_HOME/lib/hsdb_oing.so -> /lib32/hsdb_oing.so
$ORACLE_HOME/lib/hsdb_ora.so -> /lib32/hsdb_ora.so
$ORACLE_HOME/lib/hsdb_syb.so -> /lib32/hsdb_syb.so
Cause
This can be caused by a failure with the OUI native clone process. If an ORACLE_HOME is already registered in the Global inventory, whether the purpose is to refresh an existing Target instance, or the original instance was removed from the file system (but not from the inventory), then OUI native cloning will assume the instance is already registered and no further configuration is required. This will result in an incomplete target system with files and links still referencing the source instance.  This can also occur for any failure of runInstaller during cloning.

Any problems with ouicli.pl will be detailed in the log files :
/appsutil/log/$CONTEXT_NAME/ohclone.log
$INST_TOP/admin/log/ohclone.log
/logs/cloneActions.log
/logs/oraInstall.log
/logs/silentInstall.log

The following extract from ohclone.log shows a typical example of this problem:-

SEVERE: OUI-10197:Unable to create a new Oracle Home at . Oracle Home already exists at this location. Select another location. INFO: User Selected: Yes/OK      java.io.IOException: OUI-10197:Unable to create a new Oracle Home at . Oracle Home already exists at this location. Select another location.
Possible solutions to this are to rerun the native OUI cloning :

Solution 1 :
Use this if the Global Inventory is shared amongst multiple instances :

- Run OUI and "De-install" the unwanted ORACLE_HOME
- Recopy the files from Source system
- Reconfigure the Target system using the "perl adcfgclone.pl" scripts.

Solution 2 :
Use this if the Global Inventory is local to this ORACLE_HOME, i.e oraInst.loc "inventory_loc" points to :
inventory_loc=/admin/oui/$CONTEXT_NAME/oraInventory
         or (for the Applications Tier)
inventory_loc=/admin/oraInventory
Rename the global inventory :
cd RDBMS $ORACLE_HOME>/admin/oui/$CONTEXT_NAME
mv oraInventory oraInventory.bkp
       or (for the Applications Tier)
cd /admin
mv oraInventory oraInventory.bkp
Create an empty directory and set permissions :
mkdir oraInventory
chmod 777 oraInventory
Rerun the ouicli.pl scripts to register the ORACLE_HOME (repeat for all RDBMS, Tools and Web each if required) :
cd ORACLE_HOME/appsutil/clone/
./ouicli.pl

Check the log files as listed above

Database Tier clone fails with adlnkoh.sh on 64bit machines

Database Tier clone fails with adlnkoh.sh on 64bit machines

When attempting to clone 'perl adcfgclone.pl dbtier' fails on db tier, adlnkoh.sh fails with the following error:

ERROR
Failed linking target libnmarl on
CauseThe problem is linked to Note:471476.1 32 Bit Libraries Are Not Installed With Oracle11g (11.1.0.6)
For RapidClone, this was raised in Bug 7602049

Solution
Apply Patch:7207440 TXK - 12.0.4 Consolidated Patch 1 to the Source instance and redo the cloning steps.
This patch is already included in 12.0.6

sql to get the current JDBC driver version in the system

For application version 11.5.10 onwards ensure ATG_PF.H is applied onto the instance. Also ensure that you are using the latest version of the JDBC driver. You may run the following sql to get the current JDBC driver version in the system :
select bug_number, decode(bug_number,
         '3043762','JDBC drivers 8.1.7.3',
         '2969248','JDBC drivers 9.2.0.2',
         '3080729','JDBC drivers 9.2.0.4 (OCT-2003)',
         '3423613','JDBC drivers 9.2.0.4 (MAR-2004)',
         '3585217','JDBC drivers 9.2.0.4 (MAY-2004)',
         '3882116','JDBC drivers 9.2.0.5 (OCT-2004)',
         '3966003','JDBC drivers 9.2.0.5 (OCT-2004)',
         '3981178','JDBC drivers 9.2.0.5 (NOV-2004)',
         '4090504','JDBC drivers 9.2.0.5 (JAN-2005)',
         '4201222','JDBC drivers 9.2.0.6 (MAY-2005)') Patch_description
    from ad_bugs
    where bug_number in
         (
         '3043762',
         '2969248',
         '3080729',
         '3423613',
         '3585217',
         '3882116',
         '3966003',
         '3981178',
         '4090504',
         '4201222'
         )
    order by 2;

Killing the blocking session

Killing the blocking session
===============================

Normally, you should use the KILL USER SESSION menu found in TopSessions.
You can also issue an ALTER SESSION KILL SESSION sid, serial#; in an sqlplus
session.

When on unix or vms,you can kill the unix/vms shadow process directly. Is is not recommended.
When killing the shadow process, please be careful of shared servers in a multi-threaded environment.
e.g.
kill -9 6246   (shadow process on unix)
stop/id= (PROC SPID=SESS SPID on vms running single task) 

To find process information, one can execute this query:

column "ORACLE USER" format a11
column SERIAL# format 9999999
column "OS USER" format a8

    select distinct substr(s.username,1,11) "ORACLE USER", p.pid "PROCESS ID",
       s.sid "SESSION ID", s.serial#, osuser "OS USER", p.spid "PROC SPID",
       s.process "SESS SPID", s.lockwait "LOCK WAIT"
    from v$process p, v$session s, v$access a
    where a.sid=s.sid and
       p.addr=s.paddr and
       s.username != 'SYS'
       and a.sid in (select l.sid from v$lock l
                      where (id1,id2) in
                            (select b.id1, b.id2 from v$lock b where b.id1=l.id1 and
                             b.id2=l.id2 and b.request>0));

ORACLE USER PROCESS ID SESSION ID  SERIAL# OS USER  PROC SPID SESS SPID LOCK WAI
----------- ---------- ---------- -------- -------- --------- --------- --------
SCOTT               17         11     3313 oracle8i 6247      6246      801113A4
SCOTT               20         19     3611 oracle8i 6258      6257

Tuesday, August 17, 2010

FRM-92050: Failed to connect to the server: /forms/formservlet: -1

Internet Explorer 8 (IE8)

Multiple Sessions

Previous releases of Internet Explorer have allowed users to logon to the same Oracle E-Business Suite environment concurrently from the same desktop by launching each application session through a new browser session.
By default the ‘Session Merging’ feature within IE8 prevents this functionality from working correctly. This IE8 functionality causes the same session id to be used when accessing the same Oracle E-Business Suite environment despite opening a new browser window to launch a second session.
This can result in unusual behavior with invalid sessions causing errors such as “Your login session has become invalid" and failures to launch forms causing errors such as “FRM-92050: Failed to connect to the server: /forms/formservlet: -1"
To retain the use of multiple sessions to the same Oracle E-Business Suite environment with IE8, please use one of the workarounds below to ensure each browser session remains independent;
  1. Open a new explorer window using its own session cookie by selecting 'File -> New Session' from an existing browser window.
  2. Run from the command line adding the -nomerge parameter i.e. Start -> Run -> iexplore -nomerge
  3. Create a new IE8 icon adding the -nomerge parameter i.e.
    • Start -> Program Files
    • Right click on the Internet Explorer icon and select Properties
    • Add -nomerge to the end of the link in the Target field i.e.
      "C:\Program Files\Internet Explorer\iexplore.exe" -nomerge
    • Click the OK button to close the window
    • This icon may then be copied to the desktop if desired  

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...