Upgrade Oracle Apex 4.0 in 11g Database on Linux

Before start the up gradation of Oracle apex 4.0 in oracle 11g you must take backup. My working directory is /opt/oracle therefore I copy the source of oracle apex 4.0 (apex_4.0_en.zip) in my working directory. 


Open terminal and using unzip command extract the apex_4.0_en.zip


After extraction apex directory is created in /opt/oracle


Login as SYS with SYSDBA privilege and create tablespace for apex as shown


After successful creation of tablespace, exit from SQL using quit command. Note: you can assign different directory for tablespace creation.

Now get into the directory on terminal /opt/oracle/apex and log in again as SYS with SYSDBA privilege.

apexins.sql script need to execute to start installation of apex 4.0. To execute apexins.sql script type the below shown command and mention in which TABLESPACE will be default for apex installation files.




It will take 15 to 20 minutes to complete the installation.

After completing the installation then you have to load the necessary images to the database and these images located in the following directory: /opt/oracle/apex/images

Now you have to execute the apxldimg.sql script to load the images. During the execution of apxldimg.sql script will be asked to enter the value for 1, Simple type /opt/oracle and press enter to start the load images.


Now you have to execute the apxconf.sql script for reset the password and port.

After press enter you will be asked to assign a password for admin and port number for XDB HTTP listener, type your desired password and port.


You need to unlock few of the schemas that is related to Apex application.
To unlock schema you can use terminal or Enterprise manager console. To unlock from terminal you must log in as SYS with SYSDBA privilege


Now is the time to open the oracle apex 4.0 application. Open your favorite browser and type the url as

http://localhost:8080/apex


Comments

  1. AnonymousJune 3, 2013 at 4:15 AM

    hai your sound is very nice about installation in linux, i know well well in windows based installation and development,but iam not aware the linuz based installation and apex configuration! can you send the root for the same! plz
    * how to download from oracle linux(tried but could not)
    *installation
    *os file system also.
    send the information: ram_hairams@yahoo.co.in

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more