Difference between revisions of "Oracle"

From YobiWiki
Jump to navigation Jump to search
m (Reverted edits by Etegohy (Talk) to last revision by 85.234.199.24)
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
==Oracle9i on Debian Etch==
  
==Oracle9i on Debian Etch==
  +
===Prepare installation===
−  
 
Get files from
 
Get files from
 
http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html
  
http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html
Line 12: Line 12:
 
<br>Mount the DVD with exec rights:
  
<br>Mount the DVD with exec rights:
 
mount /cdrom -o exec
  
mount /cdrom -o exec
−
I followed [http://wiki.nanthrax.net/NanthraxWiki/Wiki.jsp?page=DebianOracleInstall this doc (french)]
 +
I followed [http://wiki.nanthrax.net/NanthraxWiki/Wiki.jsp?page=DebianOracleInstall this doc (french)] but there is also [http://www.the-love-shack.net/oracle-on-sid.html this one]
   
 
mkdir /opt/oracle
  
mkdir /opt/oracle
Line 36: Line 36:
 
export ORACLE_SID=dbname
  
export ORACLE_SID=dbname
 
sysctl kernel.sem
  
sysctl kernel.sem
−
sysctl -w kernel.sem="250 32000 100 128"
 +
sysctl -w kernel.sem="250"
 
sysctl kernel.shmall
  
sysctl kernel.shmall
 
sysctl kernel.shmmax
  
sysctl kernel.shmmax
Line 47: Line 47:
 
ulimit -u 16386
  
ulimit -u 16386
 
ulimit -f
  
ulimit -f
  +
But I didn't export this one so Oracle installed its own (very old) JRE
−
export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
 +
#export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
−  
  +
===Installation===
 
When trying to launch the installer I got the error
 
When trying to launch the installer I got the error
 
Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so:
  
Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so:
Line 56: Line 57:
 
<br>I ran it as the new oracle user, this means the local user had to give access to the X11 (xhost local:) and I had to export in the env of the user oracle the following:
  
<br>I ran it as the new oracle user, this means the local user had to give access to the X11 (xhost local:) and I had to export in the env of the user oracle the following:
 
export DISPLAY=:0.0
  
export DISPLAY=:0.0
  +
  +
* Oracle Database / Enterprise edition / Only software /
  +
  +
When I wanted to launch ~/bin/dbca I got the error
  +
/opt/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
  +
<br> Exporting this variable solved the problem:
  +
export LD_ASSUME_KERNEL=2.4.19
  +
This can be added to the .bash_profile as well as
  +
export DISPLAY=:0.0
  +
  +
Added some more variables:
  +
export ORACLE_HOME=/opt/oracle/OraHome
  +
export ORACLE_BASE=/opt/oracle
  +
export ORACLE_SID=test
  +
export ORACLE_TERM=xterm
  +
export NLS_LANG=AMERICAN;
  +
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
  +
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
  +
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
  +
export LD_LIBRARY_PATH
  +
  +
# Set shell search paths
  +
export PATH=$PATH:$ORACLE_HOME/bin
  +
===DB Creation Assistant===
  +
When trying dbca, the tool died with sth like
  +
dbca: line 124: 26649 Segmentation fault (or Killed)
  +
I solved it by doing what they proposed [http://www.puschitz.com/InstallingOracle9i.shtml here]:
  +
touch /etc/rac_on
  +
===Start DB===
  +
To start the DB I edited /etc/oratab:
  +
test:/opt/oracle/OraHome:Y
  +
And I had to copy the init file of my database "test":
  +
cp /opt/oracle/admin/test/pfile/init.ora.192007235112 /opt/oracle/OraHome/dbs/inittest.ora
  +
Now we can start it with
  +
dbstart
  +
===Start listener===
  +
lsnrctl start
  +
You can control the service is running and listening on port 1521:
  +
netstat -ln |grep 1521
  +
===Start Oracle Enterprise Manager Console===
  +
oemapp console
  +
Launch Standalone
  +
Connect manually to DB at 127.0.0.1:1521 SID:test
  +
user SYS pwd sys service TEST_127.0.0.1 as SYSDBA

Latest revision as of 21:34, 24 November 2010

Oracle9i on Debian Etch

Prepare installation

Get files from http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html 

gunzip ship_9204_linux_disk1.cpio.gz
gunzip ship_9204_linux_disk2.cpio.gz
gunzip ship_9204_linux_disk3.cpio.gz
cpio -idmv < ship_9204_linux_disk1.cpio
cpio -idmv < ship_9204_linux_disk2.cpio
cpio -idmv < ship_9204_linux_disk3.cpio

I burned a DVD with all three DiskN
Mount the DVD with exec rights: 

mount /cdrom -o exec

I followed this doc (french) but there is also this one 

mkdir /opt/oracle
addgroup oracle
adduser --ingroup oracle oracle
chown oracle:oracle /opt/oracle
chmod g+rwx /opt/oracle
mkdir /opt/oracle/OraHome
chown oracle:oracle /opt/oracle/OraHome/
chmod g+rwx /opt/oracle/OraHome/
apt-get install libc6 libc6-dev make binutils gcc libstdc++2.10-glibc2.2 libstdc++2.10-dev xlibs

I had hard time finding libstdc++2.9-glibc2.1, I got it finally from here 

ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/sort /bin/sort
ln -s /usr/bin/basename /bin/basename
ls -l /usr/bin/gcc
ln -sf /usr/bin/gcc-2.95 /usr/bin/gcc
unset LANG
unset LC_ALL
unset LC_CTYPE
export LC_TYPE=en_US
export ORACLE_BASE=/opt/oracle
export ORACLE_SID=dbname
sysctl kernel.sem
sysctl -w kernel.sem="250"
sysctl kernel.shmall
sysctl kernel.shmmax
sysctl -w kernel.shmmax=512000000
sysctl kernel.shmmni
cat /proc/sys/fs/file-max 
ulimit -n
ulimit -n 65536
ulimit -u
ulimit -u 16386
ulimit -f

But I didn't export this one so Oracle installed its own (very old) JRE 

#export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun

Installation

When trying to launch the installer I got the error 

Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so:
   symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

as described here so I took the patch (it's part of this zip) and I ran rhel3_pre_install.sh
Finally I got the installer GUI :-)
I ran it as the new oracle user, this means the local user had to give access to the X11 (xhost local:) and I had to export in the env of the user oracle the following: 

export DISPLAY=:0.0
  • Oracle Database / Enterprise edition / Only software /

When I wanted to launch ~/bin/dbca I got the error /opt/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
Exporting this variable solved the problem: 

export LD_ASSUME_KERNEL=2.4.19

This can be added to the .bash_profile as well as 

export DISPLAY=:0.0

Added some more variables: 

export ORACLE_HOME=/opt/oracle/OraHome
export ORACLE_BASE=/opt/oracle
export ORACLE_SID=test
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH

# Set shell search paths
export PATH=$PATH:$ORACLE_HOME/bin

DB Creation Assistant

When trying dbca, the tool died with sth like 

dbca: line 124: 26649 Segmentation fault  (or Killed)

I solved it by doing what they proposed here: 

touch /etc/rac_on

Start DB

To start the DB I edited /etc/oratab: 

test:/opt/oracle/OraHome:Y

And I had to copy the init file of my database "test": 

cp /opt/oracle/admin/test/pfile/init.ora.192007235112 /opt/oracle/OraHome/dbs/inittest.ora

Now we can start it with 

dbstart

Start listener

lsnrctl start

You can control the service is running and listening on port 1521: 

netstat -ln |grep 1521

Start Oracle Enterprise Manager Console

oemapp console
Launch Standalone
Connect manually to DB at 127.0.0.1:1521 SID:test
user SYS pwd sys service TEST_127.0.0.1 as SYSDBA
Retrieved from "https://wiki.yobi.be/index.php?title=Oracle&oldid=6839"