Below list of log file locations which will be helpful for trouble shooting errors in oracle applications 11i
- OCA (Oracle Certificate Authority)
$ORACLE_HOME/oca/logs/admin.log
- OHS (Oracle HTTP Server)
$ORACLE_HOME/Apache/Apache/conf/ssl_engine_log
$ORACLE_HOME/Apache/Apache/conf/ssl_request_log
$ORACLE_HOME/Apache/Apache/conf/access_log
$ORACLE_HOME/Apache/Apache/conf/error_log
- OID (Oracle Internet Directory)
$ORACLE_HOME/ldap/log/oidmon.log
$ORACLE_HOME/ldap/log/oidldapd01.log
$ORACLE_HOME/ldap/log/oidldapd02.log
$ORACLE_HOME/ldap/odi/log/*.trc
$ORACLE_HOME/ldap/odi/log/*.aud
- OPMN
$ORACLE_HOME/opmn/logs/ipm.log
- SSO
$ORACLE_HOME/sso/log/ssoServer.log
- Web Cache
$ORACLE_HOME/webcache/logs/event_log
$ORACLE_HOME/webcache/logs/access_log
- E-Business Suite
$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log
$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_request_log
$IAS_ORACLE_HOME/Apache/Apache/logs/access_log
$IAS_ORACLE_HOME/Apache/Apache/logs/error_log
$IAS_ORACLE_HOME/Apache/JServ/logs
- Portal
$ORACLE_HOME/j2ee/OC4J_Portal/application-deployments/portal/OC4J_Portal_default_island_1/application.log
Enabling Additional SSL Debugging
- OCA
$ORACLE_HOME/oca/bin/ocactl set -type LOG -state
$ORACLE_HOME/oca/bin/ocactl set -type TRACE -state
$ORACLE_HOME/oca/bin/ocactl clear -type <>
- OHS
$ORACLE_HOME/Apache/Apache/conf - set LogLevel $ORACLE_HOME/Apache/Apache/ssl.conf$ORACLE_HOME/Apache/Apache/ocm_apache.conf (Infrastructure Tier Only)
- E-Business Suite
$IAS_ORACLE_HOME/Apache/Apache/conf
Wednesday, January 28, 2009
Tuesday, January 27, 2009
Determining WF Java Mailer availability without using Oracle Application Manager
The Workflow Java Mailer status can be checked on table FND_SVC_COMPONENTS. The column “component_status” tells the status of the different Service Components
This table holds just a few rows and the component for the Java Mailer is called 'Workflow Notification Mailer' with component id 10006.
This table can be queried up any time using Cron jobs. So whenever the mailer is detected down, A mail can be sent to the administrator who can log in and restart the mailer.
SQL statement to query the status of the workflow mailer
SQL> select COMPONENT_ID,COMPONENT_STATUS from FND_SVC_COMPONENTS where COMPONENT_ID=10006;
COMPONENT_ID COMPONENT_STATUS
------------ ----------------------------------------------
10006 DEACTIVATED_SYSTEM
Tuesday, January 20, 2009
Blank login page in Oracle applications Release 12
When the apps URL is entered in the web browser, A blank login page is returned. The application.log under $INST_TOP//logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1 shows the following error message similar to the one below.
====================================================================================
javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException:
Missing class: _AppsLocalLogin
Dependent class: oracle.jsp.runtimev2.JspPageInfo Loader: oc4j:10.1.3 Code-Source: /u02/oracle/RE12/apps/tech_st/10.1.3/j2ee/home/lib/ojsp.jar Configuration:in META-INF/boot.xml in /u02/oracle/RE12/apps/tech_st/10.1.3/j2ee/home/oc4j.jar
====================================================================================
To solve the issue, Recompile the JSP’s by issuing the following command the the linux prompt.
perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 20
====================================================================================
javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException:
Missing class: _AppsLocalLogin
Dependent class: oracle.jsp.runtimev2.JspPageInfo Loader: oc4j:10.1.3 Code-Source: /u02/oracle/RE12/apps/tech_st/10.1.3/j2ee/home/lib/ojsp.jar Configuration:
====================================================================================
To solve the issue, Recompile the JSP’s by issuing the following command the the linux prompt.
perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 20
Monday, January 19, 2009
Automating startup/shutdown of Oracle database on Linux
The following script can be used to automate database startup/shutdown of an Oracle database on Linux platform.
- update the oratab file under /etc or /var/opt/oracle
"SID":"ORACLE_HOME":Y
where Y states that the database to be started up/shutdown
- Create the service script in the following location:
/etc/init.d/
vi dbora
- Modify the following script to match the specific environment and This becomes the content of the "dbora" service script.
===================================================================================
#!/bin/sh
# chkconfig: 35 99 10
# description: Starts and stops Oracle processes
DB_SCRIPTS=" FULL DATABASE SCRIPT LOCATION HERE"
APPS_SCRIPTS=:" FULL APPS SCRIPT LOCATION HERE"
ORADEV_OWNER=DB_USER
APPSDEV_OWNER=APPS_USER
LOG_FILE='touch /var/lock/subsys/dbora'
case "$1" in
'start') # Start the Oracle database,listener and apps
su - $ORADEV_OWNER -c "$DB_SCRIPTS/addbctl.sh start"
su - $ORADEV_OWNER -c "$DB_SCRIPTS/addlnctl.sh start SID"
sleep 100
su - $APPSDEV_OWNER -c "$APPS_SCRIPTS/adstrtal.sh apps/apps"
;;
'stop') # Stop the Oracle database,listener and apps
su - $APPSDEV_OWNER -c "$APPS_SCRIPTS/adstpall.sh apps/apps"
sleep 300
su - $ORADEV_OWNER -c "$DB_SCRIPTS/addlnctl.sh stop SID"
su - $ORADEV_OWNER -c "$DB_SCRIPTS/addbctl.sh stop immediate"
rm /var/lock/subsys/dbora
;;
esac
===================================================================================
Modify the sleep time according to the speed of the server and the time taken by the server to startup and shutdown the instance.
- Set script permissions:
chmod 755 /etc/init.d/dbora
- Register the Service
at the terminal prompt, issue the following command.
chkconfig --add dbora
The chkconfig creates the following symbolic links,
On SuSE SLES7:
* /etc/init.d/rc0.d/K10dbora
* /etc/init.d/rc1.d/K10dbora
* /etc/init.d/rc2.d/K10dbora
* /etc/init.d/rc3.d/S99dbora
* /etc/init.d/rc4.d/K10dbora
* /etc/init.d/rc5.d/S99dbora
* /etc/init.d/rc6.d/K10dbora
On Red Hat Advanced Server:
* /etc/rc.d/rc0.d/K10dbora
* /etc/rc.d/rc1.d/K10dbora
* /etc/rc.d/rc2.d/K10dbora
* /etc/rc.d/rc3.d/S99dbora
* /etc/rc.d/rc4.d/K10dbora
* /etc/rc.d/rc5.d/S99dbora
* /etc/rc.d/rc6.d/K10dbora
The symbolic links are not created in SLES8 and after with the 'chkconfig -add' command. To have the symbolic links created run the following in addition:
/sbin/chkconfig --set dbora 35
- Now the instance will startup automatically when Linux boots up.
- update the oratab file under /etc or /var/opt/oracle
where Y states that the database to be started up/shutdown
- Create the service script in the following location:
/etc/init.d/
vi dbora
- Modify the following script to match the specific environment and This becomes the content of the "dbora" service script.
===================================================================================
#!/bin/sh
# chkconfig: 35 99 10
# description: Starts and stops Oracle processes
DB_SCRIPTS=" FULL DATABASE SCRIPT LOCATION HERE"
APPS_SCRIPTS=:" FULL APPS SCRIPT LOCATION HERE"
ORADEV_OWNER=DB_USER
APPSDEV_OWNER=APPS_USER
LOG_FILE='touch /var/lock/subsys/dbora'
case "$1" in
'start') # Start the Oracle database,listener and apps
su - $ORADEV_OWNER -c "$DB_SCRIPTS/addbctl.sh start"
su - $ORADEV_OWNER -c "$DB_SCRIPTS/addlnctl.sh start SID"
sleep 100
su - $APPSDEV_OWNER -c "$APPS_SCRIPTS/adstrtal.sh apps/apps"
;;
'stop') # Stop the Oracle database,listener and apps
su - $APPSDEV_OWNER -c "$APPS_SCRIPTS/adstpall.sh apps/apps"
sleep 300
su - $ORADEV_OWNER -c "$DB_SCRIPTS/addlnctl.sh stop SID"
su - $ORADEV_OWNER -c "$DB_SCRIPTS/addbctl.sh stop immediate"
rm /var/lock/subsys/dbora
;;
esac
===================================================================================
Modify the sleep time according to the speed of the server and the time taken by the server to startup and shutdown the instance.
- Set script permissions:
chmod 755 /etc/init.d/dbora
- Register the Service
at the terminal prompt, issue the following command.
chkconfig --add dbora
The chkconfig creates the following symbolic links,
On SuSE SLES7:
* /etc/init.d/rc0.d/K10dbora
* /etc/init.d/rc1.d/K10dbora
* /etc/init.d/rc2.d/K10dbora
* /etc/init.d/rc3.d/S99dbora
* /etc/init.d/rc4.d/K10dbora
* /etc/init.d/rc5.d/S99dbora
* /etc/init.d/rc6.d/K10dbora
On Red Hat Advanced Server:
* /etc/rc.d/rc0.d/K10dbora
* /etc/rc.d/rc1.d/K10dbora
* /etc/rc.d/rc2.d/K10dbora
* /etc/rc.d/rc3.d/S99dbora
* /etc/rc.d/rc4.d/K10dbora
* /etc/rc.d/rc5.d/S99dbora
* /etc/rc.d/rc6.d/K10dbora
The symbolic links are not created in SLES8 and after with the 'chkconfig -add' command. To have the symbolic links created run the following in addition:
/sbin/chkconfig --set dbora 35
- Now the instance will startup automatically when Linux boots up.
Tuesday, January 13, 2009
Identifying and compiling invalid objects in Oracle applications:
Invalid objects can occur for many reasons. You will usually find invalid objects after upgrading, or applying patches Invalid objects are usually caused by missing grants, synonyms, views, tables or packages, but can also be caused by corrupted packages.
You should normally use DBA_OBJECTS for querying the invalid objects because it returns every object in the Database.
Use this command to find the number of invalid objects in database.
SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
For a more detailed query, use the following script:
SELECT OWNER, OBJECT_TYPE, COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID' GROUP BY OWNER, OBJECT_TYPE;
There are different ways to recompile invalid objects in schema.
1. DBMS_DDL
2. DBMS_UTILITY
3. UTL_RECOMP
4. UTLRP.SQL
DBMS_DDL
Syntax: Exec dbms_ddl.alter_compile(type,schema,name)
Where
Type : Must be procedure,function,package or package body.
Schema : Database username.
Name: Object name
Example:
Sql> exec dbms_ddl.alter_compile ('PROCEDURE','SCOTT','TEST');
PL/SQL procedure successfully completed.
DBMS_UTILITY:
This compiles the object in the specified schema.
Syntax
Exec dbms_utility.compile_schema ( schema,compile all)
Schema : Database Username
Compile All : Object type ( procedure, function, packages,trigger)
Example
SQL> exec dbms_utility.compile_schema('SCOTT');
PL/SQL procedure successfully completed
UTL_RECOMP
Syntax
Exec UTL_RECOMP.RECOMP_SERIAL ();
Example
SQL> Exec UTL_RECOMP.RECOMP_SERIAL ();
PL/SQL procedure successfully completed
Note: Required SYS user to run this package
UTLRP.SQL
Syntax
Located: $ORACLE_HOME/rdbms/admin
Example:
Sql> @$ ORACLE_HOME/rdbms/admin/utlrp.sql
Objects that requires recompilation are:VIEW, SYNONYM, PUBLIC SYNONYM, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER, UNDEFINED , JAVA CLASS, TYPE, TYPE BODY
You should normally use DBA_OBJECTS for querying the invalid objects because it returns every object in the Database.
Use this command to find the number of invalid objects in database.
SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
For a more detailed query, use the following script:
SELECT OWNER, OBJECT_TYPE, COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID' GROUP BY OWNER, OBJECT_TYPE;
There are different ways to recompile invalid objects in schema.
1. DBMS_DDL
2. DBMS_UTILITY
3. UTL_RECOMP
4. UTLRP.SQL
DBMS_DDL
Syntax: Exec dbms_ddl.alter_compile(type,schema,name)
Where
Type : Must be procedure,function,package or package body.
Schema : Database username.
Name: Object name
Example:
Sql> exec dbms_ddl.alter_compile ('PROCEDURE','SCOTT','TEST');
PL/SQL procedure successfully completed.
DBMS_UTILITY:
This compiles the object in the specified schema.
Syntax
Exec dbms_utility.compile_schema ( schema,compile all)
Schema : Database Username
Compile All : Object type ( procedure, function, packages,trigger)
Example
SQL> exec dbms_utility.compile_schema('SCOTT');
PL/SQL procedure successfully completed
UTL_RECOMP
Syntax
Exec UTL_RECOMP.RECOMP_SERIAL ();
Example
SQL> Exec UTL_RECOMP.RECOMP_SERIAL ();
PL/SQL procedure successfully completed
Note: Required SYS user to run this package
UTLRP.SQL
Syntax
Located: $ORACLE_HOME/rdbms/admin
Example:
Sql> @$ ORACLE_HOME/rdbms/admin/utlrp.sql
Objects that requires recompilation are:VIEW, SYNONYM, PUBLIC SYNONYM, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER, UNDEFINED , JAVA CLASS, TYPE, TYPE BODY
Monday, January 12, 2009
To find out linux release information:
Use the below command to find the version of linux
In Redhat Linux:
$ cat /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant Update 3)
In Suse-Linux:
$ cat /etc/SuSE-release
SUSE LINUX Enterprise Server 9 (i586) VERSION = 9
To find out kernel version:
$ uname -s -r
Linux 2.6.9-34.0.2.ELsmp$ uname -aLinux mybox.xyz.abc.com 2.6.9- 55.0.2.0.1.ELsmp #1 SMP Mon Jun 25 14:40:37 PDT 2007 x86_64 x86_64 x86_64 GNU/Linux
To find out what version of Glibc libraries:
$ rpm -q glibc
glibc-2.2.4-26
To find the more information on Glibc libraries . Use the below command.
$ rpm -qi glibc
Name : glibc Relocations: (not relocatable)
Version : 2.3.4 Vendor: XYZ USA
Release : 2.36
Build Date: Tue 13 Mar 2007 08:45:33 GMT
Install Date: Tue 15 May 2007 09:10:50 BST
Build Host: ca-build7.xyz.abc.com
Group : System Environment/Libraries Source
RPM: glibc-2.3.4-2.36.src.rpm
Size : 11958551
License: LGPL
Signature : DSA/SHA1, Fri 30 Mar 2007 00:00:41 BST, Key ID 2e2bcdbcb38a8516
Summary : The GNU libc libraries.
Description :The glibc package contains standard libraries which are used by..
Friday, January 9, 2009
Identifying if OS and Oracle installation is 64 bit or 32 bit
Use the following steps to check if Operating system and Oracle software is 32 bit or 64 bit
Determining whether OS is 64 bit or 32 bit:
- On Solaris,
$ /usr/bin/isainfo -kv
64-bit amd64 kernel modules
$ /usr/bin/isainfo -v
64-bit amd64 applications
cx16 mon sse3 pause sse2 sse fxsr mmx cmov amd_sysc cx8 tsc fpu
32-bit i386 applications
cx16 mon sse3 pause sse2 sse fxsr mmx cmov sep cx8 tsc fpu
This output tells us that solaris operating systems allow co-existence of 32-bit and 64-bit files.
- On AIX,
$ getconf -a | grep KERN
$ file /usr/lib/boot/unix*
- On HP-UX,
$ /usr/bin/ getconf KERNEL_BITS
$ /usr/bin/file /stand/vmunix
- On linux,
$uname -a
Linux debian 2.6.18-4-686 #1 SMP Wed May 9 23:03:12 UTC 2007 i686 GNU/Linux
If the output is x86_64 then 64-bit and i686 or similar for 32-bit.
- On windows,
Start>All Programs>accessories> System Tools>System Information>look for under System summary.
Or start>run>dixdiag>Then check for WHQL digital signature.
Determining whether Oracle Software is 32 bit or 64 bit:
Method 1:
--------------
Go to $ORACLE_HOME/bin and check,
# cd $ORACLE_HOME/bin
# file oracle
oracle: ELF 64-bit LSB executable AMD64 Version 1, dynamically linked, not stripped
Here it comes 64 bit and hence oracle software is 64 bit. If the output of the "file oracle" command does not say 64-bit explicitly then you are running 32-bit Oracle.
If you had 32 bit oracle software installed then output will be like,
oracle@sol:/db/oracle/bin$ file oracle
oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), not stripped
Method 2: Check for lib, lib32 folders
--------------------------------------
1) $ORACLE_HOME/lib32
2) $ORACLE_HOME/lib
If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64 bit.
If only ORACLE_HOME/lib directory exists, then it is 32 bit.
Thursday, January 8, 2009
Install Linux driver for Ethernet - Marvell Yukon 88e8056 pci-e Gigabit Ethernet Controller
1. Install the Oracle Enterprise Linux 4.4 through the DVD’s (Start, 2, 3 & 4)
2. Once the installation is done go to Applications - > System Settings - > Network
3. Check whether the networking tab has some Ethernet found and active
4. If not then we are missing NIC driver for Linux for this hardware
5. Go to the following URL and download the driver,
http://www.marvell.com/drivers/driverDisplay.do?driverId=204
Driver Name: (Kernel v2.4.20 and Higher 2.4.x Kernels Linux Driver Install Package v10.61.3.3)
6. As we are not in the network, copy the driver in a USB and mount it in the Linux and install it by running the script,
bunzip2 -c install_A.B.C.D.tar.bz2 tar xfv –
# cd DriverInstall
#./install.sh
7. Once done reboot the server, the driver will make detect the Ethernet
8. Provide the IP through static assigning or through DHCP
9. It’ll take 15 minutes to start, once done Check the Applications - > System Settings - > Network - > Ethernet
10. The status will be active and now you are connected to the network
2. Once the installation is done go to Applications - > System Settings - > Network
3. Check whether the networking tab has some Ethernet found and active
4. If not then we are missing NIC driver for Linux for this hardware
5. Go to the following URL and download the driver,
http://www.marvell.com/drivers/driverDisplay.do?driverId=204
Driver Name: (Kernel v2.4.20 and Higher 2.4.x Kernels Linux Driver Install Package v10.61.3.3)
6. As we are not in the network, copy the driver in a USB and mount it in the Linux and install it by running the script,
bunzip2 -c install_A.B.C.D.tar.bz2 tar xfv –
# cd DriverInstall
#./install.sh
7. Once done reboot the server, the driver will make detect the Ethernet
8. Provide the IP through static assigning or through DHCP
9. It’ll take 15 minutes to start, once done Check the Applications - > System Settings - > Network - > Ethernet
10. The status will be active and now you are connected to the network
Wednesday, January 7, 2009
Downloading, Installing and running Remote Diagnostic Agent (RDA)
RDA can be downloaded as a bundle with Oracle Configuration manager or as a stand alone package from metalink at note id 314422.1.
- Download the zip/tar files from the note and change the name to 'rda.zip' or 'rda.tar' depending on what format you download.
- Choose or create a directory that is owned by the OS user who is also the owner of the Oracle installation.
- Copy the rda zip/tar file to the above directory and extract its contents there using one of the following commands depending on the format of the RDA download.
tar xvf rda.tar (or)
gunzip rda.tar.gz (or)
tar xvf rda.tar (or)
unzip rda.zip
- Make sure the rda.sh and rda.pl scripts have execute permissions. If they lack it, issue the following command
chmod +x rda.sh
chmod +x rda.pl
- Test if the rda scripts can be executed
for unix/linux - sh rda.sh -cv
for windows - rda.cmd -cv
these commands should not return any issues
- To run RDA, log in as the user who owns the Oracle installation and execute the following script
for Linux/Unix machines
rda.sh - Use this command if Perl is not available.
rda.pl - Use this command if Perl is available.
For windows,
rda.cmd Use this command if Perl is not available.
rda.pl Use this command if Perl is available in the path.
- To check availability of PERL, use the following command.
perl -v
- Download the zip/tar files from the note and change the name to 'rda.zip' or 'rda.tar' depending on what format you download.
- Choose or create a directory that is owned by the OS user who is also the owner of the Oracle installation.
- Copy the rda zip/tar file to the above directory and extract its contents there using one of the following commands depending on the format of the RDA download.
tar xvf rda.tar (or)
gunzip rda.tar.gz (or)
tar xvf rda.tar (or)
unzip rda.zip
- Make sure the rda.sh and rda.pl scripts have execute permissions. If they lack it, issue the following command
chmod +x rda.sh
chmod +x rda.pl
- Test if the rda scripts can be executed
for unix/linux - sh rda.sh -cv
for windows - rda.cmd -cv
these commands should not return any issues
- To run RDA, log in as the user who owns the Oracle installation and execute the following script
for Linux/Unix machines
rda.sh - Use this command if Perl is not available.
rda.pl - Use this command if Perl is available.
For windows,
rda.cmd Use this command if Perl is not available.
rda.pl Use this command if Perl is available in the path.
- To check availability of PERL, use the following command.
perl -v
Tuesday, January 6, 2009
Enable Enterprise Manager on the Oracle E-Business Suite Release 12
- Keep the database and listener running. It is not necessary that any other Application services to be running for this process to complete.
- As the owner of the 10gR2 ORACLE_HOME, run the following command to create the Enterprise Manager repository:
$ emca -config dbcontrol db -repos create
When the command is run, EMCA prompts for the following values
Database SID: OBAIND
Listener port number: 1617
Password for SYS user: xxxxxxxxxx
Password for DBSNMP user: xxxxxxxxxx
Password for SYSMAN user: xxxxxxxxxx
Email address for notifications (optional):Outgoing Mail (SMTP) server for notifications (optional):
- Enter the values
- EMCA shows a summary of the entered values
—————————————————————–
You have specified the following settings
Database ORACLE_HOME ……………. /u11/oracle/OBAIND/db/tech_st/10.2.0 Database hostname ……………. xxxxxxxxx.newgen.com
Listener port number ……………. 1617
Database SID ……………. OBAIND
Email address for notifications ……………Outgoing Mail (SMTP) server for notifications —————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: Y
- Type ‘Y” to start the configuration.
The configuration will take anywhere between 10 to an hour depending on the machine configuration and database size.
Once it gets completes Enterprise manager can be accessed from the URL
Monday, January 5, 2009
Incorrect menu seeded with R12 causes error when iProcurement Catalog Administration is accessed
logging in to Oracle applications Release12 and selecting the iProcurement Catalog Administration responsibility immediately throws the following error
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.
Clicking the link for more details delivers the following:
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: Definition name for type View Definition is invalid
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3111)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2908)
at _OA._jspService(_OA.java:232)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
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.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _OA._jspService(_OA.java:225)
This happens in a fresh install of R12 because an incorrect menu comes seeded for in seeded for the iProcurement Catalog Administration responsibility. The following work around can be used for getting rid of the error.
- Login to the application as a user which has the System Administrator responsibility.
- Navigate to Security/Responsibility/Define
- Query the responsibility - iProcurement Catalog Administration
* The menu is 'Internet Procurement eContent Manager' - which is incorrect
- Change the menu name to - 'iProcurement Administration: Catalog Administration Home'
- Logout and then again login, the problem will be resolved.
It is better to clear the Web Browser cache to eliminate all errors and correct the problem completely.
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.
Clicking the link for more details delivers the following:
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: Definition name for type View Definition is invalid
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3111)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2908)
at _OA._jspService(_OA.java:232)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
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.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _OA._jspService(_OA.java:225)
This happens in a fresh install of R12 because an incorrect menu comes seeded for in seeded for the iProcurement Catalog Administration responsibility. The following work around can be used for getting rid of the error.
- Login to the application as a user which has the System Administrator responsibility.
- Navigate to Security/Responsibility/Define
- Query the responsibility - iProcurement Catalog Administration
* The menu is 'Internet Procurement eContent Manager' - which is incorrect
- Change the menu name to - 'iProcurement Administration: Catalog Administration Home'
- Logout and then again login, the problem will be resolved.
It is better to clear the Web Browser cache to eliminate all errors and correct the problem completely.
Friday, January 2, 2009
Configuring R12 Workflow Mailer’s SMTP server to send mails to all domains through telnet
1. Unable to send to the mails for any domain except the client’s domain
2. When looked into the log file FNDCPGSC***.txt ($APPLCSF/$APPLLOG), found out the following error,
Oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[["ADDRESS.DOMAIN.COM.AMERICAN"]]} -> javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 Unable to relay
oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:SendFailedException -> [["ADDRESS@DOMAIN.COM.AMERICAN"]] javax.mail.SendFailedException: Invalid Addresses; nested exception is: class Javax.mail.SendFailedException: 550 5.7.1 Unable to relay
3. Confirmed the same by checking the wf_notifcations table and the mails sent to the id’s outside the clients domain failed with status “FAILED” (Testes Purchase Orders to Suppliers, Workflow Test Mail, Forgot Your Password Functionality)
4. Tried to login the user through telnet and got the same error and confirmed that this is something to do with SMTP server
[applprod@perp log]$ telnet webmail.domain.in 25
Trying 192.168.1.7...
Connected to webmail.domain.in (192.168.1.7).
Escape character is '^]'.
220 EXCHMAILSERVER1.domain.in Microsoft ESMTP MAIL Service ready at Fri, 2 Jan 2009 15:36:26 +0530
HELO
250 EXCHMAILSERVER1.domain.in Hello [192.168.1.40]
MAIL FROM: wfmailer@domain.in
250 2.1.0 Sender OK
RCPT TO: address@domain.com
550 5.7.1 Unable to relay
5. The issue has been given in the notes # 374804.1, 304582.1 and 753845.1, requested the mail administrator to set the SMTP mail server to allow relaying, that is sending mail to an outside domain from that server (192.168.1.40)
6. Restarted the “Workflow Notification Mailer” through Oracle Applications Manager
7. Once done checked the notifications from purchase orders to supplier and Forgot Your Password link with other domain’s mail-id started working fine
2. When looked into the log file FNDCPGSC***.txt ($APPLCSF/$APPLLOG), found out the following error,
Oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[["ADDRESS.DOMAIN.COM.AMERICAN"
oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:SendFailedException -> [["ADDRESS@DOMAIN.COM.AMERICAN"
3. Confirmed the same by checking the wf_notifcations table and the mails sent to the id’s outside the clients domain failed with status “FAILED” (Testes Purchase Orders to Suppliers, Workflow Test Mail, Forgot Your Password Functionality)
4. Tried to login the user through telnet and got the same error and confirmed that this is something to do with SMTP server
[applprod@perp log]$ telnet webmail.domain.in 25
Trying 192.168.1.7...
Connected to webmail.domain.in (192.168.1.7).
Escape character is '^]'.
220 EXCHMAILSERVER1.domain.in Microsoft ESMTP MAIL Service ready at Fri, 2 Jan 2009 15:36:26 +0530
HELO
250 EXCHMAILSERVER1.domain.in Hello [192.168.1.40]
MAIL FROM: wfmailer@domain.in
250 2.1.0 Sender OK
RCPT TO: address@domain.com
550 5.7.1 Unable to relay
5. The issue has been given in the notes # 374804.1, 304582.1 and 753845.1, requested the mail administrator to set the SMTP mail server to allow relaying, that is sending mail to an outside domain from that server (192.168.1.40)
6. Restarted the “Workflow Notification Mailer” through Oracle Applications Manager
7. Once done checked the notifications from purchase orders to supplier and Forgot Your Password link with other domain’s mail-id started working fine
Thursday, January 1, 2009
Migrating putty settings from one desktop/laptop to other
Migrating putty settings from one desktop/laptop to the other box comes in handy when you had already customized your putty with saved sessions. The migration will also help a new member of an exisitng DBA support team.
Here are the steps
1. Start -> Run (or Windows Button + R)
2. Type in ‘regedit’ and press enter - this command will open the registry editor window
3. Go to HKEY_CURRENT_USER -> Software -> SimonTatham
4. Right Click on SimonTatham and select Export
5. Provide a file name and save the file
Copy and execute the exported file on the new machine, then import into new machine by double click it
Note: this will only bring the putty configurations and NOT the putty executable itself.
Issue when configuring Workflow Mailer with IMAP and POP enabled in MS-Exchange server 2008
1. While configuring the R12 workflow mailer, the following are the details given,
Inbound(IMAP) - webmail.domain.in 143
Outbound(SMTP) - webmail.domain.in 25
Inbound (POP3) - webmail.domain.in 110
2. The Outbound server has been configured successfully
3. The webmail server's IP has been added in /etc/hosts
4. While trying to configure the Inbound, stuck with the error even the details given are correct
Check the hostname, username and password
Hostname - webmail.domain.in
username - wfmailer
Password – password
5. Then came to know that for inbound they are using both IMAP and POP3
6. Changed the user settings of WFAMILER to use only IMAP
7. Even after that it errors out, but telnet to IMAP and SMTP is successful
$ telnet webmail.domain.in 143
$ telnet webmail.domain.in 25
8. Then with reference to note # 242941.1, tried the following to connect from the user WFMAILER,
$AFJVAPRG -classpath $AF_CLASSPATH -Ddebug=Y -Dprotocol=imap -Ddbcfile=$INST_TOP/appl/fnd/12.0.0/secure/CRP.dbc -Dserver=webmail.domain.in -Dport=143 -Daccount=wfmailer -Dpassword=password -Dconnect_timeout=120 -Dfolder=INBOX oracle.apps.fnd.wf.mailer.Mailer
MLRTST : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
DEBUG: setDebug: JavaMail version 1.3.1
DEBUG: getProvider() returning javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc]
DEBUG: mail.imap.fetchsize: 16384
* OK The Microsoft Exchange IMAP4 service is ready.
A0 CAPABILITY
* CAPABILITY IMAP4 IMAP4rev1 LOGINDISABLED STARTTLS IDLE NAMESPACE LITERAL+
A0 OK CAPABILITY completed.
A1 LOGIN wfmailer password
A1 BAD Command received in Invalid state.
9. After searching, came to know that the LOGIN is disabled through telnet causing the issue
10. With reference to the note # 333074.1 , with the help of network admin executed the following,
- Checked "SASL Authentication" enabled in EM Websites for the IMAP instance.
- Leave the "Allow Clear Text Login" as is, "True".
- Bounced IMAP
11. Then tried login from telnet and it worked fine,
$AFJVAPRG -classpath $AF_CLASSPATH -Ddebug=Y -Dprotocol=imap -Ddbcfile=$INST_TOP/appl/fnd/12.0.0/secure/CRP.dbc -Dserver=webmail.domain.in -Dport=143 -Daccount=wfmailer -Dpassword=password -Dconnect_timeout=120 -Dfolder=INBOX oracle.apps.fnd.wf.mailer.Mailer
MLRTST : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
DEBUG: setDebug: JavaMail version 1.3.1
DEBUG: getProvider() returning javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc]
DEBUG: mail.imap.fetchsize: 16384
* OK The Microsoft Exchange IMAP4 service is ready.
A0 CAPABILITY
* CAPABILITY IMAP4 IMAP4rev1 AUTH=NTLM AUTH=GSSAPI AUTH=PLAIN STARTTLS IDLE NAMESPACE LITERAL+
A0 OK CAPABILITY completed.
A1 LOGIN wfmailer password
A1 OK LOGIN completed.
A2 NOOP
A2 OK NOOP completed.
12. Then configured the inbound and its configured successfully without any issues
Inbound(IMAP) - webmail.domain.in 143
Outbound(SMTP) - webmail.domain.in 25
Inbound (POP3) - webmail.domain.in 110
2. The Outbound server has been configured successfully
3. The webmail server's IP has been added in /etc/hosts
4. While trying to configure the Inbound, stuck with the error even the details given are correct
Check the hostname, username and password
Hostname - webmail.domain.in
username - wfmailer
Password – password
5. Then came to know that for inbound they are using both IMAP and POP3
6. Changed the user settings of WFAMILER to use only IMAP
7. Even after that it errors out, but telnet to IMAP and SMTP is successful
$ telnet webmail.domain.in 143
$ telnet webmail.domain.in 25
8. Then with reference to note # 242941.1, tried the following to connect from the user WFMAILER,
$AFJVAPRG -classpath $AF_CLASSPATH -Ddebug=Y -Dprotocol=imap -Ddbcfile=$INST_TOP/appl/fnd/12.0.0/secure/CRP.dbc -Dserver=webmail.domain.in -Dport=143 -Daccount=wfmailer -Dpassword=password -Dconnect_timeout=120 -Dfolder=INBOX oracle.apps.fnd.wf.mailer.Mailer
MLRTST : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
DEBUG: setDebug: JavaMail version 1.3.1
DEBUG: getProvider() returning javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc]
DEBUG: mail.imap.fetchsize: 16384
* OK The Microsoft Exchange IMAP4 service is ready.
A0 CAPABILITY
* CAPABILITY IMAP4 IMAP4rev1 LOGINDISABLED STARTTLS IDLE NAMESPACE LITERAL+
A0 OK CAPABILITY completed.
A1 LOGIN wfmailer password
A1 BAD Command received in Invalid state.
9. After searching, came to know that the LOGIN is disabled through telnet causing the issue
10. With reference to the note # 333074.1 , with the help of network admin executed the following,
- Checked "SASL Authentication" enabled in EM Websites for the IMAP instance.
- Leave the "Allow Clear Text Login" as is, "True".
- Bounced IMAP
11. Then tried login from telnet and it worked fine,
$AFJVAPRG -classpath $AF_CLASSPATH -Ddebug=Y -Dprotocol=imap -Ddbcfile=$INST_TOP/appl/fnd/12.0.0/secure/CRP.dbc -Dserver=webmail.domain.in -Dport=143 -Daccount=wfmailer -Dpassword=password -Dconnect_timeout=120 -Dfolder=INBOX oracle.apps.fnd.wf.mailer.Mailer
MLRTST : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
DEBUG: setDebug: JavaMail version 1.3.1
DEBUG: getProvider() returning javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc]
DEBUG: mail.imap.fetchsize: 16384
* OK The Microsoft Exchange IMAP4 service is ready.
A0 CAPABILITY
* CAPABILITY IMAP4 IMAP4rev1 AUTH=NTLM AUTH=GSSAPI AUTH=PLAIN STARTTLS IDLE NAMESPACE LITERAL+
A0 OK CAPABILITY completed.
A1 LOGIN wfmailer password
A1 OK LOGIN completed.
A2 NOOP
A2 OK NOOP completed.
12. Then configured the inbound and its configured successfully without any issues
Subscribe to:
Posts (Atom)