Skip to Main Content
  • Questions
  • Oracle 9i Installation on Red Hat Linux

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Muhammad Riaz.

Asked: August 04, 2004 - 11:26 am UTC

Last updated: June 03, 2007 - 5:31 pm UTC

Version: 9.2.0

Viewed 1000+ times

You Asked

Can you tell us (or mention some document) for step by step guide of installation of Oracle 9i on Red Hat Linux ?

Best Regards

and Tom said...

Rating

  (24 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

this document has step by step instrunctions

sreekanth gadhiraju, August 04, 2004 - 1:52 pm UTC

Try This also

Jeff Hunter, August 04, 2004 - 2:23 pm UTC

Oracle9iR2 postinstallation procedure in free Red Hat 9

James Stansell, August 04, 2004 - 3:03 pm UTC

Another (short) step-by-step guide that you might find useful:
</code> http://lxer.com/module/forums/t/9908/ <code>

Werner Puschitz's site

Daivd.Fenng, August 04, 2004 - 9:37 pm UTC

Werner Puschitz's site :

Installing Oracle Database 10g on Red Hat Enterprise Linux AS 3 and 2.1, Red Hat 9, and on Red Hat Fedora Core 1
Installing Oracle Database 10g with Real Application Cluster (RAC) on Red Hat Enterprise Linux Advanced Server 3
Installing Oracle9i on Red Hat Linux 7.1, 7.2, 7.3, 8.0, 9, Red Hat Advanced Server 2.1, and on RHEL AS 3

</code> http://www.puschitz.com/ <code>

http://www.dizwell.com

Satish, August 04, 2004 - 10:07 pm UTC

I liked this site a lot . I have not found a guide to installing Oracle 9iAS on redhat ES 3.0 or any other OS other
than documentation


A step by step installation guide of Oracle 9i on Red Hat linux (with screen dump)

Joe Yung, August 04, 2004 - 11:53 pm UTC

</code> http://www.ocphk.org/linux/how_to_install_oracle_9i.jsp
Others resources (more will be added later) can be found at 
http://www.ocphk.org/linux/index.jsp <code>

Hope this help.

Great

Muhammad Riaz Shahid, August 05, 2004 - 4:58 am UTC

Thats Really Cool and more than what i expected...

Thanks TOM and all others for pointing such nice links...

Many thanks



A reader, August 24, 2004 - 7:31 am UTC


Oracle9iR2 Post Installation Procedure on shrink-wrapped Red Hat 9 or freely downloadable version

Boris Derzhavets, August 26, 2004 - 11:46 am UTC

Sorry for self evaluation.
Detailed description : how to fix both of linking phase issues
in post installation phase.

</code> http://www.linuxgazette.com/node/view/9221
or
http://lxer.com/module/newswire/view/19285/index.html <code>

A reader, September 09, 2004 - 7:11 am UTC


Quick upgrade Red Hat Linux 9 to get asynchronous AIO turned on

Boris Derzhavets, September 12, 2004 - 10:32 am UTC

Asynchronous I/O doesn't come along with Red Hat Linux 9 automatically.
It's affecting performance of any database server working in Red Hat Linux environment,which is not RHEL Advanced Server or Entry Level Server.
To fix the issue we start with kernel upgrade,supporting AIO,and libaio upgrade.

rpm -i kernel-2.4.20-35.9.i686.rpm
rpm -i libaio-0.3.96-3.i386.rpm \
ibaio-devel-0.3.96-3.i386.rpm

Restart RHL9
Login as oracle:-

Shutdown Oracle
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk async_on
make -f ins_rdbms.mk ioracle
Startup Oracle.

Login to OEM Console.
Modify "SPfile" screen:-

disk_async_io=true
filesystemio_options=asynch

Click "apply".
Restart instance.
We are done with AIO upgrade.

Thanks

Muhammad Riaz Shahid, September 20, 2004 - 2:10 am UTC


Asynchronous I/0 for Oracle9iR2 on Linux 2.6.8,2.4.20-35.9

Boris Derzhavets, September 21, 2004 - 4:44 am UTC

I sincerely apologize for my the most recent post issues.
Please view:-
</code> http://www.linuxgazette.com/node/view/9342 http://www.linuxgazette.com/node/view/9388
 I would also like to express my appreciations Axel Thimm
at atrpms.net for explanations how to read and understand
RHL 9 Kernel 2.4.20-35.9 features description at mentioned site:-

On Sun, Sep 19, 2004 at 10:46:34AM +0000, Boris Derzhavets wrote:

Please, view link:-
http://atrpms.net/dist/rh9/kernel-redhat/kernel-2.4.20-35.9.i686.rpm.html <code>
You state on this page:-
Tue Mar 26 23:00:00 2002 Benjamin LaHaise
- add aio 20020326
- correct aio library install path

Axel Thimm answers:-

That's a changelog made by Red Hat, even if after two years the aio
patches got removed or are malfunctioning, the changelog is still
valid and cannot be altered (it is there for documenting historical
steps).


Sys Admin

Dawar, January 06, 2005 - 11:48 pm UTC

Hello Tom,

I am installing Oracle on RED HAT FEDORA 2.
I got the following error on Database Configuration Screen:

Error:

Error: You do not have sufficient privileges to write to the speified path. In component Database Configuration Assistant 9.2.0.1.0.Installation cannot continue for this component.

* Stop installation of all products.
* Stop installation of this component only.

Regards,
Saeed





Tom Kyte
January 07, 2005 - 9:01 am UTC

well, it is not to be installed on fedora, that is an end user desktop operating system. it is not a server.

but, check the logs -- apparently you do not have permission to write somewhere.

install oracle 9.2.0 on test machine.....

Shankar, April 10, 2005 - 2:18 pm UTC

In our work, we would like to create 20 accounts for dbas to practice on ONE machine. What is the recommended installation solution? I want to install oracle software once and that is owned by only one user but should be shared by multiple accounts. is it possible? Then, I could create 20 separate databases so that each of the 20 users can have his/her own database to practice with. Any help would be appreciated... Thanks.

Tom Kyte
April 10, 2005 - 2:23 pm UTC

have you considered VMWARE?

If you want to set up really safe playgrounds that are isolated, it is awesome. Especially as a learning tool since anything they do wrong can be reset at a button push.

</code> http://www.oracle.com/technology/obe/start/db.html <code>

they can just put it on their desktops and play with it.



union all problem in oracle 10g

rajesh, April 13, 2005 - 8:59 am UTC

Dear tom

I have a procedure with an insert statement like

insert into table tab1 (col1, col2,...coln)
select col1, col2... coln from tab2
union all
select col1, col2... coln from tab3;

is giving end of commumnication.

the same thing if I use the following is working fine.

insert into table tab1 (col1, col2,...coln)
select col1, col2... coln from tab2;

insert into table tab1 (col1, col2,...coln)
select col1, col2... coln from tab3;

can you explain this?

Tom Kyte
April 13, 2005 - 9:16 am UTC

please contact support for ora-600, ora-7445, ora-3113


RE: union all problem in oracle 10g

Vinayak, April 14, 2005 - 10:26 am UTC

Rajesh,

try setting "_PUSH_JOIN_UNION_VIEW"=FALSE parameter.

root.sh

Jim, April 23, 2005 - 1:13 pm UTC

(1) At the end of oracle database software install, we run root.sh script. What does it actually do? I am not good in shell scripts. So is there a document that tells what is the purpose of it and what does it do? Thanks.

(2) If one places a datafile on a R/W CD-ROM, can dbwr process write to it?

Thanks.

Tom Kyte
April 23, 2005 - 1:16 pm UTC

1) read it, it is pretty simple. it changes ownership/permissions on some files.

the script is really simple, even if you are not a sh expert, it is very straightforward. file ownership changes (to be owned by oracle) and permissions -- to get the right ones.

2) read write, if it looks like a file system sure, if you can "copy a file there", yes. but I would not recommend it at all.

reader

A reader, September 21, 2005 - 11:38 am UTC

hi
i have not found anything usefull anywhere regarding my question

I installed oracle 9ir2 on linux 9..it installed fine but when it comes to the stage where it installs optional configuration tools like dbca etc..at that time dbca was not successfull(every other tool suceeded..(1)please let me know how can i reach to that screen again once installation is over#)... it showed the error message "invalid or unknown NLS parameter values specified"...i changed that in ~/.bashrc file (earlier it was american_america.we8iso8859p2 then i changed o AMERICAN)and still it did not work..what should i do..i have even tried changing it by opening another terminal window when install is going on and then export NLS_LANGUAGE=AMERICAN

and when i tried to connect to oracle by connect / as sysdba still it showed the same error..what does it mean .

2)does it mean that oracle is installed properly but database is not made or some thing else ..

and when i open dbca from terminal by writing dbca it opens fine..(3)should i make new database now with dbca



Tom Kyte
September 21, 2005 - 7:38 pm UTC

actually, you say "linux 9", that is the end user desktop OS, not a server platform, that is not actually supported. You'll have to google around to see if your issue has been encountered by someone and worked around.



Installing Oracle 9i on Suse 9

vivek, November 15, 2005 - 4:38 pm UTC

Tom,

I am trying to install Oracle 9i on Suse for first time, after specifying database type as General, it throws following error
" You do not have sufficient privileges to write to the speified path. In component Database Configuration Assistant 9.2.0.1.0.Installation cannot continue for this component.
* Stop installation of all products.
* Stop installation of this component only."

I continue with installation and after installation i found that 'dbca' file was not even installed. On investigation of install log, it said the above error with the path '/oradata' which i have not specified (seems to be default for datafiles). Further down in error it say "could not read all oracle homes from inventory". I had specified oracle home as '/oracle/product926'.

a) am i missing something, do i need to specify something more before proceeding to install or
do i have to select 'Software only' option and later on create the database.
b) what exactly error "could not read all oracle home from inventory" means , as i have specified only one oracle home.

Regards
Vivek.

Tom Kyte
November 16, 2005 - 8:29 am UTC

/oradata is typically put into a much larger path (the oracle home)

did you specify where to install the software - and when you get to the database creation step - are the right paths filled in

(and installation questions are best handled via support)...

dave, November 16, 2005 - 3:55 pm UTC

when installing dbca it looks for /oradata (cn see from the instal logs) if it doesnt exist dbca wont install

usual trick is to create a softlink elsewhere

Tom Kyte
November 16, 2005 - 6:21 pm UTC

never heard of that, i have no /oradata's on any machine.

Dave, November 17, 2005 - 8:33 am UTC

Found the cause.

Tries to set the directory for datafiles to $ORACLE_BASE/oradata, if ORACLE_BASE isn't not set it just appends /oradata to nothing, so the value it ends up looking for is /oradata.

Can see this from the install logs

"
name = ORACLE_BASE
Query returned :
Setting value of ps_mountPoint to /oradata
"

So set ORACLE_BASE to a valid writeable directory and you will be fine

root.sh

Reader, June 01, 2007 - 11:35 pm UTC

In general what does root.sh do in Oracle RDBMS installation? Thanks
Tom Kyte
June 03, 2007 - 5:31 pm UTC

chmod and chown of files. update /etc/oratab.

it is a script, you can read it and see what it does.

Oracle 11G Installation on Windows

Nand Kishore Sagi, August 18, 2011 - 12:46 pm UTC

Hi Tom,

First of all let me apologize as this question is not related to the main thread and I was not able to find the appropriate thread. I am also not sure if this would be a new question or this has been asked before. Hence I will try to be as brief as possible.

On my home laptop I was installing the Oracle 11GR2 and the software was installed successfully. I encountered the below mentioned error while creating the database.

ORA-19624: Operation Failed, retry possible
ORA-19870: error while restoring backup piece D:\Oracle\app\HomeUser\product\11.2.0\dbhome_1\assistants\dbca\templates\SEED_DATABASE.DFB
ORA-19612: Datafile 2 not restored due to missing or corrupt data
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5816 
ORA-06512: at line 20

I verified that the SEED_DATABASE.DFB file was present in the templates directory. In my "GOOGLE" analysis the issue was observed during the backup operation via RMAN and no one observed this issue while creating a new fresh database. The laptop has only a single user which has all the admin privileges but is not the administrator account. My home laptop is Windows 7 with 4GB RAM (only 2.8 usable) and is a fresh build from the Samsung authorized repair repair center. It does not have a service pack installed yet. The drive in which I am trying to install Oracle software has almost 100GB of space. C

Can you please let me know how I can fix this issue? Any pointers in resolving this issue would be really appreciated.

I again apologize for diverting this thread and would really understand if you chose not to answer or to reject this question.

As always I am really thankful to you for all your efforts and energy in helping us solve our dumbest of dumbest queries :-).

With Best Regards
Nand Kishore Sagi