Install Oracle database in LMDE 64 bit?

[dxxvi]

Hi All,

Does anybody have any experience about that?

Regards.

[Elmacus]

Dont think its common due to Mint is for end consumer, not Enterprise servers.
Linux Mint does not have any serverversion.
And probably Oracle is not that popular in open source community.
I would not run Oracle in LMDE, rather Debian Squeeze.

[oneNF]

I've been looking at installs for Oracle-xe on Linux Debian. A bit tricky given my level of experience,the best info I have found so far come from here:
https://forums.oracle.com/forums/thread ... ID=2222648
https://forums.oracle.com/forums/thread ... ID=2227554
https://confluence.bytesource.net/displ ... +10.04+x64

I have worked through the process and none work completely for me, by a process of deduction (instal - error log - uninstall) I now think it is the oracle-xe configure scrip that is giving me trouble not the installation per se so will be looking at that in my next iteration.

Please post if you have any success.

Cheers
C.

[dxxvi]

http://edin.no-ip.com/blog/hswong3i/ora ... wto-part-2

I followed the quite detailed instructions in the above link but got errors while oracle was installing.

By the way, I couldn't have the X thing (i.e. xclock didn't run) when I "su oracle", but able to run xclock after switching to root with "su". I googled around and found sth like this:
in my account: xauth list $DISPLAY
then copy the result and put it in
xauth add
when in the oracle account, but then I received an error message saying the oracle account couldn't get the lock on some file! At last I had to install openssh server.

I just installed a clean machine with debian wheezy last night. I'll try to install oracle db 11g R2 on it tonight.

[oneNF]

It took a while but I got 11g r2 installed using the instructions pasted below. But i'm having troubles with configuration.

Install
#http://edin.no-ip.com/blog/hswong3i/oracle-database-11g-release-2-apache-2-2-php5-3-debian-squeeze-howto-part-2
#created symbolic link
ln -s /usr/bin/awk /bin/awk

#if not already present create a line
#127.0.0.1 localhost.localdomain localhost
gedit /etc/hosts

#create a file location at
mkdir -p /u01

#optionally create oracle user and dba group
groupadd dba
/usr/sbin/useradd -m -g dba -d /u01/app/oracle -s /bin/bash oracle

#https://forums.oracle.com/forums/thread.jspa?threadID=2222648
# install necessary packages
apt-get install alien bc libaio1

#psuedo chkconfig
touch /sbin/chkconfig
chmod u+x /sbin/chkconfig

# convert the file including scripts
alien -d -k --scripts oracle-xe-11.2.0-0.5.x86_64.rpm

#install
dpkg --install oracle-xe_11.2.0-0.5_amd64.deb

#created folders and linked to listener, this isn't persistent
mkdir /var/lock/subsys
ln -s /u01/app/oracle/diag/tnslsnr/chris-desktop/listener /var/lock/subsys/listener

#made sure that the memory target value in init.ora <= shm below
df -h
#http://www.linkedbits.com/2011/05/26/ora-00845-memory_target-not-supported-on-this-system/
#if not update the init.ora file
sudo gedit /u01/app/oracle/product/11.2.0/xe/config/scripts/init.ora
# and/or set memory_target = 0

#set the shared memory to 1 gb from 760680
#tmpfs 760680 300 760380 1% /var/run/shm
sudo mount -t tmpfs shmfs -o size=1g /dev/shm

#run configure script
/etc/init.d/oracle-xe configure

#other notes
#login to the db using oracle su and sysdba
su - oracle
sqlplus / as sysdba

#remove
/etc/init.d/oracle-xe stop
dpkg --remove oracle-xe
dpkg --purge oracle-xe
userdel
groupdel dba
rm -rf /u01/app
update-rc.d -f oracle-xe remove

[oneNF]

The configuration errors I'm getting are the following, which to my mind means I've still got problems with the shared memory config.

I have tried MEMORY_TARGET = 0 to turn it off, and greater values < SHM with no different result so far.

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
ORA-00845: MEMORY_TARGET not supported on this system

but any other insights would be appreciated.

Cheers
C.

[zash80]

Hi,

I finally found this post in german: http://fseitz.de/blog/index.php?/archiv ... ystem.html

To summarize these steps will make it work:

Code: Select all

cd $ORACLE_HOME/bin
cp oracle oracle.bak
sed 's|/dev/shm|/run/shm|g' oracle.bak >oracle

Michael

[dxxvi]

Last time I tried, Oracle seemed to be installed successfully (although there were some errors/warnings in the middle, but the last screen said that it was successfully installed). There are 2 ways (as far as I remember) to start the Oracle database in the Oracle documentation. None of them worked for me (it might be because of some errors/warnings I had when installing the Oracle db).

I ended up with Oracle 11g R2 Express Edition in Windows XP in VirtualBox It's as easy as installing Oracle 10g Express Edition in Ubuntu 32 bit.

[oneNF]

Refer this post.
http://mikesmithers.wordpress.com/2011/ ... nd-ubuntu/

It saved my sanity.

C.

[dizwell]

Rather late, I guess, but I have a 'pre-installation' script, called Gladstone, which you can run which does everything necessary to let 64-bit LMDE run 64-bit Oracle 11g Release 2. Run it on a shiny new LMDE installation, and all your kernel parameters, user accounts, directory structures and symbolic links are done for you. You just then launch the Oracle installer, click Ignore All when the Oracle installer complains that nearly everything is wrong, and then let it do its stuff regardless.

During the linking phase, there will be "error in invoking target of makefile..." errors. When the first one pops up, just double-click the "fix-lmde-linking-errors.sh" script which Gladstone will have written to your desktop. Once that second script has run, click the 'Retry' button in the Oracle installer and the thing will complete successfully without further incident.

My article describing Gladstone maybe sets it in some context.
If you just want the script, that's available here.

And proof that it's readily do-able without having to resort to using Oracle XE is here.