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-10.2.0.1-1.0.i386.rpm
    /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-1.1.23.61-1.noarch.rpm

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 sqldeveloper-2364.zip 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.

1,287 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.

  19. I am an investor of gate io, I have consulted a lot of information, I hope to upgrade my investment strategy with a new model. Your article creation ideas have given me a lot of inspiration, but I still have some doubts. I wonder if you can help me? Thanks.

  20. Pingback: meritking
  21. Pingback: madridbet
  22. Pingback: grandpashabet
  23. Pingback: meritking
  24. Incorporating mindfulness techniques, such as mindful eating or body scan meditation, can help men with impotence increase self-awareness, reduce anxiety, and enhance the overall experience of sexual activities.

    what color is viagra pills https://belviagra.com/

  25. Pingback: meritking
  26. Pingback: meritking
  27. Быстро возводимые здания: финансовая выгода в каждой части!
    В современном обществе, где секунды – доллары, строения быстрого монтажа стали решением, спасающим для компаний. Эти инновационные конструкции комбинируют в себе твердость, финансовую выгоду и быстрое строительство, что делает их оптимальным решением для коммерческих мероприятий.
    Быстровозводимые здания
    1. Молниеносное строительство: Часы – ключевой момент в финансовой сфере, и скоро возводимые строения дают возможность значительно сократить время строительства. Это значительно ценится в условиях, когда важно быстро начать вести бизнес и начать получать прибыль.
    2. Экономия средств: За счет оптимизации производства и установки элементов на месте, финансовые издержки на быстровозводимые объекты часто снижается, по отношению к обычным строительным проектам. Это позволяет сэкономить средства и обеспечить более высокий доход с инвестиций.
    Подробнее на https://scholding.ru/
    В заключение, скоро возводимые строения – это отличное решение для коммерческих задач. Они включают в себя быстроту возведения, экономичность и твердость, что позволяет им оптимальным решением для фирм, стремящихся оперативно начать предпринимательскую деятельность и получать деньги. Не упустите возможность сократить затраты и время, лучшие скоростроительные строения для вашего следующего проекта!

  28. Моментально возводимые здания: коммерческая выгода в каждом блоке!
    В современной сфере, где время имеет значение, сооружения с быстрым монтажем стали решением по сути для бизнеса. Эти современные объекты комбинируют в себе высокую прочность, финансовую экономию и скорость монтажа, что придает им способность превосходным выбором для разнообразных предпринимательских инициатив.
    Металлоконструкции здания под ключ
    1. Молниеносное строительство: Время – это самый важный ресурс в коммерческой деятельности, и скоростроительные конструкции позволяют существенно уменьшить временные рамки строительства. Это высоко оценивается в сценариях, когда важно быстро начать вести бизнес и начать извлекать прибыль.
    2. Экономия средств: За счет оптимизации процессов производства элементов и сборки на месте, экономические затраты на моментальные строения часто приходит вниз, по сравнению с традиционными строительными проектами. Это обеспечивает экономию средств и добиться более высокой доходности инвестиций.
    Подробнее на http://scholding.ru/
    В заключение, экспресс-конструкции – это отличное решение для коммерческих проектов. Они объединяют в себе ускоренную установку, экономичность и твердость, что делает их идеальным выбором для деловых лиц, имеющих целью быстрый бизнес-старт и обеспечивать доход. Не упустите момент экономии времени и средств, оптимальные моментальные сооружения для вашего следующего делового мероприятия!

  29. Наша бригада профессиональных исполнителей завершена предоставлять вам прогрессивные средства, которые не только предоставят надежную охрану от зимы, но и подарят вашему дому стильный вид.
    Мы трудимся с новейшими средствами, ассигнуруя долгий продолжительность службы и блестящие эффекты. Изоляция наружных стен – это не только экономия ресурсов на отапливании, но и заботливость о экологии. Спасательные технические средства, какие мы используем, способствуют не только дому, но и сохранению природы.
    Самое ключевое: Утепление фасада цена за 1 м2 у нас стартует всего от 1250 рублей за м2! Это доступное решение, которое преобразит ваш хаус в подлинный уютный корнер с минимальными тратами.
    Наши проекты – это не лишь изолирование, это составление пространства, в где каждый элемент показывает ваш индивидуальный моду. Мы возьмем во внимание все ваши требования, чтобы осуществить ваш дом еще еще больше комфортным и привлекательным.
    Подробнее на http://www.ppu-prof.ru
    Не откладывайте заботу о своем обители на потом! Обращайтесь к экспертам, и мы сделаем ваш корпус не только более теплым, но и стильным. Заинтересовались? Подробнее о наших работах вы можете узнать на веб-ресурсе. Добро пожаловать в универсум благополучия и стандартов.

  30. Дорогие Партнеры!
    Подносим вам инновационное элемент в мире декора интерьера – шторы плиссе. Если вы аспирируете к превосходству в всякой части вашего дома, то эти сукна подберутся безупречным выбором для вас.
    Что делает шторы плиссе настолько живыми оригинальными? Они совмещают в себе лоск, использование и сущность. Благодаря характерной структуре, прогрессивным тканям, шторы плиссе идеально подходятся для какого бы то ни интерьера, будь то светлица, ложе, плита или рабочее поляна.
    Закажите шторы плиссе на пластиковые окна – оттворите уют и красочность в вашем доме!
    Чем подкупают шторы плиссе для вас? Во-первых, их поразительный макет, который прибавляет к привлекательность и стильность вашему декору. Вы можете подобрать из разных структур, оттенков и стилей, чтобы подчеркнуть особенность вашего дома.
    Кроме того, шторы плиссе предлагают полный базар функциональных возможностей. Они могут регулировать уровень света в помещении, преграждать от солнечного света, обеспечивать приватность и формировать уютную атмосферу в вашем доме.
    Мы веб-сайт: http://www.tulpan-pmr.ru
    Мы поддержим вам выбрать шторы плиссе, какие прекрасно гармонизируются с для вашего обстановки!

  31. Мы специалисты SEO-консультантов, занимающихся продвижением вашего сайта в поисковых системах.
    Наша команда преуспели в своей деятельности и стремимся передать вам наши знания и опыт.
    Какими преимуществами вы сможете воспользоваться:
    поисковое продвижение цена
    • Анализ всех аспектов вашего сайта и разработка уникальной стратегии продвижения.
    • Повышение эффективности контента и технических аспектов вашего сайта.
    • Постоянное отслеживание результатов и анализ вашего онлайн-присутствия с целью его совершенствования.
    Подробнее https://seo-prodvizhenie-ulyanovsk1.ru/
    У наших клиентов уже есть результаты: увеличение посещаемости, улучшение позиций в поисковых запросах и, конечно же, рост своего бизнеса. У нас есть возможность предоставить вам бесплатную консультацию, для того чтобы обсудить ваши требования и разработать стратегию продвижения, соответствующую вашим целям и финансовым возможностям.
    Не упустите возможность улучшить свои позиции в интернете. Свяжитесь с нами уже сегодня.

  32. The development of stromectol 12mg, featuring ivermectin, as a novel formulation for use in poultry farming offers advantages such as improved bioavailability and reduced environmental impact. These advancements in drug delivery technology enhance the effectiveness and safety of ivermectin-based treatments for parasitic infections in poultry, supporting sustainable farming practices.

Leave a Reply to Gcgksq Cancel reply

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