TechiWarehouse.Com


Top 3 Products & Services

1.
2.
3.

Dated: Jul. 08, 2013

Related Categories

Oracle Database

Oracle is one of the most popular commercial databases, and it is characterized by high reliability and speed. Oracle has released a free version of their server titled Oracle Database Express Edition. The current version is called 11, which has limitations in the form of maximum memory size of 1GB and one processor, but it is completely free and can be used for smaller projects, web applications, and more. It can very well be used in the development of applications which are based on Oracle DB system. Oracle Database Express Edition is released under the OTN license, which you can read in detail http://goo.gl/RcpXy. The latest installation of Oracle XE for Linux servers is downloaded directly from Oracle's website after the mandatory registration at http://goo.gl/x7Pdd. The installation is available in RPM format (Red Hat Package Manager) which means that Linux distributions that are based on the RPM package management system will not have any problems. These include: Red Hat, Fedora, CentOS, Oracle Linux, Suse, Mandriva ... For other distributions, which are based on the RPM system, such as, for example, Linux Mint, Ubuntu or Debian there will be a little more work to prepare for installation. It should be noted that the Oracle XE server is designed for 64-bit platforms (x86-64), and the architecture of your Linux, can easily be checked with the command: uname-m For RPM distributions, Oracle XE is easy to install by calling the rpm command as superuser (root):Oracle XE server 11.2.0

sudo rpm-ivh oracle-xe-11.2.0-1.0.x86_64.rpm

After the installation is finished, there is still to configure the Oracle XE server by calling the following script: / etc / init.d / configure oracle_xe During configuration you will be asked for the port number, and also whether the server always runs when booting, and we encourage you to accept all the proposed values. The system will be further configured using a web browser by opening the following locations: localhost: 8080 / apex where the default port is 8080 and can be changed when configuring the server. On this page you create the workspace and user-defined system. After that you can log into the database and start working in it. The installation of RPM packages for distributions that do not support RPM systems requires a little more work in the preparation. We give an example of Linux Mint, which is currently considered to be one of the most popular Linux distributions. First we need to install the alien package that is used to convert RPM to DEB package. We will use apt-get:

sudo apt-get install alien libaio1

It is assumed that we already downloaded the latest installation of Oracle Database Express Edition to Oracle's website. The RPM installation is zipped, so we must first unpack it using the unzip command: unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip After that we perform the conversion of the .rpm packages. Deb package:

sudo alien - scripts oracle-xe-11.2.0-1.0.x86_64.rpm

The next step is the creation of the script file named chkconfig folder in / sbin is most easily done by using nano editor:

sudo nano / sbin / chkconfig

After that, you can copy the script that we have prepared for you at http://pastebin.com/WR2qCyit and set up privileges on the files value 755:

sudo chmod 755 chkconfig

Because of the difference in the destination folders awk package Red Hat and Debian distributions, you have to create the following link:

sudo ln-s / usr / bin / awk / bin / awk

You still need to check if the shared memory is installed where Oracle expects. . Execute the command: df-k If you get a result like this: Filesystem 1K-blocks Used Available Use% Mounted on none 3571460 624088 2947372 18% /dev/shm ... everything is fine. Otherwise, you must manually add the file:

sudo nano / etc / init.d / oracle-shm

then insert the script ready from the address http://pastebin.com/g5JmFJug save the file and change his privileges with the command chmod 755 / etc / init.d / oracle-shm The following commands enable the new script to be executed at system startup: update-rc.d oracle-shm defaults 01 99 If we perform the system reboot, we get fitted with shared memory. Finally, if all preparations have been performed, we run the installation with the command

sudo dpkg - install ./oracle-xe_11.2.0-2_amd64.deb

When the installation is finished launch, as the root user, the configuration script: / etc / init.d / oracle-xe configure and then you continue the steps identical to those set forth at the beginning of the text to describe the installation of the XE in The RPM versions.

M.B.

Now that you've gotten free know-how on this topic, try to grow your skills even faster with online video training. Then finally, put these skills to the test and make a name for yourself by offering these skills to others by becoming a freelancer. There are literally 2000+ new projects that are posted every single freakin' day, no lie!


Previous Article

Next Article




Facebook