Uncategorized

Process exiting status in Oracle Application R12

Posted on May 11, 2009. Filed under: Uncategorized |

Issue:
======
a) Unable to launch the application or Home page hangs in Oracle Application Release R12
b) If you check the services on the web/Admin node, you can see process
ps -ef | grep -i exiting

– 647302 – – – exiting
– 708754 – – – exiting
– 925856 – – – exiting
– 983252 – – – exiting
– 1044536 – – – exiting
– 1134628 – – – exiting
– 1138768 – – – exiting

You can’t kill these process also
Only workaround is rebooting the box and start the services and it works fine.

This Issue will occur again after 2 weeks or less.

Application log error shows like below…….

java.io.IOException: Broken pipe
at sun.nio.ch.FileDispatcher.write0(Native Method)
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:132)
at sun.nio.ch.IOUtil.write(IOUtil.java:103)
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:329)
at java.nio.channels.Channels.write(Channels.java:74)
at java.nio.channels.Channels.access$000(Channels.java:61)
at java.nio.channels.Channels$1.write(Channels.java:148)
at com.evermind.server.http.AJPOutputStream.endRequest(AJPOutputStream.java:117)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:306)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:797)

Cause:
=======
pid directories are placed on shared mount point.

Solution:
=========
a) Make sure all your pid variables are pointing to local disk in Context File…

s_lock_pid_dir
s_pids_dir
s_web_pid_file

b) Change in all the nodes and run Autoconfig.

Note:
It is always better to keep the $INST_TOP on local disk to avoid performance Issues.

Read Full Post | Make a Comment ( 2 so far )

Oracle R12 Reports are failing with Rep 3000 error on IBM AIX

Posted on March 24, 2009. Filed under: Uncategorized |

Issue :
In R12 on IBM AIX Reports are failing with Rep 3000 error

Description:
We all know that there is no concept of Display for generating reports in R12, there is…..:) but only on IBM AIX.
We need to set the display in IBM AIX for R12 to generate the reports output without error.

Solution ;

a) Go to CM(Admin) Node
b) Login in as Application User
c) Find the display from CONTEXT_FILE

Ex :
-bash-3.2$ grep -i display $CONTEXT_FILE
oratestdev:0.0

Here the display is 0.0

d) export DISPLAY=localhost:0.0
e) /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm — :0 -vfb -force -x abx -x dbe -x GLX &
f) xhost +
g) Login as root
h) export DISPLAY=localhost:0.0
i) xhost +

Thanks,
Sam.

Read Full Post | Make a Comment ( 1 so far )

Oracle 11i forms crash in IE

Posted on March 24, 2009. Filed under: Uncategorized |

Issue :
Unable to open forms due to IE Error in 11i or Forms crashes with IE Error or Jinitiator Issue
This is due to jvm incompatibility used by other Application or tools.

Solution :
a) Go to program files java ==> jre1.6.0_07 (Or recent jre you can download from java.sun.com)
Path : C:\Program Files\Java\jre1.6.0_07\bin\client
b) Copy the jvm.dll file
c) Go to C:\Program Files\Oracle\JInitiator 1.3.1.21\bin\hotspot
d) Take the backup of current jvm.dll file
e) Copy the jvm.dll file which you have copied from the above jre directory.
f) Close all the browsers and restart
g) You can access the forms now

Thanks,
Sam.

Read Full Post | Make a Comment ( 5 so far )

Is user equivelance really required at the OS level after RAC installation?

Posted on December 18, 2008. Filed under: Database, DBA/Admin Tips, Operating System, RAC, TroubleShooting, Uncategorized | Tags: , , , |

A wild though came to my head late this evening about the user equivelance in RAC. What will happen if i remove the user equivelance for the oracle home owner between the RAC nodes. What do you think – will this mess up the normal operation of the database ???

BTW, User Equivelance = Ability to ssh between rac nodes without password.

Assumptions

RAC Servers: RAC_NODE_1, RAC_NODE_2
DB Name : opitstop
DB Owner : orapstop

orapstop@RAC_NODE_1

1. srvctl stop database -d OPITSTOP
2. cd $HOME/.ssh && mv authorized_keys authorized_keys_old [ authorized_keys file holds the rsa/dsa keys, which enables ssh to other boxes without password]

At this stage, opitstop DB is down and RAC_NODE_2 cannot ssh to RAC_NODE_1 since RAC_NODE_1 authorized_keys file had been moved.

orapstop@RAC_NODE_2

cd $HOME/.ssh && mv authorized_keys authorized_keys_old

Now both the nodes cannot do ssh between them without password.

orapstop@RAC_NODE_1

Lets start the database, using srvctl to see if it errors out

srvctl start database -d OPITSTOP

NOPE, it doesnt … it works as before, started the instances on both RAC_NODE_1 and RAC_NODE_2.

At this stage in the alert log file, the database was able to get information about the other node and a select on gv$instance shows both instances too. I let the db to run for sometime … still there was no error.

Now lets revert back the user equivelance on both nodes.

orapstop@RAC_NODE_1: cd $HOME/.ssh && mv authorized_keys_old authorized_keys
orapstop@RAC_NODE_2: cd $HOME/.ssh && mv authorized_keys_old authorized_keys

So based on this excercise my conclusion is, user equivelance is required only for RAC installation’s / RAC binary upgrades viz., 10.2.0.1 to 10.2.0.3 or 4 / patching using opatch option napply and not for normal operations of the database.

Oh yeah, its a good feeling to mess up with the setup and to get it back working.

Happy Messing !!!

cheers,
OraclePitStop

Read Full Post | Make a Comment ( None so far )

Missing Libraries during Post Clone Stage (adcfgclone.pl)

Posted on August 12, 2008. Filed under: Clone, Configuration, R12, Uncategorized | Tags: , , |

We recently faced this interesting issue during the post clone stage. All the .a and .o library files were removed during execution of adcfgclone.pl which ultimately results in relinking errors of forms and reports … strange isnt it …

Both Source and Target boxes were of the same OS configuration : HP UX 11.23 Itanium 64 Bit

For some reason adcfgclone.pl was doing a platform migration instead of normal cloning.

The culprit was this file – SystemCheck.java ($AD_TOP/java/oracle/apps/ad/util) version 120.11.12000000.5, which gets copied to $COMMON_TOP/clone/jlib/java/oracle/apps/ad/util during adpreclone.pl on the Source Instance, which is later used to verify the target server OS Platform during execution of adcfgclone.pl on the target instance.

Solution

Apply Patch p6679053_R12.TXK.A_R12_GENERIC.zip

This patch brings in a new version of SystemCheck.class file (SystemCheck.java 120.11.12000000.7) which identifies and stores the host platform information as HPUX_IA64 against the previous version of the same file (SystemCheck.java 120.11.12000000.5) which stores as HPUX_IA_64, which results in removing of .a & .o files (Platform migration).

cheers,
OraclePitStop

Read Full Post | Make a Comment ( None so far )

Beware of costly typos “crontab -r”

Posted on August 14, 2007. Filed under: Uncategorized |

Folks,

Today, i made a costly mistake in my Production definitely worth sharing !!!

On our HP-UX machine, as ‘oracle’ user , instead of issuing ‘crontab -e’,

i mistyped as ‘crontab -r’ and guess what, ALL MY CRON JOBS VANISHED !!!

****************** 

/home/oracle> crontab -r

/home/oracle>

/home/oracle> crontab -l

/home/oracle>

*******************

LUCKily i had saved the “crontab -l” listing sometime. So, i edited again

and scheduled everything.  So, beware of such costly typos and do remember

this generally happens when you are in Prod box !!!

Hope this tip was helpful.

Thanks,

Arun (OraclePitStop)

Read Full Post | Make a Comment ( None so far )

Liked it here?
Why not try sites on the blogroll...