2 Replies Latest reply: Nov 7, 2012 5:39 AM by Patrick Wolf-Oracle RSS

    Unable to create new Workspace

    972784
      Hi all,

      I successfully installed APEX 4.2 inside an Oracle 11g database. On the same server, I have setup a WebLogic 12c server which runs an Admin Server (default) as well as a manually added Managed Server. Inside the Managed Server, I successfully deployed APEX Listener 1.1.4. I was also able to configure the APEX database coupling via http://host:port/apex/listenerConfigure.

      Now when I log in to the APEX Administration Console (workspace "INTERNAL") via http://host:port/apex/apex_admin and attempt to create a new workspace "myworkspace", I always end up getting the following error message:

      Error provisioning myworkspace.
      ORA-20001: Error during the Packaged Application installation.

      Has anyone ever encountered the same problem? Can this be due to some access restriction (I'm thinking missing write-permissions in the DB)?

      Some background info:
      It is possible that something's clashing here with an old DB object: The DB was fully exported from an old machine with a 10g installation and fully imported into Oracle 11g DB on the new machine. The old 10g DB had APEX 3.2 manually installed. That machine was then used to create an APEX workspace and build an application in it.
      Is it possible that when I migrated the complete DB, I unwillingly took some DB objects created by the old APEX-version (on the old machine) with me that now clash when I try to use the new APEX version?

      Any hint is highly appreciated.

      Thanks a lot, regards,
      Chris
        • 1. Re: Unable to create new Workspace
          Matthew Morris
          Is it possible that when I migrated the complete DB, I unwillingly took some DB objects created by the old
          APEX-version (on the old machine) with me that now clash when I try to use the new APEX version?
          This at least shouldn't be something to worry about. Apex objects get installed under a schema with the corresponding name. Your 3.2 objects would have been under APEX_030200 and your Apex 4.2 objects should be under APEX_040200.

          That said, I don't know what is causing your workspace issue. Ruling something out is useful, though. :)
          • 2. Re: Unable to create new Workspace
            Patrick Wolf-Oracle
            Hi Chris,

            as a possible workaround, set "Create demonstration objects in new workspaces" = No in Manage Instance -> Feature Configuration -> Application Development. This will prevent the installation of the Sample Application when a new workspace is created.

            After you have done that and created a new workspace, can you login into that workspace and install the Sample Database Application and let us know which error you are getting?

            Your problem might be related to the following thread Re: wwv_flow_lists_of_values$ where template applications had been installed on instance level ("Manage Instance -> Manage Shared Components -> Template Applications")

            Regards
            Patrick
            -----------
            My Blog: http://www.inside-oracle-apex.com
            APEX Plug-Ins: http://apex.oracle.com/plugins
            Twitter: http://www.twitter.com/patrickwolf

            Edited by: Patrick Wolf on Nov 7, 2012 12:39 PM