Steps to install Apex 4 on linux

Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database.

Browser Requirement:
To view or develop Oracle Application Express applications, Web browsers must
support Java Script and the HTML 4.0 and CSS 1.0 standards. The following browsers meet this requirement:
1)Microsoft Internet Explorer 6.0 or later version
2)Firefox 1.0 or later

HTTP Server Requirements:
In order to run, Oracle Application Express must have access to one of the following:
1)Embedded PL/SQL gateway
2)Oracle HTTP Server and mod_plsql
Oracle XML DB HTTP Server with the embedded PL/SQL gateway installs with
Oracle Database 11g. It provides the database with a Web server and also the necessary infrastructure to create dynamic applications.

Oracle Application Express requires the shared_pool_size of the target database to be at least 100 MB.

Disk Space Requirement:
Oracle Application Express disk space requirements are as follows:
1)Free space for Oracle Application Express software files on the file system: 450 MB
2)Free space in Oracle Application Express tablespace: 100MB
3)Free space in SYSTEM tablespace: 85 MB
Free space in Oracle Application Express tablespace for each additional language
(other than English) installed: 30MB

Although you can install APEX into an existing tablespace, I recommend creating a new tablespace.
This will hold all the APEX objects and also any files uploaded to the database.
To create a new tablespace called APEX run the following:

CREATE TABLESPACE APEX DATAFILE "<filename and path>"

SIZE 200M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

Installing the Oracle Application Express Software:
To install Oracle Application Express release 4.0.1:
1.Download the file apex_4.0.1.zip from the Oracle Application Express download
page. See:
http://www.oracle.com/technology/products/database/application_
express/download.html
2.Unzip apex_4.0.1.zip as follows, preserving directory names:
$ Unzip apex_4.0.1.zip
3. Change your working directory to apex.
$ cd apex
4. Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:

$ sqlplus sys/SYS_password as sysdba
Run apexins.sql passing the following five arguments in the order shown:

@apexins password tablespace_apex tablespace_files tablespace_temp images

eg: SQL>@apexins foo APEX APEX TEMP /i/

Configure Embedded PL/SQL Gateway:
To configure the embedded PL/SQL gateway:
1. Change your working directory to the directory where you
unzipped the Application Express software.
2. Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:
$ sqlplus sys/password as sysdba
$ @apex_epg_config
eg:After unzipped you have directiory structure like: /home/apex
@apex_epg_config /home
The next step is to upload the images.
Run apxldimg.sql passing the file system path to the base directory where the Oracle Application Express software was unzipped as shown in the following example:
SQL>@apxldimg.sql /home

You need to unlock few of the schema that is related to Apex application. Now unlock the schema as :
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
SQL > ALTER USER XDB ACCOUNT UNLOCK;
SQL > ALTER USER APEX_040000 ACCOUNT UNLOCK;
SQL > ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
SQL > ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

Execute the apxconf.sql script and type the below command:

SQL>@apxconf.sql

And press enter...you will be asked to assign a password for admin : type your desired password  And press enter.
Then you will be asked to enter password for XDB HTTP port : type your desired port . here you can keep 8080 or can change like 7778.

You can verify the port no by using th following command:

SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

You can start XML DB as follows:
Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:
$ sqlplus sys/SYS_password as sysdba

Enter a statement similar to the following:

EXEC DBMS_XDB.SETHTTPPORT(port);

eg:SQL>EXEC DBMS_XDB.SETHTTPPORT(8080);

Open a browser and type the address
eg:http://localhost:8080

You will need to log in using the workspace "internal", username "admin" and the password you specified during installation.

In case you are not able to see images and logo follow this work around:
Execute reset_image_prefix script located in utilities directory.

Change your working directory to <base directory>/apex/utilities

$ sqlplus conn sys/password as sysdba

SQL>@reset_image_prefix.sql /i/

Oracle 11g Release 2 installation on linux screenshots

Provide email id if you wish to receive support from Oracle.

Select the operation you want to perform.

Enter the details below with admin password.

Easy Steps to install Java on Linux

Java is a programming language and computing platform first released by Sun Microsystems in 1995. It is the underlying technology that powers state-of-the-art programs including utilities, games, and business applications. Java runs on more than 850 million personal computers worldwide, and on billions of devices worldwide, including mobile and TV devices.

There are lots of applications and websites that won't work unless you have Java installed, and more are created every day. Java is fast, secure, and reliable. From laptops to datacenters, game consoles to scientific supercomputers, cell phones to the Internet, Java is everywhere!

So,i'm going to explain you step by step installtion of java on linux.

Step 1:
Download the Latest Version of java from http://java.com
Select the OS you would like to download for(window,linux,solaris).
There are two types of files to download.

1.Self extracting binary file.
This file can be used to install Java in a location chosen by the user and can be installed by anyone (not only root users). As long as you are not root user, it cannot displace the system version of the Java platform suppled by Linux.

2.RPM Package
Linux RPM (Redhat Package Manager) uses RPM to install Java. In order to use this method, you need to have RPM available on your system. Otherwise use the other option.

In this case we will download self extracting binary file.
I m using Java 6 update 13.

Step2.
Install as root for system wide java or if you want it just for yourself,extract the package in ~/bin/java or your home location.

a.Change the file permission.
chmod a+x  jdk-6u13-linux-i586.bin

b.Change to directory where you want to install
cd /usr/java/

c.Run the file.
./jdk-6u13-linux-i586.bin

Accept the license agreement.

Java gets installed in the directory
/usr/java/jdk1.6.0_13

Step 3.
Now, if you want to be able to execute this version of Java interpretor or compiler from any directory on your GNU/Linux system you will have to create a few symbolic links:

# ln -s /usr/java/jdk1.6.0_13/bin/java /usr/bin/java
# ln -s /usr/java/jdk1.6.0_13/bin/javac /usr/bin/javac

or

To make Java available to all users, add it to the default PATH settings by editing /etc/profile and adding:

PATH=$PATH:/usr/java/jdk1.6.0_13/bin

JAVA_HOME=/usr/java/jdk1.6.0_13

export $PATH $JAVA_HOME

Firefox or Mozilla

Create a symbolic link to the libjavaplugin.so file in the browser plugins directory

• Go to the plugins sub-directory under the Firefox installation directory
  cd <Firefox installation directory>/plugins
  
• Create the symbolic link
  ln -s <Java installation directory>/plugin/i386/
ns7/libjavaplugin_oji.so

eg.
Go to mozilla folder

cd /usr/lib/mozilla/plugins


Create a symbolic link

ln -s /usr/java/jdk1.6.0_13/jre/plugin/i386/ns7/libjavaplugin_oji_so

How to install Oracle 11g on Linux

In this article i'm going to explain step by step installation of Oracle 11g Release 1 on RHEL 4 and 5,Enterprise Linux 4 and 5 by Oracle.This version is certified by Oracle.Article also covers guide for Centos Linux 4 and 5.

Guide includes:

1.Pre-Installation Steps
2.Installation
3.Post-Installation Steps.



Pre-Installation Steps:

1. Create oracle users and groups.
groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba,oper oracle
passwd oracle

2. Set Kernel Parameters

Edit /etc/sysctl.conf and add following lines.
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6553600
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

execute sysctl command
# sysctl -p

or
reboot to apply above changes.

For RedHat (OEL, Centos, WBL) 4 version: Edit the /etc/pam.d/login file and add following line:
session required /lib/security/pam_limits.so

For RedHat (OEL, Centos) 5 version: Edit the /etc/pam.d/login file and add following line:
session required pam_limits.so


Edit the /etc/security/limits.conf file and add following lines:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536


3. Creating oracle directories
mkdir -p /u01/app/oracle/product/11.1.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

4. Setting Oracle Enviroment
Edit the /home/oracle/.bash_profile file and add following lines:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
ORACLE_SID=ORCL
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH

Save the .bash_profile and execute following commands to load new user enviroment:
cd /home/oracle
. .bash_profile
Login as root and issue the following command:
xhost +


Some additional packages are required for succesful installation of Oracle software. To check whether required packages are installed on your operating system use following command:

rpm -q binutils elfutils elfutils-libelf gcc gcc-c++ glibc glibc-common glibc-devel compat-libstdc++-33 cpp make compat-db sysstat libaio libaio-devel unixODBC unixODBC-devel|sort


Installation:

Download the Oracle 11g release 1 (11.1.0.6.0) software from Oracle website.
Extract the files using following command:
unzip linux_11gR1_database.zip


Now the system is prepared for Oracle software installation. To start the installation process go to database directory and execute the following commands:
cd database
./runInstaller

Click here for screenshot

Post-Instalation:
Auto Startup and Shutdown of Database and Listener
Login as root and modify /etc/oratab file and change last character to Y for apropriate database.
ORCL:/u01/app/oracle/product/11.1.0/db_1:Y
As root user create new file "oracle" (init script for startup and shutdown the database) in /etc/init.d/ directory with following content:
#!/bin/bash
#
# oracle Init file for starting and stopping
# Oracle Database. Script is valid for 10g and 11g versions.
#
# chkconfig: 35 80 30
# description: Oracle Database startup script

# Source function library.

. /etc/rc.d/init.d/functions

ORACLE_OWNER="oracle"
ORACLE_HOME="/u01/app/oracle/product/11.1.0/db_1"

case "$1" in
start)
echo -n $"Starting Oracle DB:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
echo "OK"
;;
stop)
echo -n $"Stopping Oracle DB:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
echo "OK"
;;
*)
echo $"Usage: $0 {start|stop}"
esac
Execute (as root) following commands (First script change the permissions, second script is configuring execution for specific runlevels):
chmod 750 /etc/init.d/oracle
chkconfig --add oracle --level 0356
Auto Startup and Shutdown of Enterprise Manager Database Control
As root user create new file "oraemctl" (init script for startup and shutdown EM DB Console) in /etc/init.d/ directory with following content:
#!/bin/bash
#
# oraemctl Starting and stopping Oracle Enterprise Manager Database Control.
# Script is valid for 10g and 11g versions.
#
# chkconfig: 35 80 30
# description: Enterprise Manager DB Control startup script

# Source function library.

. /etc/rc.d/init.d/functions

ORACLE_OWNER="oracle"
ORACLE_HOME="/u01/app/oracle/product/11.1.0"

case "$1" in
start)
echo -n $"Starting Oracle EM DB Console:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl start dbconsole"
echo "OK"
;;
stop)
echo -n $"Stopping Oracle EM DB Console:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl stop dbconsole"
echo "OK"
;;
*)
echo $"Usage: $0 {start|stop}"
esac
Execute (as root) following commands (First script change the permissions, second script is configuring execution for specific runlevels):
chmod 750 /etc/init.d/oraemctl
chkconfig --add oraemctl --level 0356
You may consider to use rlwrap for comfortable work with sqlplus and adrci utility. RPM package for RedHat compatible (x86) distribution you can download here.
su -
# rpm -ivh rlwrap-0.24-rh.i386.rpm
# exit
echo "alias sqlplus='rlwrap sqlplus'" >> /home/oracle/.bash_profile
echo "alias adrci='rlwrap adrci'" >> /home/oracle/.bash_profile
. /home/oracle/.bash_profile