Oracle installation (10g+)

Oracle database installation is not simple procedure. And it may take hours even days if something goes wrong.

Here are some useful tutorial links and explanations. Hopefully with these instructions, installing oracle database is no longer or less painful.

• 10g Express

Oracle 10g XE is a free version for development, deployment and distribution. The installation instructions are easy to follow:

How to install Oracle 10g XE on Ubuntu

How to install Oracle 10g XE on 64-bit Ubuntu

• 10g

On the contrary of XE version, the normal one is much harder to install, here is a very helpful guide:

How to install Oracle 10g on Linux

• 11g

11g is by the time of this blog the latest released version, finding an installation guide should not be difficult with google. This is a good tutorial that I have tested and worked.

How to install Oracle 11g on Ubuntu

• Startup the database

The following commands work only for user oracle, or the DBA user name you have created when you installed the database, oracle is the default DBA user name.

To start the database after installation, first of all there are few things to check:

• ORACLE_HOME, tap

echo $ORACLE_HOME

and verify if the value corresponds to your installation

• SID, tape

echo $ORACLE_SID

and verify if the value corresponds to your database settings

now we can go,

sqlplus /nolog

then

conn / as sysdba

finally

startup

and by then you should see that the database has been started successfully.

The job may not be finished yet, your should check if the listener is active :

lsnrctl start

if the listener is already started, it will do nothing

We can now test the database connection:

sqlplus username/password@//hostname:PORT/SID

if everything is fine, your should connect to the database, and the following SQL query will return 1;

select 1 from dual;

• Tips

1. LRM-00109: could not open parameter file, here is the expert’s explanation and solution.
2. Connect from a X-Windows enabled terminal with trusted X11 forwarding: 
   

   ssh -X oracle@server_hostname_or_ip

Tags: Linux, Oracle, Oracle Database, Oracle Installation, Ubuntu