Saturday, February 7, 2009

On fresh install: Forms session <1> failed during startup FRM-92101


Problem Description:

We installed 1204 fresh instance then upgraded to RUP6. After completion of rup6 activity the instace was working fine all the services are running fine without any failure.

The main problem encountered when we are accessing forms they are opening fine after some time they got hang state/r FRM-92101,92102 errors were frequently araising after some time. The root cause of this issue is below

[Wed Feb 4 11:11:12 2009] [notice] Oracle-Application-Server-10g/10.1.3.0.0 Oracle-HTTP-Server configured -- resuming normal operations

[Wed Feb 4 11:11:12 2009] [notice] Accept mutex: fcntl (Default: fcntl)

[Wed Feb 4 11:26:19 2009] [error] [client 122.169.29.45] [ecid: 1233726979:192.168.1.202:6608:0:23,0] Directory index forbidden by rule: /erpapps/UAT/apps/apps_st/comn/java/classes/

[Wed Feb 4 11:45:02 2009] [error] [client 122.169.46.193] [ecid: 1233728102:192.168.1.202:6547:0:37,0] Directory index forbidden by rule: /erpapps/UAT/apps/apps_st/comn/java/classes/

[Wed Feb 4 11:45:02 2009] [error] [client 122.169.46.193] [ecid: 1233728102:192.168.1.202:6547:0:38,0] File does not exist: /erpapps/UAT/apps/apps_st/comn/java/classes/oracle/apps/media/oracle/apps/media/splash.gif

[Wed Feb 4 11:45:02 2009] [error] [client 122.169.46.193] [ecid: 1233728102:192.168.1.202:6547:0:39,0] File does not exist: /erpapps/UAT/apps/apps_st/comn/java/classes/oracle/apps/media/oracle/apps/media/splash.gif

[Wed Feb 4 13:35:05 2009] [error] [client 122.169.50.30] [ecid: 1233734705:192.168.1.202:5705:0:62,0] Directory index forbidden by rule: /erpapps/UAT/apps/apps_st/comn/java/classes/

[Wed Feb 4 13:37:40 2009] [error] [client 122.169.50.30] [ecid: 1233734860:192.168.1.202:5704:0:124,0] Directory index forbidden by rule: /erpapps/UAT/apps/apps_st/comn/java/classes/

[Wed Feb 4 13:37:40 2009] [error] [client 122.169.50.30] [ecid: 1233734860:192.168.1.202:5704:0:125,0] File does not exist: /erpapps/UAT/apps/apps_st/comn/java/classes/oracle/apps/media/oracle/apps/media/splash.gif

[Wed Feb 4 13:37:41 2009] [error] [client 122.169.50.30] [ecid: 1233734861:192.168.1.202:5704:0:126,0] File does not exist: /erpapps/UAT/apps/apps_st/comn/java/classes/oracle/apps/media/oracle/apps/media/splash.gif

[Wed Feb 4 13:42:02 2009] [error] [client 122.169.50.30] [ecid: 1233735122:192.168.1.202:5709:0:72,0] Directory index forbidden by rule: /erpapps/UAT/apps/apps_st/comn/java/classes/

[Wed Feb 4 13:42:02 2009] [error] [client 122.169.50.30] [ecid: 1233735122:192.168.1.202:5709:0:73,0] File does not exist: /erpapps/UAT/apps/apps_st/comn/java/classes/oracle/apps/media/oracle/apps/media/splash.gif

[Wed Feb 4 13:42:02 2009] [error] [client 122.169.50.30] [ecid: 1233735122:192.168.1.202:5709:0:74,0] File does not exist: /erpapps/UAT/apps/apps_st/comn/java/classes/oracle/apps/media/oracle/apps/media/splash.gif

cause:

The Rapidinstall created symbolic links to an area not on the system.

Possibly to an internal Oracle test area.

The file "ldflags" in $ORACLE_HOME/lib32 is missing or pointing to a wrong location

Solution:

To implement the solution, please execute the following steps:

1.The file "ldflags" in $ORACLE_HOME/lib32 is missing or pointing to a wrong location, recreate

the symbolic link

$ rm $ORACLE_HOME/lib32/ldflags

$ ln -s $ORACLE_HOME/lib/ldflags $ORACLE_HOME/lib32/ldflags

make -f ins_forms.mk install

2.Relink the forms executables. Please follow the next below steps:

2.1. Source the Applications environment file

2.2. Run the folloiwng comand to relink the forms from 10.1.2 home/lib folder

make -f ins_forms.mk install

Or make -if ins_forms.mk install

2.3.generate all forms through adadmin.

2.4. Re-test the issue.

Reference:

DocId : 469428.1



Monday, February 2, 2009

Usage of adclonectx.pl in Oracle Apps

adclonectx.pl script running automatically while we are running adcfgclone.pl when we are doing cloning using rapid clone utility.

This perl script is use to retrieve the Application Context File is Currupted/Deleted.
The Applications & Database Context Files are retrieved by running the adclonectx.pl script

To Retrieve the Applications Tier Context File (R12):

1.Exceute the following script
Perl /clone/bin/adclonectx.pl retrieve

2. On being promted for the context file to be retrieved, select the option of retrieving the applications Tier context file that has been lost and retrieve it to the default location specified by the script.

This is procedure will be useful when INST_TOP is still available. If accidentally it was also loss then the application context file retrieval is as follows:

1. Execute the below script in the Database Tier
Perl /appsutil/clone/bin/adclonectx.pl retrieve

2. On being prompted for the context file to be retrieved, select the option of retrieving the applications tier context file that has been lost.

3. While confirming the location of the context file, set it to any existing directory with write permissions.

4. Once the context file has been generated in the specified location, move it to the specified location for the context file in the context variable ‘s_contextfile’.

To Retrieve the Database Tier Context File:

1. Execute the below script in the Database Tier
Perl /appsutil/clone/bin/adclonectx.pl retrieve

2. On being prompted for the context file to be retrieved, select the option of retrieving the database tier context file that has been lost and retrieve it to the default location specified by the script .

Enabling Mails in Linux

MAIL
First run a quick test to make sure the “sendmail” application is installed and working correctly. Execute the following command, replacing “you@youremailid.com” with your e-mail address.
Enable the mail services in server
For enabling the mail services we have to follow the following steps
U must know the nameserver of the Email server.

U must login as superuser for enebling the services.
1. vi /etc/mail/sendmail.mc ----open file and search 127


edit line dnl# DAEMON_OPTIONS(`PORT=smtp,Addr=127.0.0.1, Name=MTA')

2. m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf

3. /etc/init.d/sendmail restart

# mail -s “Hello world” you@youremailid.com

Hit the return key and you will come to a new line. Enter the text “This is a test from my server”. Follow up the text by hitting the return key again. Then hit the key combination of Control+D to continue. The command prompt will ask you if you want to mark a copy of the mail to any other address, hit Control+D again. Check your mailbox. This command will send out a mail to the email id mentioned with the subject, “Hello world”.
To add content to the body of the mail while running the command you can use the following options. If you want to add text on your own:

# echo “This will go into the body of the mail.” | mail -s “Hello world” you@youremailid.com

And if you want mail to read the content from a file:

# mail -s “Hello world” you@youremailid.com < /home/calvin/application.log

Some other useful options in the mail command are:

-s subject (The subject of the mail)
-c email-address (Mark a copy to this “email-address”, or CC)
-b email-address (Mark a blind carbon copy to this “email-address”, or BCC)

Here’s how you might use these options:

# echo “Welcome to the world of Calvin n Hobbes” | mail -s “Hello world” u@umailid.com -c copier@copiermail.com -b bcc@bccmail.com