This discussion is archived
4 Replies Latest reply: Feb 11, 2013 3:30 AM by munky RSS

APEX 2.2 404-Not Found on Cloned installation

user503699 Expert
Currently Being Moderated
Hello,

I am trying to clone an existing working APEX 2.2 setup to a new machine (Yes, I know it is an outdated version but...can't help).
So far, I have done following steps:
1) Restored cold backup of DB (version 10.1.0.4) on to new machine; the DB works fine
2) Cloned the Oracle HTTP Server to the new machine; changed the marvel.conf and httpd.conf; HTTP server starts (and stops) without any errors

But when I try to access APEX homepage(http://xxxx.yyy.zzz.com:7777/pls/htmldb/apex/f?p=4550:1), it gave "404 - Not Found" error. Thanks to Patrick Wolf, I managed to get detail error message but don't really know how to resolve it.

Following is the error message:
apex: SIGNATURE (parameter names) MISMATCH
VARIABLES IN FORM NOT IN PROCEDURE: P
NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM: 

  DAD name: htmldb
  PROCEDURE  : apex
  URL        : http://xxx.yyy.zzz.com:7777/pls/htmldb/apex/f?p=4550:1
  PARAMETERS :
  ===========
  P:
   4550:1
Can somebody please help ?
Thanks in advance.
  • 1. Re: APEX 2.2 404-Not Found on Cloned installation
    user503699 Expert
    Currently Being Moderated
    BTW, I have also read Blank page after cloning apex 2.2.1 which appears to be a similar problem but have not tried the re-install as mentioned in that post.
  • 2. Re: APEX 2.2 404-Not Found on Cloned installation
    riedelme Expert
    Currently Being Moderated
    These are the notes I have stretching back to Apex 3.0.2 - not quite your version but may help
    1.     Make sure browser URL is specified correctly
      a.     Instructions don’t mention use of htmldb virtual folder, defined in marvel.conf (if copied from instructions)
      b.     Example: http://mobile4:7777/pls/htmldb/apex
    2.     Make sure the tnanames listener has been started
    3.     Make sure http server is running
      a.     Test it by using “http://servername:port/; should display welcome screen
    4.     Check configuration files very carefully
      a.     Httpd.conf
        i.     Make sure include file for marvel.conf is not commented
        ii.     Make sure include file for marvel.conf is specified correctly (no typos, incorrect path elements)
      b.     Modplsql.conf
        i.     Make sure correct (listener) port is specified in PlsqlDatabaseConnectString (1521; check tnsnames.ora file)
        ii.     Make sure correct host name is specified in PlsqlDatabaseConnectString (localhost; check hosts file)
      c.     Dads.conf (version 3.2; contains former contents of marvel.conf)
        i.     Make sure entires are correct
    5.     Make sure the PL/SQL toolkit is a proper version for the version of Apex
      a.     3.2 requires 10.1.2.0.0
      b.     Check using “select sys.owa_util.get_version from dual”
      c.     If necessary install it from the Apex script owainst.sql
        i.     Also utlrp.sql (from database $ORACLE_HOME) to recompile existing packages
      d.     De-install and re-install Apex if necessary
        i.     Apxremove.sql in Apex setup files to remove
        ii.     Apexins apex_tablepace files_tablespace temp_tablespace images_shortcut
          1.     images_shortcut should be /i/
          2.     @apexins users users temp /i/
    Edited by: riedelme on Feb 8, 2013 1:45 PM
  • 3. Re: APEX 2.2 404-Not Found on Cloned installation
    user503699 Expert
    Currently Being Moderated
    riedelme wrote:
    These are the notes I have stretching back to Apex 3.0.2 - not quite your version but may help
    Thank you for your response. My comments below.
    1.     Make sure browser URL is specified correctly
    a.     Instructions don’t mention use of htmldb virtual folder, defined in marvel.conf (if copied from instructions)
    b.     Example: http://mobile4:7777/pls/htmldb/apex
    I have confirmed that the URL I am using is correct. The marvel.conf has /pls/htmldb defined as the virtual folder.
    2.     Make sure the tnanames listener has been started
    Yes. I can use it to connect to DB
    3.     Make sure http server is running
    It is. Checked from opmnctl as well as ps
    a.     Test it by using “http://servername:port/; should display welcome screen
    It does show "Welcome Screen".
    4.     Check configuration files very carefully
    a.     Httpd.conf
    i.     Make sure include file for marvel.conf is not commented
    ii.     Make sure include file for marvel.conf is specified correctly (no typos, incorrect path elements)
    b.     Modplsql.conf
    i.     Make sure correct (listener) port is specified in PlsqlDatabaseConnectString (1521; check tnsnames.ora file)
    ii.     Make sure correct host name is specified in PlsqlDatabaseConnectString (localhost; check hosts file)
    c.     Dads.conf (version 3.2; contains former contents of marvel.conf)
    i.     Make sure entires are correct
    I have changed the entries in httpd.conf as well as marvel.conf and can confirm that the changes are valid.
    5.     Make sure the PL/SQL toolkit is a proper version for the version of Apex
    a.     3.2 requires 10.1.2.0.0
    b.     Check using “select sys.owa_util.get_version from dual”
    c.     If necessary install it from the Apex script owainst.sql
    i.     Also utlrp.sql (from database $ORACLE_HOME) to recompile existing packages
    d.     De-install and re-install Apex if necessary
    i.     Apxremove.sql in Apex setup files to remove
    ii.     Apexins apex_tablepace files_tablespace temp_tablespace images_shortcut
    1.     images_shortcut should be /i/
    2.     @apexins users users temp /i/
    I have verified the PL/SQL Toolkit version as well as have run utlrp.sql (which executed successfully). The images directory contains all the necessary files
    and has been correctly defined in marvel.conf file.
    Probably the only thing remaining to try out is remove and re-install the APEX in database. But that is the last resort.
    I was hoping to make this work without having to re-install APEX.
  • 4. Re: APEX 2.2 404-Not Found on Cloned installation
    munky Guru
    Currently Being Moderated
    Hi

    I may be barking up the wrong tree, but it wasn't called apex at version 2.2.

    (Obviously disregard this if you have some custom URL setup)

    Have you tried the URL 'http://xxx.yyy.zzz.com:7777/pls/htmldb'?

    Cheers

    Ben

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points