LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-24-2003, 07:45 AM   #1
Evilone
Member
 
Registered: Oct 2002
Location: UK
Distribution: Slack 9.1 (2.6.5)
Posts: 307

Rep: Reputation: 30
Oracle 9i for Linux


Where do i get oracle 9i for linux?? server and client !!!

I looked on the oracle website, not sure what to get !!
 
Old 07-24-2003, 08:37 AM   #2
bentz
Member
 
Registered: Mar 2003
Distribution: Fedora, Mac OSX
Posts: 362

Rep: Reputation: 30
You have to get trial Oracle software from the Oracle Technology Network: http://otn.oracle.com/software/content.html.

Oracle 9i is less than straightforward to install. If you've never done it before, be preparted. I've personally done it and documented the (my) proceedure, so if you run into any problems, I might be able to help.

I should mention that if you plan to use Oracle's products in production, you need to purchase a license. Make sure you fully read and understand the license agreements presented on the OTN site.

I was recently repremanded on this board for using the word 'warez' because I was mistakenly thought by the operators to be encouraging piracy, which I was not. The above message is just my way of making sure all my ducks are in a row... I like this board a lot and don't want to get booted!
 
Old 07-28-2003, 03:41 AM   #3
Evilone
Member
 
Registered: Oct 2002
Location: UK
Distribution: Slack 9.1 (2.6.5)
Posts: 307

Original Poster
Rep: Reputation: 30
Cheers dood, i DO have an oracle license. Site license to be exact.

So no worries on the piracy front.. I'm setting up the oracle server for a university i work for. And allthough i have the windows version running, as usual i thought it may be faster on a unix box. Hence i wanted to test it out before i went live.
 
Old 07-28-2003, 04:00 AM   #4
moeminhtun
Member
 
Registered: Dec 2002
Location: Singapore
Distribution: Fedora Core 6
Posts: 647

Rep: Reputation: 30
Oracle is fastest on Linux. Even faster than on Unix.
That's what they say officially and they recommand Linux for Oracle.

 
Old 07-28-2003, 06:45 AM   #5
dkaplowitz
Member
 
Registered: Oct 2002
Location: Havertown PA
Distribution: Ubuntu/RHEL/Fedora
Posts: 253

Rep: Reputation: 31
Bentz,

Why not post a link to your Ora install documentation? I'd like to see how you did it. I remember seeing a buddy install it back in '99 and it required a kernel re-compile and a number of other fiddly things to be done. I'd be curious to see how the install's changed since then, if at all.

Regards,

Dave
 
Old 07-28-2003, 08:36 AM   #6
mrhyde
Member
 
Registered: Jul 2003
Location: Europe
Posts: 198

Rep: Reputation: 30
moeminhtun, you've obviously never seen oracle run on a serious UNIX kit, I have installed Oracle 9i for prep for OCP course, on a HP Alpha DS10 running tru64, the installation and configuration was far quicker than the time it took me on a Dell power edge with two P4 running RHL 2.1AS. Like most big software companies Oracle are jumping on the "Linux revolution" band wagon. The Dell server cost $2500 and the HP costs $15000, there are a lot more of those Dells going to sell than HP machines, Oracle sales are going to go with the fastest selling system, so they'll tell you black is white if they think you're going to buy!!
 
Old 07-28-2003, 09:02 AM   #7
moeminhtun
Member
 
Registered: Dec 2002
Location: Singapore
Distribution: Fedora Core 6
Posts: 647

Rep: Reputation: 30
Quote:
Originally posted by mrhyde
moeminhtun, you've obviously never seen oracle run on a serious UNIX kit, I have installed Oracle 9i for prep for OCP course, on a HP Alpha DS10 running tru64, the installation and configuration was far quicker than the time it took me on a Dell power edge with two P4 running RHL 2.1AS. Like most big software companies Oracle are jumping on the "Linux revolution" band wagon. The Dell server cost $2500 and the HP costs $15000, there are a lot more of those Dells going to sell than HP machines, Oracle sales are going to go with the fastest selling system, so they'll tell you black is white if they think you're going to buy!!
I don't know. I'm just telling you what they says.
 
Old 07-28-2003, 02:20 PM   #8
bentz
Member
 
Registered: Mar 2003
Distribution: Fedora, Mac OSX
Posts: 362

Rep: Reputation: 30
Oracle 9iR2 for Red Hat Linux 7.3

1. Install Red Hat 7.3. Choose no packages.
2. Add XFree86 support for Oracle Universal Installer:
a. chkfontpath-1.9.5-2.i386.rpm
b. freetype-2.0.9-2.i386.rpm
c. gdk-pixbuf-0.14.0-8.i386.rpm
d. Glide3-20010520-13.i386.rpm
e. gtk+-1.2.10-15.i386.rpm
f. libjpeg-6b-19.i386.rpm
g. libpng-1.0.12-2.i386.rpm
h. libtiff-3.5.7-2.i386.rpm
i. perl-5.6.1-34.99.6.i386.rpm
j. Xaw3d-1.5-12.i386.rpm
k. Xconfigurator-4.10.7-1.i386.rpm
l. XFree86-4.2.0-8.i386.rpm
m. XFree86-base-fonts-4.2.0-8.i386.rpm
n. XFree86-font-utils-4.2.0-8.i386.rpm
o. XFree86-libs-4.2.0-8.i386.rpm
p. XFree86-tools-4.2.0-8.i386.rpm
q. XFree86-xfs-4.2.0-8.i386.rpm
3. Add Development support for Oracle linking:
r. binutils-2.11.93.0.2-11.i386.rpm
s. compat-libstdc++-6.2-2.9.0.16.i386.rpm
t. cpp-2.96-110.i386.rpm
u. gcc-2.96-110.i386.rpm
v. glibc-devel-2.2.5-34.i386.rpm
w. glibc-kernheaders-2.4-7.14.i386.rpm
x. make-3.79.1-8.i386.rpm
y. wget-1.8.1-4.i386.rpm
4. Use Xconfigurator to configure XFree86. Acquire LKMs to support the video adapter, if necessary.
5. Configure the network adapter. Create a new file, /etc/sysconfig/network-scripts/ifcfg-eth0:
DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
IPADDR=w.x.y.z
NETMASK=w.x.y.z
6. Establish a DNS server, Default gateway, and restart network services:
echo ‘nameserver w.x.y.z’ >> /etc/resolv.conf
echo ‘GATEWAY=w.x.y.z’ >> /etc/sysconfig/network
/etc/rc.d/init.d/network restart
7. Edit /etc/rc.d/rc.local, append the following lines, and apply the changes:
echo 100 32000 100 100 > /proc/sys/kernel/sem
echo 2147483648 > /proc/sys/kernel/shmmax
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
/etc/rc.d/rc.local
8. Create an oracle user and associated groups:
groupadd dba
groupadd oinstall
useradd –g oinstall –G dba –d /home/oracle –s /bin/bash oracle
passwd oracle
9. Login as oracle
10. Edit the /home/oracle/.bash_profile, and append the following lines:
DISPLAY=localhost:0.0 ; export DISPLAY
ORACLE_BASE=$HOME ; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/OraHome1 ; export ORACLE_HOME
ORACLE_SID=global_database_name ; export ORACLE_SID
ORACLE_TERM=xterm ; export xterm
NLS_LANG=AMERICAN ; export NLS_LANG
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data ; export ORA_NLS33
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib ; export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin ; export PATH
11. Logout & back in again as oracle on console 1 (ALT+F1)
12. Login as root on console 2 (ALT+F2)
13. Insert the Oracle 9iR2 CD1 and mount it: mount /mnt/cdrom
14. Switch to oracle on console 1 (ALT+F1)
15. Type startx. With the above XFree86 configuration, xterm should start automatically, putting you in a GUI terminal. You are now on console 7 (ALT+F7).
16. In the xterm, type /mnt/cdrom/runInstaller
17. The Oracle Universal Installer starts. Select Next on the Welcome screen.
18. A base directory of /home/oracle is appropriate. Next. The group for OUI should be oinstall. Next.
19. You will be prompted to run a script as root. Switch to Console 2 (CTRL+ALT+F2) and type /tmp/orainstRoot.sh. Once it is complete, which back to Console 7 (ALT+F7), and click Continue.
20. A default Oracle Instance home of /home/oracle/OraHome1 is appropriate. Next.
21. Select the Oracle 9i Database product. Next.
22. Choose Standard Edition. Next.
23. Choose General Purpose. Next.
24. Enter a Global Database name. It must be less than 8 characters, and must start with an alpha.
25. Accept defaults on the Database File location, Database Character Set, and Summary windows.
26. The installation will begin. Eventually you will be prompted for Disc 2. Switch to Console 2 (CTRL+ALT+F2) and type eject or umount /mnt/cdrom. Insert Disc 2 and type mount /mnt/cdrom. Switch back to Console 7 (ALT+F7) and choose OK. Repeat this procedure for Disc3.
27. OUI will begin to compile the binaries. At 79%, it will error out with "Error in invoking target install of makefile /opt/oracle/product/9.2.0/ctx/lib/ins_ctx.mk". Switch to Console 2 (CTRL+ALT+F2) and edit the /home/oracle/OraHome1/ctx/lib/env_ctx.mk file and make the following modification:
INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)
28. Switch back to Console 7 (ALT+F7) and hit Retry.
29. The binaries should complete the compile. You will be prompted to run another script. Switch to Console 2 (CTRL+ALT+F2) and type /home/oracle/OraHome1/root.sh. Return to Console 7 (ALT+F7) and acknowledge that the script has been executed.
30. The component tests will run automatically, and the database will be built.
31. A dialog will be presented for the SYS and SYSTEM passwords for the Oracle database.
32. End of Installation. Exit.
33. Copy the oracle init file for your SID:
cp $ORACLE_HOME/admin/$ORACLE_SID/pfile/init$ORACLE_SID.ora.* \ $ORACLE_HOME/dbs/init$ORACLE_SID.ora
34. Type exit to quit xterm, and get out of XFree86. Logout oracle from Console 1.
35. Switch to Console 2 (ALT+F2) where you are logged in as root.
36. Download Guru Lab’s SysV init scripts for Oracle, and uncompress them:
wget http://www.gurulabs.com/files/oraclerun9i-1.4.tar.gz
tar zxvf oraclerun9i-1.4.tar.gz
37. Install the SysV files on the system:
cp oraclerun9i-1.4/etc/init.d/oracle /etc/rc.d/init.d/
cp oraclerun9i-1.4/etc/sysconfig/oracle /etc/sysconfig/
38. Append some environment variables to the SysV configuration:
echo ‘HOME=/home/oracle’ >> /etc/sysconfig/oracle
cat /home/oracle/.bash_profile | grep ‘ORACLE\|NLS’>> \ /etc/sysconfig/oracle
39. Enable SysV Oracle services by editing /etc/sysconfig/oracle
Set START_ORACLE=”yes”
Set START_LISTENER=”yes”
Set START_AGENT=”yes”
Set START_ORA_APACHE=”yes”
40. Enable the SysV script:
chkconfig --add oracle
chkconfig --level 2345 oracle on
41. Edit /etc/oratab, modifying the line that reads
global_database_name:/home/oracle/Orahome1:Y
42. Reboot the system to initialize the new SysV configuration.
 
Old 07-28-2003, 02:26 PM   #9
bentz
Member
 
Registered: Mar 2003
Distribution: Fedora, Mac OSX
Posts: 362

Rep: Reputation: 30
This document was written for someone wholly unfamilar with Linux in mind, so it's very quick and dirty.

I should mention that I'd no Oracle DBA or anything, and these defaults I've accepted are due to ignorance. Take this information with a grain of salt, there could be better ways to do it. All I know is that it works-
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between Oracle Server and Oracle Database ganninu Programming 3 02-27-2007 01:06 AM
xhost + as user oracle not working, need to see oracle install GUI enzo250gto Linux - Software 2 02-11-2007 11:27 AM
Oracle in Linux saint_devil Programming 11 02-08-2005 10:25 PM
Oracle 9i client with Oracle 8i server ganninu Programming 1 02-19-2004 04:35 PM
Oracle on Linux santosow Linux - Newbie 1 08-20-2003 01:45 AM


All times are GMT -5. The time now is 06:43 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration