Oracle Database Express Edition 11g Release 2 For Mac

 

  1. Oracle Database Express Edition 11g Release 2 For Macbook Pro
  2. Oracle Database Express Edition 11g Release 2 For Mac Download
  1. All Oracle Database 11g Release 2 editions (Enterprise, Standard, Standard One, Personal, Client) are supported on the above operating system editions. 64-bit Oracle software is certified on Windows x64 operating systems. 32-bit Oracle software is certified on 32-bit Windows operating systems. 32-bit Oracle Database clients are supported on.
  2. Download Oracle Client (Oracle Express) The first step is to download the Oracle client.
  3. Oracle Database Express Edition (XE) is a community supported edition of the Oracle Database family. Please go to the Oracle Database XE Community Support Forum for help, feedback, and enhancement requests. Note: Oracle Support Services only provides support for Oracle Database Enterprise Edition (EE) and Oracle Database Standard Edition 2 (SE2.

Oracle Database 11g Release 2 (11.2.0.2) Express Edition (XE) To assist in building the images, you can use the buildContainerImage.sh script. See below for instructions and usage.

I am going to demonstrate how to install Oracle 11gR2 Express Edition in Ubuntu 13.04. Take note that Ubuntu is not supported by Oracle but I will still attempt to install the platform. I used the following source as basis for my installation:

http://meandmyubuntulinux.blogspot.com/2012/05/installing-oracle-11g-r2-express.html
http://meandmyubuntulinux.blogspot.com/2011/09/installing-1-gb-swap-without.html

Make sure you download Oracle11g Release 2 Express Edition x64 (The only available cpu architecture for XE edition) and placing it in a directory that you can work on before proceeding further:

Installation prerequisites:

1. Install the needed packages:
shell> sudo apt-get install alien libaio1 unixodbc vim

2. While downloading the packages, you can also unzip the Oracle database file you’ve just downloaded earlier as both will take some time:
shell> unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

3. Next, we need to convert the .rpm file to .deb file with the following command:
shell> sudo alien –scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

While doing this step, you may proceed to the next step at this may take time:

Pre-installation configuration

1. We will create a special chkconfig script in this step.The Red Hat based installer of Oracle XE 11gR2 relies on /sbin/chkconfig, which is not used in Ubuntu. The chkconfig package available for the current version of Ubuntu produces errors and my not be safe to use. Based on the source I followed, below is a simple trick to get around the problem and install Oracle XE successfully:

shell> sudo vim /sbin/chkconfig
(copy and paste the following into the file )
# Oracle 11gR2 XE installer chkconfig hack for Ubuntu
file=/etc/init.d/oracle-xe if [[ ! `tail -n1 $file | grep INIT` ]]; then
echo ‘### BEGIN INIT INFO’ >> $file
echo ‘# Required-Start: $remote_fs $syslog’ >> $file
echo ‘# Required-Stop: $remote_fs $syslog’ >> $file
echo ‘# Default-Stop: 0 1 6’ >> $file
echo ‘# Short-Description: Oracle 11g Express Edition’ >> $file
echo ‘### END INIT INFO’ >> $file fi update-rc.d oracle-xe defaults 80 01
Save the above file and provide appropriate execute privilege :
2. Set the Kernel parameters :
Oracle 11gR2 XE requires to set the following additional kernel parameters:
(Enter the following) :
# Oracle 11g XE kernel parameters
net.ipv4.ip_local_port_range=9000 65000
kernel.shmmax=536870912
Note: kernel.shmmax = max possible value , e.g. size of physical RAM ( in bytes e.g. 512MB RAM 512*1024*1024 536870912 bytes )
Verify the change :
Load new kernel parameters:
Verify: sudo sysctl -q fs.file-max
3. Increase the system swap space : Analyze your current swap space by following command :
**Swapfile Notes: Minimum swap space requirement of Oracle 11gR2 XE is 2 GB . In case, your is lesser , you can increase it by following steps (Mine is originally 1GB only):
a) switch to root and perform the following commands:
shell> su root
shell> dd if=/dev/zero of=/swapfile bs=1024 count=2097152 (Preferably, you should set the count to 1048576. This will add to the current total of 1GB = 2GB. Mine totalled to 3GB)
shell> swapon /swapfile
shell> cp /etc/fstab /etc/fstab.orig (This is for backup of the original fstab)
shell> echo ‘/swapfile swap swap defaults 0 0’>> /etc/fstab (Adds the entry of new swap to fstab upon boot)
Verify with:

Just in case you want to revert to the original config, perform the following:
shell> sudo swapoff -a
shell> sudo rm /swapfile

shell> sudo cp /etc/fstab /etc/fstab.changed; sudo cp /etc/fstab.org /etc/fstab
shell> sudo swapon -a; swapon -s

End of Swapfile Notes**

Oracle Database Express Edition 11g Release 2 For Macbook Pro

We need to make some additional required changes :
shell> mkdir /var/lock/subsys
1. Going back to the directory where we converted the installation package of Oracle XE, we perform the following commands to install the package:
shell> sudo dpkg –install oracle-xe_11.2.0-2_amd64.deb
(Note: If you encounter any ‘shared memory’ error or anything related to memory, look through http://meandmyubuntulinux.blogspot.com/2012/06/trouble-shooting-oracle-11g.html for more information.)
Enter the following configuration information:
  • A valid HTTP port for the Oracle Application Express (the default is 8080)
  • A valid port for the Oracle database listener (the default is 1521)
  • A password for the SYS and SYSTEM administrative user accounts
  • Confirm password for SYS and SYSTEM administrative user accounts
  • Whether you want the database to start automatically when the computer starts (next reboot).

Note: I pretty much used the default configuration here except for the password of course

IMPORTANT: If the previous step or the configuration fails to complete, then you may have encountered the problem in which the link above was created for. The author explained in the link above the reason for the failure. Nevertheless, you will need to reinstall the package again. This happened to me. I followed the troubleshooting guide created by the author and everything went well afterwards.

2. We need to set up the environment variables to ensure the database will run. Add the following env variables to the .bashrc:
shell> vi ~/.bashrc
shell> export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
shell> export ORACLE_SID=XE
shell> export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
shell> export ORACLE_BASE=/u01/app/oracle
shell> export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
shell> export PATH=$ORACLE_HOME/bin:$PATH

3. Load the changes:
shell> . ./.profile (from root or just type cd before this command)
shell> sudo service oracle-xe start (mine is running already)

Configuring User Accounts in Oracle 11gR2 XE

1. Login in the database as follows:

shell> sqlplus / as sysdba
Note: If you get the error ORA-01031: insufficient privileges after the above command, it means you need to add your user in the dba group. Perform the following:
shell> su root
shell> vim /etc/group
Add your user name at the end of dba:x:1001: like
dba:x:1001:<user>

2. Create a user account using the following commands:
sqlplus> create user <username> identified by <password>;
sqlplus> grant connect, resource to <username>;

3. Now try logging in to that user account using the username you’ve just created:
shell> sqlplus
Enter username:
Enter password:

This article explains how to install Oracle 11G release 2 Database on Windows 10. These instructions should also work on Windows 7, Windows 8.

Download 11G Database

Click to Download Oracle 11G database. You need an Oracle account to download any software. Click on Accept License Agreement. Enter the username and password.

Below are the step by stape installation steps.

Installing 11G Database

Mac

Next, unzip both the zip files in the same folders. If you unzip in different folder then copy stage folder from win64_11gR2_database_2of2database to win64_11gR2_database_1of2database folder.

Now click on setup.exe file to start the installation. Oracle quickly does the pre-requisite check and launches the Universal Installer.

Configure Security Updates

Oracle Database Express Edition 11g Release 2 For Mac Download

Provide your email address to receive security issue information. It is optional. Unselect I wish to receive security updates via My Oracle Support.

If you have this information you can enter it.

Installation option

Now select the database installation option.

  • Create and configure database – This option creates and configures a database.
  • Install database software only – This installs only database software. Post-installation you need to manually create and configure database.
  • Upgrade existing database – This upgrades the existing database.

Select the default and click the Next button.

System Class

Select either Desktop Class or Server Class and click Next button.

Database configuration

Installed defaults all basis configuration like Oracle base, Software location, Database file location. Click browse and select a different location to change it.

The installer creates a global database with the name orcl. Enter Administrative password and enter the same password in Confirm Password field and click Next

Summary

This screen shows a summary of the installation. Review it. If it is fine click on the Finish button or click on the Back button to change.

Install Product

The installer starts and copies all necessary files.

Click Allow Access.

Database Configuration Assistant

The installer creates and configures the database.

Below popups shows database information. Click Ok to finish the installation.

Express

Summary

In this guide, we explained how to install Oracle Database 11G Release 2 on Windows.