Oracle XE is only distributed in 32-bit binary, which causes it not to be installed on 64bit linux distributions 'as is'. For reasons of an internal project I had to see the feasibility of installing and using a database XE on Ubuntu Edgy 64 bit, and after discussion a little hali in # oracle of irc.freenode.org and some Google searches, has been far harder. Although these explanations are described for Ubuntu, to understand the idea of \u200b\u200bwhy everything has to be trivial to reproduce the process-based distributions such as RedHat.
apt-get install libc6-i386
We install 32-bit libraries for the process of linking of Oracle binaries can be made.
Explanation
library libc6-i386
( I realized then that there are some libraries that are libc6-i686 to i686 optimized compilation of libc6, so it would be more optimal use instead of libc6-i386)
We install the 32bit version of the libaio library. This process I have to see if it would be possible with apt (in a previous post pointed out how to install packages on different architectures using RedHat up2date), but for now we'll do it manually as it is only a package and we have well located.
can download it from http://packages.ubuntu.com/edgy/libs/libaio1 , clicking on the Download link i386 paragraph libaio1 and selecting the most appropriate version mirror (read the reason for the existence of these libraries for you to understand and improve the performance of I / O).
We must get off Oracle XE package
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html
and once you accept the license Use, download the package. deb in paragraph Oracle Database 10g Express Edition (Universal) to have multiple language support
dpkg-i - force-architecture
libaio1_0.3.106-0ubuntu1_i386.deb dpkg-i - force-architecture oracle-xe-universal_10.2.0.1-1.0
_i386.deb
- As I suppose you try to install an Oracle who know minimal recommended requirements of environment, I will not get to explain what swap size, minimal memory ... This is well explained in hundreds of sites, San Google you can help:)
We run a script provided by Oracle which among other things scritps create the automatic start / stop Oracle instance and listener. This script must be run as root, without using sudos to first obtain a session so pure root (no need to enable direct root login)
sudo-s
Now that we have a root session, we launched the service configuration script for Oracle XE (listener port of the web aplición management, passwords ...)
- / etc / init .d / oracle-xe configure
- After a while we should give the ok to the appointment process configuration / creation of the database and have multiple processes running oracle (the listener, pmon, smon, rec ...) and should have access to the administration of the new BD through the local web browser to the server, going to the address http://127.0.0.1: (port you've set before) / apex
is imperative to define the environment variables ORACLE_HOME and ORACLE_SID oracle user, so you can work with command line tools (lnsrctl , sqlplus, rm ...) without problems
- su - oracle
export ORACLE_SID = XE export ORACLE_HOME = / usr / lib / oracle / xe / app / oracle / product /= $ ORACLE_HOME / network / admin
10.2.0/server export PATH = $ ORACLE_HOME / bin: $ PATH export TNS_ADMIN
oracle session Come out, come back to enter and now you can work normally with the new instance
nclserver02 oracle @: ~ $ sqlplus / nolog
- SQL * Plus: Release 10.2.0.1.0 - Production on Tue Apr 10 16:37:03 2007
- Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn / as sysdba Connected
SQL> select INSTANCE_NAME, VERSION, DATABASE_STATUS, EDITION from v $ instance;INSTANCE_NAME DATABASE_STATUS EDITION VERSION ---------- ----------------
------- ----------------- ------- ACTIVE
XE XE
- 10.2.0.1.0 SQL> exit Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 10 16:39:59 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
- connected to target database: XE (DBID = 2500655873) using target database control file INSTEAD of recovery catalog RMAN
>
- Sources: channel # oracle irc.freenode.org Google led me to
- http://valery.bgit.net/blog-en/2006/07/09/oracle-database-10g-express-edition-in-linux I recommend reading post-installation actions
0 comments:
Post a Comment