adapcctl.sh: exiting with status 3

One of the issue reported after 11.5.10.2 upgrade. Whenever we try to start Apache it is exiting with status code 3.

$ adapcctl.sh start
adapcctl.sh version 115.54
Apache Web Server Listener is not running.
Starting Apache Web Server Listener (dedicated HTTP in SSL mode) ...
Apache Web Server Listener (PLSQL) is not running.
Starting Apache Web Server Listener (dedicated PLSQL) ...

adapcctl.sh: exiting with status 3

Here is what adapcctl.txt says:

================================================================================

Apache Web Server Listener is not running.

Starting Apache Web Server Listener (dedicated HTTP in SSL mode) ...

/oracle/EDEV/oradev/iAS/Apache/Apache/bin/apachectl startssl: httpd started

Apache Web Server Listener (PLSQL) is not running.

Starting Apache Web Server Listener (dedicated PLSQL) ...

Syntax error on line 17 of /oracle/EDEV/oradev/iAS/Apache/modplsql/cfg/plsql_pls.conf:

Cannot load /oracle/EDEV/oradev/iAS/Apache/modplsql/bin/modplsql.so into server: ld.so.1: httpd: fatal: libclntsh.so.8.0: open failed: No such file or directory

/oracle/EDEV/oradev/iAS/Apache/Apache/bin/apachectl start: httpd could not be started
========================================================================

Metalink says modplsql.so might be corrupted or you might not be having libclntsh.so.8 etc etc. We tried all options but no results. It was erroring out like that only with status code 3. After digging more I realize LD_LIBRARY_PATH which was coming from adovars.env having link to old java 1.1.8. I have to remove those entries and source the env again. After that we were able to resolve this issue. But it was a nice experience which I would like to share with you all.

Happy Troubleshooting !!!

Unable to Copy files on unix

We have some weird issue few days back. My team mate reported issue that he was not able to copy files from backup location to target location for doing database refresh. As per him he was able to see files under backup location, but whenever he tries to copy files he gets an error. After I had a look I found the issue like this. Whenever you do ls -l you can see the files like:
filea.dbf
fileb.dbf
But when we issue a command cp filea.dbf target_location throws an error. moreover if you do cp file* target_location it worked. I got the issue, which means file has some zunk characters in its name. As its a common dba error while adding dbf files we add space. So I used command cp "filea.dbf " target_location, this time I gave file name under "" with one space after dbf. It worked, but problem didn't end here, we have to rename the datafile too as it has space in it at end.

Happy Troubleshooting !!!

Update User password field Disable in Apps after 10g SSO Integration

We encountered one issue after integration 10g iAS (IDM 1.4 + SSO) with our Oracle Application Instance 11.5.10.2. We were not able to change user password via form (FNDSCAUS). Navigation as follows Security > User > Define. Although we were able to change password via FNDPASS but not via form.
The problem lies in system profile "Application SSO LDAP Synchronization" (APPS_SSO_LDAP_SYNCH). We had this proble disabled at site level, which was causing the issue. After changing this profile at site level to value enabled it worked. So make sure you have this profile enable if you like to use standard feature of password change.

Happy Troubleshooting !!!

Metalink New Look

I came across with New Metalink URL, Its really mass improvement from its old looks. Just try this

https://csm.oracle.com/CSP/ui/index.html

Happy Troubleshooting !!!

Change Global Preferences for WF Notification Style

I come across with one of such requirement where I have to change the Global Preference from Backend. Here how I did it

Changing Global preferences for notification style
=====================================================
select PREFERENCE_VALUE
from FND_USER_PREFERENCES
where USER_NAME='-WF_DEFAULT-'
and MODULE_NAME='WF'
and PREFERENCE_NAME='MAILTYPE' ;

Now Update the record :

Update FND_USER_PREFERENCES
set PREFERENCE_VALUE = 'MAILATTH'
where USER_NAME='-WF_DEFAULT-'
and MODULE_NAME='WF'
and PREFERENCE_NAME='MAILTYPE' ;

Different PREFERENCE_VALUES to select from
====================================
MAILATTH == Plain text with HTML attachment
MAILTEXT == Plain Text
SUMMARY == Plain text Summary email
MAILHTML == HTML Mail with attachments
MAILHTM2 == HTML Mail
SUMHTML == HTML Summary email

Happy Troubleshooting !!!