22 de mayo de 2017

adformsctl.sh: exiting with status 152 R12.1

Cuando iniciamos forms en R12.1.3, el adformctl termina con status 152 , mostrando un timeout.


*** Latest formsapp.ear has been deployed ***
=============================================


Program : /u01/oracle/EBS1213P/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Mon May 22 12:12:51 2017
Perl script txkChkFormsDeployment.pl got executed successfully


adformsctl.sh: exiting with status 152
adformsctl.sh: check the logfile /u01/oracle/EBS1213P/inst/apps/EBS1213P_laborasrv006/logs/appl/admin/log/adformsctl.txt for more information ... 




Solución:
Volver a Configurar el deployment de forms.


perl $FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws


1213P/inst/apps/EBS1213P_hostname/logs/appl/rgf/TXK/txkDeployForms-c4ws_Mon_May_22_13_34_43_2017.log
Program : /u01/oracle/EBS1213P/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDeployForms-c4ws.pl started @ Mon May 22 13:34:43 2017

*** Log File = /u01/oracle/EBS1213P/inst/apps/EBS1213P_laborasrv006/logs/appl/rgf/TXK/txkDeployForms-c4ws_Mon_May_22_13_34_43_2017.log
Stopping all OPMN processes.
opmnctl: opmn is not running.
OPMN stopped.
Removing OC4J instance if it exists: forms-c4ws
OC4J instance "forms-c4ws" does not exist.
Creating OC4J instance: forms-c4ws
opmnctl: opmn started.
opmnctl: starting opmn managed processes...
OPMN started.
Web module :"formsclient" is not deployed  for application: "forms-c4ws"
Deploying Application : "forms-c4ws" onto OC4J instance: "forms-c4ws"
Application deployed successfully.
Stopping and starting OC4J instances.
opmnctl: stopping opmn managed processes...
opmnctl: starting opmn managed processes...
Started OC4J instances.
Binding webApp : "forms-c4ws" with webmodule : "formsclient" for OC4J instance: "forms-c4ws"
Web application bound successfully.
Stopping OPMN.
opmnctl: stopping opmn and all managed processes...
OPMN stopped.



Program : /u01/oracle/EBS1213P/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDeployForms-c4ws.pl completed @ Mon May 22 13:38:58 2017
End of /u01/oracle/EBS1213P/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDeployForms-c4ws.pl : No Errors encountered


Check Status:


$ sh adformsctl.sh status
You are running adformsctl.sh  version 120.16.12010000.3
Checking status of OPMN managed FORMS OC4J instance ...
Processes in Instance: EBS1213P_laborasrv006.hostname.domain.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status 
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |    2595 | Alive  
OC4JGroup:default_group          | OC4J:forms         |    4224 | Alive  
OC4JGroup:default_group          | OC4J:oacore        |    2352 | Alive  
HTTP_Server                      | HTTP_Server        |    2292 | Alive
  





8 de mayo de 2017

Validar sesiones adop en EBS 12.2 (Finished Failed Adop Sessions in EBS)

Buenas tardes, les voy a facilitar 3 simples querys para chequear y solucionar problemas de adop cuando valla un parche.


1) Primero hay que ver las sesión activas y validar que no exista ninguna pendiente.
select *
from ad_adop_sessions
order by adop_session_id desc;


2) La columna STATUS, debería estar con el status 'C', en caso de ver una F (failed), se puede forzar para iniciar un nuevo ciclo de adop.


3)
--finalize Session ADOP

update ad_adop_sessions set status='C' where adop_session_id=;


Espero que les sirva para poder continuar con un nuevo ciclo de adop.