There was an error in this gadget

Monday, January 19, 2009

Installing Oracle 10g on Ubuntu Hardy

Now you might wonder why I would need to install Oracle on Linux, but I just wanted to see if it could be done... obviously it can be done !
Here it is :

Add the following repository to the "/etc/apt/sources.list" file using the following command to open the file in any editor:

$ gksudo gedit /etc/apt/sources.list


Goto the very end and paste the following line:

deb http://oss.oracle.com/debian unstable main non-free


Open up the terminal and paste the following lines one after the other:

$ wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
$ sudo apt-get update
$ sudo apt-get install oracle-xe


After installation the oracle db needs to be configured.
$ sudo /etc/init.d/oracle-xe configure


The configuration will ask you for
1. HTTP port for the application (default is 8080 which conflicts with GlassFish or Apache Tomcat, hence I chose 33333 !!!)
2. Port used for the database listener (kept the default 1521)
3. The PASSWORD for the username 'system' with which you will login (DO NOT forget this password)
4. Whether you want the database to run at startup ( I chose no)

The configuration completes (may take some time) & you are ready to go.

To start the database:
$ sudo /etc/init.d/oracle-xe start


To stop the database:
$ sudo /etc/init.d/oracle-xe stop


This installation also adds a menu under "Applications" . If you want to start/stop the database using the GUI, you will need to add your user to the usergroup 'dba'. After this the database can be started/stopped using the GUI options.

You can then run the command-line tool SQL Plus. At the prompt type:
connect username/ password

(username can be 'system' or 'sys' and password is the password specified during the configuration

OR
You can use the interface via the browser using the address:
(Use your own port number instead of 33333)
http://127.0.0.1:33333/apex
Login with the same credentials as above.


Thats it. You can run all your SQL queries now :)

EDIT:
This is where I got my howto

http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html

EDIT 2:

If you want to install the oracle deb file separately (offline), you will need to download & install the libaio package using the command:

$ sudo apt-get install libaio



Edit 3:

If you are having problems starting, stopping and using the web interface(http://127.0.0.1:33333/apex) as mentioned above you could follow the steps below:

To start the Database server
Applications -> Oracle 10g -> Start Database
To Stop the Database
Applications -> Oracle 10g -> Stop Database

To run SQL commands (after you have started the Database) :
Applications -> Oracle 10g -> Run SQL Command Line

Hope this helps as well !

Wednesday, January 7, 2009

Ok... so nothing much after that first post.

Now I'm thinking of just making a list of all the things i have done on ubuntu before i start making entries for them.

1. installed and setup (if any !!!) LAMP (not difficult at all)

2. installed wine and using Dreamweaver and uTorrent

3. installed extra compiz plugins

4. installed AWN and screenlets

5. installed kde4 then removed it, installed kde3.5 and xfce4 as well

5. started using phpmyadmin much later and found that it was not working... therefore needed some work. For some silly reason, that took time... but got there in the end.

6. setup loads of aliases and used the .bash_aliases file instead of everything being inside .bashrc

7. downloaded and install VirtualBox (required some work)

8. downloaded and installed dnsmasq and mydnsconfig (required a lot of work... stayed up whole night to make it work)

9. installed sun-java and netbeans

10. installed openoffice 3 in ubuntu hardy manually since it wasnt supported

11. installed python 2.6 for no reason whatsoever and ended up messing my python 2.5. Fixed that somehow using this link. used the "update-alternatives" command. Also used this command to fix my Java soft links which had gotten messed up due to some more mess ups on my part

12. installed 64-bit edition of ubuntu hardy. also installed openSuse11 64-bit and Mandriva 2008.1 64-bit.
Had installed fedora9 as well, but removed it in favour of the 64bit ubuntu hardy.

13. installed ubuntu tweak and google earth on ubuntu hardy 64bit as well as skype with some manipulation of 32bit libs with a script i found on ubuntuforums (need to find a link to that how-to desperately, if i dont have it with me)

14. downloaded loads of themes and general look & feel stuff. around 350MB of it :)

15. downloaded and customized the cairo dock

16. created virtualhosts for apache and made localhost/~username accessible

Follow this blog !!!