Friday, November 30, 2018

Apache http Failed To Start In R12.1.3 after clone

Hiya Buddies!!!
We would like to share this below error which is very normal during cloning. Here, we are facing this issue because of some OS upgrade/incompatibilities from source to target.
We got the below error while starting the EBS Apps services. While start the application services, we found that apache was getting failed as shown below error log details:

Executing service control script:
/u01/test/inst/test_tech/admin/scripts/adapcctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...

adapcctl.sh: exiting with status 204

adapcctl.sh: check the logfile /u01/test/inst/test_tech/logs/appl/admin/log/adapcctl.txt for more information ...
 ==
 opmn id=tech:6208
    0 of 1 processes started.
ias-instance id=test_tech.tech.non-tech.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
    HTTP_Server/HTTP_Server/HTTP_Server/
Error
--> Process (index=1,uid=778177156,pid=9722)
 failed to start a managed process after the maximum retry limit

Log:
 /u01/test/inst/test_tech/logs/ora/10.1.3/opmn/HTTP_Server~1.log
07/15/18-21:08:04 :: adapcctl.sh: exiting with status 204
=============================================================
    /u01/test/inst/test_tech/logs/ora/10.1.3/opmn/HTTP_Server~1.log
18/07/15 21:08:02 Start process
--------
Can't stat executable /u01/test/inst/test_tech/ora/10.1.3/Apache/Apache/bin/.apachectl
18/07/14 03:05:56 Start process
--------
/u01/test/inst/test_tech/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd

Status:
Web Entry Point Services   Oracle HTTP Server test_tech          adapcctl.sh      Failed

Solution:
For this we need to apply a patch in 10.1.3 Oracle Home as shown below:
Please find the below steps:

1. We need to source oracle_home to 10.1.3
[tech:] $cd $ORA_CONFIG_HOME/10.1.3/
$ls -ltr *.env
or we can export ORACLE_HOME to 10.1.3 manually...

2. We need to attached oracle home, this step can be ignored also...
$cd $ORACLE_HOME/oui/bin
$./runInstaller -silent -attachHome -invPtrLoc $INST_TOP/admin/oraInst.loc ORACLE_HOME=/u01/test/apps/tech_st/10.1.3  -ignoreSysPrereqs ORACLE_HOME_NAME=test_10_1_3_home
$$ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc \  $INST_TOP/admin/oraInst.loc

3. We need to apply this patch 12722501 on 10.1.3 Oracle Home (OPatch).
$cd /u01/patch/OPatch/12722501
#$ORACLE_HOME/OPatch/opatch apply -invPtrLoc $INST_TOP/admin/oraInst.loc
$ORACLE_HOME/OPatch/opatch apply -silent -invPtrLoc \ $INST_TOP/admin/oraInst.loc -ocmrf \ /appdata/delphix/postclone/apps/backup/ocm_response.rsp
Here, -ocmrf is oracle configuration manager response file, it is included with release of opatch.

4. $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc \ $INST_TOP/admin/oraInst.loc

5. Run the Apps env file.

6. Run autoconfig on Apps Tier.
$cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh appspass=$APPS_PWD

7. Start the application services.

Note
: This solution is not for all cases if apache is not starting. This is only as per MOS.

Some more useful links:
Regards,
TechOrNontech Team

Wednesday, November 28, 2018

OID , OAM and ASM log files location and details:


Hiya Buddies!!!
We would like share some real time log file path which is very important for any organizations or DBAs.

Actually, we all think that how can we remember the every log files path. It is true but while working for long time on same team or company , you can keep remember for almost path of the alert log files.

And also, the fact is everyone forget the stuff. But the thing is somebody keep revision or keep working on same things, so they can remember the stuff easily.
Otherwise, there is no short-cut to remember everything... hahahh

We will keep update this post as getting some log files which are not easily found.
This is only sample, path may depends on server to server or projects.

Note: The way to find out either log file or any files by name is either you can use "find" command or "locate" command. Locate command works only if it is installed/configured on your server.

For using find command better to go to base directory and try, or the directory where software is installed. You can find out by using "grep process" command as ps -ef|grep ASM.

$find . -name "filename" -exec ls -ltr {} \;

If you are not sure about the exact file name then you can use "*" as shown below:
$find . -name "alert*" -exec ls -ltr {} \;

$locate <file_name>

OID log:
In below path we are checking for first ods1 log. If there are many or two servers then we can go to two directory back and get the list of servers under Server directory.

[tech&non-tech:] $ pwd
/u01/oracle/oid/domain/oid_domain/servers/wls_ods1/logs
[tech&non-tech:] $

[tech&non-tech:] $ pwd
/u01/ admin/ oid_domain/ servers  ### We have changed starting path
[tech&non-tech:] $

OAM logs:
[tech&non-tech:] $ pwd
/u01/oracle/oam/domain/oam_domain/servers/oam_server1/logs
[tech&non-tech:] $

ASM alert log file:
$ pwd
/u01/app/oracle/diag/asm/+asm/+ASM1/trace
oracle@tech&non-tech:/u01/app/oracle/diag/asm/+asm/+ASM1/trace$

$ tail -100f alert_+ASM1.log

Some more useful links:
Thanks,