Installing Oracle 1. R2 Express Edition on Ubuntu 6. Recently I installed Oracle 1. R2 Express Edition on my ubuntu 1. Precise Pangolin). But for this, I have to google a lot and had to install two times to get a fully working environment. So, I thought it would be better if I share my experience with my fellow ubuntu'ers so that they don't have to face the troubles that I encountered. I have came up with following series of steps ( mostly derived from the link source I given at the end of this post ) for easy and hassle- free installation. But at first, I must inform you about the limitations of Oracle 1. R2 Express Edition (XE) which are as follows : The Installer released by Oracle is only meant for 6. If you wish to install the 3. 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 1. Security. Oracle Database 11g delivers a rich new security functionality—from case-sensitive passwords, to Transparent Tablespace Encryption, to Access Control. Cómo descargar e instalar el motor de bases de datos Oracle Database 11g Release 2 Enterprise 64bits en un equipo con sistema operativo Microsoft Windows Server 2003. Instead, you must create individual database conne ctions manually, as explained in this section. You can create database connections to the local Express Edition. I've just installed an Oracle 11g Standard Edition Database. It ran successfully and everything, however when going to Oracle Enterprise Manager Im not really sure. A while ago I tried to install Oracle 11g R2 Express Edition on a 64-bit Ubuntu machine. This proved to be not as easy as you would expect. There are many blogs and. GB. The maximum amount of RAM that Oracle XE uses cannot exceed 1 GB, even if more is available. Now the steps for Installation : 1). Download the Oracle 1. ![]()
This link: Creating the Sample Database in Oracle 11g Release 2 is a good example of creating a sample database. This link: Newbie Guide to Oracle 11g Database Common. Oracle® Database Express Edition. Getting Started Guide. 11 g Release 2 (11.2) E18585-05. May 2014. Welcome to Oracle Database Express Edition (Oracle Database XE). Recently I installed Oracle 11g R2 Express Edition on my ubuntu 12.04 ( Precise Pangolin). But for this, I have to google a lot and had to install two. R2 express edition installer from the link given below: (. You will need to create a free oracle web account if you don't. Unzip it : unzip. Install the following packages : sudo. Convert the red- hat ( rpm ) package to Ubuntu- package : sudo. Note. this may take a while , till that time you can go for step 5 )5). Do the following pre- requisite things: a). Create a specialchkconfigscript. Red Hat based installer of Oracle XE 1. R2 relies on /sbin/chkconfig. Ubuntu. The chkconfig. Ubuntu produces errors. Below is a simple trick to get around the. Oracle XE successfully: sudo. Oracle 1. 1g. R2 XE installer chkconfig hack for Ubuntufile=/etc/init. INIT` ]]; thenecho. BEGIN INIT INFO' > > $fileecho. Provides: Oracle. XE' > > $fileecho. Required- Start: $remote_fs $syslog' > > $fileecho. Required- Stop: $remote_fs $syslog' > > $fileecho. Default- Start: 2 3 4 5' > > $fileecho. Default- Stop: 0 1 6' > > $fileecho. Short- Description: Oracle 1. Express Edition' > >. END INIT INFO' > > $filefiupdate- rc. Save the above file and provide. Set the Kernel parameters : Oracle. R2 XE requires to set the following additional kernel parameters: sudo. Enter. the following) #. Oracle 1. 1g XE kernel parameters fs. Save. the file) Note: kernel. RAM ( in bytes e. MB RAM == 5. 12*1. Verify. the change : sudo. Load. parameters: sudo. Verify. sysctl - q fs. Increase the system swap space : Analyze. Oracle 1. 1g. R2 XE is 2 GB . In case, your is. Oracle 1. 1g. R2 XE. Go to the directory where. Step 4 and enter following. Update : Before you proceed to next step , do have a look at this trouble- shooting post in order to avoid MEMORY TARGET or any other "shared memory" error. Enter. the following configuration information: A. HTTP port for the Oracle Application Express (the default is. Oracle database listener (the default is 1. 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. Before you start using Oracle 1. R2 XE you have to set- up more things. Set- up the environmental variables : Add. ORACLE_HOME=/u. 01/app/oracle/product/1. ORACLE_SID=XEexport. NLS_LANG=`$ORACLE_HOME/bin/nls_lang. ORACLE_BASE=/u. 01/app/oracleexport. LD_LIBRARY_PATH=$ORACLE_HOME/lib: $LD_LIBRARY_PATHexport. PATH=$ORACLE_HOME/bin: $PATHb). Start the Oracle 1. R2 XE : sudo. service oracle- xe start. The. output should be similar to following : user@machine: ~$. Starting. Oracle Net Listener. Starting. Oracle Database 1. Express Edition instance. Step 6. should come to following : SQL*Plus. Release 1. 1. 2. 0. Production on Wed May 9 1. Copyright. (c) 1. Oracle. All rights reserved. Enter. password: Connected. Database 1. 1g Express Edition Release 1. Production SQL>. Enter following on the sql prompt : Replace username and. SQL>. create user username identified by password; User. SQL>. grant connect,resource to username; Grant. Now as you have created the user , you can login to it : user@machine: ~$. SQL*Plus. Release 1. Production on Wed May 9 1. Copyright. (c) 1. Oracle. All rights reserved. Enter. user- name: temp Enter. Connected. Database 1. Express Edition Release 1. Production SQL>. SQL> Reference Links : -.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
October 2016
Categories |