Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora Core 5 (FC5) - A brief guide to installing Oracle 10g Release 2 (10.2.0.1) on Fedora Core 5.



Pete said...

Gave it a try with fc5t3 +all updates to
March 20

installs fine up to trying to start listener
sez the host string is bad in linstner.ora
changed to 127.0.0.1 etc, hostname and 127...
ping just fine. setting a high trace number
indicates that it can not find the protocol
when parsing the line.

changed gcc to be the 3.32 but that didnt help,
willing to reload PC with a fresh FC5 is that
will help ...


Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
TNS-01150: The address of the specified listener name is incorrect
TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nix2.city)(PORT=1521)))

[20-MAR-2006 20:56:18:611] nsgllsn: LSNDSC==>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nix2.city)(PORT=1521)))
[20-MAR-2006 20:56:18:611] nsglhcrt: entry
[20-MAR-2006 20:56:18:611] nsglhcrt: exit
[20-MAR-2006 20:56:18:611] nsglbgetRSPidx: entry
[20-MAR-2006 20:56:18:611] nladini: entry
[20-MAR-2006 20:56:18:611] nladini: exit
[20-MAR-2006 20:56:18:611] nladget: entry
[20-MAR-2006 20:56:18:611] nladget: exit
[20-MAR-2006 20:56:18:611] nsglbn2i: entry
[20-MAR-2006 20:56:18:611] nsglbn2i: exit
[20-MAR-2006 20:56:18:612] nladtrm: entry
[20-MAR-2006 20:56:18:612] nladtrm: exit
[20-MAR-2006 20:56:18:612] nsglbgetRSPidx: returning ecode=0
[20-MAR-2006 20:56:18:612] nsglbgetRSPidx: exit
[20-MAR-2006 20:56:18:612] nsgllsn: Couldn't get pRotocol/Session/Presentation indexes
[20-MAR-2006 20:56:18:612] nsglhfre: entry
[20-MAR-2006 20:56:18:612] nsglhrem: entry
[20-MAR-2006 20:56:18:612] nsglhrem: entry
[20-MAR-2006 20:56:18:612] nsglhfre: Deallocating cxd 0x872e490.
[20-MAR-2006 20:56:18:612] nsglhfre: exit
[20-MAR-2006 20:56:18:612] nsglma: Reporting the following error stack:
TNS-01150: The address of the specified listener name is incorrect
TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nix2.city)(PORT=1521)))


did the usual, relinked etc ..



Tim... said...

It's a draft document. I've not tried it since T2, so I can't guarantee it works, that's why it says DRAFT at the start.

Cheers

Tim...

Bart said...

The article about FC5 and Oracle is totally false.
FC5 has a new version of GLIBC, without linux threads. Many apps are broken (SAP, Oracle) and it
cannot be fixed. Linux threads communication facilities cannot be used. Result is ORA-12157.

Mladen Gogala said...

The article about FC5 and oracle 10.2 is seriously
misleadning and should be retracted and replaced
with a warning that FC5 and Oracle do not mix. I
explained everything on OTN and usenet group for
such things (comp.databases.oracle.server.) Please,
remove this article so that nobody else would lose
time and sleep like I did.

Tim... said...

Hi.

The article clearly states it is a draft document written against a test version of FC5. I've added some stronger comments, but so far I've not been able to test against the final version of FC5, so I'm not in a position to judge its value.

I'm sorry if you've wasted time, but if you will follow instructions clearly stated as DRAFT, then that's not exactly my fault.

Cheers

Tim...

Shashin said...

Hi ,

I have got Oracle 10gR2 up and running on FC5 following your set of instructions.
Thanks for your information , especially about
that gennttab stuff which was the only blocking one.

Tim... said...

Judging by the general feedback, you've just performed a minor miracle :)

I hope I get to test it soon!

Cheers

Tim...

Andrea said...

It does't work, network error also for me (ORA-12157).

Tim... said...

Have you read the start of the article?

It clearly states it is a draft copy and it does not work!

Usually, if I read an article that says, "it doesn't work", I assume it doesn't work. It's not exactly rocket science :)

Cheers

Tim...

Shashin said...

Hello again ,

Here are some minor differences from the article.

Set of packages from my kickstart of FC5

@Base
@Editors
@Administration Tools
@X Window System
@System Tools
@GNOME Desktop Environment
@Development Libraries
@Development Tools
@text-internet
@legacy-software-development
firefox
compat-db
libaio
libaio-devel
openmotif
tcl-devel
tcl-html

You also need openmotif21-2.1.30-14.i386.rpm which I took from FC4.

I had only these two lines in oracle user's .bashrc before starting Installer.

export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=YOUR_SID

And these after installation
export RACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Apart from that you need to apply suggested gennttab change during installtion.

And , I installed it inside FC5 xen guest , but that should be irrelevant I suppose.

Shashin.

Tim... said...

Hi.

I tried your amendments, but I still get ORA-12157 when the DBCA starts up. Are you sure you didn't do anything else?

Cheers

Tim...

Mladen Gogala said...

I was working hard to make it work, without much success. Here are things that I've tried, in chronological order:
1) Plain installation
2) Relink with different options for
"ipc" in ins_rdbms.mk
3) Add patchset 10.2.0.2 to see whether
it helps. It doesn't
4) Try few more relinks with new options
from ins_rdbms.mk
5) Unpack glibc RPM from FC3 in a separate
dir ($ORACLE_HOME/glibc) and point to
it by LD_LIBRARY_PATH - breakes
everything.
6) Move so created glibc into
$ORACLE_HOME/lib/i686 - this also
doesn't work.
7) Installed FC3 on another partition and
mounted it and started a shell with
chroot - this worked.

So far, the only way I found to start Oracle on FC5 is to install FC3 partition,
start the machine under FC3, perform the installation, reboot the machine with FC5 and start oracle in a "chroot" environment, pointing to an old FC3 partition. Technically, I did make it work, butI was so annoyed by the whole thing that I removed everything, settled for FC4 and decided to wait for FC6.

Shashin said...

For the sake of it I tried it again today on FC5.
I performed it on the FC5 install from the release ISOs which contains kernel-2.6.15-1.2054_FC5. To be honest I did not read all the installation screens from the article. But instead just choose most of the default values including create sample database schema during installation.

I see that you have amended the article with mentioning of openmotif21 rpm , but I notice you have mentioned source of (openmotif21-2.1.30-14.src.rpm) and not binary one .

I think you already might know it , but it is important to make sure that hostname is not listed in /etc/hosts file against 127.0.0.1

Apart from that and list of earlier mentioned packages I don't think any information is missing.

And yes , the installation went very smoothly without problems.

But still keeping my fingers crossed if I missed out on any other information.

Regards,
Shashin.

David said...

Thanks for the helpful document. Thanks to this, I have managed to get past the hang during linking and have managed to get FC5 working with 10gR2. Smashing!
Regards,
David

Andrew said...

Many thanks for what you all have done so far. The gennttab helped me further, but I also am stuck with the TNS-01150 error. Has anyone found a solution for this error yet?

oracle@fedora5 [~]
!3 > lsnrctl start

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 11-APR-2006 23:22:57

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /opt/oracle/product/rdbms/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.2.0 - Production
System parameter file is /opt/oracle/product/rdbms/10.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/product/rdbms/10.2.0/network/log/listener.log
TNS-01150: The address of the specified listener name is incorrect
TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=fedora5)(Port=1521)))

Listener failed to start. See the error message(s) above...


Many thanks, Andrew

Tim... said...

As you can see from the comments, some people have had some success, but I've yet to get an installation working.

Sorry.

Tim...

Jan Vissers said...

The installation instruction worked for me. There was one typo in the Classpath. JRE should be 'jre' (in lowercase). Regarding the FC5 installation - I installed almost all packages, but not the Office tools.

Tim... said...

Thanks for the info. I've corrected the path :)

Cheers

Tim...

Tim... said...

************ NOTICE ************
Hi.

The installation procedure now works fine for me, so the article is no longer a draft. All comments prior to this one relate to the draft article.

Thanks to everyone who has helped in the process.

Cheers

Tim...
************ NOTICE ************

Rich said...

Don't know if this page is x86 specific but for
x86_64 FC5 using 10201_database_linux_x86_64.cpio
I've had no success. I get the infamous
ORA-12157 error during the install at
the execution of product/10.2.0/db_1/bin/dbca.
Neither this page's recipe nor suggests
floating about the web crack the nut.
Those who claim success at least provide hope.

Tim... said...

Hi.

This article is written against x86-32. I don't have access to a x86-64 box, so I wouldn't have a clue what the issues are there.

Sorry :(

Tim...

Thai said...

It's very interesting to read the articles and all the comments although I haven't tried it yet.

By the way, is there any article about installing Oracle Database 10g Client on FC5? There'll be no listener, DBCA .... I just need SQL*Plus and Enterprise Manager Client.

Thanks.

Tim... said...

Hi.

I would expect the client to load without any (or many) of the prerequisites, although I've not tried just the client myself.

Cheers

Tim...
PS. If you have any other questions, please ask questions in the forum. :)

Piyush Panchal said...

I appreciate it. this article is very help to install the oracle on FC5. I had got succeed.

Erick said...

I succefully installed the database in a Fedora Core 5 x86_64 (64bits).

Among all the things I did properly and wrong ...

Good.
When I finally get it to work I forgot to install the openmotif21-2.1.30-14.i386.rpm. The database installation did not report me any errors, even the Oracle Universal Installer created the database without errors. Database is up and running!!!

Bad thing...
My mistake was that while I was modifing the "$ORACLE_HOME/bin/gennttab" I left an extra space in between "/\n \g" . It took me hours to find out the issue. I left it just as the instructions stated originally "/\n\g" (no space).

Does anyone knows what kind of errors I might get later since I forgot to install the openmotif21-2.1.30-14.i386.rpm.

Note:
There is no openmotif21-2.1.30-14.i386.rpm for the x86_64 os. FC 5 64 bit. I know this RPM still can be added into this OS.

Saumyendra N. Basu said...

Hi

I am trying to install 10g on FC5 on a AMD dual core 64 bit m/c. Apart from the downloaded Oracle file, what else is necessary to make it work. Installer is failing on Java language. Please let us know.

Basu

Rich said...

Erick - FC5 uses a different thread library
than that used when oracle 10g was compiled.
How did you get around this reality?
Thanks.

Tim... said...

The latest Oracle version for linux works perfectly. Download it again and follow the instructions.

Cheers

Tim...

SalvoLP said...

Thanks for your very helpful guide!

I have a problem: when I run
/etc/rc.d/init.d/dbora start

I have the following error:

connect to address 127.0.0.1 port 544: Connection refused
Trying krb4 rsh...
connect to address 127.0.0.1 port 544: Connection refused
trying normal rsh (/usr/bin/rsh)
datimetis: Connection refused

With some debug I noticed that the error is caused by the line

rsh $HOST -l $ORACLE $0 $1 ORA_DB

of dbora script (I copy-pasted the one you gave in your guide)

I suppose that it is a problem of host names...

My server in not part of a domain and a static private IP.

My /etc/hosts file is
# ...
# ...
127.0.0.1 datimetis localhost.localdomain localhost
192.168.2.101 datimetis datimetis

The second line has been added by me.
Is it correct?

Thank you very very much in advance!

SalvoLP said...

I forgot to mention that obviously the server's static private IP address is 192.168.2.101 and that hostname (i chose it during FC5 installation) is datimetis.

Thanks again, I'm waiting for any kind suggestion...

Tim... said...

Hi.

It looks like you don't have RSH configured on your server. Sort that and try again.

Please do't ask questions in the comments. That's for the forum.

Cheers

Tim...

Johan said...

I've managed to install oracle, including workflow on an AMD 64bit architecture, thanks to your article. I had to install some packages (esp. 32 bit) manually. I cannot remember which packages, but it is relatively easy to find out if you do the following:
1. look at the redhat ES 4 prerequisites
2. on error look in the the log for a missing library, then use something like rpm.pbone.net to find and download the appropreiate package

thanks again, it helped me a lot!

Jerome Strausberg said...

I want to thank the author for this note. I used Oracle's own readme the first time,and had multiple errors. I used the author's note the second time. The notes about the needed older version of the compatibility libraries did the trick. I got through the entire process without errors! The database, listener, and database control came up.

Ignoto said...

Thanks for this usefull guide. It saved me the day!

I only miss one step in the post install part. One need to modify a hardcoded path in the scitpt "$ORACLE_HOME/bin/dbstart", just to get it work. The modification I've done is:

1> Edit $ORACLE_HOME/bin/dbstart
2> Goto line 78
3> Replace the line with
ORACLE_HOME_LISTNER=$ORACLE_HOME

I hope it helps...

Ciao


Rob Sargent said...

The trick of updating gennttab could be more explicit. One needs to have a script that tests for the file's existence and then cp in a fixed version

while true
do
# INST_BIN_DIR = the absolute install location
if [ -e $INST_BIN_DIR/gennttab ];
then
do
cp fixed.version.of.gennttab ${INST_BIN_DIR}/gennttab;
echo substituted file;
exit(0);
done
else
echo not there;
fi
sleep 3;
done;

Chris said...

These instructions seem to be pretty good. I have a FC5 circa 6/8/2006 (whatever build was current then) and I tried this first for 10 XE, which didn't work for the apps (APEX) part, but seeems to be working for the big boy version. One snag I hit that may get other newbies is this:

If you get a error about Xwindows not being able to open on display 0:0, then you are probably logged in as root and su'ing to oracle. Just log out and log in as oracle. You shouldn't be logged in as root anyway.

Thanks for the instructions. These were very handy.

Jacques said...

I have a problem with "dbora". Under services setting->server, I have a "permission denied" at the right of the dbora service. When I boot , the dbora service does not start the database.

On the other hand, if I start the lsnrctl then do dbstart, the database is up and runing!

What could be the problem?

Thanks,

Jacques

Tim... said...

***Questions in the forum***

Try running the dbora script manually as the root user:

./dbora start

This should show the error messages properly and help you diagnose the problem.

Please don't post questions here. It's just for comments on the articles. Questions should beposted on the forum!

Cheers

Tim...

sudsy said...

Excellent article! The only thing I found that I needed to do which wasn't mentioned was installing the i386 version of libXp, i.e. in the Setup section, after changing directory, I ran the following:
rpm -U libXp-1.0.0-2.2.i386.rpm
After that, everything was straight-forward.
A big THANK YOU from this corner!

sudsy said...

Sorry, should have mentioned that I'm running the AMD64 version of Fedora Core 5 and the corresponding version of Oracle 10g. Thanks again!

blackscutum said...

Is there any solution for "ORA-12157", Yet?

it makes me crazy...T_T..



I found that "Oracle require telnet, vsftp".

I didn't full install when I was setup for FC5.

So, It has not had telnet-server package.

So, I installed telnet-server.(yum install telnet-server)

But ORA-12157 is again....;(

How to solve it?


i am poor at english... sorry..

Tim... said...

Hi.

If you are on x32, download the latest version of Oracle and try again. It works fine.

If you are on x64, download the correct version of Oracle again, and read the two comments prior to yours. It works fine.

Cheers

Tim...

Apakabar said...

Hi Tim,
your work and description has been very helpfull for me, as a brand new oracle installer .
Thanks a lot.
Just a few problems with Xterm. I had this error whern I tried to start Xclock to check my X server installation: "Xhost : can't open display: [my localmachine name]:0.0, or when I tried this :
[oracle@kebogiro ~]DISPLAY=kebogiro:0.0; export DISPLAY
[oracle@kebogiro ~]xhost +kebogiro

that I resolved with this http://linuxfr.org/forums/10/3999.html and with :
[root@kebogiro ~]su - oracle
[oracle@kebogiro ~]DISPLAY=:0; export DISPLAY
[oracle@kebogiro ~]xhost +localhost
localhost being added to access control list

Salut !
Apakabar, Marseille, France

Gerhard Eickenhorst said...

A big thank you for this article. 10gR2 on Fedora Core 5 is up and running.

Andrew said...

I still have listener problems
TNS-01150: The address of the specified listener name is incorrect
TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fedora5)(PORT=1521)))

Has anybody found a solution for this yet? I have tried installing patch 10.2.0.2.0 and the latest CPU and they seem to install correctly (no errors in log files and reports no errors). However I am doing something wrong here.

cheers, Andrew

Tim... said...

Hi.

I re-downloaded the Oracle software from OTN and everything worked fine for me. I'm not able to recreate your problem.

Cheers

Tim...

Sri said...

I'm a newbie..aspiring to be a DBA. This is veryhelp ful to me in getting installed 10g on FC5. Thanx alot!

One thing wrong.... said...

Hi,

# To this...
LIB=`$ECHO ${TtoLIB} | $SED 's/ /\n/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'`
INI=`$ECHO ${TtoINI} | $SED 's/ /\n/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'`
BAS=`$ECHO ${TtoBAS} | $SED 's/ /\n/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'

Should be

# To this...
LIB=`$ECHO ${TtoLIB} | $SED 's/ /\\n/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'`
INI=`$ECHO ${TtoINI} | $SED 's/ /\\n/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'`
BAS=`$ECHO ${TtoBAS} | $SED 's/ /\\n/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'

Note the extra "\" beside the "n

See metalink 656177992

Paul Breitenbach said...

What is the linking-phase?

Tim... said...

When you install Oracle in Linux and UNIX systems, the object code is linked by the C compiler. On Windows, you get redy linked executables.

Cheers

Tim...

michael porter said...

xclock error while installing 10g on redhat..

Mike

Rama Krisna said...

I think we can not add or modify
bash_profile file: from oracle user We have to do it from root .

pratap said...

awesome article...!!!
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired