Главная » Linux

Oracle 11g express linux

На чтение 7 мин Просмотров 1 Опубликовано
Содержание
  1. How to and tutorials
  2. Sencha Touch, ExtJs, Zend, Linux, Security, Oracle, MySQL and much more.
  3. Menu
  4. Widgets
  5. Search
  6. Categories
  7. Recent Posts
  8. Recent Comments
  9. Archives
  10. Meta
  11. How to install Oracle Database 11g Express Edition on Linux Ubuntu-Server
  12. How to Quick-Start With Oracle 11g Express Database for Linux Easy Guide
  13. Follow Us
  14. The GNU/Linux Free Software Phylosophy
  15. Steve Jobs' Last Words
  16. Credits

How to and tutorials

Sencha Touch, ExtJs, Zend, Linux, Security, Oracle, MySQL and much more.

Widgets

Categories

Recent Posts

Recent Comments

Archives

Meta

How to install Oracle Database 11g Express Edition on Linux Ubuntu-Server

Oracle is a RDBMS (relational database management system), which is produced and marketed by Oracle Corporation. The Oracle Database Systems is one of the most popular database systems, competing with likes of MySQL, PostgreSQL, IBM DB2,Sybase, Microsoft SQL Server among others. Oracle is a great choice for applications that require large, distributed databases.

Oracle Database Express Edition 11gR2 is free for download and is available for variety of platforms including various distros of Linux and Microsoft Windows without needing a license. in this this guide will help you how to install Oracle Database Express Edition 11gR2 on Ubuntu Server.

But at first, I must inform you about the limitations of Oracle 11g R2 Express Edition (XE) which are as follows :

The Installer released by Oracle is only meant for 64-bit (x86_64) systems.
It will consume, at most, processing resources equivalent to one CPU.
Only one installation of Oracle Database XE can be performed on a single computer.
The maximum amount of user data in an Oracle Database XE database cannot exceed 11 GB.
The maximum amount of RAM that Oracle XE uses cannot exceed 1 GB, even if more is available.

Step-by-Step Installing Oracle Database Express Edition 11gR2 on Ubuntu Server.

Читайте также:  Обновить linux apt get

Managing Swap partition. Oracle Database Express Edition 11gR2 may require up to a 2GB (2095100 KB) swap partition, Enter the following command in terminal to verify your swap space:

cat /proc/meminfo | grep -i swap

If you don’t have enough swap space, you can increase available swap space by the following guide to create and enable swap partiton, in this case I’ll create 1 GB swap file and loaded at startup, located in the /home directory

Create swap file on /home directory with following commands:

dd if=/dev/zero of=/home/swapfile bs=1024 count=1048576 mkswap /home/swapfile swapon /home/swapfile swapon -a

Create a backup of the original “fstab” file and add the new swap file:

cp /etc/fstab /etc/fstab.backup_`date +%N` echo '/home/swapfile swap swap defaults 0 0' >> /etc/fstab

Logout from root and verify the new swap space:

Step 1. Install additional software thats require Oracle 11g Express Edition

sudo apt-get install alien libaio1

Download Oracle Database Express Edition 11gR2 via Oracle Official website, it require registration before downloading.

unzip the downloaded file, then convert the Oracle Database Express Edition 11gR2 package installer to debian package

unzip oracle-xe-11.2.0.1.0.x86_64.rpm.zip cd Disk1/ sudo alien --to-deb --scripts oracle-xe-11.2.0-1.0.x86_64.rpm

Configure Awk and Chkconfig, The following needs to be set for compatibility:

sudo ln -s /usr/bin/awk /bin/awk sudo mkdir /var/lock/subsys

Ubuntu uses different tools to manage services and system startup scripts. The “chkconfig” tool required by the Oracle installer is not available in Ubuntu. The following will create a file to simulate the “chkconfig” tool.

Copy and paste the following Script directly into the terminal to create a file chkconfig:

cat > /sbin/chkconfig > /etc/init.d/oracle-xe

Set the file /sbin/chkconfig executable :

sudo chmod 755 /sbin/chkconfig

Step 5. Install Oracle Database Express Edition 11gR2 with the following commands:

cd ~/Downloads/Disk1 sudo dpkg -i oracle-xe-11.2.0-1.0.x86_64.deb

Run the following configuration script to create (clone) the database. Accept the default answers, including “y” to startup the database automatically, or modify as required.

sudo /etc/init.d/oracle-xe configure

To verify success, the procedure should end showing:

Starting Oracle Net Listener…Done
Configuring database…Done
Starting Oracle Database 11g Express Edition instance…Done
Installation completed successfully.

Set a password for the Oracle account:

Post-Installation, In order to use sqlplus and other tools, the Oracle account requires specific environment variables. The following will set these variables automatically at every Oracle login:

Copy the default account skeleton files and add the Oracle env script to .profile:

cp /etc/skel/.bash_logout ./ cp /etc/skel/.bashrc ./ cp /etc/skel/.profile ./ echo "" >>./.profile echo '. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh' >>./.profile

Configure remote login. By default, the Oracle Database XE graphical user interface is only available at the local server, but not remotely. The following will enable remote logins:

Login as the Oracle user, then login as SYSDBA and run the following commands:

su - oracle sqlplus / as sysdba SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); exit

Источник

How to Quick-Start With Oracle 11g Express Database for Linux Easy Guide

You are Welcome! The Tutorial shows you Step-by-Step How to Install and Getting-Started with Oracle 11g R2 Express Edition Database on Linux Desktops/Servers.

Oracle Database Express Edition is a free, smaller-footprint edition of Oracle Database. Oracle Database XE is easy to install and easy to manage.

With Oracle Database XE and related tools you can:

  • Administer the database
  • Create tables, views, and other database objects
  • Import, export, and view table data
  • Run queries and SQL scripts

How to Install JDeveloper 12c Ubuntu 18.04 Bionic LTS

sudo /u01/app/oracle/product/11.2.0/xe/bin/sqlplus
CONNECT SYSTEM/[yourSYSTEMadminPASS]

Showing Ads here is the best solution I found for not embarassing somebody about participating in a #%$Foundation^.

"When the Last Tree has been cut down, the Last Fish caught, the Last River poisoned, only then will we realize that One Cannot Eat Money."

"No usable Computer exists today with completely Open Software and Hardware (as much as some companies want to Market themselves as such)."

Follow Us

The GNU/Linux Free Software Phylosophy

GNU/Linux Logo

Steve Jobs' Last Words

Steve Jobs Last Words in the Darkness

"Being a Winner in a Free Computing OS Mission means to adopt a Commercial like Strategy. Transcending Duality in Oneness and so dispensing both Free and Non Free Software. Cause evangelizing Freedom in a Non Free World is like keeping a Trojan Horse. Hallelujah!"

"Using the Money just for buying Stuff and Not Supporting the Free Gift Philosophy is a sign of a Selfish and Narrow Mind."

What can Save the World from a Blind and Quick Self-destruction.
The Immediate and Humble Mass Conversion to the Spiritual Way!
Because Earth & Nature has been Ravaged without Pity by the Wild and Selfish mass Competition to Win and Shown that U're someone Better because you got a Lot of fla$hY Power$$$.

"Taking care if somebody is liking, following, or buying is just a serious hidrance on the priceless Way of Creative Freedom."

Credits

Ganesha

Everlasting Glory to God, Jesus Christ, The Holy Spirit, Ganesha, Shiva, Vishnu, Krisna, Laozi, Buddha, Bodhidharma, Ma Gcig, Hakuin, Ikkyu, Nagarjuna, Tilopa, Naropa, Milarepa, Suhrawardi, St Dismas, St Francesco, St Teresa, St John, St Filippo, Eckehart. All The Holy Divinities, Avatars, Saints, Mystics, and True Spiritual Masters. Because they are in the Eternal Light of Truth & Delight Enlightening a World of Darkness, Nescience, Blindness, Uneasiness and Falsehood!

Источник

Оцените статью
© 2023 Posetke
Adblock
detector