Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't stat executable /u01/oracle/inst/apps/FIN_finprdap/ora/10.1.3/Apache/Apache/bin/.apachectl

user8977605Nov 7 2019 — edited Feb 9 2021

Recently we have migrated Our E-business Suite 12.1.3 from Solaris 10 to Solaris 11. Entire migration process completed successfully but while starting up application tier services we are not able to start Apache on the migrated server.

I am getting below error while starting up Apache using adapcctl.sh script.

a12new@finprdap.alshaya.com:~$ /u01/oracle/inst/apps/FIN_finprdap/admin/scripts/adapcctl.sh start

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/oracle/inst/apps/FIN_finprdap/logs/appl/admin/log/adapcctl.txt for more information ...

a12new@finprdap.alshaya.com:~$ tail -50f /u01/oracle/inst/apps/FIN_finprdap/logs/appl/admin/log/adapcctl.txt

opmn id=finprdap.alshaya.com:6200

0 of 1 processes started.

ias-instance id=FIN_finprdap.finprdap.alshaya.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

--------------------------------------------------------------------------------

ias-component/process-type/process-set:

HTTP_Server/HTTP_Server/HTTP_Server/

Error

--> Process (index=1,uid=1827571881,pid=8140)

failed to start a managed process after the maximum retry limit

Log:

/u01/oracle/inst/apps/FIN_finprdap/logs/ora/10.1.3/opmn/HTTP_Server~1.log

11/07/19-15:49:21 :: adapcctl.sh: exiting with status 204

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

11/07/19-16:01:24 :: adapcctl.sh version 120.7.12010000.2

11/07/19-16:01:24 :: adapcctl.sh: starting OPMN if it is not running

opmnctl: opmn started.

11/07/19-16:01:25 :: adapcctl.sh: starting OPMN managed OHS instance

opmnctl: starting opmn managed processes...

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

opmn id=finprdap.alshaya.com:6200

0 of 1 processes started.

ias-instance id=FIN_finprdap.finprdap.alshaya.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

--------------------------------------------------------------------------------

ias-component/process-type/process-set:

HTTP_Server/HTTP_Server/HTTP_Server/

Error

--> Process (index=1,uid=1827571882,pid=8213)

failed to start a managed process after the maximum retry limit

Log:

/u01/oracle/inst/apps/FIN_finprdap/logs/ora/10.1.3/opmn/HTTP_Server~1.log

11/07/19-16:01:29 :: adapcctl.sh: exiting with status 204

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

a12new@finprdap.alshaya.com:~$ tail -20f /u01/oracle/inst/apps/FIN_finprdap/logs/ora/10.1.3/opmn/HTTP_Server~1.log

--------

19/11/07 15:49:17 Start process

--------

Can't stat executable /u01/oracle/inst/apps/FIN_finprdap/ora/10.1.3/Apache/Apache/bin/.apachectl

Comments

SmithJohn45

can you give some " sample data " like this:

with t as (Select 'account01' as account_name, '1990' as year, 'Jan' as month from dual
           Select 'account02' as account_name, '2000' as year, 'Feb' as month from dual
)
select ( your query here ) from t;

the seniors can help after checking the actual results of your query will return.
Help seniors to help yourself...

Stax
SQL> ed
Wrote file afiedt.buf


  1  with t (account_name,year,month,sal) as (
  2   select 'u1','2022','January',150 from dual union all
  3   select 'u1','2022','February',200 from dual union all
  4   select 'u1','2022','March',300 from dual
  5  )
  6  select
  7    t.*
  8   ,sum(sal) over (partition by account_name order by  to_date(month||year,'MonthYYYY','NLS_DATE_LANGUAGE=AMERICAN')) ssal
  9* from t
SQL> /


AC YEAR MONTH           SAL       SSAL
-- ---- -------- ---------- ----------
u1 2022 January         150        150
u1 2022 February        200        350
u1 2022 March           300        650


1 - 2

Post Details

Added on Nov 7 2019
3 comments
50 views