Clone

How to route / send all workflow mailer notifications to a single email id / address ?

Posted on September 12, 2008. Filed under: Clone, Configuration, DBA/Admin Tips, R12, Workflow Mailer | Tags: , , , |

Mostly, this option will come handy after a clone, wherein you want to retain all the production / source instance data and continue to run workflow mailer but without sending emails to the real end users.

To achieve this you can set an Override address to route all the notifications to a single email address.

Steps

1. Login as sysadmin
2. Select System Administration Responsibility
3. Click Workflow under Oracle Applications Manager
4. Click on the tick mark or page icon next to Notification Mailers
5. Click on Workflow Notification Mailer under Name column
6. Click “Set Override Address” button next to Test Mailer button
7. Key in the new email address and click submit.

After submitting, Java mailer will send a verification email to the mentioned email address with a verification code and link to activate the override entry.

Either you can request the email id owner to send you the email with the verification code so that you can key-in the code or if the email address owner has access to Oracle Apps, he/she can click the link and enter the verification code.

cheers,
OraclePitStop.

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

Cloning or Refresh – What did I do?

Posted on August 25, 2008. Filed under: Clone, DBA/Admin Tips | Tags: , , |

Most of us use these terms, interchangeably. Is there a difference in the actual meaning of these terms, Yes, it does.

Clone – Describes when you create a new environment exactly as that of an existing environment. Eg. RAC to RAC, Multi Node Appl Top to Multi Node Appl Top

Refresh – Describes wherein you already have an environment (same replica or different) and you just sync the data between the instances. (eg. RAC to Non-Rac, Multi Node Appl Top to Single Node Appl Top)

So what did you do over the weekend, cloning or refresh 

cheers,
OraclePitStop

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

Post Clone – Forms Error – oracle.forms.engine.RunformException: Forms session failed during startup: no response from runtime process

Posted on August 12, 2008. Filed under: Clone, Diagnostics, R12, TroubleShooting | Tags: , , , , , , |

We recently did a clone and everything went well – autoconfig ran properly – services started sucessfully – but when we selected a responsibility which will launch a form it errored out with below message :

formsweb: Forms session exception stack trace:
oracle.forms.engine.RunformException: Forms session failed during startup: no response from runtime process
at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

Checking the log file revealed more information

formsweb: Forms session aborted: runtime process failed during startup with errors /usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘nnftboot’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘nnfoboot’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘nnfoboot’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘nnfhboot’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘nnfhboot’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘nnflboot’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘nttini’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘ntusini’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘ntpini’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.
/usr/lib/hpux32/dld.so: Unsatisfied code symbol ‘ntzini’ in load module ‘/opt/var/applbin/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1’.

As a normal standard practice we normally recreate all the symbolic links under APPL_TOP, but still we got this error. Now heres the

Solution :

Stop the forms services (if possible run adopmnctl.sh stopall)
cd $ORACLE_HOME/forms/lib32
make -f ins_forms.mk install
restart the services.

cheers,
OraclePitStop

Read Full Post | Make a Comment ( 3 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 )

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