Install Oracle 11G Release 2 (11.2) on Oracle Linux 6 (OEL6)

This article presents installation of Oracle 11.2.0.3 on OEL6.

Read following article to install OEL6 Linux: Install Oracle Linux 6 64 bit(for comfort set 2G memory for your virtual machine). During OEL6 installation I drop user oracle and both group dba and oinstall.

11.2.0.3 installation guide presents full separation of grid and oracle user.

Add groups

/usr/sbin/groupadd -g 501 oinstall
/usr/sbin/groupadd -g 502 dba
/usr/sbin/groupadd -g 503 oper
/usr/sbin/groupadd -g 504 asmadmin
/usr/sbin/groupadd -g 505 asmdba
/usr/sbin/groupadd -g 506 asmoper
Add users
/usr/sbin/useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper,dba grid
/usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba oracle
Continue reading

Install Fedora 17

This article presents how to install Fedora 17.

I assume you have already downloaded Fedora 17 64 bit(about 3.5 G)  and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Linux Fedora 64 bit. 1GB ram and 64G for disk is enough plus increase video memory to 128M and turn on accelaration 3D. Rest of options you can keep default.

Continue reading

Install and configure Apex 4.2.X embedded PL/SQL

This article presents how to install and configure Apex for version 4.2, 4.2.1, 4.2.2, 4.2.3, 4.2.4, 4.2.5

Prepare software to installation

Download installation package from Oracle site and unzip.

Download apex_4.2.X.zip to directory /tmp and unzip it from
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

cd /tmp
unzip <downloaded software>

After unzip is completed a new directory will be created /tmp/apex so go to this directory and log into database as SYSDBA. Always use SYSDBA account for running all scripts.

cd /tmp/apex
sqlplus / as sysdba

Pre-installation steps

It’s recommended to do backup of the database and disable the Oracle XMLDB HTTP server by setting the HTTP port to 0.

EXEC DBMS_XDB.SETHTTPPORT(0);

Continue reading

Install Oracle 11G Release 2 (11.2) on Oracle Linux 5 (OEL5)

This article presents how to install Oracle 11.2.0.3 on OEL5.

Read following article to install OEL5 Linux: Install Oracle Linux 5 64 bit (for comfort set 2G memory for your virtual machine). During OEL5 installation I drop user oracle and both group dba and oinstall.

11.2.0.3 installation guide presents full separation of grid and oracle user.

Continue reading

Install and configure Apex 4.1.1 embedded PL/SQL

This article presents how to install Apex 4.1.1

Download installation package from Oracle site and unzip.

Download apex_4.1.zip to directory /tmp and unzip it
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

After unzip new directory will be created /tmp/apex so go to this directory and loging to database as SYSDBA. Always use SYSDBA account for running all scripts.

cd /tmp/apex
sqlplus / as sysdba

Continue reading