Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Oracle 8.1.7 on Gentoo: another How To
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Documentation, Tips & Tricks
View previous topic :: View next topic  
Author Message
ldegiorgi
n00b
n00b


Joined: 18 Nov 2002
Posts: 21
Location: Milan (Italy)

PostPosted: Fri May 28, 2004 2:11 pm    Post subject: Oracle 8.1.7 on Gentoo: another How To Reply with quote

Following the text of the how-to to install Oracle 8.1.7 on a Gentoo Linux Box. Hope this help.

Regards

Luca

P.S.

You can find the original link at:

http://nemesisit.rdsnet.ro/zen/oracle8/
----------------------------------------------------------------------------------

Installing Oracle 8i Database on Gentoo


Rodica Balasa


rodica.balasa@nemesisit.ro


I wrote this installation guide after succesfully installing Oracle8 on Gentoo to describe the steps I used in hope that other people will experience a smooth migration of Oracle8 server on Gentoo distribution. For further details please contact me at rodica.balasa@nemesisit.ro


Requirements:


Database Version: Oracle 8i R3 (8.1.7), available here:


http://otn.oracle.com/software/htdocs/devlic.html?http://otn.oracle.com/software/products/oracle8i/htdocs/linuxsoft.html


Java 1.1.8 is available at one of the www.blackdown.org mirrors or from here:


http://mirrors.sunsite.dk/java-linux/JDK-1.1.8/i386/v3/jre118_v3-glibc-2.1.3.tar.bz2






Unpack the install kit.






The first step is to unpack the install kit:


# tar xvf linux81701.tar


Create users and groups:


The oracle database requires the oracle user and also two groups for database install and administration. The standard group names used are oinstall and dba. Oracle user must be member of oinstall and dba group, with main group dba. Also oracle user password must be set.


For that, become root and execute the following commands:


$ su


# groupadd oinstall
# groupadd dba
# adduser -g oinstall -G dba,wheel,audio,video,cdrom,cdrw -s /bin/bash -d /home/oracle -m oracle
# passwd oracle


Preinstallation (system configuration):


Some preinstallation configuration is required for successful oracle installation.


The new gcc installed on your system is not compatible with the older gcc version required by Oracle. The fix is to install the gcc compatibility libraries.


Install the compatibility libraries:
# emerge lib-compat
# emerge gcc-compat


The oracle graphical install utility requires Java 1.1.8.


Install java 1.1.8:


#cp jre118_v3-glibc-2.1.3.tar.bz2 /opt


#cd /opt


#tar xvfj jre118_v3-glibc-2.1.3.tar.bz2


The next step is to set the environment variables required by the oracle installation. In this example the locale settings are for Romanian language. One important setting is ORACLE_SID which is the name of the oracle server.


Login as oracle user:


#su oracle


Put the following lines in ~/.bashrc (the script is executed each time the oracle user logs in):


umask 022


unset LANG


export ORACLE_BASE=/home/oracle


export ORACLE_HOME=$ORACLE_BASE/product/8.1.7


export ORACLE_TERM=vt100


export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data


export ORACLE_SID=orcl


export PATH=$PATH:$ORACLE_HOME/bin


export NLS_LANG='ROMANIAN_ROMANIA.EE8ISO8859P2'


You can change NLS_LANG according to the computer local settings. Do not set LD_ASSUME_KERNEL=2.2.5, it is not required and it will only generate lots of errors (probably you do not have 2.2.5 kernel).


Installation


The first step is to give the oracle user the right to use X, using xhost + command. Then DISPLAY variable must be set for the oracle user to be able to connect the X server.


Login as root and allow user oracle to write to X display:


$ su
# xhost +


Login to oracle user:


#su oracle


Export display for oracle user:


$export DISPLAY=?localhost:0.0?


Now is a good time to start the installation:


$Disk1/install/linux/runInstaller


You will be asked about the group for installation and upgrade, enter oinstall. Also you will be asked about oracle sid and name, enter orcl to both.


During install you will be asked about java 1.1.8 installation directory (/opt/jre118_v3)


Choose not to register to oracle or other directories.


At the end, Oracle installation will probably inform you that creating a database failed. Ignore on this one, we will fix it later.


Postinstall


After install (but before creating the database) some patches must be applied: stub patch and libnldapj8.so. The stub patch is a set of stub libraries which are used at link-time only to mimic the contents of old glibc-2.1.3 shared objects. The libnldapj8.so is a patch for the bug 1542738 of Oracle Directory Manager.


Apply the stub patch:


# su oracle


$ cp glibc-2.1.3-stubs.tar.gz $ORACLE_HOME


$cd $ORACLE_HOME


$tar xvfz glibc-2.1.3-stubs.tar.gz


$ ./setup_stubs.sh


Apply libnldapj8.so patch:


$ cp Disk1/patch/bug1542738/libnldapj8.so $ORACLE_HOME/lib


$ cp Disk1/patch/bug1542738/oidadmin $ORACLE_HOME/bin


Create the database


Once the patches have been applied, we can proceed to database creation, using the dbassist utility.


# su oracle


$ cd $ORACLE_HOME/bin


$ ./dbassist


Start the database


After initial database creation we can start the database engine. For that we must login as oracle user, only as oracle user you can start and stop the database and perform other database operations.


# su oracle


$ cd $ORACLE_HOME/bin


Next we start the server, using svrmgrl to open the server console. From the console we can connect to the server using connect internal command. After we connect we start the database database with startup command.


$ ./svrmgrl


> connect internal


>startup


>quit


After the server is started also the listener must be started. The listener answers to connect requests on 1521 port (oracle default port), it must be started in order to bee able to connect to the database. The listener starts using lsnrctl command.


$ ./lsnrctl start


Next we can test the database (as oracle user). The initial database contains demo tables for user scott with password tiger. The database client utility is sqlplus. Gqlplus is an improved command line client, with completion and command history, more details at: http://gqlplus.sourceforge.net


Test the database


$./sqlplus


When asked password enter:


scott/tiger@orcl


For a graphical client try the worksheet application:


$./oemapp worksheet


For administration you can start the enterprise manager. The enterprise manager is started using oemapp utility with parameter dbastudio. For maximum privileges connect with user sys, password change_on_install as dba.


$./oemapp dbastudio
Back to top
View user's profile Send private message
anoland
Tux's lil' helper
Tux's lil' helper


Joined: 27 May 2003
Posts: 86

PostPosted: Tue Aug 03, 2004 1:23 am    Post subject: Reply with quote

Is there a way to install Oracle without using X? Also will these instructions work for >= 9.2??

Thanks.
Back to top
View user's profile Send private message
ldegiorgi
n00b
n00b


Joined: 18 Nov 2002
Posts: 21
Location: Milan (Italy)

PostPosted: Tue Aug 03, 2004 5:05 am    Post subject: It's better......... Reply with quote

I thinks it's better to use Oracle 10. I've installed it without a glitch.
No libraries problems, no binaries problem, no strange things.
It works as it should be.

Give it a try!

Reg.
Back to top
View user's profile Send private message
heidar
Tux's lil' helper
Tux's lil' helper


Joined: 30 Aug 2003
Posts: 135

PostPosted: Mon Aug 09, 2004 1:28 am    Post subject: Reply with quote

All I get is that I need to be running Red Hat...I used the ship.crs.cpio.gz package, it's the oracle 10g server only...I'm gonna try it again soon but any idea what went wrong, or more like, what I didn't do?
Back to top
View user's profile Send private message
Joe Kinley
n00b
n00b


Joined: 31 May 2003
Posts: 74
Location: Germany

PostPosted: Fri Sep 10, 2004 6:39 am    Post subject: Reply with quote

I need help with it too.... it keeps saying i got no RedHat oder UnitedLinux. How did you manage this issue ??
_________________
No matter what, always follow your heart
Back to top
View user's profile Send private message
kozmic
n00b
n00b


Joined: 29 Oct 2002
Posts: 33

PostPosted: Fri Sep 10, 2004 2:03 pm    Post subject: Reply with quote

Run it like this:

Quote:


./runInstaller -ignoreSysPrereqs

Back to top
View user's profile Send private message
Joe Kinley
n00b
n00b


Joined: 31 May 2003
Posts: 74
Location: Germany

PostPosted: Thu Sep 16, 2004 12:58 pm    Post subject: Reply with quote

Thanx.... but now i got, right after this, a new problem:

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/sysman/oii/oiic/OiicInstaller

What should I do now ??
_________________
No matter what, always follow your heart
Back to top
View user's profile Send private message
netcetera
n00b
n00b


Joined: 10 Feb 2003
Posts: 30
Location: ummm, ya , let me get back to you on that...

PostPosted: Tue Sep 28, 2004 1:53 am    Post subject: SOLVED Reply with quote

Thanx for the howto to install Oracle 8.1.7, but I followed the steps exactly - really exactly - and can't get the install started.

This message is generated when I try to run

$Disk1/install/linux/runInstaller

Quote:
Disk1/install/linux/runInstaller The Java RunTime Environment was not found at bin/jre. Hence, the Oracle Universal Installer cannot be run.
Please visit http://www.javasoft.com and install JRE version 1.1.8 or higher and try again. : No such file or directory


Any thoughts ?

SOLVED: from here http://www3.sympatico.ca/arothmel/oracle/817.html#1

was a link issue for jre
Code:
# ln -s /usr/local/jre118_v3 /usr/local/java


I use jre - and got into the installer - now the fun begins.



Tx,

Dave
_________________
If you always do what you've always done - you'll always get what you always got...
Back to top
View user's profile Send private message
Joe Kinley
n00b
n00b


Joined: 31 May 2003
Posts: 74
Location: Germany

PostPosted: Tue Oct 05, 2004 9:40 am    Post subject: Reply with quote

It still does not work for me, i got the following reply:

Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.
bla....
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:593)

What shall I do there ?
_________________
No matter what, always follow your heart
Back to top
View user's profile Send private message
madmax
Tux's lil' helper
Tux's lil' helper


Joined: 17 Jul 2002
Posts: 126

PostPosted: Thu Oct 07, 2004 3:17 pm    Post subject: Reply with quote

export DISPLAY=localhost:42:0

one of the java components needs x..
i resorted to having xfvb running & that fixed it

it was quite a long time ago so cross check
& if possible switch to oracle 10g instead of using 817
Back to top
View user's profile Send private message
sasubillis
n00b
n00b


Joined: 30 Apr 2004
Posts: 20
Location: FINLAND

PostPosted: Thu Oct 07, 2004 9:27 pm    Post subject: some additions to the Oracle8 howto on Gentoo Reply with quote

Hi,

Its really a good howto for Oracle on Gentoo posted by Luca.

However I would like add some additions to this after my experiences with Oracle8.1.7 installation on my G-Box.

1) If you have higher gcc version than 2.95.3, please install 2.95.3-r8 version

2) After instllaing Oracle go to $ORACLE_HOME and add '-lnsl' flag to the file 'sysliblist' and execute this command 'relink all'

By doing these things you will have Oracle on your machine.

Hope these points will be useful to community.

Regards,
Sreenu.S
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Documentation, Tips & Tricks All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum