About Me.

My self Adinarayana working as Implementation Application DBA with advanced technologies like RAC/PCP,OID/SSO,DMZ,Exadata and Fusion Middleware i.e Demantra,Application Server,SOA,FMW,BPEL and UPK. Created this blog to share the useful information related to DBA and Application DBA Your comments and suggestions are most welcome. Disclaimer: Please note all the views and opinions expressed in this site are my own. It's not recommend to use the fixes/suggestions provided in this site directly in production instance, please test them before implementing.
Showing posts with label EBSO Troubleshooting. Show all posts
Showing posts with label EBSO Troubleshooting. Show all posts

Wednesday, August 7, 2013

Apache Issues

Issue 1:
<$INST_TOP>/apps/VIS_at3/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
Syntax error on line 17 of <$INST_TOP>/apps/<SID>_<hostname>/ora/10.1.3/Apache/Apache/conf/mod_osso.conf:
Unable to open <$INST_TOP>/apps/<SID>_<hostname>/ora/10.1.3/Apache/Apache/conf/osso/<SID>_<hostname>_osso.conf.

Solution:
1. Backup the $CONTEXT_FILE

2. Edit the parameter  "s_mod_osso_conf_comment" in the $CONTEXT_FILE using editContext utility,  or manually using a text editor

3. Set the value for the above parameter to "#"

4. Save the changes and run Autoconfig

5. Start the Apache service to re-test the issue

6. Migrate the solution as appropriate to other environments

Reference doc id:Starting R12 Apache errors with status 204 after Cloning SSO Enabled E-Business Suite Instance (Doc ID 730982.1)

Issue 2:
Error:
adapcctl.sh: exiting with status 204

From : HTTP_Server_1.log
---------------------------------
Start process
$IAS_ORACLE_HOME/Apache/Apache/bin/apachectl startssl: execing httpd

Steps to Reproduce:
The issue can be reproduced at will with the following steps:
Start Apache Services using adapcctl.sh :
$ sh adapcctl.sh start

Business Impact :
Due to this issue, users cannot log in to Oracle Application.

Cause:

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd executable got corrupt or having zero in size.

Solution:

To implement the solution, please execute the following steps:
1.) Replace the file $IAS_ORACLE_HOME/Apache/Apache/bin/httpd from working Instance.
2.) Bounce the appsTier services.
3.) Retest the issue.

Reference Doc id:Error - adapcctl.sh: Exiting With Status 204 (Doc ID 1289128.1)

Issue 3:
Error:
adapcctl.sh: exiting with status 204

From : HTTP_Server_1.log
---------------------------------
Start process
$IAS_ORACLE_HOME/Apache/Apache/bin/apachectl startssl: execing httpd

Cause:
Apache/Apache/logs are 100% full.(Mount Point)

Solution:

Delete logs or add space to the mount point.

Issue 4:

adapcctl.sh: exiting with status 204


$ORACLE_HOME/Apache/Apache/logs/xml.log shows:

pid file /xxx/inst/apps/XXX/pids/10.1.3/Apache/httpd.pid overwritten

An unclean shutdown of previous Apache may have occurred.
 
$ORACLE_HOME/Apache/Apache/logs/error.log shows:

httpd: could not log pid to file /xxx/inst/apps/XXX/pids/10.1.3/Apache/httpd.pid
fopen: Permission denied

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Stop services as user root.
2. Re-start the services.

Cause:
The services were shut down using user root, and the file httpd.pid cannot be opened by oracle user.

Solution:

-- To implement the solution, please execute the following steps:

1. Check if root owns file httpd.pid:
/xxx/inst/apps/XXX/pids/10.1.3/Apache/httpd.pid

$ cd /xxx/inst/apps/XXX/pids/10.1.3/Apache
$ ls -lart
-rw-r--r-- 1 root system 7 Nov 16 15:10 httpd.pid

Reference Doc id:adapcctl.sh: 'Exiting With Status 204' After Shutdown As User ROOT (Doc ID 751390.1)

Issue 5:
You are running adapcctl.sh version 120.6.12000000.4
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
adapcctl.sh: exiting with status 204

Review the HTTP log file. The error is very clear about the missing soft link. It would show this error:
...
<physical Path>/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
<physical Path>/10.1.3/Apache/Apache/bin/httpd: error while loading shared
libraries: libdb.so.2: cannot open shared object file: No such file or directory
...

Soft link libdb.so.2 is missing.

Solution:

To implement the solution, please execute the following steps:

1. Shut down all Oracle Application Services.

2. As the unix root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
3. Start up all Oracle Application Services.

Reference Doc id:Attempting to Start Apache (adapcctl.sh) Throws an 'Error While Loading Shared Libraries: libdb.so.2' on RedHat Linux 5 (Doc ID 879522.1)

Issue 6:

/sid/inst/apps/hostname/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
Error: Failed to open the wallet [Hint: incorrect path, incorrect password, bad wallet, ...]
(Server ebsdev1.snapbs.com:443, wallet file:/sid/inst/apps/hostname/certs/Apache)

Solution:

Then check the $ORACLE_HOME/opmn/conf/opmn.xml and make sure ssl-enabled is set:
<ias-component id="HTTP_Server">
<process-type id="HTTP_Server" module-id="OHS">
<module-data>
<category id="start-parameters">
<data id="start-mode" value="ssl-enabled"/>
</category>
</module-data>
<process-set id="HTTP_Server" numprocs="1"/>
</process-type>

Referenece Doc id:
Troubleshooting Oracle HTTP Server with SSL and Common Errors in Oracle Application Server 10g (10.1.2-10.1.3) (Doc ID 829217.1)

Thursday, July 25, 2013

Add Button disabled

 1) uncheck  Freeze flexfield def button
 2) do the required changes
 3) check Freeze flexfield def button again
 4) save it. it will automatically compile the flexfield

To view Added Responsibility

1. Run the request ‘Sync responsibility role data into the WF table’.
2. Run the request “Synchronize WF LOCAL tables”.
3. Run the request “Workflow Directory Services User/Role Validation” (with parameters 10000, yes,yes, yes).
4. Have the user log off and back on and verify that the responsibility appears.

Functional Administrator issue

Issue:
------
 Functional admin is not available for sysadmin, i have activated this responsibilty.
 but infront end it is showing that "Functional Administrator is not a valid responsibility for the  current user.
 Please contact your System Administrator"

Solution:
---------
1.Create one application test user.
2.Add Functional Administrator responsibilty to test user.
3.Clear Cache

- go to "Functional Administrator" responsibility

- select Core Services => Caching Framework => Global Configuration => Clear cache

(please review Note 759038.1 for details).

4.Bounce opmn services
5.End date the test user

Sunday, July 21, 2013

Cloning Issues

Troubleshooting RapidClone issues with Oracle Applications R12 [ID 603104.1]

Some of the Cloning Issues faced and it’s solution:

1 - While running adpreclone on EBS ,  APPS  user locked continiously .
Soultion - Follow metalink Note Id - ID 420001.1

2- PDF output problem in Instance. No PDF output produced  after cloning .

        Solution - Follow metalink Note Id ID 981163.1

3- Got this in alert.log WARNING: Oracle executable binary mismatch detected.

Solution - Follow the metalink Note ID - 369260.1.

4- After cloning, forms will not launch ,it will not come up.Performed the below Steps:

  EXEC FND_CONC_CLONE.SETUP_CLEAN; commit;
Ran the cmclean.sql scripts

Run Autoconfig on all nodes.(DB+CM+WEB Nodes)

5. After cloning Purge Concurrent Request and/or Manager Data request  status alway is running , it is not completing.

As per Metalink ID 1016766.102 ( OS Files are Purged from Wrong Instance when Running Purge Concurrent Requests),It is because of FNDCPPUR is trying to delete files it can't access because they are belonging to the original environment.
The following table and columns still contain PATH referencing the original
environment :
FND_CONCURRENT_REQUESTS.LOGFILE_NAME
FND_CONCURRENT_REQUESTS.OUTFILE_NAME
Perfoem the below Steps:

     a) Stop the concurrent managers.
     b) Start a SQL*Plus session as APPLSYS.
     c) Issue the following commands:
             TRUNCATE TABLE fnd_concurrent_requests;
             TRUNCATE TABLE fnd_concurrent_processes;
       
             UPDATE fnd_concurrent_queues
                SET running_processes = 0,
                    max_processes = 0;
             COMMIT;
     d) Exit the SQL*Plus session.
d) Restart the concurrent managers.

6)While running adcfgclone.pl getting the Inventory problem , so enter the correct entry in /etc/oraInst.loc location.

7) Also after starting the services the listener was not coming up because of missing listener.ora file in $TNS_ADMIN location.

Solution:

Then Stop the APPS Services ./adstpall.sh apps/<appspwd>
run the Autoconfig .   ./adautocfg.sh

Then start the APPS Services   ./adstrtal.sh apps/<appspwd>