Youry's Blog

Youry's Blog

Oracle APEX (some issues and solutions)

leave a comment »

Some good papers and solutions

  1. Oracle Application Express Deployment http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-deploy-installation-1878444.html
  2. Oracle Application Express 4.2 Downloads http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
  3. Thread: help to upgrade to version 4.1 of apex
    1. In my 10g XE installation (upgrade from 4.0.2 ) I did ( in this order ):  https://forums.oracle.com/forums/thread.jspa?threadID=2273952
      install SQL> @apexins SYSAUX SYSAUX TEMP /i/
    2. upgrade img folder SQL> @apxldimg.sql c:\oraclexebe sure about correct location for image files in ..\apex\img
      old 1: create directory APEX_IMAGES as ‘&1/apex/images’
      new 1: create directory APEX_IMAGES as ‘/mnt/hgfs/vm_share/apex/images’ — make sure here is the right directory….
      https://forums.oracle.com/forums/thread.jspa?threadID=2358765if you need to change admin user password.
      SQL> @apxchpwd
      Enter a value below for the password for the Application Express ADMIN user.
    3. removing prior installationsfinding old installations
      SELECT username FROM dba_users
      WHERE (username LIKE ‘FLOWS_%’ OR USERNAME LIKE ‘APEX_%’)
      AND USERNAME NOT IN ( SELECT ‘FLOWS_FILES’ FROM DUAL
      UNION
      SELECT ‘APEX_PUBLIC_USER’ FROM DUAL
      UNION
      SELECT SCHEMA s FROM dba_registry WHERE comp_id = ‘APEX’);removing old installations. DROP USER APEX_040000 CASCADE;—-
      Notes:My installation – apex 4.1 unzipped – resides in:c:\oraclexe\apex — no empty apex folder in apex main folder

      always loggin in as :

      sqlplus system/password as sysdba

      Final Result: works fine. Elapsed: 00:39:38.50

Advertisements

Written by youryblog

January 22, 2013 at 1:19 AM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: