Install Oracle database in LMDE 64 bit?

Questions about applications and software
Forum rules
Before you post please read this

Install Oracle database in LMDE 64 bit?

Postby dxxvi on Sat Oct 15, 2011 10:09 pm

Hi All,

Does anybody have any experience about that?

Regards.
dxxvi
Level 1
Level 1
 
Posts: 16
Joined: Thu Sep 09, 2010 5:06 pm

Linux Mint is funded by ads and donations.
 

Re: Install Oracle database in LMDE 64 bit?

Postby Elmacus on Sun Oct 16, 2011 3:44 am

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.
LMDE 64 bit. Use my advices on your own risk, it might be wrong on your system.
Laptop LMDE SID, Desktop home LMDE Testing, Desktop work LMDE UP4.
"If you can't apt-get something, it isn't useful or doesn't exist"
User avatar
Elmacus
Level 2
Level 2
 
Posts: 60
Joined: Mon Mar 07, 2011 9:44 am

Re: Install Oracle database in LMDE 64 bit?

Postby oneNF on Tue Oct 18, 2011 2:49 am

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.
Julia - AMD Phenom 4x 2.0Ghz - 4GB
oneNF
Level 1
Level 1
 
Posts: 18
Joined: Thu Jul 14, 2011 4:32 am

Re: Install Oracle database in LMDE 64 bit?

Postby dxxvi on Tue Oct 18, 2011 5:53 pm

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.
dxxvi
Level 1
Level 1
 
Posts: 16
Joined: Thu Sep 09, 2010 5:06 pm

Re: Install Oracle database in LMDE 64 bit?

Postby oneNF on Fri Oct 21, 2011 1:48 pm

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
Last edited by oneNF on Fri Oct 21, 2011 2:12 pm, edited 2 times in total.
Julia - AMD Phenom 4x 2.0Ghz - 4GB
oneNF
Level 1
Level 1
 
Posts: 18
Joined: Thu Jul 14, 2011 4:32 am

Re: Install Oracle database in LMDE 64 bit?

Postby oneNF on Fri Oct 21, 2011 1:53 pm

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.
Julia - AMD Phenom 4x 2.0Ghz - 4GB
oneNF
Level 1
Level 1
 
Posts: 18
Joined: Thu Jul 14, 2011 4:32 am

Re: Install Oracle database in LMDE 64 bit?

Postby zash80 on Sat Dec 17, 2011 5:18 pm

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
zash80
Level 1
Level 1
 
Posts: 1
Joined: Sat Dec 17, 2011 3:09 pm

Re: Install Oracle database in LMDE 64 bit?

Postby dxxvi on Sun Dec 18, 2011 6:57 am

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.
dxxvi
Level 1
Level 1
 
Posts: 16
Joined: Thu Sep 09, 2010 5:06 pm

Re: Install Oracle database in LMDE 64 bit?

Postby oneNF on Fri Jan 20, 2012 6:01 pm

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

It saved my sanity.

C.
Julia - AMD Phenom 4x 2.0Ghz - 4GB
oneNF
Level 1
Level 1
 
Posts: 18
Joined: Thu Jul 14, 2011 4:32 am

Re: Install Oracle database in LMDE 64 bit?

Postby dizwell on Sun Aug 26, 2012 7:44 pm

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.
dizwell
Level 1
Level 1
 
Posts: 5
Joined: Sun Aug 26, 2012 7:34 pm

Linux Mint is funded by ads and donations.
 

Return to Software & Applications

Who is online

Users browsing this forum: Google [Bot] and 6 guests