Tuesday, April 10, 2007

How To Make A Snowboard/skateboard Rail

watch instruction in Ubuntu Edgy amd64 / EM64T (x86-64)

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.

We install 32-bit libraries for the process of linking of Oracle binaries can be made.
apt-get install libc6-i386

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:)
Now we have the binaries properly installed (the installation and we have created the user 'oracle' and group 'dba', owners of the Oracle software we installed). All we need is the final configuration and commissioning.
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
vi $ HOME / .bash_profile
export ORACLE_SID = XE export ORACLE_HOME = / usr / lib / oracle / xe / app / oracle / product /
10.2.0/server export PATH = $ ORACLE_HOME / bin: $ PATH export TNS_ADMIN
= $ ORACLE_HOME / network / 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
nclserver02 oracle @: ~ $ rman target / nocatalog
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