≡ Menu

oracle database

Oracle 11g for Linux x86 has been released and available for download from official web site:
Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation, making it easier to innovate faster with confidence using Real Application Testing, manage more data for less with advanced partitioning and compression, and much more.

The following are the operating sytem requirements for Oracle Database 11g release 1:
=> Asianux 2.0
=> Asianux 3.0
=> Oracle Enterprise Linux 4.0
=> Oracle Enterprise Linux 5.0
=> Red Hat Enterprise Linux 4.0
=> Red Hat Enterprise Linux 5.0
=> SUSE Enterprise Linux 10.0

I'm sure you will be able to use Debian or Cent OS for testing purpose.

Download Oracle Database for Linux

=> Click here to download Oracle 11g for Linux

See also:

=> How to: Install Oracle Database XE Server on my Ubuntu / Debian Linux desktop system

One of my friend installed Oracle first time. After installation, he just wants to make sure everything is working fine so he called me. If you are installing oracle for Unix/Linux oses first time then it will confuse you. He wanted to know how to start oracle service and test it. He emailed me the following error:
ORA-27101: shared memory realm does not exist
ORA-01034: ORACLE not available

You need to add following line to oracle user’s .bash_profile file for testing purpose (once it is tested, you can give control to Oracle DBA) (login as a oracle user):
$ cd;vi .bash_profile
Append following lines:
export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin

Save file. Just load the above settings:
$ . .bash_profile
Start oracle Net listing service:
$ lsnrctl start
ALTERNATIVELY use full path:
$ /home/oracle/oracle/product/10.2.0/db_1/bin/lsnrctl start
Start oracle database:
$ dbstart
ALTERNATIVELY, use full path:
$ /home/oracle/oracle/product/10.2.0/db_1/bin/dbstart
Connect to Oracle database with sqlplus client (test it with scott username):
$ sqlplus "scott/tiger"
sql> select * from tab;

To shutdown Oracle database:
$ lsnrctl stop
$ dbshut

Further readings:

If you are new to Oracle try out Oracle Database 10g Documentation library, especially 2 Day DBA is fantastic document. Do not forget check out John Smiley's "Installing Oracle Database 10g Release 2 on Linux x86" article. It will teach you the basics of installing Oracle Database 10g Release 2 on Red Hat Enterprise Linux or Novell SUSE Enterprise Linux, from the bare metal up.