This discussion is archived
2 Replies Latest reply: Nov 7, 2012 3:39 AM by Patrick Wolf RSS

Unable to create new Workspace

972784 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

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