Oracle Express Edition and SQL Developer

So the first phase of my testing I installed Oracle Express Edition on Windows XP, Windows 2000, Windows 2003, Red Hat Enterprise Edition 4, and Oracle Unbreakable Linux 4 Update 4. The installation required two sets of binaries, one for Windows and one for Linux. There were the Express Edition binaries and the SQL Developer binaries. The size of the binaries looked like…

Linux – Express Edition – 215Mbytes
         – SQL Developer – 39Mbytes
         – JDK for Linux 57Mbytes
         – install footprint 200M app, 450M database – 650M
         – memory footprint – 512Mbytes
Windows – Express Edition – 162Mbytes
                – SQL Developer – 67Mbytes
                – install footprint – 1.1G (includes JDK as part of package)
                – memory footprint – 512Mbytes

The installation on Windows was trivial. Execute the database installation executable and select the defaults. The only data that needed to be entered was the password for the system account. The installation on Linux was a little more difficult. The Linux installation did not have a large enough swap footprint so I had to double the swap area to properly perform the installation. The installation was a simple rpm folled by a custom script generated by the installation. To install the software on Linux I had to perform the following steps

1) verify swap space
     swapon -s
     On RHEL4 I had to add swap space which involved adding another disk through vmware which required halting the operating system and adding a vmware SCSI disk. Once I did this I had to use fdisk to define a primary partition and label it as Linux Swap. Once I did this I had to use the mkswap command to initialize the device and then add it to swap using the swapon command.
     On Unbreakable Linux, this was not an issue because the swap space was defined at 2G.

2) verify that the network was up and running with ifconfig -a
     On Unbreakable Linux the network was bound to a MAC address that was different than the hardware that I was running on. I had to uncheck this and make sure that I could get a DHCP address

3) mount the software images from the localhost
     On RHEL4 and Unbreakable Linux I had to define the vmware host in the /etc/hosts file and share the external USB disk from the vmware host as well. Once I did this I was able to mount the disk using
     mkdir /mnt/e
     mount -t smbfs //vmware-host/e /mnt/e

4) install the database software
    cd /mnt/e/products/database/Express Edition
    rpm -i oracle-xe-
    /etc/init.d/oracle-xe configure
       – define HTTP port
       – define database listener port
       – define password for SYS and SYSTEM
       – opt to start the database on boot which also starts the database now.

5) install the SQL Developer software
    cd /mnt/e/products/sqldeveloper
    rpm -i sqldeveloper-

On RLEH4 I had to download a JDK and the Firefox browser to get SQL Developer working. I could have done these when I installed RHEL4 but the image provided to me did not contain these packages. Installation of these packages were simple but did require an additional step on this platform.

To install the software on Windows I just executed the OracleXE.exe and unzipped the file. The OracleXE binary asked for an installation directory location and password for the system account. Once these were finished, the database was installed, configured, and running. When I started the SQL Developer I had to define a connection to the localhost and login using the ports and password provided when I installed the database.

Once the software was installed, it looked the same independant of the operating system configuration. The SQL Developer and Database web management interfaces function and look the same on all operating system levels.

The reason I started with the Express Edition and SQL Developer is that these are the basis for most software development and testing. These platforms in conjunction with Oracle Unbreakable Linux can be obtained at zero cost for a developer. Many companies use this model for development or use Windows XP as the basis because that is the operating system that comes with new desktops or laptops.

next up…. installing standard edition on the same platfoms.

353 thoughts on “Oracle Express Edition and SQL Developer”

  1. I would like to voice my admiration for your kind-heartedness in support of men and women that absolutely need assistance with that topic. Your real dedication to passing the message all through turned out to be especially valuable and has in most cases allowed individuals just like me to arrive at their desired goals. Your entire invaluable hints and tips indicates a great deal a person like me and further more to my peers. Regards; from each one of us.

  2. I simply wanted to thank you so much yet again. I am not sure what I would’ve followed in the absence of the actual creative ideas shown by you concerning that problem. Entirely was a real troublesome setting in my view, however , taking a look at the specialised mode you solved it forced me to leap with happiness. Extremely happier for your support and thus trust you know what a powerful job you are always undertaking educating others using your blog post. Most probably you have never encountered any of us.

  3. I really wanted to develop a comment to be able to thank you for all of the nice tips and hints you are giving on this website. My considerable internet research has at the end of the day been honored with extremely good suggestions to share with my friends. I ‘d say that many of us site visitors actually are truly fortunate to be in a good place with so many outstanding individuals with beneficial methods. I feel quite lucky to have encountered the webpage and look forward to tons of more enjoyable times reading here. Thanks once more for everything.

  4. Thanks for every one of your labor on this blog. Debby really loves making time for investigation and it is easy to see why. Almost all know all regarding the lively medium you create powerful guidance on your website and even invigorate participation from others on this subject plus our favorite girl is in fact studying a great deal. Have fun with the remaining portion of the new year. You have been performing a terrific job.

  5. Thanks so much for providing individuals with an exceptionally splendid opportunity to read articles and blog posts from this website. It is always so enjoyable plus stuffed with a lot of fun for me and my office mates to search your web site more than thrice in one week to learn the fresh guides you have. Not to mention, we are usually contented considering the striking points you give. Some two ideas in this posting are unequivocally the most effective we have ever had.

  6. I precisely wished to appreciate you yet again. I do not know the things that I would’ve achieved without these techniques discussed by you directly on that problem. It truly was an absolute traumatic setting in my position, but being able to see this skilled mode you solved that took me to leap over gladness. I am just grateful for this assistance and even wish you really know what a great job you are always getting into teaching men and women by way of your web blog. Most likely you have never got to know any of us.

  7. I wanted to send you the very small remark to be able to say thanks yet again on the unique tricks you’ve contributed on this site. It has been certainly wonderfully generous with people like you to provide unreservedly what many individuals would’ve marketed as an electronic book to help make some bucks on their own, notably now that you might well have tried it if you wanted. The good ideas also acted to be a easy way to recognize that some people have a similar zeal similar to my personal own to figure out a little more in regard to this issue. I’m certain there are lots of more enjoyable periods in the future for individuals that check out your blog post.

  8. I precisely needed to appreciate you yet again. I’m not certain the things that I might have handled without the techniques shown by you over such a area of interest. It had been a very horrifying problem in my opinion, but looking at the very expert fashion you handled the issue forced me to jump over joy. Now i am thankful for this work and in addition hope that you recognize what an amazing job that you are accomplishing instructing the others using a web site. I am certain you’ve never met all of us.

  9. I am only writing to let you know of the superb experience my friend’s daughter undergone viewing your webblog. She noticed several issues, with the inclusion of how it is like to possess an excellent giving mindset to have many others easily understand chosen tricky things. You really surpassed our expectations. Thank you for producing such great, healthy, explanatory and as well as cool thoughts on your topic to Tanya.

  10. I wanted to develop a brief note to say thanks to you for the unique hints you are showing at this site. My time intensive internet lookup has finally been honored with professional know-how to go over with my partners. I would assume that many of us website visitors are truly blessed to exist in a remarkable website with many wonderful individuals with great basics. I feel very much blessed to have seen the web pages and look forward to plenty of more amazing times reading here. Thanks a lot once more for all the details.

  11. Thanks for your whole effort on this web site. My mom takes pleasure in going through investigation and it’s easy to understand why. A number of us know all relating to the dynamic mode you present important information on your website and therefore cause response from other individuals about this subject while our own girl is in fact starting to learn a lot. Have fun with the remaining portion of the new year. You are carrying out a brilliant job.

  12. I have to show appreciation to the writer for rescuing me from this particular predicament. After exploring throughout the the net and coming across thoughts which are not productive, I assumed my entire life was done. Being alive minus the solutions to the difficulties you’ve sorted out by means of this guide is a serious case, as well as the kind which may have in a wrong way affected my entire career if I had not noticed your site. Your good training and kindness in dealing with all things was very helpful. I’m not sure what I would have done if I hadn’t discovered such a thing like this. I’m able to now look forward to my future. Thanks so much for the professional and effective help. I won’t be reluctant to recommend your blog to any individual who requires care about this topic.

  13. Needed to draft you the very small remark just to say thanks a lot once again with your splendid strategies you’ve discussed above. It is quite remarkably open-handed with people like you giving unreservedly precisely what a lot of folks could possibly have advertised as an e book to help with making some money for themselves, primarily now that you might well have done it in case you decided. These tricks additionally worked to be a easy way to know that other people have similar zeal like my personal own to realize a great deal more around this matter. I think there are many more pleasurable times in the future for individuals who looked over your site.

  14. I simply wished to thank you very much once again. I’m not certain the things that I might have created in the absence of these solutions contributed by you directly on such a area of interest. It had been a real terrifying difficulty in my circumstances, nevertheless considering a new specialized style you treated that took me to cry over fulfillment. I’m happy for this assistance and in addition trust you know what an amazing job you’re providing training many others via a blog. More than likely you haven’t met any of us.

  15. I would like to show thanks to you just for bailing me out of such a difficulty. Right after checking through the search engines and seeing recommendations which are not powerful, I was thinking my entire life was over. Being alive minus the answers to the problems you’ve fixed all through your good guide is a critical case, as well as the kind that would have in a negative way damaged my career if I hadn’t noticed the blog. Your own personal knowledge and kindness in handling a lot of things was crucial. I don’t know what I would’ve done if I hadn’t discovered such a solution like this. I can at this moment look forward to my future. Thank you very much for this impressive and effective help. I will not think twice to recommend your blog to any person who needs to have guidelines about this area.

  16. A lot of thanks for all of your labor on this web site. My mom delights in conducting internet research and it’s obvious why. My spouse and i know all concerning the compelling way you render both useful and interesting tricks via the web blog and as well boost participation from other individuals on the issue then our child has been starting to learn a lot. Take advantage of the rest of the new year. Your doing a wonderful job.

  17. I simply wanted to send a simple message to express gratitude to you for these awesome information you are giving on this website. My extensive internet investigation has at the end of the day been compensated with good knowledge to go over with my family and friends. I ‘d suppose that most of us visitors actually are quite endowed to exist in a superb place with so many wonderful professionals with insightful methods. I feel quite lucky to have used your entire web page and look forward to tons of more fabulous moments reading here. Thank you once more for a lot of things.

  18. I enjoy you because of your own efforts on this web site. My niece takes pleasure in managing research and it’s simple to grasp why. We know all concerning the lively method you convey very useful ideas on your blog and increase response from website visitors about this point so my girl is always becoming educated a great deal. Have fun with the remaining portion of the new year. You’re performing a wonderful job.

Leave a Reply

Your email address will not be published. Required fields are marked *