Running Oracle XE on OSX


Written by Jan Eerdekens

If you want to run Oracle XE on OSX you'll quickly run into the problem that Oracle only provides a Windows & Linux, but not an OSX specific version. This means we'll need to run Oracle XE in some sort of virtualized environment and for this we'll use the freely available Oracle VirtualBox (version 4.8.2 r83876) and CentOS (version 6.3).

If you haven't got VirtualBox installed yet, just download & install it. We're going to create a CentOS 6.3 x86_64 virtual machine and for this you'll need to download the corresponding minimal ISO first: CentOS-6.3-x86_64-minimal.iso. Now we are ready to create the virtual machine by going through the following steps:

  • Start VirtualBox.
  • Click New to open the Create Virtual Machine dialog and give the machine a NameCentOS 6.3 x86_64. Using the aforementioned name should already select the correct machine Type and Version, if not select Linux and Red Hat (64 bit).
  • Set the Memory size to 1024 MB (or more if you think you need it for your purposes).

 

 

  • Select Create a virtual hard drive now and click Create. This will open the Create Virtual Hard Drive dialog where you can change the default File location if you want, but the default should be fine.
  • The default File size of 8,00 GB should be sufficient, but feel free to increase it (less won't work for our case).
  • Select VDI (VirtualBox Disk Image) as the Hard drive file type and Dynamically allocated as Storage on physical hard drive and click Create.

 

  • After clicking Create you'll be taken back to the main manager screen where your new image will appear in the list.
  • Before starting it we'll first need attach the downloaded ISO to the cdrom drive and set the networking to bridged. To do this select your image im the manager list and click Settings (or right click it and choose Settings).
  • Go to the Storage tab and under Controller: IDE select Empty and click on the CD/DVD icon beside the IDE Secondary dropdown.
  • Select Choose a virtual CD/DVD disk file and select the iso you downloaded earlier.

 

 

 

Go to the Network tab and for Adapter 1 select Bridged Adapter from the Attached to dropdown.

 

 

Click OK to save and close the settings dialog and click Start to boot up the new machine and start the installation of CentOS.

 

  • Starting the machine you just configured with the ISO and the bridged networking will start the actual CentOS installation. The next steps will guide you through this.
  • Select Install or upgrade an existing system.

 

Click Skip in the Disk Found dialog (media testing isn't needed here).

Click Next in the graphical installer screen.

 

Choose your language and click Next (we'll use English (English)).

Choose your keyboard layout and click Next (we'll use U.S. English).

Leave Basic Storage Devices selected and click Next.

Click Yes, discard any data (there really isn't any data on this newly created virtual disk anyway).

On the networking screen we'll need to change a few settings so that the network interface we'll be actually up after boot and DNS works correctly.

Change the Hostname to oraclexe and then click Configure Network.

Click Edit... for the System eth0 interface in the Wired tab.

Check the Connect automatically checkbox and in the IPv4 Settings tab select Automatic (DHCP) addresses only in the Method dropdown and add127.0.0.1,8.8.8.8,8.8.4.4 in the DNS servers field and click Apply...

Select your correct timezone and click Next (we'll use Brussels, Europe)

Fill in a suitable root password (twice) and click Next (we'll use oracle as password).

If it complains that the password is too weak just click Use Anyway.

Keep the Replace existing Linux System(s) selected and click Next.

Click Write changes to disk on the dialog that appears, click Next and wait while the system is being installed.

When the installation is done a screen will appear with a success message and a Reboot button.

Click the Reboot button to finish the installation and after reboot you should be presented with a terminal screen and you should be able to login in as root with the password you entered during install.

This is a good time to run yum update y so the system will be updated with the latest versions of several components, libraries and programs. It is also a good idea to run yum install unzip (to unzip the Oracle XE download) and yum install bc (needed by the Oracle XE install) as we'll need this later on for the Oracle XE installation. The last thing we need to do before we can start the actual install of Oracle XE is to set the hostname in /etc/hosts. Open this file in vi and add the hostname you entered during the install of CentOS (in our case oraclexe) to the entry for 127.0.0.1. If the hostname isn't correctly set or resolvable the Oracle XE configuration command will fail with an obscure error message. After this we just need to restart the machine for all the changes to take effect. Just run the shutdown -r nowcommand to reboot the machine.

At this point you'll basically have an running and up to date CentOS 6.3 virtual machine that can be used for multiple purposes. So this is a good moment to create a snapshot that you can use to go back to in case of problems or to use as a base to clone new virtual machines from.

Now we're ready to install Oracle XE 11g on this machine, but before we can actually start, we'll first need to download it. Go to the Oracle XE download page, selectAccept License Agreement and click the Oracle Database Express Edition 11g Release 2 for Linux x64 link to download the correct Oracle XE distribution. After it has downloaded you can transfer the ZIP file to the virtual machine via SFTP using the credentials you entered during installation. You can find the correct IP address by running ifconfig -a and looking for the IP address of the eth0 interface.

Go to the location where you transfered the ZIP file, e.g. /opt, and unzip it. After unzipping go to the Disk1 subdirectory and run yum install oracle-xe-11.2.0-1.0.x86_64.rpm

[root@191 Disk1]# yum install oracle-xe-11.2.0-1.0.x86_64.rpm
Failed to set locale, defaulting to C
Loaded plugins: fastestmirror, presto
Loading mirror speeds from cached hostfile
 * base: centos.weepeetelecom.be
 * extras: centos.weepeetelecom.be
 * updates: centos.weepeetelecom.be
Setting up Install Process
Examining oracle-xe-11.2.0-1.0.x86_64.rpm: oracle-xe-11.2.0-1.0.x86_64
Marking oracle-xe-11.2.0-1.0.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-xe.x86_64 0:11.2.0-1.0 will be installed
--> Finished Dependency Resolution
 
Dependencies Resolved
 
============================================================================================================================================================================================================
 Package                                      Arch                                      Version                                       Repository                                                       Size
============================================================================================================================================================================================================
Installing:
 oracle-xe                                    x86_64                                    11.2.0-1.0                                    /oracle-xe-11.2.0-1.0.x86_64                                    564 M
 
Transaction Summary
============================================================================================================================================================================================================
Install       1 Package(s)
 
Total size: 564 M
Installed size: 564 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : oracle-xe-11.2.0-1.0.x86_64                                                                                                                                                              1/1
Executing post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
 
  Verifying  : oracle-xe-11.2.0-1.0.x86_64                                                                                                                                                              1/1
 
Installed:
  oracle-xe.x86_64 0:11.2.0-1.m0                                                                                                                                                                            
 
Complete!
[root@191 Disk1]#

 

After the installation you'll need to configure Oracle XE before you can actually use it. This can be done by running /etc/init.d/oracle-xe configure as root. You'll need to provide an port for the Apex web interface (the default 8080 will do), a port for the database listener (the default 1521 will do) and a password for the SYS/SYSTEM user (we'll use oracle).

[root@191 ~]# /etc/init.d/oracle-xe configure
 
Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.
 
Specify the HTTP port that will be used for Oracle Application Express [8080]:
 
Specify a port that will be used for the database listener [1521]:
 
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:
 
Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:
 
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.

 

When this configuration completes successfully you should be able to tunnel the database listener port, 1521, to your local machine and connect to it using something like Oracle SQL Developer with user SYS or SYSTEM and the password you provided during the configuration step. Additional users can be created using SQL Developer using the information on this oracle tips site.

« back
Comments
Add Comment
[...] As an end result, Padovani left this guitar rock band in early August. Learn the many yoga meditation techniques now and utilize it being a pain relief tool. The outfielders ought to be within a... [...] Read More

17/09/2016 02:05

[...] In case you are investing in a home, be sure to enlist an experienced home inspector. Using this method, you will be aware exactly what should be replaced or resolved. When you get in touch with a... [...] Read More

16/09/2016 05:30

[...] In case you are investing in a home, be sure to enlist an experienced home inspector. Using this method, you will be aware exactly what should be replaced or resolved. When you get in touch with a... [...] Read More

16/09/2016 05:30

[...] In case you are investing in a home, be sure to enlist an experienced home inspector. Using this method, you will be aware exactly what should be replaced or resolved. When you get in touch with a... [...] Read More

16/09/2016 05:30

[...] In case you are investing in a home, be sure to enlist an experienced home inspector. Using this method, you will be aware exactly what should be replaced or resolved. When you get in touch with a... [...] Read More

16/09/2016 05:30

[...] In case you are investing in a home, be sure to enlist an experienced home inspector. Using this method, you will be aware exactly what should be replaced or resolved. When you get in touch with a... [...] Read More

16/09/2016 05:30

[...] get court records payne county ok district tuscaloosa arrest records warrants 3 types of background radiation criminal records list nj free california wisconsin laws free criminal background check... [...] Read More

14/09/2016 05:50

[...] background checks without credit card free financial for employment florida law criminal how can i check my work history credit card criminal background real estate check greece halkidiki sale... [...] Read More

14/09/2016 02:52

[...] background check industry richmond virginia are preemployment background investigations important cook jail inmate search las vegas nevada county criminal background check free run a criminal laws for... [...] Read More

13/09/2016 20:59

[...] washington state attorney general public records request national public records wisconsin free new zealand government salary grades pictures of prisons in texas public arrest records background check... [...] Read More

13/09/2016 20:55

[...] order copy birth certificate scotland reference check mail format court results online dc superior court reporting division what is background reading and foreground public court records illinois real... [...] Read More

13/09/2016 06:02

[...] oklahoma court dockets search washington county pa criminal standard employment virginia court docket dallas county previous employee california landlord jobs charlotte nc background investigation... [...] Read More

13/09/2016 04:02

[...] display memory usage process linux federal penitentiary death row are background checks legal required to buy a gun shows in georgia free advanced background check colorado genealogy gems employee... [...] Read More

13/09/2016 01:39

[...] To calculate this accurately, ensure you include all of your monthly debt including cards, auto loans, other loans or everything else you pay on the monthly basis which was purchased on credit.... [...] Read More

12/09/2016 00:04

[...] The no faxing cash advance loans offer convenience to borrower who may cease within the reach of an fax machine. Further, some figuratively speaking taken out by parents could also be discharged any... [...] Read More

08/09/2016 11:36

[...] Boost the style of your kitchen area by using a normal stone kitchen counter-best. Stone counter-top-shirts are available in a selection of designs and colours, and therefore are likely the most long... [...] Read More

22/08/2016 06:14

[...] Most rooms could be presented new energy by changing the flooring. You may opt to carry out the operate yourself, or most floor coverings firms can put in the flooring surfaces of your liking... [...] Read More

20/08/2016 15:58

[...] IBM followed suit and produced his or her. technology reaches the pinnacle of the appeal with all the. The rule of thumb needs to be to wear something which could boost more confidence. It's nothing... [...] Read More

18/08/2016 06:02

[...] If you might have a taste for ceramic sinks then that's on you. Drugs that belong to your cortisone family will likely put you for a greater chance getting a infection. All electrical and rubber parts... [...] Read More

18/08/2016 04:05

[...] Most internet sites accept. will have the capacity to handle anxiety and. On the Internet, we could also find plenty of interesting home plans and find some ideas following that and know which type of... [...] Read More

17/08/2016 23:25

[...] Sports cars are popular because in their capability to respond or counter the motive force. Many organic recipes for that control of pest and disease come straight from your kitchen cupboard. Often,... [...] Read More

17/08/2016 21:13

[...] It can sound weird but an all-inclusive knowledge on. The United States has been a fore-runner, whether it's movies, fashion or music. You are against no subjective rules throughout race track however... [...] Read More

13/08/2016 22:28

[...] Costo Itami (Diclofenac) Doprovet (Doxycycline) Compresse In Vendita Bifrizide (Hydrochlorothiazide) 12.5 Mg Pillola E Senza Ricotta Pillola E Senza Ricotta Antrolin (Adalat) 20 Mg Farmacia Senza... [...] Read More

06/08/2016 02:01

[...] ÊÇÈöÚ @PhO2uP Potencil (Augmentin) 635 Mg Al Miglior Costo glucovance 400 mg ordinare online fincar (finasteride) spedizione gratuita Farmacia Senza Ricetta Omeprax (Prilosec) 40 Mg Comprare Senza... [...] Read More

05/08/2016 23:10

[...] ÊÇÈöÚ @PhO2uP suhagra (sildenafil) 100 mg comprare online a prezzi bassi Prid (Estrace) Al Miglior Prezzo Curcix 6.25 Mg Vendita Libera In Farmacia Pillola pillola erection packs 3 () 1 confezioni... [...] Read More

05/08/2016 19:29

[...] Antrolin (Adalat) Compresse Prezzo Basso prezzo mycelex-g 100 mg acquisto retin-a 0,025 (tretinoin) 20 grammi Prezzo Dei Farmaci Forthyron 200 ?g Negozio Online Vendita online Primadox 200 Mg Costo... [...] Read More

05/08/2016 18:54

[...] ÊÇÈöÚ @PhO2uP Porodron (Fosamax) 5 Mg Compresse Prezzo Basso ordine dei farmacisti rogaine 5 Lukasm Vendita Libera In Farmacia Economici e senza ricetta Ibusifar (Motrin) 600/400 Mg Al Miglior Costo... [...] Read More

05/08/2016 18:48

[...] ÊÇÈöÚ @PhO2uP Pharmacie De Garde Veclam 500/250 Mg Voltadvance (Diclofenac) 100 Mg Negozio Vendita Online kamagra oral jelly (sildenafil) 100 mg farmacia italiana online Visa Cicladol (Feldene)... [...] Read More

05/08/2016 17:04

[...] ÊÇÈöÚ @PhO2uP Doxyclin (Doxycycline) 200 Mg Pillola In Vendita Curakne (Accutane) 5 Mg Al Miglior Prezzo Alenic (Fosamax) 5 Mg Farmacia Italiana Online Farmacia Italiana Online kamagra soft 100 mg... [...] Read More

05/08/2016 14:58

[...] ÊÇÈöÚ @PhO2uP Azafalk (Imuran) 50 Mg Online Bestellen Online Shop Captobeta Comp Kaufen Rezeptfrei Agopton (Prevacid) 30/15 Mg Kaufen Ohne Rezept Mona Hexal (Lynoral) 50 Mck Verkauf Online Medikamente... [...] Read More

03/08/2016 11:05

[...] brand viagra (sildenafil) generika indien Kaufen Billig Rosaced (Flagyl ER) 500 Mg Pille Qlaira (Estrace) 2/1 Mg Pille Zu Verkaufen rumalaya gel 30 g generika indien Kosten Clotrimazol Al Kaufen... [...] Read More

03/08/2016 09:29

[...] Purinol 100 Mg Kaufen Billig Co Diovane 80 Mg Bester Preis Viromed (Aciclovir) 200 Mg Durchschnittliche Kosten Ohne rx Malafene 400 Mg Kaufen Rezeptfrei Durchschnittliche Kosten isoptin (verapamil)... [...] Read More

03/08/2016 05:10

[...] Uro Cephoral (Cefixime) 100 Mg Pille Preis Pedea (Motrin) 600 Mg Generika Ohne Rezept Pille Rezeptfrei Pille Dexa Ct Zu Einem Niedrigen Preis Billig Eryhexal 500/250 Mg Online Shop effexor xr... [...] Read More

03/08/2016 03:49

[...] ÊÇÈöÚ @PhO2uP kaufen rezeptfrei tinidazole Primofenac Rezeptfrei Pille Simvalip 30/20 Mg Online Bestellen Online Kaufen Pille Exacyl 500 Mg Rabatt Preis Gynokadin Zu Verkauf . kaufen ohne rezept... [...] Read More

02/08/2016 22:52

[...] probalan kosten pro pille Prothyrid Bester Preis lopressor (metoprolol) 25/12.5/50/100 mg rezeptfrei pille Durchschnittliche Kosten Online Bestellen Cliovelle (Estrace) 2/1 Mg Kaufen Tamox (Tamoxifen)... [...] Read More

02/08/2016 22:33

[...] Enatec (Vasotec) 10 Mg Online Kaufen shallaki 60 kaps kaufen rezeptfrei decadron (dexamethasone) generika ohne rezept pille Mastercard singulair (montelukast) 5 mg durchschnittliche kosten Pille zu... [...] Read More

02/08/2016 21:14

[...] ÊÇÈöÚ @PhO2uP rabatt online innopran xl pristiq (desvenlafaxine) online shop Cordichin 120 Mg Durchschnittliche Kosten Los Precios Mas Baratos Billig Mefenabene 250 Mg Baratos Sin Receta Generic... [...] Read More

02/08/2016 01:04

[...] If you liked this report and you would like to obtain much more data with regards to Pixel gun 3d cheats kindly stop by our website. Hymeneals traditions shank backbone from the commencement of fourth... [...] Read More

07/06/2016 20:20

[...] When you are acquiring all set to go out and have pleasurable even though on a nude cruise, you will need to glance at all of the diverse possibilities that are offered. There are many distinctive... [...] Read More

08/09/2015 07:15