Tuesday, 15 August 2017

August 15, 2017

How To Install Coming Soon Packaged Sample Applications

How To Install Coming Soon Packaged Sample Applications

Installing one of the Package Sample Application should be a piece of cake , right. While , I wonder why I find most often facing the situation where, when I try to install any of the Packaged Applications, It will throw Coming Soon into my face.😰

That's how a Computer would treat you nowadays, till you find your self in the abyss called troubleshooting mother lode of code and it definitely involves some head-scratching and hair pulling.

It may be due to faulty installation or whatever went kaput. I don't want to poke around to find the root cause.  I just wanted to be able to install the packaged applications , and to heck with troubleshooting the stars. And by the way I hate the way people describe space, it seems like a whole lot of emptiness out there, and its not even air.😛

So I was stuck with this

Packaged Sample Applications with Coming Soon
Packaged Sample Applications with Coming Soon

So, I do not want you to go on a wild goose chase. Just Follow the instructions below :

Connect to you apex user.
You can find your apex user by querying the database for users , However, it would require a user with dba privileges to connect to the database.
sqlplus sys/password@service_name as sysdba
e.g.
sqlplus sys/s@xe as sysdba


Select * From dba_users;

Your Apex user should have a name something like  APEX_#VERSION# ( EX : APEX_05000).

Now Connect to APEX_05000
sqlplus APEX_050000/s@xe

Find out your apex installation folder, where you unzipped you apex.zip file.e.g D:\apex folder
Run the following script:
@D:\apex\core\wwv_flow_pkg_app_tab.sql

Now Run the following script:
@D:\apex\core\packaged_apps\install_packaged_apps.sql

By now,  you will get the Installation button working as shown below,Go to your Packaged application Installation screen and voilà  , bob's your uncle.

Packaged Sample Applications with Coming Soon
Packaged Sample Applications with Install Application Button





2 comments:

  1. Thank you for sharing this information. I find this information is easy to understand and very useful. Thumbs up!


    E-Learning

    ReplyDelete