Troubleshooting on installing Oracle Database 10g in Ubuntu Hardy
According to the official installation guide, to install Oracle Database 10g in linux, the host operation system must meet the requirement that is one of the following:
Red Hat Enterprise Linux 3.0 (Update 3 or later), Red Hat Enterprise Linux 4.0, SUSE Linux Enterprise Server 9.0, Asianux 1.0,Asianux 2.0
Therefore a simulation must be done under Ubuntu linux.
sudo ln -s /usr/bin/awk /bin/awk
sudo ln -s /usr/bin/rpm /bin/rpm
sudo ln -s /usr/bin/basename /bin/basename
sudo ln -s /etc /etc/rc.d
To finish with this step, we have to create a file /etc/redhat-release that contains the information of the Red Hat system, this file is scanned by the installer and if it doesn't exist or if the information contained is wrong, the installer will not work:
sudo gedit /etc/redhat-release
Copy/Paste the following text:
Red Hat Linux release 3.0 (drupal)
- "TNS:lost contact"
If the universal installer popups the error alert "TNS:lost contact", that may be caused by the missing package of libaio1 in Ubuntu.
"Can't connect to X11 window server using 'oasis-latin:0.0' as the value of the DISPLAY variable."
if you've already export the display with ':0.0', the error occurs, however, it may be solved by: xhost +
- Environment Parameters
After successful installation, you need set following parameters before you can safely use your Oracle instance, database and utilities attached.
export ORACLE_BASE=/media/disk/app/oracle/
export ORACLE_HOME=/media/disk/app/oracle/product/10.2.0/db_1/
export PATH=/media/disk/app/oracle/product/10.2.0/db_1/bin
export ORACLE_SID=orcl
- ed command in sqlplus
ed command invoked editor can be set in the file '//sqlplus/glogin.sql' with adding the following line:
Tags: database, install, linux, oracle, redhat, troubleshooting, ubuntuDEFINE _EDITOR = /usr/bin/gedit
